els_p Posted March 13, 2008 Share Posted March 13, 2008 when I execute these statements: $road = 'A013'; $result = odbc_prepare($conn_id, "SELECT from, to FROM roads WHERE ident4 = ?"); odbc_execute($result, array($road)); I get this error message: Warning: odbc_execute() [function.odbc-execute]: SQL error: , SQL state 00000 in SQLExecute in /var/www/html/rapportering/events/kiesweg2.php on line 24 when I use odbc_prepare without ? like this: $result = odbc_prepare($conn_id, "SELECT from, to FROM roads WHERE ident4 = 'A013'"); odbc_execute($result); It gives me the correct results. How can I solve this? I already tried to get more error info with echo odbc_errormsg( $conn_id ); but this doesn't give me any extra info... Quote Link to comment https://forums.phpfreaks.com/topic/95923-odbc_execute-doesnt-work-with-variable-parameter/ Share on other sites More sharing options...
phoeniix Posted May 6, 2011 Share Posted May 6, 2011 I just read this was a bug fixed in PHP 5.2.2. Quote Link to comment https://forums.phpfreaks.com/topic/95923-odbc_execute-doesnt-work-with-variable-parameter/#findComment-1211734 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.