Code example. Depends on what your XML is structured like, can you post a sample?
How many records are we talking about? What db platform? You could also setup SQL XML IIS support if you are on MS SQL and post your XML files to a template that inserts it into a database. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy > Sent: Monday, 26 September 2005 1:47 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: XML to Query > > > Yeah all I want to do is insert it into a database. I thought > putting it into query would be easier, but if you think that > looping over an xml document is okay i.e. not resource > intensive on the server then i will give that a go. I hadn't > thought of it that way. > > You got a code example? > > J. > > > If all you want to do is insert it into a db, why not just > loop over > > the = XML structure and insert it? > > > > If you want to convert the xml document to a query, then create a > > dummy query, run wddx over it and have a look at the > output, so need > > to create = the same output either directly or via XSLT.=20 > > > > Hope that helps. > > > > Taco Fleur - Pacific Fox > > an industry leader with commercial IT experience since 1994 . > > http://www.pacificfox.com - Web Design and Development > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > >Jeremy > > > Sent: Monday, 26 September 2005 1:24 PM > > > To: CFAussie Mailing List > > > Subject: [cfaussie] RE: XML to Query > > >=20 > > >=20 > > > Mmm..yeah I want to convert an XML document into a query. In=20 > > > the end I want to loop over that query and insert it into a=20 > > > database. Just trying to figure out how to go about it. > Make sense? > > >=20 > > > J. > > >=20 > > > --- > > > You are currently subscribed to cfaussie as:=20 > > > [EMAIL PROTECTED] To unsubscribe send a blank email=20 > > > to [EMAIL PROTECTED] > > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > >=20 > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email > to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
