RE : PHP 4 + Freetds 0.60 + SQL Server 2000

In fact we use a debian SARGE OS with the 0.61 package for freetds.

I'm not administrator but it seems difficult to updgrade.

So, I would to know if my problem is a known bug or if it's a fonctionnality
evolution.

Thanks a lot

-----Message d'origine-----
De : ZIGLIO, Frediano, VF-IT [mailto:Frediano.Ziglio@xxxxxxxxxxxx] 
Envoyé : lundi 13 septembre 2004 17:06
À : FreeTDS Development Group
Objet : RE: [freetds] PHP 4 + Freetds 0.60 + SQL Server 2000

> 
> Hello,
> 
> Since 2 years ago we use freetds 0.52 to connected between PHP and SQL
> Server.
> 
> Due to problem with the euro character (€) we upgrade to Freetds 0.60.
> 
> But now we've got a big problem with the php function mssql_query or
> mssql_fetch_array.
> 
> When my query return an empty result the link identifier 
> return 1 instead of
> a true link identifier (# XX)
> 
> 
> Do I need to upgrade again or any other idea.
> 
> Thanks and excuse for my poor english
> 
> Cedric
> 
> 
> **************
> * in my code *
> **************
> echo 'first query';
> $sql = "select COLONNE_1 from MY_TABLE where 1=1";
> $rs = mssql_query($sql) or die($sql);
> echo $rs. '<br>';
> $row = mssql_fetch_array($rs);
> echo row["COLONNE_1"] . '<br>'. '<br>';
> 
> echo 'second query';
> $sql = "select * from MY_TABLE where 1=0";
> $rs = mssql_query($sql) or die($sql);
> echo $rs. '<br>';
> $row = mssql_fetch_array($rs);
> echo row["COLONNE_1"] . '<br>'. '<br>';
> 
> **************
> * it's write *
> **************
> first query
> Resource id #5
> TOTO
> 
> second query
> 1
> Warning: mssql_fetch_array(): supplied argument is not a 
> valid Sybase result
> resource in ......
> 

??
2 years ago we released 0.60, I don't understand why you choose 0.52
version... This year we release 0.62 (current it's 0.62.4 with some
additional fixes in CVS) and we are going to release 0.63 (famous last words
:) )... yes, I think it's time to try a new version :)...

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS@xxxxxxxxxxxxxxxxx
http://lists.ibiblio.org/mailman/listinfo/freetds