Re: CFUPDATE character restriction

[GArlington <garlington@xxxxxxxxxxxxx>]

On Jan 21, 3:25 am, "Kaplanconstruct" <webforumsu...@xxxxxxxxxxxxxx>
wrote:
> Well, the way i have my site coded it would take a lot of rework to change it
> to a standard UPDATE query. I was hoping there was some kind of fix to allow
> CFUPDATE to insert more characters. The DB column is the same for both queries
> and I have run into no input limitations with the UPDATE.

Neither CFUpdate NOR CFQuery will allow you to insert longer string
into shorter field. Where do you expect the DB to store these extra
chars?
The fact is that CFQuery will just trim your input quietly...