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:

    
  1. Re: XML values to database records (grep?) (Mike Davis 2000)
  2. Re: XML values to database records (grep?) (John Peacock 2000)
  3. XML values to database records (grep?) (Mike Davis 2000)
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:

PhotoMill -> PhotoMaster (1997) Removing [showif] makes a big difference in speed (1997) redirect with frames (1997) Problems with dbcatalog.exe (1997) Spreadsheet App pref. [OT] (2001) Searching Numbers (2004) WebDNA Examples (Was Suggestions) (1998) RE: type 2 errors with ssl server (1997) Sales Tax db (1998) Pulling Captions from JPGs (2003) E-mail Attachments (1997) [WebDNA] encoding with webdna/JS, in context of various file encodings/charsets (2010) Post size Limit? (1998) Summing fields (1997) IIS4b2 and WebCatalog b19 (1997) RequiredFields template (1997) Preventing Merchant Settling ? (1997) Help! WebCat2 bug (1997) WebCat2 - Getting to the browser's username/password data (1997) [quantity] within formulas (1997)