Heterogeneous queries with mssql

From: 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

« previous php.db (#9325) next »