On Mon, 31 Mar 2003 21:13:41 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
> >
> > I have discovered that it is the placement of single quotes around
> > the key value in the query:
> >
> > > my $rth = $dbh->prepare("SELECT * FR
On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
>
> I have discovered that it is the placement of single quotes around the
> key value in the query:
>
> > my $rth = $dbh->prepare("SELECT * FROM demographics_1 WHERE
> > KEY1=$key");
>
> that makes the difference. The abov
On Mon, 31 Mar 2003, Michael A Chase wrote:
> > Anyway, you should probably be using placeholders.
>
> Or if placeholders are absolutely unavailable, $dbh->quote().
> Both are described in the fine DBI manual.
Just curious. Are there any drivers that don't support placeholders? If
so which on
On March 31, 2003 10:41 am, Ronald J Kimball wrote:
> On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
> > I have discovered that it is the placement of single quotes around the
> >
> > key value in the query:
> > > my $rth = $dbh->prepare("SELECT * FROM demographics_1 WHERE
> >
On Mon, 31 Mar 2003 12:41:48 -0500 Ronald J Kimball <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
>
> > I have discovered that it is the placement of single quotes around the
> > key value in the query:
> >
> > > my $rth = $dbh->prepare("SELECT
On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
> I have discovered that it is the placement of single quotes around the
> key value in the query:
>
> > my $rth = $dbh->prepare("SELECT * FROM demographics_1 WHERE
> > KEY1=$key");
>
> that makes the difference. The above
On Mon, 31 Mar 2003 17:05:28 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2003 at 09:40:24AM -0600, Michael Muratet wrote:
> > On Mon, 31 Mar 2003 10:07:55 +0100
> > Tim Bunce <[EMAIL PROTECTED]> wrote:
> > > > The same query from the command line takes 0.02 seconds. A
> > > > fact