Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

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="http://www.w3.org/2001/XMLSchema-instance" xmlnssd="http://www.w3.org/2001/XMLSchema"><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:\/\/www.w3.org\/2001\/XMLSchema
    +-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\"><items
    +><item><data>//g;
    
    $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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1011021]
Approved by Corion
Front-paged by Jim
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (11)
As of 2015-07-07 12:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls