MSSQL Ansi Warnings Blah...

[Spudgun]

Hi all

I've had a look through the manual and this forum, but couldn't find the answer I'm looking for... so please help!

I have a view over an MSSQL db, and within the view are some calculated fields. some of the calculations are resulting in a divide by zero error - which you can get around in query analyser etc using the set ansi_warnings off command.

But - when I try to include this command in my query before the select statement, nothing happens.

e.g.

$repqry= "set nocount on set ansi_warnings off select * from vwxobpromo ";

When I try to loop through the records, none have been selected. Can anyone please tell me if I'm doing something wrong?

Thanks a lot

[tomhath]

Try each "set" in a separate query. It should remain in effect as long as you have the connection.