strange sybase results

"Florian Kornhoffer" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Organization LAUFWERK Systemhaus
Message-ID <1DB2B6344D6041B1A9D631B09A27EA34@PCFLORIAN>
Hi,


I have a very strange issue with a php site which calls a function
within the sybase database (SQL Anywhere 8)


The call itself is like this:

include "../connect.syb.php";
syb_connect();
$s = "SELECT RoutingGetVon ( 'KP111', 2, 'X', '55555' )";
$q = sybase_query($s);
$x = sybase_fetch_row($q);
$r = $x[0];


Depending on the values in the function I get an value back or and
that's my problem not.

Sounds as the function has an error, but doing the same SELECT in ISQL
it returns the propper value always.


Adding a 
if ($r == NULL) echo "NULL";
shows NULL for all the non results


So my questions are:
- what can be the difference in a result from the same function, which
one time is the same as in ISQL and with other values it is different to
ISQL result?
- is there a way to get the raw result data shown? Maybe
sybase_fetch_row() works buggy (I tried with sybase_fetch_array() - it's
the same result)?
- any other ideas or suggetions?


Thanks for any help
Florian
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.