Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

DBI accessing SQLite with XML data

by Anonymous Monk
on Dec 31, 2012 at 08:33 UTC ( #1011021=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
    <element xmlnssi="" xmlnssd=""><items><item><data>some text here</data></item></items></element>
  2. or download this
    my $myQuery = $dbh->prepare( "SELECT source FROM myTable" );  
    $source =~ s/<element xmlns:xsi=\"http:\/\/\/2001\/XMLSchema
    +-instance\" xmlns:xsd=\"http:\/\/\/2001\/XMLSchema\"><items
    $source =~ s/<\/data><\/item><\/items><\/element>//g;
  3. or download this
    ( "SELECT ('/element/items/item/data') as source FROM myTable WHERE so
    +urce LIKE '%some string%'" );

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1011021]
Approved by Corion
Front-paged by Jim
[1nickt]: my $x = $aohoaoh->[0]->{' foo'}->[0]->{'bar' }; should work
[thepkd]: not indexing
[thepkd]: getting data out of the ds
[choroba]: it depends. Give more details, please
[thepkd]: i used a series of {}'s but it dont work
[choroba]: You need square brackets for arrays
[GotToBTru]: you can certainly construct a single expression to access any part of the data structure, without using temp variables. but you might make it easier on yourself and any other poor soul who has to understand your code if you do
[thepkd]: to dereference i mean
LanX .oO( oh tempz, oh moretz)
[thepkd]: @GotToBTru Sure. But.

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

    Results (104 votes). Check out past polls.