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:

same products but different (1998) Resume Catalog ? (1997) Re2: frames & carts (1997) Security Issues and WebCommerce Solution (1997) select multiple 2 more cents (1997) Forms Search Questions (1997) WC1.6 to WC2 date formatting (1997) hidden (phantom) file downloads (2000) Another form question (2000) NT Email Stops Sending (2000) [SearchString] usage (1997) Problem with updating 2.1b7 -> 2.1.1 (1998) Help! WebCat2 bug (1997) Re1000001: Setting up shop (1997) [random] only for 1-100??? (1997) newbies to web, spaces in email address (1998) Email Scavengers (2003) Multiple Users.db Possible? (1997) emailer and other smtp (1998) Monthly Help File (1997)