Thanks Mark, I am currently using Apache Tomcat combined with Apache FOP to perform xsl:fo transformations. In this particular case, I don't need the data in CFMX as such, but it may indeed be the easiest way to create the XML file.
-----Original Message----- From: Mark M [mailto:[EMAIL PROTECTED] Subject: [cfaussie] Re: Retrieving XML from SQL Server for use in CFMX Not sure if this applies in this case, but I thought I would throw it in there anyway - Don't forget that CFMX can handle XSL/T XML transformations. So using the DB to spit out the XML and then using XSL to transform it into the format you want (if that is even necessary) will probably be an easy and fast way to do what you need to do. (Also means you can XSL on the fly too if you want) Considering that this is what XSL is built for, it would most likely (not tested) be the easiest and fastest option to provide XML you want. Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- > [EMAIL PROTECTED] On Behalf Of Ben Reid > Sent: Monday, 2 June 2003 4:08 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Retrieving XML from SQL Server for use in CFMX > > Thanks Gary... > > I think I might run with your suggestion, and just use CF to construct the > XML file. > > > -----Original Message----- > From: Gary Menzel [mailto:[EMAIL PROTECTED] > Subject: [cfaussie] Re: Retrieving XML from SQL Server for use in CFMX > > > What is the best way to go about getting an XML document containing data > from a database? > > I suppose it depends on what format you want the XML to be in. If the > format is the same as that which you can deliver from SQL*Server - then > getting that going is probably worthwhile. If the format from SQL*Server > is not suitable, then you need to read your data from SQL*Server and then > create is using Cold Fusion. Now, you may or may not want to use the XML > Dom in Cold Fusion to create the XML (sometimes, it is just easier to > create XML by concatenating the appropriate strings, or possibly using > <CFLOOP> and <CFSAVECONTENT>). > > Most of the XML work I have done has not used any XML standard schemas and > it has therefore been easier to create the XML just using normal Cold > Fusion (i.e. not SQL*Server and not the CF XML Dom). > > For example WebFX have a Javascript XLoadTree (which allows you to specify > a call back to the server to obtain each level of the tree as it is > requested). For this, the format expected is defined by the XLoadTree > code. My hierarchy is stored in a database. So I just get CF to get the > data for the section of the tree being request and compose the XML and > then pass back the output with the appropriate mime content type. > > > Gary Menzel > IT Operations Brisbane -+- ABN AMRO Morgans Limited > Level 29, 123 Eagle Street BRISBANE QLD 4000 > PH: 07 333 44 828 FX: 07 3834 0828 > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
