[sqlite] Most basic of questions

2007-10-10 Thread Brian Rowlands (Greymouth High School)
Hi I'm absolutely new to sqlite which I'm using with a perl project. I did a test script: use strict; use DBI; my $dbfile = 'H:\trythis.s3db'; my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile","","",{RaiseError => 1}); my $sql = "SELECT name FROM Fields ORDER BY name"; my $sth =

RE: [sqlite] Most basic of questions

2007-10-10 Thread Brian Rowlands (Greymouth High School)
've found if I simply undef $sth; before disconnecting, it eliminates the message about closing $dbh with active statement handles. -Clark - Original Message From: Brian Rowlands (Greymouth High School) <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, October 10,

[sqlite] Reading Blob data using Perl

2007-10-16 Thread Brian Rowlands (Greymouth High School)
Hi I'm hoping someone can help me explain how to fix a problem I have with reading a Blob field from a SQLite DB using Perl. My long term aim is to not save it to a file but use it within my application and store it as a label bitmap. However, first things first. This code reads the Blob but when

FW: [sqlite] Reading Blob data using Perl

2007-10-16 Thread Brian Rowlands (Greymouth High School)
ent: Wednesday, 17 October 2007 3:07 p.m. To: sqlite-users@sqlite.org Subject: Re: [sqlite] Reading Blob data using Perl can't help you all the way, but below are a few comments -- On 10/16/07, Brian Rowlands (Greymouth High School) <[EMAIL PROTECTED]> wrote: > Hi > I'm hoping someone can