RE: [sqlite] Most basic of questions

2007-10-10 Thread Brian Rowlands (Greymouth High School)
Nice one Clark. Worked a treat. -Original Message- From: Clark Christensen [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 October 2007 5:47 a.m. To: sqlite-users@sqlite.org Subject: Re: [sqlite] Most basic of questions As you've discovered, $sth->finish doesn't quite do t

Re: [sqlite] Most basic of questions

2007-10-10 Thread Clark Christensen
As you've discovered, $sth->finish doesn't quite do the job. I'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 PROTECTE

Re: [sqlite] Most basic of questions

2007-10-10 Thread John Stanton
Brian Rowlands (Greymouth High School) wrote: 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