Why does the old photo remain in my blog after being replaced by a new one?
Fw: How to Retrieve Table Name from Statement Handle
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > Perl web-programming > Fw: How to Retrieve Table Name from Statement Handle 8 May 2008 23:26:34
  Recent blog posts: 
real ventures
My prayer for u: Starting from today, you are moving from glory to glory; anything you lay your hands on…

Of Gold and Current Trends
Gold still hovers over the $860/oz mark. As usual, whenever such a price spike occurs -- and they do not…

Handpunch
if any one want to know about handpunch programming(Rsidll3­­2.dll), plz contact me. Hi hairul…

My Best Person
Hello, I have some one whom i love very much. Love beyond anyone cud think of . This brother of mine…

The valley of life
I WALKED THROUGH THE VALLEY OF LIFE THE VALLEY WAS FILLED WITH ROSE LIFE SEEMED TO BE BEAUTIFUL BUT…

A Poem by Gloria Oelman
:-)­ I knew You once in all your glory When I was unafraid And had no guilt to block Your…

Watch out the network trap
I wonder if everybody notice recent in the msn, our window have nothing to be different? Anyway I am…

RSIDLL32.DLL
Hi All, I done a programme for HandPunch device using RSIDLL32.DLL. I can establish a connection with…

Not until we see there fear !!!
"Can you smell that" I asked my friend as the car lurched forward and sped off into the night…

locking a cell dependant upon…
Hi I have a sheet full of look ups, charts etc. that I have designed for managing projects and…

  They have birthday today: 
islamsabri
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
DBD::Oracle, InstantClient…
Hello, I'm trying to get the Oracle InstantClient to work so we can connect to some remote data…

DBI->connect Error
A very simple script: #!/usr/bin/perl -w use strict; use DBI; my $dbname = "test"; my $host…

DBD::ODBC and cancel()
(DBI 1.604, DBD::ODBC 1.15, WinXP, AS 5.8.8) I'm trying to test cancel of long running queries via…

DBD::ODBC 1.16 uploaded to CPAN
Hi, I have just uploaded DBD::ODBC 1.16 to CPAN. This release contains the following changes: =head1…

ANNOUNCE: IBM Informix Database…
IBM Informix Database Driver for Perl DBI Version 2008.0513 (2008-05-13) has been uploaded to CPAN…
  Recent forum topics: 
Register Globals &…
I'm converting old code to work with Register globals turned off in php.ini. With it on…

[JBoss jBPM] - Problem during…
Hello all, I want to deploy a very simple process in jbpm Bpel. I could configure and test helloworld…

DBD::Oracle, InstantClient…
Hello, I'm trying to get the Oracle InstantClient to work so we can connect to some remote data…

DBI->connect Error
A very simple script: #!/usr/bin/perl -w use strict; use DBI; my $dbname = "test"; my $host…

DBD::ODBC and cancel()
(DBI 1.604, DBD::ODBC 1.15, WinXP, AS 5.8.8) I'm trying to test cancel of long running queries via…
  Recent forum comments:
RE: Re: Convert .exe to .html Is…
no -appledyl

RE: Register Globals &…
You are working with Register globals turned off, so try…

RE: [JBoss jBPM] - Problem during…
]:-)­ same with me.... r u working on jBPM BPEL

RE: DBD::ODBC and cancel()
Tim Bunce wrote: Thanks for that - as Tim says it is a bug, cancel is not just for select statements…

RE: neopets hacking
Wtf??! Yew just wanna get referrals and prizes don't think I don't knoe that it's not gonna work pplz…

RE: DBD::ODBC and cancel()
On Wed, May 14, 2008 at 03:12:27PM -0700, Dean Arnold wrote: I don't think it should be checking the…

RE: Cannot see AND Windows system…
Steven Perreau wrote: Is this a 64 bit windows machine? I only ask because on 64 bit windows there are…

RE: DBD-ODBC and DBI 1.21
Hi Beadles: "ppm install DBD-ODBC.ppd -nodeps" worked for me also. thanks for the trick…

