The original was binary. Even tried int...
Perhaps this is one of those "funky" situations, I will go ahead and use
straight SQL..
Thanx, for the advice!
Eddie
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 3:29 PM
To: [EMAIL PROTECTED]
Subject: Re: ODBC error
What was the original datatype?
I second the notion of avoiding cfupdate.. the time saved by using it is
minimal
(15-30 seconds typically), and you end up losing time each time you find
yourself jumping through hoops to make it work. Besides, not using raw SQL
keeps you from leveraging the power of Transact SQL (which I value every bit
as
much as SQL Server's perfomance).
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
Shawn Cassedy wrote:
> Are you sure your dynamic input name("#bldgary[x]#") matches the value in
> the update tag (DeptY2k)? Also just for future development, CFupdate is
> notoriously funky and it's usually better to use CFQuery and a SQL update
> statement.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Phillips, Eddie
> Sent: Wednesday, March 28, 2001 2:41 PM
> To: '[EMAIL PROTECTED]'
> Subject: ODBC error
>
> Greetings all,
>
> I am getting the following ODBC error when trying to use CFUPDATE and
insert
> a value received from a checkbox in a calling page.
> ODBC Error Code = 22005 (Error in assignment)
> [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
> specification
> The error occurred while processing an element with a general identifier
of
> (CFUPDATE), occupying document position (91:3) to (91:127).
>
> Code
> Calling page:
> <input type="checkbox" name="#bldgary[x]#" value=1>
>
> <!--- note the above variable will be equal to DeptY2k--->
>
> CFUPDATE Page:
>
> <CFUPDATE DATASOURCE="IMM" TABLENAME="MBSiteInformation" username="xx"
> password="xxxxx" formfields="sitenumber, DeptY2k">
>
> I have tried changing the type of data in the SQL table to char, binary,
but
> still get the same message. I am running on Windows 2000 with a SQL 7
> backend. Through testing it appears to be simply passing a one, I can't
> figure out why it is not accepting it.
>
> Eddie Phillips
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
