How big is this text object that is getting truncated? is it near 32K or 64K in size?
What version of CF? What connectiontype are you using for that data source (ODBC or Native drivers)? Jerry Johnson >>> [EMAIL PROTECTED] 06/17/03 02:22PM >>> 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
