Re: DB_FETCHMODE_ASSOC result differs forMySQL and MS-SQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Gunther,

there was an error in the mssql.php file. I have just fixed that in cvs.

Change line 161 from

            $ar = @mssql_fetch_array($result);

to 

            $ar = @mssql_fetch_array($result, MSSQL_ASSOC);


And it will work on your system

- Frank


> I have a problem with PHP 4.3.0, latest PEAR running under w2k with
either
> MySQL or MS-SQL. With MySQL everything is fine, running the same
application
> just
> changing the DB server to MS-SQL I get different results.
> 
> I am using fetchRow(DB_FETCHMODE_ASSOC) to get my DB rows.
> Under MySQL (correct) a row would look like this:
> 'fieldname' => value    (e.g. [whateverfield] => 9 )
> 
> Under MS-SQL I get:
> 0 => value 'fieldname' => value (e.g. [0] => 9 [whateverfield] => 9 )
> 
> It seems that under MS-SQL DB_FETCHMODE_ASSOC AND DB_FETCHMODE_ORDERED
> are both on at the same time.
> 
> Any ideas how I get this working ...?
> 
> Gunther
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux