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