DatabaseBlocks from CommerceBlocks http://www.commerceblocks.com/ already
does a lot of this for you!
However, from the developer's perspective, I think they use COM calls to
the ColdFusion RDS server, which gives you a universal way to list and
represent all the the tables and field names and field types for any ODBC
database source.
At 04:42 AM 5/8/01, Adam Reynolds wrote:
>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
