Actually, I'd better clarify that comment. The bug only affects values with apostrophes being inserted into or updating the database. So it wouldn't be a factor in this case.
Besides, the whole reason for prepending the variable with a wildcard is to deal with anything that might precede the value, even whitespace. Matthew, have you tried outputting the form value just before you run the query? And, if you have debugging on, what does your parsed SQL statement look like? ~Dina ----- Original Message ----- From: "Dina Hess" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, March 13, 2003 2:39 PM Subject: Re: like %whatever% doesn't work in access? > Not if he's using MX. Bug. > > ----- Original Message ----- > From: "Jeff" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Thursday, March 13, 2003 2:24 PM > Subject: Re: like %whatever% doesn't work in access? > > > > on 3/13/03 3:21 PM, Dina Hess at [EMAIL PROTECTED] wrote: > > > > > Really? > > > > > > I use that syntax with Access and don't have a problem: > > > > > > t.summary LIKE <CFQUERYPARAM CFSQLTYPE="CF_SQL_LONGVARCHAR" > > > VALUE="%#form.txtsearch#%"> > > > > > > ~Dina > > > > You think maybe he should try wrapping it in a trim() function? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
