> Its not the length of the string, it seems to be all the > special characters in the string you are trying to store.
not all of them, just the single quotes > ... Thus the syntax error is because the string is > being truncated before it gets to the closing single quote that's right, because it *contains* a single quote > I am told that single quotes, not double quotes should be used to > surround text fields in sql. yup > Also, in Coldfusion, the use of single > quotes inside a sequel string is permitted if the function > preservesinglequotes is used as has been done here. um, not sure that applies here what you want to do is *double up* the single quotes inside a string that is used in an INSERT statement Values ( 'Main Test Form for testing purposes' , 'English' , 'Test Form' , 'Originals = 1 ... Shrink Wrap: 100''s;... ' notice that 100's has to have two consecutive single quotes -- 100''s see http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_ci d467541_tax285649,00.html rudy - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
