queryname.columnlist is what you are looking for. use listlen() to set
your upper bound. You may also want to check out cflib.org for some
helpful functions like converting query rows to structs, structs to
xml, etc. (there are tons of handy functions there)
Anthony
On 7/13/05, Merrill, Jason <[EMAIL PROTECTED]> wrote:
> Well, I got it working, didn't realize I could use the Array access
> operator like I can in Flash and Javascript - gotta love ECMA.
>
> Here is the script, but how can I make it cleaner - i.e. get names of
> fields and then loop over those?
>
> <cfscript>
> lrXML = XmlNew();
> lrXML.xmlRoot = XmlElemNew(lrXML,"lData");
> for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
> lrXML.lData.XmlChildren[i] =
> XmlElemNew(lrXML,"Content");
> lrXML.lData.XmlChildren[i].XmlChildren[1] =
> XmlElemNew(lrXML,"ID");
> lrXML.lData.XmlChildren[i].XmlChildren[2] =
> XmlElemNew(lrXML,"Lesson");
> lrXML.lData.XmlChildren[i].XmlChildren[3] =
> XmlElemNew(lrXML,"Required");
> lrXML.lData.XmlChildren[i].XmlChildren[4] =
> XmlElemNew(lrXML,"Time");
> lrXML.lData.XmlChildren[i].ID.XmlText =
> #qLessons.ID[i]#;
> lrXML.lData.XmlChildren[i].Lesson.XmlText =
> #qLessons.Lesson[i]#;
> lrXML.lData.XmlChildren[i].Required.XmlText =
> #qLessons.Required[i]#;
> lrXML.lData.XmlChildren[i].Time.XmlText =
> #qLessons.Time[i]#;
> }
> </cfscript>
>
> Jason Merrill | E-Learning Solutions | icfconsulting.com
>
>
>
>
>
>
>
>
>
> >>-----Original Message-----
> >>From: Merrill, Jason [mailto:[EMAIL PROTECTED]
> >>Sent: Wednesday, July 13, 2005 11:31 AM
> >>To: CF-Talk
> >>Subject: Simple XML cfscript question
> >>
> >>New here - Flash-guy, also new to ColdFusion and SQL (CF-Newbies
> doesn't
> >>seem to be populated with anybody)
> >>
> >>(...and before I ask the question, I'm also looking for a cleaner way
> to
> >>write this, like not having to hard code the field column names)
> >>
> >>How do I insert each subsequent record from a database into my XML
> file?
> >>I got this working, but it of course repeats the first record in each
> >>child node,which is not what I want.
> >>
> >><cfquery name="qAllLessons" datasource="coursesDB">
> >> SELECT * FROM Lessons
> >></cfquery>
> >><cfquery name="qLessons" datasource="coursesDB">
> >> SELECT ID, Lesson, Required, Time FROM Lessons
> >></cfquery>
> >>
> >><cfscript>
> >> lrXML = XmlNew();
> >> lrXML.xmlRoot = XmlElemNew(lrXML,"lData");
> >> for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
> >> lrXML.lData.XmlChildren[i] =
> >>XmlElemNew(lrXML,"Content");
> >> lrXML.lData.XmlChildren[i].XmlChildren[1] =
> >>XmlElemNew(lrXML,"ID");
> >> lrXML.lData.XmlChildren[i].XmlChildren[2] =
> >>XmlElemNew(lrXML,"Lesson");
> >> lrXML.lData.XmlChildren[i].XmlChildren[3] =
> >>XmlElemNew(lrXML,"Required");
> >> lrXML.lData.XmlChildren[i].XmlChildren[4] =
> >>XmlElemNew(lrXML,"Time");
> >> lrXML.lData.XmlChildren[i].ID.XmlText = #qLessons.ID#;
> >> lrXML.lData.XmlChildren[i].Lesson.XmlText =
> >>#qLessons.Lesson#;
> >> lrXML.lData.XmlChildren[i].Required.XmlText =
> >>#qLessons.Required#;
> >> lrXML.lData.XmlChildren[i].Time.XmlText =
> >>#qLessons.Time#;
> >> }
> >></cfscript>
> >><cfdump var=#lrXML#>
> >><cfset XMLText = ToString(lrXML)>
> >><cffile action="write"
> >>file="C:\CFusionMX7\wwwroot\com\macromedia\test\myTextXml_3.xml"
> >>output="#XMLText#">
> >>
> >>
> >>This outputs:
> >>
> >><?xml version="1.0" encoding="UTF-8" ?>
> >><lData>
> >> <Content>
> >> <ID>1</ID>
> >> <Lesson><b>Introduction to Spatial Analysis</Lesson>
> >> <Required>True</Required>
> >> <Time>2</Time>
> >> </Content>
> >> <Content>
> >> <ID>1</ID>
> >> <Lesson><b>Introduction to Spatial Analysis</Lesson>
> >> <Required>True</Required>
> >> <Time>2</Time>
> >> </Content>
> >>...etc...
> >>
> >>How do I write the query to insert each record into each subsequent
> node
> >>instead of inserting the first record each time?
> >>
> >>Or, is there a cfscript out there that will take a table and convert
> its
> >>contents to XML with the nodes being named what the field names are
> >>named? I have searched the web, but haven't found one yet.
> >>
> >>Thanks.
> >>
> >>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:211758
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
