Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: mayo
To: CF-Talk
Sent: Wednesday, March 24, 2004 1:42 PM
Subject: RE: show tables in cold fusion
I suppose in all databases. (Access, MySQL, MS SQL are what I use most
often.) Ben answered for SQL. (thank you)
I'm thinking of setting up a little app to be able to administer my
databases remotely.
The basic is to be able to see the tables (show tables) and the fields
within (describe [table]).
Too many ISPs I'm looking at want the user to install phpmyadmin and the
like.
I just got frustrated and felt that if I'm going to have that trouble I
might as well solve the problem once and for all.
Gil Midonnet
-----Original Message-----
From: Steve Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 4:15 PM
To: CF-Talk
Subject: RE: show tables in cold fusion
What database? In SQL it's sp_tables. then you could cfdump it in CF.
Steve Nelson
-----Original Message-----
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 4:01 PM
To: CF-Talk
Subject: show tables in cold fusion
OK,
I'm having a bad day. I've googled to no avail for the last half hour.
How
do you do a
show tables;
describe [table];
within CF?
thx,
Gil
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
