Help for this page

Select Code to Download


  1. or download this
    my $blogTagToShow           =       shift;
    my $dbh = DBI->connect("dbi:SQLite:dbname=$db");
    ...
    my $sth = $dbh->prepare($query);
    $sth->bind_param(1, $blogTagToShow);
    $dbh->trace(0);
    
  2. or download this
    sqlite trace: prepare statement: SELECT * FROM tblBlogPosts WHERE fldT
    +ags LIKE '%?%' ORDER BY fldDate DESC at dbdimp.c line 258
        <- prepare= DBI::st=HASH(0x93bba20) at Libraries//libBlog.pm line 
    +42 via  at index.pl line 152
    ...
        -> execute for DBD::SQLite::st (DBI::st=HASH(0x93bba20)~0x93b64ec)
    sqlite trace: execute at dbdimp.c line 325
    sqlite trace: Execute returned 6 cols