in reply to DBD::CSV quote() oddity

Yes, it's the version of SQL::Statement. I recently fixed the empty string parsing. In general it's better to use placeholders or to use NULL instead of empty string, but your problem should be fixed in the most recent SQL::Statement. I'm debugging some errors in the make test for the latest statement but you can safely ignore the test failure and install it anyway, it's a test problem, not a module problem.

update please let me know if this fixes your problem.

Replies are listed 'Best First'.
Re^2: DBD::CSV quote() oddity
by shemp (Deacon) on Apr 22, 2005 at 18:17 UTC
    Thanks much!
    Yep, i upgraded to SQL::Statement 1.13 (from cpan) and things now work as expected.
    Regarding using NULL, etc, im taking results directly from reads from another csv table (file) and normalizing the data. At this stage all im doing is re-arranging the table structure, actually modifying field contents will come later.