John, I have had this problem more than once.
Which DBMS are you using? -- Jillian > -----Original Message----- > From: John McCosker [mailto:[EMAIL PROTECTED] > Sent: June 17, 2003 12:33 PM > To: CF-Talk > Subject: RE: Data getting truncated on select > > > 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
