CFUPDATE on Linux CF 4.5 / mySQL 1

[DeZiner]

I have a field set to longtext in mySQl database. When I populate the field the first time it will take 1000's of characters. When I run a CFUPDATE on the same field it limits the input to 10 char. Any thought? DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[da644]

Hi Deziner.

I would personally use the SQL update, I always found problems using CFUPDATE. Try just using CFQUERY and the input the SQL required yourself. Example:

<cfquery name=&quot;updateData&quot; datasource=&quot;#dsn#&quot;>
update

set [field] = [data]
where [key] = [key]
</cfquery>

Best Regards

Andrew

http://www.clickitstudios.com

 

[DeZiner]

Worked like a charm!

Thank you
DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic