Larry, <cfqueryparam> will treat hex as a 'varchar', so if your cfsqltype="cf_sql_varchar" on your <cfqueryparam> tag, then it will accept it, but it will do no conversion from hex to ascii, if that's what you're looking for. It doesn't see it as 'hex' but just as a simple string.
If your cfsqltype is cf_sql_numeric or cf_sql_integer, for example, then it WILL throw a hard error, IF the hex string has any letters in it. If it is only numbers, it will accept it, since it sees them as numeric or integer, but it will ignore any leading zeroes. Make sense? HTH, Dave -----Original Message----- From: Larry Schaberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2008 9:21 AM To: cf-newbie Subject: Question on cfqueryparam CFMX7 and HEX I was wondering if the <cfqueryparam> is able to convert hex into text and then go about doing what it does with normal text? I usually do an if statement in my Application.cfc to detect HEX exec,select,update,delete etc. If it does, then I do not need to do this anymore. Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4082 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
