--- Dave Watts <[EMAIL PROTECTED]> wrote: > > You mentioned about > > " > > <cfquery name="UpdStuff" ...> > > UPDATE mytable > > SET OrderEntry_Date = <cfqueryparam > > value="#Form.OrderEntryDate#" > > " > > But here, it's a SELECT statement, besides, > > Form.OrderEntryDate does not contain "_date". > > <cfquery name="GetStuff" ...> > SELECT OrderEntry_Date AS OrderEntryDate ... > </cfquery> >
The problem is it compromises efficiency, yes, we know that a tbl_column can be aliased into tbl_colas, suppose, in this situation, say, we have to dynamically determine the table name, now, I have to SELECT CASE WHEN THEN ... or something to that nature MUCH LESS EFFECIENT code-wise. And for Macromedia, to add "enable/disable these six rules from CF ADMIN" it should be fairly easy to do, why not???? > > You said "So, again, this isn't a bug. If you > design > > a database schema for use with a CF application", > > the fact is, in lot of cases, databases are not > > designed for a particular client language, > database > > design is essentially based on business > requirements > > including business rules, it shouldn't and care > less > > what language will be used to interface with it. > > That's exactly what my argument was, one should > not > > attempt to "bend" a given database. > > That's true enough, but still not a big deal. You're > free to use one field > name in your database, and use another field name in > your HTML form. So, I > don't really see this as a serious problem - while I > generally would > recommend that you use the same names for your HTML > form fields as your > database columns, I'd make an exception in this > case. Well, making HTML form field name not to correspond with respective table column is a step toward 'misfortune'. > > Considering that this behavior has existed since CF > 1.5, I think, I suspect > it's unlikely to change any time soon. Your observation is true, however, you and other folks will be on my side to push Macromedia to do this little thing for the good of this community. Regards, Humble Don > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
