I know it's good that I'm learning SQL better and writing my own code for the updates and inserts instead of using CFUPDATE and CFINSERT... I'm just in the throws of agony having to go through 200 pages of code that I thought was finished and rewrite all the queries incorporating better practices than I was using before...
I was also forced to swap from Access to mySQL (which, I'll admit is a good thing... but would be better if mySQL supported SubSelects...it will in 4.2, I'm told) because of remote connectability at the last moment before deploying the app after months of work. It's all for good, ultimately...it just added quite a bit of work to a project that I thought was 95% complete. :o\ I'm almost done with the rewrite, and now I'm a better coder, to boot. :o) Rick -----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 2:02 PM To: CF-Talk Subject: RE: Best way to handle Checkboxes with Insert Query? I learned CF and SQL at the same time -- in fact, I learned SQL in order to do CF. My boss -- who had done SQL for a lot longer than he'd done CF -- responded to my inquiry about cfinsert like this: I don't know what the hell kind of code it produces, so I'll just write my own, thank you very much. At least that way, when it doesn't do what it should, I can fix it. I certainly agree that with something as easy to learn (or at least look up) as SQL, control is worth far more than ease of use. And, of course, for the kinds of SQL calls you do day in and day out, you can always save snippets. You know I did! --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : From: Everett, Al [mailto:[EMAIL PROTECTED]] : Sent: Friday, December 27, 2002 12:57 PM : To: CF-Talk : Subject: RE: Best way to handle Checkboxes with Insert Query? : : : > Using CFQUERY Insert Into and <cfqueryparam>'s sure is a lot : > more work than CFINSERT, : : It gives you better control. Two companies ago, our coding guidelines : specifically prohibited the use of CFINSERT and CFUPDATE. I'm glad, too, : because I learned to write better SQL. : : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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