Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters.
-----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -----Original Message----- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, "data data etc........... end" on outputting the data it was prove somehow on select its being truncated as "end" did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROM SchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4