If you're daring you can try Ashpool (http://ashpool.sf.net). It's an xml database I wrote a while ago that you can run SQL commands against against. The catch is the "tables" (xml documents) have to be in table form, which is exactly like yours sound like they are.
I've used it on 2 projects, and as long as the files are not too big (bigger than the CIA's Factbook xml) it works pretty well. It also has a jdbc driver and works with cf (at least it worked with 6.1) http://ashpool.sourceforge.net/DBMSUsersGuide.pdf http://ashpool.sourceforge.net/commandref.pdf http://ashpool.sourceforge.net/screenshots.php On 9/13/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > Hey guys, > > I'm workin' with my new cart app project and the db schema/product > options/queries are flat out insane. Looks like NASA got involved with it! > > XML looks like it'd be much more natural in structuring the data. > <item> > <id>123</id> > <color>red</color> > <size>large</size> > </item> > > etc ... etc ... > > Is there any way I can use an XML doc instead of a db for this purpose? Or > would it be just totally inefficient? > > Thanks, > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218139 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
