(You might get this twice...just posted it...but the mail server grumbled shortly thereafter... :) )
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: "Jeff" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, March 13, 2003 2:48 PM Subject: Re: like %whatever% doesn't work in access? > on 3/13/03 3:39 PM, Dina Hess at [EMAIL PROTECTED] wrote: > > > Not if he's using MX. Bug. > > > > Really? Trim()? Do explain...does it just bomb whenever you use it? Or just > in SQL? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
