Re: importing and accessing data - redux
If you are looking for a crash course in what exists in XML and data access, I wrote http://www.25hoursaday.com/StoringAndQueryingXML.html a while ago which should be helpful in pointing you in the right direction. As for converting the tab delimited data to XML, I suggest using whatever scripting/programming language you are familiar with to complete this task. I'd go with Perl myself. -- THINGS TO DO IF I BECOME AN EVIL OVERLORD #15 I will never employ any device with a digital countdown. If I find that such a device is absolutely unavoidable, I will set it to activate when the counter reaches 117 and the hero is just putting his plan into operation. ----- Original Message ----- From: "Paul Freedman" <paul@f...> To: <xml-dev@l...> Sent: Friday, December 07, 2001 1:55 PM Subject: importing and accessing data - redux > On the offchance that the only person who knows the answer didn't see > this earlier, I'm posting it again. I apologise for the redundancy; the > answer may be real important to this job. > > I am a newcomer to xml and to this list. I hope this is the place for > basic questions, or if not then at least the place to learn where to ask > them. Please let me know if I'm being inappropriate, too. > > I have a small database with two tables of about 250 records each. One > table is a glossary with two fields, "word" and "definition". The other > is a directory called 'papers', containing five fields. All the data is > string. Nothing, including the definitions, is longer than 600 > characters. > > Currently the data resides in 2 tab-delimited .txts. > > I want to handle the data with normal database functions: search, > select, sort. I am at a loss as to how to begin. I can't even see > how to import the data into an xml document (or generate a document > with the data in place). > > I know that, using Matt Sergeant's DBIx::XML_RDB module, I can access a > mySQL database through Perl. I'm trying to avoid Perl and Java. > > My interface, incidentally, is a Shockwave piece built in Macromedia > Director 8.5. I'm trying to not use their database-accessing xtras. > Their XML Parser xtra is known to work, but first I'd need, it seems, an > "XML Database". Building it by hand would defeat my purpose, and leave > me with the problem of building a maintenance device. > > Is there a way to use xml as my database here? > > Any help will be deeply appreciated. > > Thanks, > Paul Freedman > > ----------------------------------------------------------------- > The xml-dev list is sponsored by XML.org <http://www.xml.org>, an > initiative of OASIS <http://www.oasis-open.org> > > The list archives are at http://lists.xml.org/archives/xml-dev/ > > To subscribe or unsubscribe from this list use the subscription > manager: <http://lists.xml.org/ob/adm.pl> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format