Hi Carl, Are you using cfqueryparam on your insert query?
I had this problem once which turned out to be that I was trying to insert into a 'text' type field using A varchar cfqueryparam tag.. Just had to remove the cfqueryparam and insert 'directly' into the db and Presto.. Cheers, Adam > Hello CFAussie, > > I have an sql 2k databse with a Data Type set to 'text' and > the length automatically sets to 16..and my customer is > trying to insert some text into the field (he said around > 1400 words) but it won't accept it all...into the database. > So do I need to change the field type to something else? he > suggested I allow for 3,000 words just in case. > > Any suggestions? > > 2) and if we do change it will that effect the text already in there? > > > Best regards, > Carl Vanderpal > Po Box 3462 Dural, NSW 2158 > mailto:[EMAIL PROTECTED] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
