RE: Error converting data type varchar to int.

[Robert Rawlins - Think Blue]

Right you are Jochem!

Here is the stored proc code:

CREATE PROCEDURE Sp_Credential_Create
        @User_ID        INTEGER,
        @Username       VARCHAR(128),
        @Password       VARCHAR(128)
AS
SET NOCOUNT ON
INSERT INTO Credential (User_ID, Username, Password)
VALUES  (@User_ID, @Username, @Password)

And here is the function that fires the stored proc.

<!--- Create Record --->
<cffunction name="create" access="public" output="false" returntype="void"
hint="I create a record in persistance">
        <cfargument name="UserID" required="true" type="numeric" hint="I'm
the user id for the profile to be inserted" />
        <cfargument name="Username" required="true" type="string"
hint="Username" />
        <cfargument name="Password" required="true" type="string"
hint="Password" />
        
        <!--- Create Temporary Local Structure --->
        <cfset var LOCAL = structNew() />
        
        <!--- Query To Create Record --->
        <cfstoredproc procedure="Sp_Profile_Create"
datasource="#VARIABLES.Instance.Datasource.getDatasource()#"
username="#VARIABLES.Instance.Datasource.getUsername()#"
password="#VARIABLES.Instance.Datasource.getPassword()#">
                <cfprocparam value="#ARGUMENTS.UserID#" variable="User_ID"
cfsqltype="cf_sql_integer" maxlength="128" />
                <cfprocparam
value="#VARIABLES.Instance.Cryptographer.getEncrypted(ARGUMENTS.Username)#"
variable="Username" cfsqltype="cf_sql_varchar" maxlength="128" />

                <cfprocparam
value="#VARIABLES.Instance.Cryptographer.getEncrypted(ARGUMENTS.Password)#"
variable="Password" cfsqltype="cf_sql_varchar" maxlength="128" />
        </cfstoredproc>
        
        <cfreturn />
</cffunction>

And finally the code that triggers the function.

<cfset VARIABLES.DAO.create(1, 'TestUser, 'TestPassword') />

Hope that all makes sense to you, it would be great to figure out what's
causing this.

Thanks,

Rob

-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: 14 June 2007 18:21
To: CF-Talk
Subject: Re: Error converting data type varchar to int.

Robert Rawlins - Think Blue wrote:
> 
> [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
> varchar to int.
> 
> This is a snippet of the query details thrown back in the error, it simple
> takes 3 parameters, the first is an integer and the second 2 are
> strings/varchar.
> 
> (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']
> 
> The param java types appear to match the cf_sql_type. These types also
match
> those defined inside the stored proc and the table columns, I can't see
> what's causing this issue.

If you don't include the stored procedure and CFML code neither can we :)

Jochem



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281239
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4