XML values to database records (grep?)
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32904
interpreted = N
texte = I'm trying to parse some values from XML so that they can be appended as records into a database. So far I'm stumped as to how to parse this style of data using WebDNA. But I have the feeling that someone who is more fluent in grep than I (John Peacock hint hint nudge nudge) could see how to make this happen. The construct of the XML is listed below. I want to take each
, treat is as a database record, and append its s to the database using the pairs within each . So using the example below, I would like to be able to create an [append] context like this: [append db=x.db] channeltitle=NZ Jazz Online - Jazz.co.nz &id=75 &storytext=<a href=http://jazz.co.nz>Manuel Bundy</a> &time=19991004T02:01:13 [/append]Of course, I would like to extrapolate the data into an array of variables first so that I could manipulate it (change the date format for instance) before I append it to the database. *Note that some s have sub-identifiers such as and .XML: snip... channeltitle NZ Jazz Online - Jazz.co.nz id 75 storytext <a href=http://jazz.co.nz>Manuel Bundy</a> time 19991004T02:01:13 ...snip-- This is only one isolated . The entire XML source would have many s so my solution will need to recurs through the XML source and break each out as an individual record.Hmmf. Anyone? Ken? John? Grant?Thanks, Mike ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I'm trying to parse some values from XML so that they can be appended as records into a database. So far I'm stumped as to how to parse this style of data using WebDNA. But I have the feeling that someone who is more fluent in grep than I (John Peacock hint hint nudge nudge) could see how to make this happen. The construct of the XML is listed below. I want to take each , treat is as a database record, and append its s to the database using the pairs within each . So using the example below, I would like to be able to create an [append] context like this: [append db=x.db] channeltitle=NZ Jazz Online - Jazz.co.nz &id=75 &storytext=<a href=http://jazz.co.nz>Manuel Bundy</a> &time=19991004T02:01:13 [/append]Of course, I would like to extrapolate the data into an array of variables first so that I could manipulate it (change the date format for instance) before I append it to the database. *Note that some s have sub-identifiers such as and .XML: snip... channeltitle NZ Jazz Online - Jazz.co.nz id 75 storytext <a href=http://jazz.co.nz>Manuel Bundy</a> time 19991004T02:01:13 ...snip-- This is only one isolated . The entire XML source would have many s so my solution will need to recurs through the XML source and break each out as an individual record.Hmmf. Anyone? Ken? John? Grant?Thanks, Mike ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Mike Davis
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
serial number dishing (1997)
Mime Headers for Mail (1998)
Quit revisited (1997)
[Sum] function? (1997)
WCS Newbie question (1997)
Online reference (1997)
[thisurl] file name? (1999)
Secure Server basic question... (1997)
need help with [sendmail] and [showif]s (1998)
[OT] friday pics :-) (2005)
this works sometimes and sometimes not (1997)
Webcat Security (1998)
Calendar using WebCatalog? (1997)
Queertrons? (1997)
Looking for a WebCatlog programmer in the Silicon Valley (1998)
Cookie problems using Mozilla and Camino browsers (2004)
Date Help (2004)
bye bye tax rate (1998)
Data Entry ... Excel Style ... How To? (2001)
popups, netscape vs explorer (1997)