Yep using CFMX, the text strings are very big, pure html. >>Perhaps you are having >>the same issue.
How did you get round this Bryan? -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:56 To: CF-Talk Subject: RE: Data getting truncated on select Are you using CFMX? I've had that problem using WDDX packets in client vars that are stored in the DB because the Java type that CFMX uses is/was (fixed yet? dunno) not large enough to handle the string. Perhaps you are having the same issue. +-----------------------------------------------+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -----Original Message----- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:51 AM 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
