if have an problem with a CustomQuery not return the complete recordset, I have this query (simplified for this example):
sql = "select * from trip_pricing"
rs = CustomQuery(sql)
if not rs.eof then
....
end if
There are several rows in the table but I get this result:
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'eof'
It seems that "rs" does contain at least 1 row of data as if I trace through I get:
sql = select * from trip_pricing
rs("id") = 4
isObject(rs): True
isArray(rs): False
Yet it won't allow me to traverse through the object. What is wrong with this SQL?
The frustrating part is that I have another custom query in a different event and it works fine so why won't this one work?
I am using ASPRunner 6.2 with MySQL