in reply to DBI data types

To use the constants such as 'SQL_INTEGER' you need to define them by replacing 'use DBI' with: 
use DBI qw(:sql_types);

[download]
That should fix the bareword error, and might affect the other errors you are getting.

-Blake

Replies are listed 'Best First'.
Re: Re: DBI data types
by Dalin (Sexton) on Aug 21, 2001 at 23:18 UTC
    That seems to have corrected those problems, but I seem to be having a parsing problem. I made the change to the "Use DBI" line, and I get the following when I run the script - 
    DBD::Pg::st execute failed: ERROR:  parser: parse error at or near "al
+bino" at .
/dbtest.insert line 27, <CSV> line 1.

    [download]
    "albino" is part of a name from the file being read for the values. The file is "|" delimited, but two of the three fields have spaces between words within them. The other field is numeric. i.e. 12345|SWORDTAIL ALBINO REG|XIPHOPHORUS HELLERI (This is a fish in case you are wondering) Any ideas?????? Thanks for the help. Bradley Where ever there is confusion to be had... I'll be there.
[reply]
[d/l]

In Section Seekers of Perl Wisdom