Jillian Your a god damn star!! Thank you. Problem is solved.
-----Original Message----- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 21:22 To: CF-Talk Subject: RE: Data getting truncated on select In CFMX. -- Jillian > -----Original Message----- > From: John McCosker [mailto:[EMAIL PROTECTED] > Sent: June 17, 2003 1:53 PM > To: CF-Talk > Subject: RE: Data getting truncated on select > > > >>- 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. > > Adminstrative settings in MSSQL or CFMX? > > -----Original Message----- > From: Jillian Carroll [mailto:[EMAIL PROTECTED] > Sent: 17 June 2003 20:42 > To: CF-Talk > Subject: RE: Data getting truncated on select > > > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
