Navigator problem when GROUP BY used in SQL

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Java

Navigator problem when GROUP BY used in SQL

Author

Message

Mukul

Posts: 53

Posted: 07/20/2007, 8:32 AM

Hi,

When group by clause is used in the sql, the navigator shows only page 1 of 1.
The result set may be 1000 rows but still it shows the Navigator; < page 1 of 1 >
So we are not able to go to next page.

Thanks in Advance!
Mukul

Mukul

Posts: 53

Posted: 07/20/2007, 11:00 PM

It works,
in the before execute select add custom code:

e.getCommand().setCountSql("select count(*) from ( your select statement ) as t");

Have a nice day!

Mukul

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login