Mailing List Archive


Back to the month index Back to the list index
Jeff Carnahan (tails@hooked.net)
Tue, 07 Jan 1997 16:23:17 -0800 

Message-Id: <3.0.32.19970107162313.00a2cc94@mail.hooked.net>
Date: Tue, 07 Jan 1997 16:23:17 -0800
From: Jeff Carnahan <tails@hooked.net>
Subject: [mSQL] Re: perl/msql

At 08:59 AM 1/7/97 -0600, Bob Basques wrote:
>
>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?
>

You could try inserting a dummy entry inside the table, then doing a

SELECT * FROM table_name

and seeing if $[OBJECT NAME]->numrows; is over 1 (if your using MsqlPerl..)

then remember to delete the dummy entry when you're finished... 

--
Warmest Regards...
__________________________________________________________________
|       Terminal Productions          | Jeff Carnahan            |
| WWW, CGI & HTML Consulting & Design |     tails@hooked.net     |
|    http://www.terminalp.com/        |     tails@usa.net        |
|                                     |      jeff@terminalp.com  |
|_____________________________________|__________________________|
| Member of:     The HTML Writers Guild - http://www.hwg.org/    |
|       ISIP ("WEBPRO") Founding Member - http://www.webpro.org/ |
|                                                                |
| Jeff's CGI Scripts   --->    http://www.terminalp.com/scripts/ |
| HP Quake Clan Page   --->    http://www.terminalp.com/hp/      |
|________________________________________________________________|
--------------------------------------------------------------------------
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!