Thanks for the tip, Jon. I'll check that out. I'm currently using PremiumSoft's "Navicat" frontend. It's doing a good job. I haven't had time to explore its finer functions... (I have found out it doesn't handle replication through its interface. That's something I have to tackle next, and was hoping it would help. That won't happen until the next version tech support said
Rick -----Original Message----- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 5:01 PM To: CF-Talk Subject: Re: Best way to handle Checkboxes with Insert Query? 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 Get the mailserver that powers this list at http://www.coolfusion.com