MSSQL's Query Analyzer and DBArtisan both have functionality that will generate INSERT statements from a table. Saves a ton of time, I would hate to have to write every insert from scratch... I'm sure one of the MySQL frontends does something similar.
-- jon mailto:[EMAIL PROTECTED] Friday, December 27, 2002, 3:39:49 PM, you wrote: RF> I know it's good that I'm learning SQL better and writing my own code RF> for the updates and inserts instead of using CFUPDATE and CFINSERT... RF> I'm just in the throws of agony having to go through 200 pages of code RF> that I thought was finished and rewrite all the queries incorporating RF> better practices than I was using before... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm