macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Error on Update - SQL Server datatype ??

Subject: Error on Update - SQL Server datatype ??
From: "KimMazz"
Date: Mon, 4 Feb 2008 12:22:31 -0500
Newsgroups: macromedia.coldfusion.cfml_general_discussion

I keep getting an error when I try to update a row in a MS SQL table. The 
insert works and doesn't tell me the content is too long, however, when I 
update I get the error below. The field of Article_Content is set to a 
"text". Why is the content allowed to be inserted, and its not to long. But 
when I try to update I get the error? And, I am actually removing some text 
on update.

Any help is appreciated,

Thanks,
Kim

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The identifier that starts 
with '
Two of my sons and I saw the Army/Navy game together a few weeks ago. (One 
son is in the Army and the other the Marines [Navy' is too long. Maximum 
length is 128.

  The error occurred in 
C:\CFusionMX7\wwwroot\ActionLeadership\cw3\Admin\AddArticles.cfm: line 24

22 : Article_Date = "#FORM.Article_Date#",
23 : Article_Number ='#FORM.Article_Number#',
24 : Article_Volume = '#FORM.Article_Volume#' )
25 :   </cfquery>
26 : </cfif>



<Prev in Thread] Current Thread [Next in Thread>