I'm still confused. Are you explaining why it isn't working? I'm am having trouble understanding where to adjust to make this work. I figured since it's already encrypted in the database, I'd encrypt the form information, capitalize both and then search - at least that's what I tried and it didn't work. How do I then get "Bob" to find "BOB"?
> On Wednesday 01 November 2006 17:58, Daniel Kessler wrote: > > AND UPPER(meeting_name) LIKE <cfqueryparam value="%#encrypt(UCase > > (Form.meeting_name),the_key)#%" cfsqltype="cf_sql_varchar"> > > Imagine encrypt(name,key) is '5HIO' if name is 'Bob', and '7HJL' if > name > is 'BOB' > You're saying: > '5HIO' LIKE '%7HJL%' > > -- > Tom Chiverton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
