Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
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 browsing the Monastery: (16)
As of 2014-09-17 14:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (85 votes), past polls