I see that you may have an answer to your problem from another fellow, but a few suggestions (my problems were with PostgreSQL and MySQL):
- Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. - Have you checked your driver? Are you using the native driver for SQL Server 7 that ships with CF? -- Jillian > -----Original Message----- > From: John McCosker [mailto:[EMAIL PROTECTED] > Sent: June 17, 2003 1:28 PM > To: CF-Talk > Subject: RE: Data getting truncated on select > > > Using sql server 7. > > -----Original Message----- > From: Jillian Carroll [mailto:[EMAIL PROTECTED] > Sent: 17 June 2003 20:14 > To: CF-Talk > Subject: RE: Data getting truncated on select > > > 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
