application log:
"Error","1344","10/28/03","09:46:08",,"ODBC Error Code = 22005 (Error in
assignment)<P> [Microsoft][ODBC SQL Server Driver]Invalid character value
for cast specification<P><P> SQL = ""storeproc_SaveComment""
""Error","1344","10/28/03","09:46:08",,"172.16.91.52, Mozilla/4.0
(compatible; MSIE 5.17; Mac_PowerPC), ODBC Error Code = 22005 (Error in
assignment)<P><P> [Microsoft][ODBC SQL Server Driver]Invalid character value
for cast specification<P><P><p>The error occurred while processing an
element with a general identifier of (CFSTOREDPROC), occupying document
position (13:1) to (13:73).</p><p>The error occurred while processing an
element with a general identifier of (CFRETHROW), occupying document
position (246:11) to (246:21).</p><P><P>Date/Time: 10/28/03
09:46:08<BR>Browser: Mozilla/4.0 (compatible; MSIE 5.17;
Mac_PowerPC)<BR>Remote Address: 172.16.91.52<BR>HTTP Referrer:
http://k12.org/Grades.cfm?Fuseaction=RC.Comments String:
fuseaction=RC.SaveComment<P>"
Sounds like a simple invalid character situation- but I figure out how to
fix it.
This stored procedure/query has 2 fields. The cf code looks like this:
<CFTRANSACTION>
<CFSTOREDPROC PROCEDURE="storeproc_SaveComment"
DATASOURCE="#Request.maindsn#">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_INTEGER" DBVARNAME="@ComID"
VALUE="#Attributes.ComID#">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@Comment"
VALUE="#PreserveSingleQuotes(Attributes.Comment)#">
</CFSTOREDPROC>
</CFTRANSACTION>
AND then the actual stored proc is:
CREATE PROCEDURE storeproc_SaveComment
@ComID INTEGER,
@Comment varchar(2000)=Null
AS
UPDATE tbl_StudentComments
SET [EMAIL PROTECTED]
WHERE [EMAIL PROTECTED]
GO
I can't reproduce the error but it looks like one or two users had their
information cut off. And not at an obvious place (ie: where the apostrophe
is)
Any ideas? I'm stumped.
Thanks in advance!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
