Nevermind, after some headaches, I figured it out on my own:
<cfquery name="GetAll" datasource="coursesDB">
SELECT * FROM Lessons
</cfquery>
<!-- the following query used to dynamically get the table names !-->
<cfquery name="GetTables" datasource="coursesDB">
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Flags = 0
AND MSysObjects.Type = 1
ORDER BY MSysObjects.Name
</cfquery>
<cfscript>
d = XmlNew();
d.xmlRoot = XmlElemNew(d, #GetTables.Name#);
for (i=1; i LTE #GetAll.RecordCount#; i=i+1){
d[#GetTables.Name#].XmlChildren[i] =
XmlElemNew(d,"Content");
for(n=1; n LTE listLen(#GetAll.ColumnList#); n=n+1){
d[#GetTables.Name#].XmlChildren[i].XmlChildren[n] =
XmlElemNew(d,#ListGetAt(GetAll.ColumnList,n)#);
d[#GetTables.Name#].XmlChildren[i][#ListGetAt(GetAll.ColumnList,n)#].Xml
Text = #GetAll[#ListGetAt(GetAll.ColumnList,n)#][i]#;
}
}
</cfscript>
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain privileged or
confidential information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of this e-mail by you
is prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211776
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
