Count number of records returned by doSelect()

[mks50]

Hi,

Does anyone have a way of counting records returned by a doSelect() on an SCFile object ? I can write a function to do it if the SCFile object and the SCFile object populated by the query is passed, however I can't seem to use any of the supplied functions ?

thanks

[tommy]

Which function are you not able to use?

To my knowledge you need to loop through the results and count manually. I don't have access to it here but I have a small javascript that do a count on a query.

[mks50]

Tommy - thanks .... thats what I did already. I just kind of thought there would be a simple method of a SCFile object which would count the records in a recordset, e.g. like the RecordCount method of an ADO recordset .... however I think u just confirmed there isn't !

thx

[tommy]

Well I didn't find it documented so had to make my own.