It did go through. Check the website, there have been several responses. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:54002
Thanks, Eric Ben Mueller wrote: > Posted this yesterday, but it didn't seem to go through... > > I became a convert to cfqueryparam, thanks to this list, about 2 months ago. > Since then, I've wondered about this kind of statement (shortened here): > > <cfquery> > > SELECT username > FROM user > WHERE lastname = <cfqueryparam type="varchar" value="#mylastname#"> > <cfif len(myfirstname)> > AND <cfqueryparam type="varchar" value="#myfirstname#"> > </cfif> > > </cfquery> > > Does the presence of the <cfif> block inside the SQL negate the speed > benefits I would get from using cfqueryparam? I'm kind of hoping not, but > guessing yes. > > Thanks in advance for the advice, > Ben Mueller > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4