On Wed, 7 May 2008 12:41:01 -0700 (PDT), Lamb Joseph wrote:
>I will have to break apart the SQL statement with a regex and store it that
>way.
>
>Thanks for the input.
More input: take a look at Ovid's article "Lexing Your Data" on
perl.com, at
http://www.perl.com/pub/a/2006/01/05/par
this any further. Suffice to say, what you are asking for
> is incredibly non-trivial in the general case, and the general case has to
> work as well as the trivial.
>
>
>
> > ----- Forwarded Message
> > From: Alexander Foken <[EMAIL PROTECTED]>
> > To: La
non-trivial in the general case, and the general case has to
work as well as the trivial.
> - Forwarded Message
> From: Alexander Foken <[EMAIL PROTECTED]>
> To: Lamb Joseph <[EMAIL PROTECTED]>
> Cc: dbi-users@perl.org
> Sent: Wednesday, May 7, 2008 11:18:53 AM
>
12:22:06 PM
Subject: Re: How to Retrieve Table Name from Statement Handle
On Wed, May 7, 2008 at 10:51 AM, Lamb Joseph <[EMAIL PROTECTED]> wrote:
> I am creating a simple tool that will query one table and retrieve the
> data. Then this tool will turn the data into insert statements.
>
le:
schema.narf
schema.zord
Joseph Lamb
- Forwarded Message
From: Alexander Foken <[EMAIL PROTECTED]>
To: Lamb Joseph <[EMAIL PROTECTED]>
Cc: dbi-users@perl.org
Sent: Wednesday, May 7, 2008 11:18:53 AM
Subject: Re: How to Retrieve Table Name from Statement Handle
Hmmm,
On Wed, May 7, 2008 at 10:51 AM, Lamb Joseph <[EMAIL PROTECTED]> wrote:
> I am creating a simple tool that will query one table and retrieve the
> data. Then this tool will turn the data into insert statements.
>
> I was wondering if there was a way to retrieve the table name from the
> statement
Hmmm, and what do you think $sth->{TABLENAME} should contain after
executing the following SQL?
SELECT t1.foo,t2.bar FROM narf t1, zord t2 WHERE t1.ikes=t2.blurb
Alexander
On 07.05.2008 19:51, Lamb Joseph wrote:
I am creating a simple tool that will query one table and retrieve the data.
The
I am creating a simple tool that will query one table and retrieve the data.
Then this tool will turn the data into insert statements.
I was wondering if there was a way to retrieve the table name from the
statement handle?
Similar to print "SQL statement contains $sth->{NUM_OF_FIELDS} columns\