Darren
|
| Posted: 05/17/2002, 8:11 AM |
|
Hi,
what type of recordset cursor does CCS assign? Is it the default forward-only? If so, is it possible to change that so I can access the RecordCount property. Also how do I access the recordset object for a particular grid?
Failing that, is there a way to get the entire SQL string that was used for the grid so I can re-execute a count on the query?
Thanks!
Darren.
|
|
|
 |
Darren
|
| Posted: 05/17/2002, 9:59 AM |
|
Ok, on looking into this further by going through some of the code I can see that there are two key variables, either of which would really help me out if I could access them; they are RecordsCount (which holds the number of records in a grid - exactly what I want) and CountSQL which is SQL written specifically to return the RecordsCount information.
Is it possible to access either of these variables?
Thanks,
Darren.
|
|
|
|
Nicole
|
| Posted: 05/20/2002, 2:14 AM |
|
Darren,
from common file you'll see that cursor type is: adOpenForwardOnly
To access sql, where and order clauses and coun sql of particular grin in e.g. Before Show or Before Show row events using code like:
Dim DSource
Set DSource = New clsempsDataSource
response.write DSource.SQL & "<br>"
response.write DSource.countSQL & "<br>"
response.write DSource.Where & "<br>"
response.write DSource.Order & "<br>"
|
|
|
|
|
