Adam
We are doing something similar to this at the moment but using SQL Server.
We use the "systables" to define the names of the tables and columns in our
database so I guess if your looking for a generic solution you would have to
have a master table which defines the name of the "system tables" and their
"columns" on which the whole operation is based. This way the top level SQL
can also be dynamic.
Tim
-----Original Message-----
From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 09:42
To: Fusebox
Subject: SQL Help
I've written a tool that you point at a database resource and it
automatically generates all of the qry_insert qry_update qry_select
qry_delete files for each table. I'm also looking to expand it to generate
a simple two column table form for each table.
In Oracle I am using the USER_TABLES and the ALL_TAB_COLUMNS tables to get
the information. As we only work with Oracle this is not a problem BUT I
would like to expand it so that it can look at any datasource and retrieve
the table data.
So anybody able to help?
Best Regards,
Adam Reynolds
ColdFusion Web Developer
ISMG Development, Unilever
London
( +44 20 7822 5450 (ext 5450)
m: +44 7973 386620
* [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
