You could always wddx it in and out of a text field. Instant objects. (c: Dawesi
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Sent: Monday, 26 September 2005 2:03 PM To: CFAussie Mailing List Subject: [cfaussie] RE: XML to Query mmm yeah I figured that...I can't post the sample cos its got super secert stuff in it. No worries I'll figure it out. Thanks man! J > 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/ ---------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. ---------------------------------------------------- --- 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/
