Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
varchar to int.
The error occurred in
C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm: line 56
54 :cfprocparam type=In cfsqltype
: 17 September 2008 12:51
To: CF-Talk
Subject: Error converting data type varchar to int.
I keep getting an error that appears to be in my cfprocresult as
follows.
Any quick help would be greatly appreciated
I hope that I have included enough information for some help.
Thanks in advance
Thank You for the reply...
As shown before, my code is below...
What are you saying I need to do here?
I am still new to Stored Procedures and the use of them.
Larry
cftransaction
cfstoredproc procedure=sp_schol_ins
datasource=profilesandgo
cfprocparam type=In
Hi Larry,
You need to add a cfprocparam for every parameter as follows.
So your parameters are:
@name varchar(50) = NULL,
@schol_type_id int = NULL,
@scholarships_uid int = NULL,
@academic_uid int = NULL,
@tablename varchar(50) = NULL,
@Student_UID int = NULL
Therefore your call to the stored
: houseoffusion [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2008 8:42 AM
To: CF-Talk
Subject: RE: Error converting data type varchar to int.
Hi Larry,
You need to add a cfprocparam for every parameter as follows.
So your parameters are:
@name varchar(50) = NULL,
@schol_type_id int
the empty cfprocparams for the fields and set them to null=yes
Thanks for youyr help
Larry
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2008 8:51 AM
To: CF-Talk
Subject: RE: Error converting data type varchar to int.
The only parts
/cfstoredproc
I have added the check for NULL to each parameter that requires it
null=#NOT len(FORM.schol_type_id)#.
Later,
Niall.
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]
Sent: 17 September 2008 14:51
To: CF-Talk
Subject: RE: Error converting data type varchar to int
To: CF-Talk
Subject: RE: Error converting data type varchar to int.
I got it
cftransaction
cfstoredproc procedure=sp_schol_ins datasource=profilesandgo
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbVarName=Name value=#FORM.Sport# null
cftransaction
cfstoredproc procedure=sp_schol_ins
datasource=profilesandgo
...
/cfstoredproc
/cftransaction
Why do you have a CFTRANSACTION there? It doesn't seem to be doing anything.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides
deprecated, but made a welcome return in a
recent updater/CF8 I believe.
-Original Message-
From: Dean Lawrence [mailto:[EMAIL PROTECTED]
Sent: 18 June 2007 16:19
To: CF-Talk
Subject: Re: Error converting data type varchar to int.
Rob,
I think I remember what caused me to have this error
Thanks for your help on this Neil, It now works an absolute charm.
I owe you a pint.
Rob
-Original Message-
From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]
Sent: 19 June 2007 09:37
To: CF-Talk
Subject: RE: Error converting data type varchar to int.
I spoke with Rob, the fix
Rob,
I think I remember what caused me to have this error. Try removing the
variable attribute of the cfprocparam tags. If the variable names do
not explicitely match the variables defined in your stored proc, CF
will throw an error.
Variable names were depriciated in CFMX and were basically
by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sat Jun 16 21:32:59 2007
Subject: Re: Error converting data type varchar to int.
Hello Neil,
I'm running SQL Server 2005, and this is a create table script
our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sat Jun 16 21:32:59 2007
Subject: Re: Error converting data type varchar to int.
Hello Neil,
I'm running SQL Server 2005, and this is a create table script for you.
CREATE TABLE Credential
this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sat Jun 16 21:32:59 2007
Subject: Re: Error converting data type varchar to int.
Hello Neil,
I'm running SQL Server
this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 10:08:28 2007
Subject: Re: Error converting data type varchar to int.
Morning Niel,
Thanks for that info
are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 10:08:28 2007
Subject: Re: Error converting data type varchar to int.
Morning Niel,
Thanks for that info, I'm
-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 10:44:08 2007
Subject: Re: Error converting data type varchar to int.
Thanks N,
Ok, so it looks like that cumulative patch was already installed on the
box, I must have placed it on when I built the server and forgotten about
it, I've reinstalled
our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 10:44:08 2007
Subject: Re: Error converting data type varchar to int.
Thanks N,
Ok, so it looks like that cumulative patch was already installed on the
box, I must have placed
://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 10:44:08 2007
Subject: Re: Error converting data type varchar to int.
Thanks N,
Ok, so it looks like that cumulative patch was already installed on the
box, I must have placed it on when I built
.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 10:44:08 2007
Subject: Re: Error converting data type varchar to int.
Thanks N,
Ok, so it looks like that cumulative patch was already installed on the
box, I must
17 10:44:08 2007
Subject: Re: Error converting data type varchar to int.
Thanks N,
Ok, so it looks like that cumulative patch was already installed on the
box, I must have placed it on when I built the server and forgotten
about
it, I've reinstalled the patch and rebooted the box, So
.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 12:03:30 2007
Subject: Re: Error converting data type varchar to int.
Mate,
I've just spotted a few blog posts that 3.3 is the out of date version
which was listed a bug
this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 12:03:30 2007
Subject: Re: Error converting data type varchar to int.
Mate,
I've just spotted
-Talk
Sent: Sun Jun 17 12:13:52 2007
Subject: Re: Error converting data type varchar to int.
Hello Mate,
There are only 2 or 3 rows currently in the table, from where I've been
running the stored procs from SSMS.
Maybe it would be worth you trying to replicate the issue, I dont want you
to spend
Hi Neil,
I've just tried an in-line query and that appears to work just fine.
I'm unable to try the other elements as my SSMS seems to have decided to
forget my connection passoword so I cant get connected untill I'm in the
office, doh!
Rob
:11 2007
Subject: Re: Error converting data type varchar to int.
Hi Neil,
I've just tried an in-line query and that appears to work just fine.
I'm unable to try the other elements as my SSMS seems to have decided to
forget my connection passoword so I cant get connected untill I'm in the
office
Hi Neil,
I tried the truncate method and that didnt have any effect. I created a
new version of the proc as follows.
cfquery name=LOCAL.qUpdate datasource=SecurityModel
CREATE PROC Proc_Credential_Create
@User_ID INTEGER
: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 13:25:43 2007
Subject: Re: Error converting data type varchar to int.
Hi Neil,
I tried the truncate method and that didnt have any effect. I created a
new version of the proc as follows.
cfquery name=LOCAL.qUpdate datasource
Jun 17 13:25:43 2007
Subject: Re: Error converting data type varchar to int.
Hi Neil,
I tried the truncate method and that didnt have any effect. I created a
new version of the proc as follows.
cfquery name=LOCAL.qUpdate datasource=SecurityModel
CREATE
: Sun Jun 17 13:25:43 2007
Subject: Re: Error converting data type varchar to int.
Hi Neil,
I tried the truncate method and that didnt have any effect. I created a
new version of the proc as follows.
cfquery name=LOCAL.qUpdate datasource=SecurityModel
. The opinions expressed within
this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sun Jun 17 13:52:22 2007
Subject: Re: Error converting data type varchar to int
Sent: Sun Jun 17 15:31:47 2007
Subject: Re: Error converting data type varchar to int.
Thanks Neil,
It certainly is very odd, I have no idea what its doing, like you say with
that explicite string definition it should be fine.
I've sent a mail to my SQL guy to see whether he has any suggestions
in the cf that's causing the problem, it really is
most wierd.
Thanks for any further ideas you guys have on this.
Rob
-Original Message-
From: Dean Lawrence [mailto:[EMAIL PROTECTED]
Sent: 15 June 2007 22:41
To: CF-Talk
Subject: Re: Error converting data type varchar to int.
Rob
In the cfstoredproc call, for your int type you still have a maxlength
defined, which is only useful for strings:
cfprocparam value=#ARGUMENTS.UserID# variable=User_ID
cfsqltype=cf_sql_integer maxlength=128 /
Perhaps it's messing up the assignment to the int - try removing it.
On 6/16/07,
Hi James,
Thanks for the suggestion mate, I've tried changing that but still get the same
error. :-(
Thanks,
Rob
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: 16 June 2007 13:44
To: CF-Talk
Subject: Re: Error converting data type varchar to int
at http://www.reedexpo.com
-Original Message-
From: Robert Rawlins - Think Blue
To: CF-Talk
Sent: Fri Jun 15 10:56:00 2007
Subject: RE: Error converting data type varchar to int.
Right you are Jochem!
Here is the stored proc code:
CREATE PROCEDURE Sp_Credential_Create
@User_ID
-
From: Robert Rawlins - Think Blue
To: CF-Talk
Sent: Fri Jun 15 10:56:00 2007
Subject: RE: Error converting data type varchar to int.
Right you are Jochem!
Here is the stored proc code:
CREATE PROCEDURE Sp_Credential_Create
@User_IDINTEGER,
@Username VARCHAR
://www.reedexpo.com
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sat Jun 16 20:06:54 2007
Subject: Re: Error converting data type varchar to int.
Hi Neil,
Thanks for the tip on the name of sp's I didnt realize that was the case,
I'll rename them all from now on in, just to keep to the best
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Sat Jun 16 20:06:54 2007
Subject: Re: Error converting data type varchar to int.
Hi Neil,
Thanks for the tip on the name of sp's I didnt realize that was the case,
I'll rename them all from now on in, just to keep to the best
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
On 6/15/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
cfset VARIABLES.DAO.create(1, 'TestUser, 'TestPassword') /
Rob,
I don't know if this was just your typing into the email, but in the
above statement you did not place a closing quote after the second
value.
So instead it should
:[EMAIL PROTECTED]
Sent: 15 June 2007 13:52
To: CF-Talk
Subject: Re: Error converting data type varchar to int.
On 6/15/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
cfset VARIABLES.DAO.create(1, 'TestUser, 'TestPassword') /
Rob,
I don't know if this was just your typing
-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
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
Rob,
Hmmm, it certainly appears to be passing in an int and 2 strings. What
is killing me is that I know I had run up against this error in the
past, and for the life of me, I cannot remember exactly what the
problem was.
You may want to double check the field names and types that are
defined in
Hello guys,
I've got a stored proc that enters information into a table on my SQL Server
database, and I'm getting the following error message when trying to run it.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
varchar to int.
This is a snippet of the query
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
48 matches
Mail list logo