TallyList : mailing list management, archiving, and analysis

Archive of:
Fusebox
Cold Fusion Fuse Box List

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About CF Fusebox Methods :
product's home
product's list home

Archived TallyList / Fusebox:
Subject: RE: SQL Help

Tim Price (21p/+0r) Posted: Tuesday 08 May 2001
This post: 59 views, +0 rating

The likelihood of the query returning the same column names from the system tables is None ! ................ Thats what I'm suggesting a master table to name the system table columns and then use a static set of alias's in the SQL query so that your always referencing your own defined system column names.

Does this make sense ? , not sure I'm explaining it well enough.

Tim

-----Original Message----- From: Adam Reynolds [mailto:Adam.Reynolds@unilever.com] Sent: 08 May 2001 11:33 To: Fusebox Subject: RE: SQL Help

Yup, As long as the query return the same named columns from whichever system tables, then there is no problem.

I've got it working under Oracle. I'm not sure how useful this would be as I rarely just run basic SQL, but as a code base to start from, it could save you a few days.

If anybody is interested, I can email the final version to people.

-----Original Message----- From: Tim Price [SMTP:TimPrice@btinternet.com] Sent: 08 May 2001 10:58 To: Fusebox Subject: RE: SQL Help

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:Adam.Reynolds@unilever.com] 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 * adam.reynolds@unilever.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/fusebox@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Similar Subject Line Posts (+/- two weeks of this post)

Re: SQL Help	08 May 2001	(155 v/ +0 r)
Re: SQL Help	08 May 2001	(67 v/ +0 r)
RE: SQL Help	08 May 2001 (this post)	(59 v/ +0 r)
RE: SQL Help	08 May 2001	(61 v/ +0 r)
RE: SQL Help	08 May 2001	(63 v/ +0 r)
RE: SQL Help	08 May 2001	(66 v/ +0 r)
RE: SQL Help	08 May 2001	(62 v/ +0 r)
SQL Help	08 May 2001	(59 v/ +0 r)

Send a reply to the Fusebox list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)