RE: Cannot see AND Windows system…
Here's the code that does this, maybe some guru can see something wrong! #!/usr/bin/perl # # This…

RE: DBI::_new_handle leak?
On Fri, May 09, 2008 at 11:31:46AM -0500, James R. Leu wrote: You've two choices: cut-down or…
  Moderators:
 Administrator
 Protorioris

Fw: How to Retrieve Table Name from Statement Handle

Lamb Joseph 8 May 2008 23:26:34
 To answer you question, for an Oracle environment I would like $sth->{TABLENAME} to contain a list.

my $tablename = $sth->{TABLENAME} ->[0] = First table
$tablename $sth->{TABLENAME} ->[1] = Second table

The $tablename value will be schema.tablename format.
For example:
schema.narf
schema.zord

Joseph Lamb


----- Forwarded Message ----
From: Alexander Foken <alexander@foken.de­>
To: Lamb Joseph <joseph_lamb@yahoo.­com>
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, 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. 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_FIELD­S} columns\n";
but like this
print "SQL statement table name is $sth->{TABLENAME} \n";
Joseph Lamb
___________________­____________________­____________________­____________________­_____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo­.com/;_ylt=Ahu06i62s­R8HDtDypao8Wcj9tAcJ


--
Alexander Foken
mailto:alexander@fo­ken.de http://www.foken.de­/alexander/


___________________­____________________­____________________­____________________­_____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo­.com/;_ylt=Ahu06i62s­R8HDtDypao8Wcj9tAcJ

OptionsAdd comment
Lamb Joseph 7 May 2008 23:41:01 [ permanent link ]
 I will have to break apart the SQL statement with a regex and store it that way.

Thanks for the input.

Joseph Lamb


----- Forwarded Message ----
From: Jonathan Leffler <jonathan.leffler@g­mail.com>
To: Lamb Joseph <joseph_lamb@yahoo.­com>
Cc: dbi-users@perl.org
Sent: Wednesday, May 7, 2008 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 <joseph_lamb@yahoo.­com> 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 handle?
Similar to print "SQL statement contains $sth->{NUM_OF_FIELD­S} columns\n";
but like this
print "SQL statement table name is $sth->{TABLENAME} \n";


Over and above Alexander's cogent (but gentle - the SQL could have been a
lot more complex than that) rebuttal, there's another question for you:

How did you decide which table to build the 'SELECT * FROM $table' query
from?
Can't you keep tabs on the table name from that?

(Succinctly - no, you can't tell the table name from the statement handle
because, in general, there isn't a single table name to report.)

--
Jonathan Leffler <jonathan.leffler@g­mail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org­
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."



___________________­____________________­____________________­____________________­_____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo­.com/;_ylt=Ahu06i62s­R8HDtDypao8Wcj9tAcJ

Add comment
Jonathan Leffler 7 May 2008 23:48:56 [ permanent link ]
 On Wed, May 7, 2008 at 12:37 PM, Lamb Joseph <joseph_lamb@yahoo.­com> wrote:

To answer you question, for an Oracle environment I would like
$sth->{TABLENAME} to contain a list.
my $tablename = $sth->{TABLENAME} ->[0] = First table
$tablename $sth->{TABLENAME} ->[1] = Second table
The $tablename value will be schema.tablename format.
For example:
schema.narf
schema.zord


So, what do you expect from a more complex statement, such as one which
includes multiply nested sub-queries in the FROM clause, with renaming
operations?

SELECT * FROM table1, (SELECT * FROM (SELECT * FROM ...) AS renaming) AS
renaming2 OUTER JOIN (...) ...

And who do you expect to do the parsing of your SQL? On average, the DBD
driver shouldn't have to, and the average database server won't tell you,
so... Also, don't forget that any of the names could be a reference to an
arbitrarily complex view -- what should be returned then?

I'm sorry, but I don't think you are going to get the information, unless
some DB server is willing to give that information to the driver.

I've seen your response to my other post:
I will have to break apart the SQL statement with a regex and store it
that way.
Question: how do you know that it is query using a single table - as your
original question posited?


I won't lambast 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 <alexander@foken.de­>
To: Lamb Joseph <joseph_lamb@yahoo.­com>
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, 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. 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_FIELD­S}
columns\n";
but like this
print "SQL statement table name is $sth->{TABLENAME} \n";
Joseph Lamb
___________________­____________________­____________________­____________________­_____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo­.com/;_ylt=Ahu06i62s­R8HDtDypao8Wcj9tAcJ
--
Alexander Foken
mailto:alexander@fo­ken.de http://www.foken.de­/alexander/
___________________­____________________­____________________­____________________­_____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo­.com/;_ylt=Ahu06i62s­R8HDtDypao8Wcj9tAcJ



