faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower?
im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: <cfquery syntax Because it's safer and faster and is therefore considered best practice. -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: <cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problems....just wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: <cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use <cfqueryparam> The only exception you can make is for static values like "isActive = 1" or something. And even then you can't go wrong using them. -----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: <cfquery syntax I checked the database and there seems to be something wrong with the <cfqueryparam> because when I check the fields using SQL Query Analyzer there are question marks "?" in the fields which I think is an error trying to update the fields? Do I need the <cfqueryparam>? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: > Hi, > > What's wrong with the below syntax? I think the single quotes around > the "commalist" is throwing it for a loop? How can I get around this? > If I use double quotes I'll run into the same problem around the > "ListGetAt..." code. > > <cfquery name="Insert" datasource="prefs"> > UPDATE tblProfiles > SET > strSelect='<cfqueryparam value="#ListGetAt(commalist,1,'|')#" cfsqltype="CF_SQL_LONGVARCHAR">' > WHERE strUsername='#auth#' > </cfquery> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
