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 asrecords into a database. So far I'm stumped as to how to parse this styleof data using WebDNA. But I have the feeling that someone who is morefluent in grep than I (John Peacock hint hint nudge nudge) could see how tomake this happen. The construct of the XML is listed below. I want to takeeach
, treat is as a database record, and append its s tothe database using the pairs within each . So usingthe example below, I would like to be able to create an [append] contextlike 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 variablesfirst so that I could manipulate it (change the date format for instance)before I append it to the database. *Note that some s havesub-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 havemany s so my solution will need to recurs through the XML source andbreak 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 asrecords into a database. So far I'm stumped as to how to parse this styleof data using WebDNA. But I have the feeling that someone who is morefluent in grep than I (John Peacock hint hint nudge nudge) could see how tomake this happen. The construct of the XML is listed below. I want to takeeach , treat is as a database record, and append its s tothe database using the pairs within each . So usingthe example below, I would like to be able to create an [append] contextlike 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 variablesfirst so that I could manipulate it (change the date format for instance)before I append it to the database. *Note that some s havesub-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 havemany s so my solution will need to recurs through the XML source andbreak 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)