ID: 10980 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: ODBC related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: ODBC related should not be reported as MSSQL related. Furthermore I think we need some more information about this error. Are you getting other results than expected ? What is 'result' ? You dont have any variables in the code with that name. If 'result' is the output from odbc_num_rows() we need to know the structure of the table and what you expect from your data. Previous Comments: --------------------------------------------------------------------------- [2001-05-21 02:57:59] [EMAIL PROTECTED] //error source $connid=odbc_connect('odbc_db','odbc_user','odbc_pswd'); $sql='select id from bt_article where id<>978'; $row=odbc_do($connid,$sql); echo odbc_num_rows($row); //result -1 //if $sql='select title from bt_article where id<>978 order by id'; //result is ok //if $sql='select title from bt_article where id=978 order by id'; //result -1 --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10980&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]