Database Values not showing up in A Recordset Test

[kophjager]

I have a very perplexing problem. I am building asp pages that access my Oracle 9i database. I created a connection, tested it and the test was sucessful. I went to one of my pages and added in a recordset to gather values from a table in my database and tested in and in the test window, all the data appeared. I then completed the page and went to another and added in a recordset and tested it and the data appeared. I then went to my Oracle SQL worksheet and dropped all my test tables and redefined them the same way and added in the same values. I then went back to those two pages and redefined the recordsets and went to test them and the test window appeared fine but it said there was no data. I was able to do my SQL statement fine in the Oracle worksheet and it verified that the data was in the tables.
I then went back to UltraDev and deleted the connection and created an enitre new one. I went to the pages with the recordsets defined and deleted them and then went to add in a new recordset with this new connection. Upon defining where I want my dta and from what tables, mind you it can see the tables and the table columns fine in the simple search creation window, I would again test the recordset, the test window would pop up blank again and say no data. I have tried creating new tables for these pages to access and no luck. I have saved the pages as new names and still no luck. I have restarted the entire machine and both applications with no luck.
I am just wondering what is going on here? UltraDev can see the tables and the colummns but when I try to access the data in a recordset test under any circumstance, it does not see any data. Can any one plese help me? Thank you for your help.

Kophjager

 

[schase]

another user was having similiar difficulties
thread770-389834 dont know what ever came of his. "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[kophjager]

Thanks Schase. I still do not know what it is and have tried everything. the very odd part is that Dreamweaver does recognize the table and table colums upon the recordset test, but finds no values in the table. I think somehow someway there is some setting in Oracle now that is stopping it from storing table values. A long shot but I am at a loss. Thanks again for your help.

 

[Reesy]

are you using any variables in your sql? Blood, Sweat But No Tears!

 

[kophjager]

No. I am not using variables. I was just doing a simple select * from Table_Name and it would say that there was no data when I would hit the test button. The column names would show up and it had the correct columns but no data.