Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^2: DBI accessing SQLite with XML data

by Anonymous Monk
on Dec 31, 2012 at 10:34 UTC ( #1011038=note: print w/replies, xml ) Need Help??


in reply to Re: DBI accessing SQLite with XML data
in thread DBI accessing SQLite with XML data

Actually I found a way using regular expressions. You have to create a custom regexp function and then use it to parse the XML (courtesy of http://www.justatheory.com/computers/databases/sqlite/).

Not exactly what I was looking for and surely not very efficient performance-wise, but for now it does the trick.
  • Comment on Re^2: DBI accessing SQLite with XML data

Replies are listed 'Best First'.
Re^3: DBI accessing SQLite with XML data
by NetWallah (Abbot) on Dec 31, 2012 at 17:17 UTC
    Thanks for sharing that link - I believe it WOULD be efficient, and could be extremely powerful, if you embed XML processing into the function.

    Please post working code back, for lazy bums like me to plagiarize.

    Happy 2013!

                 "By three methods we may learn wisdom: First, by reflection, which is noblest; Second, by imitation, which is easiest; and third by experience, which is the bitterest."           -Confucius

      Will do - but you'll need to wait a couple of days as I won't have access to the Internet.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1011038]
help
Chatterbox?
[1nickt]: If 1nickt is the some guy, that's not what he said.
[GotToBTru]: thepkd might not know about last hour of cb
[1nickt]: my $x = $aohoaoh->[0]->{' foo'}->[0]->{'bar' }; should work
[thepkd]: its not $aohoaoh->[0]. its $aohoaoh[0]->{'foo '}. Tried it. Its working. Thnaks
[thepkd]: Hey 1nickt sorry man. What
[GotToBTru]: a ref too far ;)
[thepkd]: Yes this is my first time in cb. Trying to work my way around.
[JohnCub]: "A ref too far" would make a good title for anyone's perl memoirs
[thepkd]: Anyways it works with $aohoaoh[0]->{'foo '}[0]->{'bar'}

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (11)
As of 2016-12-06 13:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (105 votes). Check out past polls.