Is there a way to set the ANSI_NULLS and ANSI_WARNINGS options when using
mssql_connect(), etc., to connect to an MS SQL server database?

I'm trying to execute the following query via PHP:

select R.Rank, CS.ACCOUNTNO, R.Path from 
     openquery(Resumes,
          'SELECT Rank, Path, FileName from SCOPE() 
          where contains(contents, ''unix'') ' ) as R,
     CONTSUPP as CS
     WHERE (CS.Address1=R.Path and CS.RecType='L')
               order by R.Rank Desc


Thanks muchly!

----
Gary Pullis
Supporting: Sage MAS90/MAS200 | Linux | Windows NT | Novell Netware
Office Management Technologies
http://www.clwares.com  

Reply via email to