Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CFUPDATE on Linux CF 4.5 / mySQL 1

Status
Not open for further replies.

DeZiner

Programmer
Joined
May 17, 2001
Messages
815
Location
US
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?[sadeyes] DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic
 
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
 
Worked like a charm!

Thank you
[thumbsup2] DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic
 
Status
Not open for further replies.

Similar threads

Part and Inventory Search

Sponsor

Back
Top