[PHP] RE: MSSQL 2000's 'real' type kills php

2002-05-14 Thread Mullin, Reginald
Jerome, I'd had a similar problem a few weeks ago (see http://marc.theaimsgroup.com/?l=php-generalm=101960285228542w=2). Try modifying your SQL statement like so: mssql_query(SET TEXTSIZE 2048 select inventory from products where code = 'FCA13'); O From Now 'Till Then, \-Reginald

[PHP] RE: MSSQL 2000's 'real' type kills php

2002-05-14 Thread Jerome Houston
Thank you for your reply. i can't tell if your solution works yet because PHP can't seem to handle multiple SQL statments in one call to mssql_query(). when i do what you said: mssql_query(SET TEXTSIZE 2048 select inventory from products where code = 'FCA13'); I get: Warning: Supplied