Hi, Deetra. I believe this is probably an Access issue rather than a CF issue. The "Description" field is probably set to "Text" rather than to "Memo". A "Text" fieldtype in Access has a limit of 255 characters. "Memo" fieldtype has a limit of 65,000 characters, I think.
Try setting the database fieldtype for the "Description" field and see if that helps. Rick Rick Faircloth, Prism Productions -----Original Message----- From: Deetra Whatley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 12:01 AM To: CF-Talk Subject: Truncating the text in my description field Good Day, I am using Dreamweaver MX, ColdFusion MX and Access 2000. Using CFMX, I created several web pages using the same query with a different "Where" clause. When I do not use a "Where" clause, it truncates my text in my description field. To better explain, here is my website. http://66.241.205.93/tmame/ministries/allministries.cfm The allministers.cfm descriptions are truncated. Allministries Query <cfoutput> <h3>#qGetSubMinistries.Main# </h3> </cfoutput> <cfoutput query="qGetSubMinistries"> <p><span class="headingtext">#Sub# </span> <br>#Description# <span class="boldattribute">#Leader# #MeetingDay# #TimeFormat(MeetingTime, "h:mm tt")#</span></p></cfoutput> My subministries' page descriptions are not truncated. http://66.241.205.93/tmame/ministries/academic.cfm and any of the other subministries are fine. Subministries Query <cfquery name="qGetSubMinistries" datasource="tmame"> SELECT DISTINCT Ministries.Main, Ministries.Sub, Ministries.Description, Ministries.Leader, Ministries.MeetingDay, Ministries.MeetingTime FROM Ministers, Ministries WHERE Main='Christian Education' </cfquery> Output from both queries <cfoutput> <h3>#qGetSubMinistries.Main# </h3> </cfoutput> <cfoutput query="qGetSubMinistries"> <p><span class="headingtext">#Sub# </span> <br>#Description# <span class="boldattribute">#Leader# #MeetingDay# #TimeFormat(MeetingTime, "h:mm tt")#</span></p></cfoutput> Question. What do I need to do to remedy this problem? Am I supposed to use a special setting or parameter? Thank you for your assistance. Deetra Whatley ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
