As Lon said check your Tools|Options setting. I believe the default for the maximum is ~250 characters and you can increase it.
______________________________________________________ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com ______________________________________________________ > -----Original Message----- > From: Lon Lentz [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 5:59 PM > To: CF-Talk > Subject: RE: SQL Query Analyzer > > > How long is it? Under tools/options there is a "maximum > characters per column". > > > > -----Original Message----- > > From: Kahng, Lucius [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 14, 2002 3:12 PM > > To: CF-Talk > > Subject: SQL Query Analyzer > > > > > > I'm trying to retrieve a long text field from out > ColdFusion SQL database > > using SQL Query Analyzer, however, the program truncates the > > field contents. > > Is there a way to display the full contents of long text fields? > > (Instead of > > having to use CFML to output a the whole table's column contents!) > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists