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
