MySQL

[BlueGazoo]

Gooday,

objRecordset.RecordCount is not working. The connection is fully dynamic, here's the code:

objRecordset.Open objCommand,,2,3,1

RecordCounts spits out -1 always.

Found a little blurb on net saying MySQL ODBC doesn't support recordCount but that don't sound right, does it...

any help is much appreciated.

The Great Blue Gazoo

[BlueGazoo]

... I tried doing:

objRecordset.movelast
objRecordset.RecordCount

...but it still spits out -1

so, for now im doing:

intCount = 0
Do While NOT objRecordset.EOF
intCount = intCount + 1
objRecordset.movenext
Loop

but would rather use the objRecordCount, of course,

thanks in advance

[M Owen]

Check and see if you have a CursorLocation property (or like it ...) If so set it to AdUseClient. This will give you and accurate record count.

[BlueGazoo]

oi!

Thank you, sir!