What do you mean by 'execute' ? Can you give me a specific example of what you are talking about?
Dave -----Original Message----- From: Larry Schaberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2008 9:29 AM To: cf-newbie Subject: Re: Question on cfqueryparam CFMX7 and HEX Yes, so it sounds like it would go through to the database and execute if I am understanding correctly? >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 > >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:4084 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
