| 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> |
|---|---|---|
| ||
| Previous by Date: | cfinsert works with mySQl 5 but NOT with ms sql server 2005, masticwarrior |
|---|---|
| Next by Date: | Re: CFUPDATE character restriction, Dan Bracuk |
| Previous by Thread: | cfinsert works with mySQl 5 but NOT with ms sql server 2005, masticwarrior |
| Next by Thread: | Re: CFUPDATE character restriction, Dan Bracuk |
| Indexes: | [Date] [Thread] [Top] [All Lists] |