-e 'use DBI; print $DBI::VERSION,"\n";' it gives following
> errorcd c\
> Can't find string terminator "'" anywhere before EOF at -e line 1.
It works for me!
owen@owen-desktop:~$ perl -e 'use DBI; print $DBI::VERSION,"\n";'
1.607
On Sun, 05 Dec 2010 11:27:01 +
Clive Eisen wrote:
> On 05/12/2010 10:52, Owen wrote:
> >
> > I have 445, 6 element csv files, about 35 lines in all. I only
> > have one machine, but a number of Linux OS.
> >
> > These csv files are parsed, the data check
On Sun, 05 Dec 2010 11:27:01 +
Clive Eisen wrote:
> On 05/12/2010 10:52, Owen wrote:
> >
> > I have 445, 6 element csv files, about 35 lines in all. I only
> > have one machine, but a number of Linux OS.
> >
> > These csv files are parsed, the data check
On Sun, 05 Dec 2010 11:27:01 +
Clive Eisen wrote:
> On 05/12/2010 10:52, Owen wrote:
> >
> > I have 445, 6 element csv files, about 35 lines in all. I only
> > have one machine, but a number of Linux OS.
> >
> > These csv files are parsed, the data check
.
I am at a loss to understand why this is so.
Are there any suggestions as to what may cause this anomaly?
The version of SQLite is 3.6.13
TIA
Owen
; of this.
> I am ready to treat for this :)
What exact platform are you using?
Linux(distro?), solaris? ???
What version of DBI are you trying to install?
What happened when you tried to build (or install) DBI?
Were there any error messages?
--
Owen
(@INC contains:
Error messages are meant to be read. See
http://search.cpan.org/~smueller/PathTools-3.31/Cwd.pm or do it via
cpan
--
Owen
ng Perl DBI to first identify whether a given
> database exists or not if it doesn't create the database?
Well I am not sure what you are trying to do, but lets say your
database has the name "my_data.db"
Check that my_data.db exists
if (-e my_data.db){connect} else {connect and create}
See how you go from there
Owen
SQLite is a great facility for my purposes, I don't know how it would
get on with gigabyte sized files, but certainly for smaller stuff and
general hack work, it and its perl interface are ideal
Owen
TIA
Owen
erl.org to get the idea of what
people ask, and how.
Owen
ine.
>
> I wrote a very simple perl script as a test, and always get the same
> message:
>
> use DBI;
>
> my $dsn="DBI:mysql:koha:localhost:3306";
Should there not be a semicolon after koha, rather than a colon?
--
Owen
tatements if I decide to use DBD::SQLite?
I use DBD::SQLite all the time, but never had to reuse another script.
I would simply try it on a sample file. Hopefully it will silently
ignore those assignments.
perldoc DBD::SQLite and DBI are worth the read if you haven't done so.
Owen
I have a script that operates on SQLite and SQLite2 that finished like;
$sth->finish; # Statement handle for $data_dbh
$sth_users_dbh->finish;# Statement handle for $users_dbh
$data_dbh->disconnect;
$users_dbh->disconnect;
__END__
After running successfully, it reports;
"clos
://search.cpan.org/~mschwern/Test-Simple-0.66/lib/Test/More.pm
Owen
error
occurs, you need to read the last few lines to determine what went wrong.
So go back to the make part and see if you can psyche out what's wrong
Owen
On Sun, 17 Sep 2006 22:16:12 -0500
Lane <[EMAIL PROTECTED]> wrote:
> Hi.
>
> Can someone please point me to a searchable archive of dbi-users.
You can search Google Groups perl.dbi.users
Owen
The code below creates a database, then reads it but it fails when I try to
match an apostrophied name.
Any suggestions as to where I am going wrong would be much appreciated.
Owen
===
#!/usr/bin/perl -w
use strict;
use
Can any Windows user advise me if the module DBD::SQLite is available as
part of the windows packaging system with Perl for Windows.
TIA
Owen
when s/baz/bar/ but not s/baz/foo/
Not sure what to make of that.
Owen
--
ering the list.
On Apr 8, 2005 4:49 PM, Owen Berry <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm experiencing the wonderful "Total Environment allocation failure"
> message when using DBD::DB2. I've searched all over for people with
> this problem, but everyone
Hi,
I'm experiencing the wonderful "Total Environment allocation failure"
message when using DBD::DB2. I've searched all over for people with
this problem, but everyone else seems to be suffering when running as
a CGI program. Mine is a CGI program, but I also get the error when
running from the c
e-ID: <[EMAIL PROTECTED]>)
with references that I followed up but I was unable to see how or if that would
be relevant to the above.
So is 'bind' relevant to speeding up the search or is there some other SQL
means of doing it
TIA
--
Owen
ences as I am not an SQL person.
As I am starting from scratch (no existing databases), I presume I might
just as well install DBD-SQLite-1.04
Would my assumption be correct?
TIA
Owen
as I'm sure you intended them to be.
FWIW
Owen
--
mit => 1});
AutoCommit=>1 means the entries are automatically numbered..right? so
$dbh->do("CREATE TABLE names (id INTEGER PRIMARY KEY, name)");
$dbh->do("INSERT INTO names VALUES (NULL, 'Dan')");
if you insert "NULL" into the first column, where does the column number come from? Or
is that part of the AutoCommit magic?
TIA
Owen
26 matches
Mail list logo