So would the syntax be... table.fieldname LIKE %<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value=#client.SectionFilter#>%
? Cheers, --------------------------------------- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --------------------------------------- ---------- Original Message ---------------------------------- from: "Scott Brady" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Thu, 26 Dec 2002 17:29:42 -0700 >>Is there a way to put something like the following SQL WHERE smt into a cfqueryparam >and have it still behave as expected? >> >>table.fieldname LIKE '%#form.SearchText#%' > >I believe I've done that many times, so I'd say yes. > >Scott >-------------------------------- >Scott Brady >http://www.scottbrady.net/ > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
