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

CFUPDATE character restriction

Subject: CFUPDATE character restriction
From: "Busswire.com" <webforumsuser@xxxxxxxxxxxxxx>
Date: Sun, 20 Jan 2008 22:24:47 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

The problem I'm having is that if I use CFUPDATE or CFINSERT and go over around 
400 characters in the submitted text area it bombs out. I don't know the exact 
amount of characters but if I remove some text there is no issue. Does anyone 
know why this is happening? If I uses a query with just UPDATE I can add as 
much text as I want, but CFUPDATE limits me. Any help is greatly appreciated!

 Here is the error I get when I go over with too many characters. Thanks

  Error Executing Database Query.
 Application uses a value of the wrong type for the current operation.
  
 The error occurred in D:\Hosting\kapman78\quickadmin3.cfm: line 10

 8 : <CFIF IsDefined("FORM.postnum")>
 9 :     <!--- Update game --->
 10 :     <CFUPDATE datasource="kapman78_accesscf_buss" 
TABLENAME="#URL.tablename#">
 11 : <CFELSE>
 12 :     <!--- Add game --->
  


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