Does these ODBC_EXEC function changed their sintax in PHP4?
| From: | Andre Felipe | Date: | Thu, 07 Dec 2000 20:32:24 +0000 |
| Subject: | Does these ODBC_EXEC function changed their sintax in PHP4? | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-40490@lists.php.net to get a copy of this message | ||
Hi friends,
after some digging I've found that to compile PHP 4.0.2 (or 4.0.3PL1 or 4.0.4RC4) with Openlink
ODBC on Sun Solaris we must alter
php_odbc.c, changing:
"SQLINTEGER len" to "SDWORD len".
Ok, it now compiles. But ODBC functions that used to work in PHP 3.0.12 doesn't work anymore.
The following code gives the error:
Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in
SQLExecDirect in /software/apache/htdocs/aplic/teste/teste.htm on line 28
<?
$db = odbc_connect("DSN=Producao;UID=notes" , "" , "");
$query = "select nomefunc, matrica from srhtb002";
$result = odbc_exec ($db, $query); // THIS is line 28
print "ok. result = $result";
$nextrow = odbc_fetch_row($result, 1);
if (! $nextrow ) {
print "Nothing...<br>";
}
else {
print odbc_result($result , 1 );
print "<br>";
print odbc_result($result , 2 );
}
?>
Does these ODBC functions changed their sintax ????????