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
gh School) <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, October 10, 2007 1:48:49 AM Subject: [sqlite] Most basic of questions 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:

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 = $dbh->prepare