I am having a challenge trying to envision a solution to the following:

Wherever I have a textarea field in my insert statement I strip commas and
returns in this fashion:

'#Replace(form.specialrequest, "#chr(13)##chr(10)#", " ", "ALL")#',

Is there a way to check the number of characters that was entered when the
form was submitted? I need to limit it to 255 - I have a specific group
entering war and peace in this field and upon insert it is causing problems
down the line when a data team member (internal) tries to download the form
submissions out of the database for processing.

Any thoughts, suggestions, ideas?

Tony Gruen


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to