I am entering information into a database and on my INSERT command, I am encrypting it using a generated key and the encrypt() function. Now I wish to search on the information. I usually do an UPPER on both the search criteria the data in the field to assure that caps do not matter. IOW, 'Meeting' will also find 'meeting'. Now that the information is encrypted, I'm having trouble figuring out how to search for it and where to encrypt during the search
Need to adjust: AND UPPER(meeting_name) LIKE <cfqueryparam value="%#UCase (Form.meeting_name)#%" cfsqltype="cf_sql_varchar"> This finds nothing when it should find something, assuming it were correct: AND UPPER(meeting_name) LIKE <cfqueryparam value="%#encrypt(UCase (Form.meeting_name),the_key)#%" cfsqltype="cf_sql_varchar"> if the db data is not encrypted an neither is the query then the above code finds lots of entries. thank you. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4