From: [EMAIL PROTECTED]
Operating system: Linux Mandrake
PHP version: 4.0.4pl1
PHP Bug Type: ODBC related
Bug description: Freetds + iODBC problems retrivind numeric fields
I Have problems retrivind and printing fields type numeric and date.
Using iODBC to access SQL Server 7.0
My Configure Line:
./configure --prefix=/usr/local/matriz/php4
--with-apxs=/usr/local/matriz/apache/bin/apxs
--with-iodbc=/usr/local/matriz/iodbc --enable-track-vars
Script PHP:
<?php
putenv("LD_LIBRARY_PATH=/usr/local/freetds/lib/libtdsodbc.so");
putenv("ODBCINSTINI=/etc/odbcinst.ini");
putenv("ODBCINI=/etc/odbc.ini");
if ($con = odbc_pconnect("SQLSERVER","username","passwd")) { print
"Success!
<br>"; } else { print "Error connection <br>"; } // This line prints
"Success";
$sql = "SELECT * FROM contacts";
/* Contacts have 2 fields: Name (char) and Number (numeric) */
$prep = odbc_prepare($con,$sql);
if (odbc_execute($prep))
{
while (odbc_fetch_row($prep))
{
print odbc_result($prep,1); // Print correct name
print " - ";
print odbc_result($prep,2); // Print nothing, not return any error,
simply
prints ''
print "<br>\n";
}
}
else
{
print "Error executing query! <br>";
}
?>
--
Edit bug report at: http://bugs.php.net/?id=13286&edit=1
--
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]
