I am trying to generate a page that has Training Categories with Sub-Categories within a page with frames. I am having trouble just getting the query to display the names of the Training Categories within the frame. Here is what I have so far: There is an application.cfm within the directory of files I am generating for this page. It has 3 queries which are: <cfquery datasource="FirmDaily" name="GetTips"> select * from TrainingTips order by TrainingCategory </cfquery> <cfquery datasource="FirmDaily" name="GetTrainingCatgories"> select * from TrainingCategory order by TrainingCategory </cfquery> <cfquery datasource="FirmDaily" name="GetSubCatgories"> select * from SubCategory order by SubCategory </cfquery>
Then on the framed page this is what I have: <FRAMESET COLS="150,*" framespacing=1 frameborder=0> <FRAME SRC="tiplinks.htm" name="tiplinks" noresize > <FRAME SRC="viewtip.cfm" name="tip" marginwidth=100 marginheight=50> </FRAMESET> The tiplinks.htm is the one giving me fits: <BODY bgcolor="red" link="white" vlink="white" alink="black"> <H3><a href="todaystip.htm" target=tip>Today's Tip</a></H3> <H4>Archived Tips</H4> <cfoutput query="GetTrainingCategories"> <a href="MainPage2.htm?TrainingCategory=#URLEncodedFormat(Trim(TrainingCategory ))#" target="_parent">#TrainingCategory#</a> </cfoutput> Presently, my output within the frame looks like this: Today's <http://dailynews/education/todaystip.htm> Tip Archived Tips #TrainingCategory# <http://dailynews/education/MainPage2.htm?TrainingCategory=#URLEncodedFormat (Trim(TrainingCategory))> Where is says #TrainingCategory#, it's supposed to be showing me the Training Categories in my table which are things like: Word Outlook Excel PowerPoint etc. Why is this not generating the output correctly in my frame? Any help would be greatly appreciated. Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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.
