Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:15547 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 657 invoked by uid 1010); 23 Mar 2005 00:59:38 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 642 invoked from network); 23 Mar 2005 00:59:38 -0000 Received: from unknown (HELO pb1.pair.com) (127.0.0.1) by localhost with SMTP; 23 Mar 2005 00:59:38 -0000 X-Host-Fingerprint: 203.22.197.21 houston.au.fhnetwork.com FreeBSD 4.6-4.9 Received: from ([203.22.197.21:3218] helo=houston.familyhealth.com.au) by pb1.pair.com (ecelerity HEAD r(5268)) with SMTP id 4D/90-27565-87FB0424 for ; Tue, 22 Mar 2005 19:59:36 -0500 Received: from houston.familyhealth.com.au (localhost [127.0.0.1]) by houston.familyhealth.com.au (Postfix) with ESMTP id AEBE724FE0; Wed, 23 Mar 2005 08:59:32 +0800 (WST) Received: from [192.168.0.40] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (Postfix) with ESMTP id 9836124FDD; Wed, 23 Mar 2005 08:59:32 +0800 (WST) Message-ID: <4240BFD5.9090605@familyhealth.com.au> Date: Wed, 23 Mar 2005 09:01:09 +0800 User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dan Scott Cc: php-dev References: <423F84AD.9070809@familyhealth.com.au> <027201c52ed8$8b369170$1200000a@intra.emini.dk> <42402D82.8000305@familyhealth.com.au> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] pdo_pgsql From: chriskl@familyhealth.com.au (Christopher Kings-Lynne) Hi Dan, What I mean is, will PDO happily parse this PostgreSQL statement and substitute the two variables correctly? SELECT '?', ? from "?" where ? = $_$?$_$; Chris Dan Scott wrote: > Hi Chris: > > As documented in http://www.php.net/manual/en/function.pdo-prepare.php: > > "The SQL statement can contain zero or more named (:name) or question > mark (?) parameter markers for which real values will be substituted > when the statement is executed." > > Anything beyond this would be an extension to the PDO spec that would > have to be implemented within the actual pdo_pgsql driver. > > Dan > > On Tue, 22 Mar 2005 22:36:50 +0800, Christopher Kings-Lynne > wrote: > >>>Most of the PDO interface is supported in pgsql driver. However we do not >>>use native pgsql prepare/execute but PDO's built in emulation for it. If you >>>could look into how could native api be used in pdo_pgsql that would be >>>great. >>> >> >>Ooer. How on earth do you simulate the parameter markers? Are they >>required to be '?'? Do you deal with dollar quoting, etc.? >> >>Chris >> >>-- >>PHP Internals - PHP Runtime Development Mailing List >>To unsubscribe, visit: http://www.php.net/unsub.php >> >> > >