Heterogeneous queries with mssql
| From: | Gary Pullis | Date: | Tue, 15 May 2001 16:00:04 +0000 |
| Subject: | Heterogeneous queries with mssql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9325@lists.php.net to get a copy of this message | ||
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