Hi Dean, These are a few snippets from the error dump.
{call Sp_Profile_Create( (param 1) , (param 2) , (param 3) )} And (param 1) = [type='IN', class='java.lang.Integer', value='1', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.String', value='07C67BA421500B791090E92F4C3D7032', sqltype='cf_sql_varchar'] , (param 3) = [type='IN', class='java.lang.String', value='D5534BDE55CAB29E3932D6CE4F211C34', sqltype='cf_sql_varchar'] Thanks for your help with this, would be nice to get this wrapped up before i head home after what seems like a REALLY long week lol. Rob -----Original Message----- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: 15 June 2007 17:29 To: CF-Talk Subject: Re: Error converting data type varchar to int. On 6/15/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > Thanks Dean, > > That was just a typo on my part, the actual code I've been testing with has > the quote after it. Looking at the SQL code in the error message those > strings seem to encrypt fine as well. > Yea, I figured it probably was. But, it was worth a shot. Have you tried dumping the error scope and seeing what the actual SQL query is? It should be located in the ERROR[RootCause].[Sql] structure. Dean -- __________________________________________ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4