Hi y'all

Some help here please

'Define SQL
SQL = "select "
'Table Orders
SQL = SQL & "schema1.orders.order_sid, "
SQL = SQL & "schema1.orders.order_date "
'From Table Orders
SQL = SQL & "from "
SQL = SQL & "schema1.orders "
'Where --> Only not Ready-to-Go Orders ...
SQL = SQL & "where "
SQL = SQL & "readytogo = 0 "
'And --> From Session User
SQL = SQL & "and "
SQL = SQL & "user_sid = '" & Session("user_sid") & "' "
'And --> From the Selected Company
SQL = SQL & "and "
SQL = SQL & "company_sid = '" & Session("company_sid") & "' "

Now, the Columns here are
order_sid - Number(10)
order_date - Date
readytogo - Number(1) with Constraint for 0 or 1 only (False ou True)
user_sid - Char(12)
company_sid - Char(14)

Then, the SQL String results in:
...
where
readytogo = 0
and
user_sid = '773433'
and
company_sid = '153'

Here's the thing: When I run this code in ASP, I get EOF and BOF true. That means there are no matches. But yes, there are. When I run it in TOAD, I get 1 row.

To complete the info, the user in toad is toplevel, and the site user only has grants for SELECT, INSERT, UPDATE and DELETE. Although I do not think that's the problem, since I also tried it on the site with the toplevel user...

Furthermore, the Provider is MSDAORA, CursorLocation = 3, and Oracle version is some 9i, not too sure.

Did this ever happen to anybody? Does anyone have any clues as to WHY this is happening?

Please, any help would be extremely appreciated.
(and if you clueless like me, thanx for reading anyways)