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 the job. I

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

[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 =