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...