Ok, so I have a cfc that pulls data from a database:
<cffunction name="getDropDownData" access="public" returntype="query">
<cfargument name="pageType_ID" type="numeric" required="true"
default="0">
<cfset var qgetDropDownData = ""/>
<cfquery name="qGetDropDownData" datasource="#REQUEST.DSN#">
Select DD_ID, DD_Title, DD_Header1, DD_Header2,
DD_Header3, DD_HEader4, PageType_ID
From DD
Where DD_PageType_ID = #PageType#
</cfquery>
<cfreturn getDropDownData>
</cffunction>
</cfcomponent>
And then I also have an xml file that populates a flash menu:
<?xml version="1.0"?>
<NAV main_onColor="#000000" main_offColor="#ff0000"
sub_onColor="#000000" sub_offColor="#666666" navWidth="150" fadeTime="0"
lineWidth="150" main_y_padding="4" sub_y_padding="2" sub_indent="10">
<MAIN text="Foyer" URL="index.htm" target="_self"></MAIN>
<MAIN text="Family Room" expand="true">
<SUB text="The Family" URL="http://www.treadwaygallery.com";
target="_blank"></SUB>
<SUB text="All-time Favorites" URL="http://www.wright20.com";
target="_blank"></SUB>
<SUB text="2002 Group Reading List" URL="http://www.lamodern.com";
target="_blank"></SUB>
<SUB text="Current Personal Reads" URL="http://www.ragoarts.com";
target="_blank"></SUB>
</MAIN>
So, my question is, how do I get the query to populate the xml nodes?
Is it possible to somehow loop throught the query and ouput the
attributes like... (this is conceptual code only)
<MAIN text="#DD_Header1#" expand="true">
<SUB text="#DD_SubHeader1#" URL="#DD_SubHeader_URL#"></SUB>
<SUB text="#DD_SubHeader2#" URL="#DD_SubHeader2_URL#"
target="_blank"></SUB>
</MAIN>
<MAIN text="#DD_Header2#" expand="true">
<SUB text="#DD_SubHeader1#" URL="#DD_SubHeader_URL#"></SUB>
<SUB text="#DD_SubHeader2#" URL="#DD_SubHeader2_URL#"
target="_blank"></SUB>
</MAIN>
Thanks in advance, and sorry if I cause any brain tumors...
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
