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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
