velo
Posts: 6
|
Posted: 05/24/2009, 11:45 AM |
|
Hello:
I have this custom code in ccs4 and mssql:
Dim sqlh
Dim rscredi
Dim dbcredi
Set dbcredi = new clsDBSQLHUSA
dbcredi.Open
sqlh="SELECT * FROM CreditosGH"
Set rscredi = dbcredi.Execute(sqlh)
response.write rscredi.RecordCount
While rscredi.EOF
response.Write "Prueba"
rscredi.MoveNext
Wend
The response for rscredi.RecordCount is "-1" and in process while, no records are processed.
The table are correct and have records.
Anyone can help me?.
Thanks.
Avelino Alonso
|
|
|
Edd
Posts: 547
|
Posted: 05/24/2009, 3:05 PM |
|
Record Count is not always returned - you would need to do a .MoveLast to get the record Count
The statement
While rscredi.EOF
Should be
While NOT rscredi.EOF
Cheers - Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|