Re: impatient DBI query

2007-10-31 Thread usenet
On Oct 31, 5:20 am, [EMAIL PROTECTED] (Beginner) wrote: > SELECT foo FROM bar WHERE foo like 'baz%' If you are gonna make multiple queries then you should save a prepared statement handle as Jeff showed you. But if this is a one-off query then you can use one of the DBI shortcut methods (untested

Re: impatient DBI query

2007-10-31 Thread Beginner
On 31 Oct 2007 at 0:00, Jeff Pang wrote: > > > -Original Message- > >From: Beginner <[EMAIL PROTECTED]> > >Sent: Oct 31, 2007 9:20 PM > >To: beginners@perl.org, beginners@perl.org > >Subject: impatient DBI query > > > >Hi, > &g

Re: impatient DBI query

2007-10-31 Thread Jeff Pang
-Original Message- >From: Beginner <[EMAIL PROTECTED]> >Sent: Oct 31, 2007 9:20 PM >To: beginners@perl.org, beginners@perl.org >Subject: impatient DBI query > >Hi, > >I have ordered my Perl DBI book (is that a leopard?) but I am >impatient and want to

impatient DBI query

2007-10-31 Thread Beginner
Hi, I have ordered my Perl DBI book (is that a leopard?) but I am impatient and want to know how I could do a select/like statement a bit like this: SELECT foo FROM bar WHERE foo like 'baz%' the % being the wildcard operator. Any advice? Dp. -- To unsubscribe, e-mail: [EMAIL PROTECTED] Fo