And in response to your first question: "Is there a way to dynamically generate a database schema using CF?" have a look at http://databases.about.com/od/sql/a/sqlfundamentals_2.htm to learn more about DDL (I just googled and found this). You can plug DDL commands inside a <cfquery> tag.
Indy On 5/16/05, Shane Farmer <[EMAIL PROTECTED]> wrote: > It is probably lazy programming and as such bad practice but the cut down > version works as well. > > Straight from query analyser: > > exec sp_tables 'history' > go > > Shane --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To > unsubscribe send a blank email to > [EMAIL PROTECTED] Aussie Macromedia > Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
