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

Reply via email to