>I'm having a weird problem with ora_do. It works fine as long as I don't >have a "WHERE" clause in the query. For example: > >select * from table_name > >works just fine but .... > >select * from table_name where col_name = value > >returns nothing. > >However, if I use ora_open, ora_parse and ora_exec everything works fine. >I'm running on Compaq Tru64 ver 5.1. I compiled PHP with gcc 3.1. I'm not >getting any errors or warnings and nothing is being logged in the Apache >logs. I guess it's not a big deal since I have been able to work around it, >but it would be nice to know what the problem is.
Show us real source code... Nothing in what you say seems 'wrong', but who knows? Wild Guesses: You're not seeing any errors because you're not *ASKING* to see any errors. You have to specifically request error messages to be displayed or logged somewhere. You are doing something like: $x = 2; $query = "select * from table_name where col_name = x"; And, oddly enough, there are none with 'x' even though there are lots with 2... So, there's no problem with the query, it's just not the query you intended. Try printing out your query, and paste it into the Oracle command-line thingie (sql-dba?) -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
