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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
