Re: Quote "draft"
| From: | Tomas V.V.Cox | Date: | Wed, 11 Jul 2001 11:57:58 +0000 |
| Subject: | Re: Quote "draft" | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-632@lists.php.net to get a copy of this message | ||
Stig Bakken wrote:
>
> uhm, why do we really need this placeholder? there's no "db independent"
> function layer and such, right?
>
Yeah and also it a little bit silly to have a placeholder for functions
who won't change:
insert into foo (?, ? ,!) => array(1, 'bar', 'now()');
when you could simply do:
insert into foo (?, ? , now()) => array(1, 'bar');
But for apps that build queries, binary data, etc. this placeholder
could be the solution. Do you think it so?
Tomas V.V.Cox
> On Tue, 10 Jul 2001, Tomas V.V.Cox wrote:
>
> > Minor change to the draft:
> >
> > >
> > > - Add a new placeholder char, for example "#" (please propose others). A
> > > value in the position of a "#" should be returned without changes (for
> > > example to not escape native SQL functions: insert into date ('id',
> > > 'date') values (?, #) with an array => (1, NOW())).
> > >
> >
> > yavor shahpasov, warn me about the probably risk of using the SQL
> > comments char as placeholder, so I propose the new one "!" for this.
> > Also the example I gave have a bug, it should be:
> > insert into date ('id', 'date') values (?, #) with an array => (1,
> > "NOW()")
> >
> >
> > Tomas V.V.Cox
> >