Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

[PHP-DB] Heterogeneous queries with mssql From: Gary Pullis (gpullis <email protected>)
Date: 05/15/01

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