--
Jonathan Leffler <jonathan.leffler@g­mail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org­
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
Add comment
Steve Baldwin 8 May 2008 00:11:23 [ permanent link ]
 You may be able to use the explain plan functionality in Oracle to
obtain the tables participating in a SELECT statement.

Steve

On Wed, 2008-05-07 at 12:48 -0700, Jonathan Leffler wrote:
On Wed, May 7, 2008 at 12:37 PM, Lamb Joseph <joseph_lamb@yahoo.­com> wrote:
To answer you question, for an Oracle environment I would like
$sth->{TABLENAME} to contain a list.
my $tablename = $sth->{TABLENAME} ->[0] = First table
$tablename $sth->{TABLENAME} ->[1] = Second table
The $tablename value will be schema.tablename format.
For example:
schema.narf
schema.zord
So, what do you expect from a more complex statement, such as one which
includes multiply nested sub-queries in the FROM clause, with renaming
operations?
SELECT * FROM table1, (SELECT * FROM (SELECT * FROM ...) AS renaming) AS
renaming2 OUTER JOIN (...) ...
And who do you expect to do the parsing of your SQL? On average, the DBD
driver shouldn't have to, and the average database server won't tell you,
so... Also, don't forget that any of the names could be a reference to an
arbitrarily complex view -- what should be returned then?
I'm sorry, but I don't think you are going to get the information, unless
some DB server is willing to give that information to the driver.
I've seen your response to my other post:
I will have to break apart the SQL statement with a regex and store it
that way.
Question: how do you know that it is query using a single table - as your
original question posited?
I won't lambast 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 <alexander@foken.de­>
To: Lamb Joseph <joseph_lamb@yahoo.­com>
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, 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. 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_FIELD­S}
columns\n";
but like this
print "SQL statement table name is $sth->{TABLENAME} \n";
Joseph Lamb
___________________­____________________­____________________­____________________­_____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo­.com/;_ylt=Ahu06i62s­R8HDtDypao8Wcj9tAcJ
--
Alexander Foken
mailto:alexander@fo­ken.de http://www.foken.de­/alexander/
___________________­____________________­____________________­____________________­_____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo­.com/;_ylt=Ahu06i62s­R8HDtDypao8Wcj9tAcJ



*******************­********************­********************­*******
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.

If you receive this email in error please immediately notify the
sender and delete the email.
*******************­********************­********************­*******


Add comment
Bart Lateur 8 May 2008 23:26:34 [ permanent link ]
 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/pa­rsing.html

which discusses using a tokenizer (lexer) to pull tokens, such as table
names, out of SQL statements.

--
Bart.

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > Perl web-programming > Fw: How to Retrieve Table Name from Statement Handle 8 May 2008 23:26:34
see also:
Mod_rewrite help
Apache behaviour for bad HTTP headers
Exact behaviour of KeepAliveTimeout
see also:
Bizarre 404 errors
Limiting space.
Limiting User on a Virtual Site
see also:
Authentication and Redirect...
odd log entry
2.x and mod_ssl
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
You can find the help and FAQ in the Admin's blog.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .