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
