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:
readytogo = 0
user_sid = '773433'
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)