Mailing List Archive


Back to the month index Back to the list index
bob basques (blammo@win.bright.net)
Tue, 7 Jan 1997 23:53:26 -0500 

Message-Id: <v02140b03aef8d8b18aeb@[208.140.3.173]>
Date: Tue, 7 Jan 1997 23:53:26 -0500
From: blammo@win.bright.net (bob basques)
Subject: Re: [mSQL] perl/msql

>Greetings,
>
>You may use the ListTables method from the CGI module to get a list of
>all the tables in the database currently selected:
>
>@tables = $dbh->ListTables();
>
>HTH.
> -vlad.

Thanks, but . . . let me explain further.

I'm using MSQL to access some databases, some exist, some don't (yet), some
may never exist, in most instances I'm not going to know which tables are
going to be queried until I get some input from a script built in perl that
is hooked to a graphical interface (GIS oriented), in other words each
table name corrosponds to a geographic area, so i don't know which area,
table name, is going to be queried until it is time to make the query. I
subsequently need some way of telling wether a table exists or not, or be
able to read an error returned from MSQL when a query is made on a table
that does not yet exist to tell the user "no data available" or some such.

I've thought of making a complete coverage of empty tables, there are about
three hundred of them, but there are going to be more overlays in the
future of each area . . . so, help!

Thanks again.

bobb

>
>--
>Vladimir Mukhin vladdy@nynow.com
>Webmaster/UNIX Specialist vladdy@pantheon.yale.edu
>New York Now (www.nynow.com) Use finger(1) for more info.
>Opinions expressed herein are not necessarily my own.
>
>On Tue, 7 Jan 1997, Bob Basques wrote:
>
>> people,
>>
>> Is there a way from within Perl, to tell if a Table Name exists within a
>> MSQL Database, am I stuck with using "relshow" or is there a some type
>> of SQL query that will work?
>>
>> Thanks in advance.
>>
>> bobb
>>
>>
>> --
>> Bob Basques
>> bob.basques@stpaul.gov - WORK
>> blammo@win.bright.net - HOME
>> www.stpaul.gov - 3rd of a bunch of (Volunteer) Webmasters
>> bridges.stpaul.gov - Webmaster
>> 25 W. 4th St. PHONE (612)266-6188
>> 900 C.H.A. Bridge Div. FAX (612)292-6315
>> St. Paul, Mn. 55102
>> --------------------------------------------------------------------------
>> To remove yourself from the Mini SQL mailing list send a message containing
>> "unsubscribe" to >> "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
>> "info msql-list" to majordomo@bunyip.com for info on monthly archives of
>> the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!
>>

bob basques

bob.basques@stpaul.gov, blammo@win.bright.net

City of St. Paul, Mn.

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!