Carl, What version of CF are you running? Go into your datasource and make sure the settings are set so as to allow the retrieval of long text.
In CFMX: open the advanced settings of the datasource, and make sure you have the CLOB field ticked (Enable long text retrieval (CLOB)) In CF5: open the CF settings of the datasource, and make sure the "Long Text Retrieval Settings" are ticked (quote: "Enable this option only if you want to retrieve all the data for a long text field. If the option is not selected ColdFusion retrieves the number of characters specified in the long text buffer size. Enabling this option may compromise performance.") Hope this solves your problem. Steve C -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Kear Sent: Tuesday, 3 February 2004 12:24 AM To: CFAussie Mailing List Subject: [cfaussie] RE: sql question... "Text" types in MS SQLServer allow for huge fields sizes. Something like 3MB, if I remember correctly. It's the one you want if you have very large amounts of text. It's set to 16 because its only a reference to data held somewhere else that's needed in that record. For 1400 word fields, it's definitely the Text type you need. The problem must be elsewhere. Perhaps a double quote mark in the text being inserted? You can fix that by changing the double quote to a single quote or using " in the text instead. However if you were to change that field to another type, say Varchar with a length of 255 characters (the maximum), you'd lose everything in that field after the 255th character. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carl Vanderpal Sent: Tuesday, 3 February 2004 12:16 AM To: CFAussie Mailing List Subject: [cfaussie] sql question... 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 --- 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 --- 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
