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 - Varchar2(12) (sorry, I had it like Char(12) before)
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)
If you inserted the record through TOAD and your SELECT statement returns it back (but you can't see it in ASP), did you perhaps forget to COMMIT inserted data in TOAD? If you don't do that, noone but your current session will be able to see this data.
Ouch!!!! Did I forget to commit?!?!?!?! Guess now I'll never know, because I dropped the table and created it again. It's working fine now... But since you mentioned, I could've forgotten to commit... Never thought of that!