Oddly, I don't seem to be able to reproduce the problem now. I have some vague memory of attempting to change the amount of content and smaller volumes of content not altering it, but it's been a while... sorry I couldn't be more helpful.
> Does it matter if the information we put into the field > was just "test" and it didn't return that? > (This is not my server, it is one of our customers) > Paul Giesenhagen > QuillDesign > ----- Original Message ----- > From: "S. Isaac Dealey" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, January 07, 2003 4:01 PM > Subject: Re: Output not showing up >> Check your dns settings in the CF Administrator -- this >> was the experience > I >> had when I tried to check "enable retrieval of long >> text". Unfortunately I >> don't know why this happened and settled for increasing >> the long text > buffer >> size to the maximum allowed 999999 characters -- almost >> 1mb of data. >> >> > We have a very strange problem trying to output some >> > information from the database. The information is in >> > the >> > database when we look at the raw data, but it won't >> > output >> > on a template page. >> >> > The column name is CONTENT it is a text/16/allows nulls >> > (MS SQL Server 2000) >> >> > I can do a recordcount and get 1 record, but when >> > outputing it is blank! The information that is in >> > content >> > doesn't display ...the other types of columns like >> > varchars display fine but not the TEXT column. I can >> > go >> > into the database and see that there is information in >> > the >> > content column, but it just won't output. >> >> > If I do a query >> >> > <cfquery datasource="DSN" name="getStuff"> >> > SELECT content >> > FROM tableName >> > WHERE id = 111 >> > </cfquery> >> >> > <cfoutput> >> > Recordcount: #getStuff.recordcount#<br> >> > CONTENT: #getStuff.content# >> > </cfoutput> >> >> > Produces >> >> > Recordcount: 1 >> > CONTENT: >> >> > Has anyone ever heard of something like this? >> >> > Paul Giesenhagen >> > QuillDesign >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> > ~~~ >> > ~~~~~~~~~~~| >> >> s. isaac dealey 954-776-0046 >> >> new epoch http://www.turnkey.to >> >> lead architect, tapestry cms http://products.turnkey.to >> >> certified advanced coldfusion 5 developer >> http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > 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 > Structure your ColdFusion code with Fusebox. Get the > official book at http://www.fusionauthority.com/bkinfo.cfm > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
