problems using freetds with php & unixodbc

Axel Westhagen <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hello,


I use freetds with php SQLServer2008 and unixodbc
generally it works great, but I have problems with errors and numeric fields with NULL values.

As example I use "SELECT SUM(FIELD) FROM VIEW".
-with tsql in commandline it works fine.
-with iodbc in commandline it works fine.
-with php I get a "No tuples available at this result index" error.

When I change the query to prevent NULLs with the COALESCE function it works with php too.
Is there a workaround for this behavior and what can I do for make the error messages readable?


thanks a lot

Axel
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.