Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (4)
As of 2017-06-25 00:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (563 votes). Check out past polls.