Okay, so this question pops into my mind. I use the CFMX ODBC Datasources page to set usernames and passwords for datasources, is there some logic (that I'm missing) to doing it again in my application.cfm? I do use variables in my datasource="" that are set in application.cfm, should I also be using usernames and passwords in my query calls, etc.?
Just wondering, would like to know if I'm doing something colossally stupid. ^_^ will ---- William H. Bowen Webmaster ALSTOM's T&D Energy Automation & Information Business "Your friendly neighborhood Webmaster!" [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX ----- Original Message ----- From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 6:14 AM Subject: Re: Big "dummy" flags > >What else? I don't know, maybe Deanna will chime in with what I normally do > that she has to clean up. :-) > > Nah, the stuff that Kevin normally doesn't do that I tell him to do are the > newer things that I haven't pounded into his head yet - like using > cfqueryparams (which is more of a "bonus - this coder knows something" flag > than a "dummy" flag). > > Some other dummy things: > Using static datasource names/usernames/passwords for your cfqueries. These > should always be variables that you set one place (Application.cfm or > something else that's included in the Application.cfm). If you've ever had > to change a database password without doing this, you'll know what I mean. > > Not using any caching anywhere - ie calling a query for a list of states > over and over, instead of caching it. If I recall correctly, the list of > states hasn't changed much in the last oh....50 or so years. > > Not checking for the existence of crucial variables (okay, Kevin does this > one, but I forget sometimes, too). In other words, you have an action page > that has to have a "recordid" passed to it. You forgot to either to set a > default or check to see if it is defined. > > Oh, that reminds me of another one - using really old deprecated tags - like > parameterexists(). I still see that in code occasionally. > > Enough. > -d > > > > > > Deanna Schneider > Interactive Media Developer > [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
