in reply to Re: Help with DBD::CSV
in thread Help with DBD::CSV

Thanks to both sacked and jZed for Answering the post.

jZed, you were right! When the field's names are not specified in both the file and the csv_table hash, Perl does not complain anymore. In fact, I choose to specify them in the file(s), but is there a reason for prefering one method to the other?

For the SQL command, I also take note that this is not supported yet and I will find a different way of doing this subselect. (key and value were field name I only used in the example for illustrating my problem.

--
jey

Replies are listed 'Best First'.
Re: Re: Re: Help with DBD::CSV
by jZed (Prior) on Apr 30, 2004 at 23:12 UTC
    In fact, I choose to specify them in the file(s), but is there a reason for prefering one method to the other?
    No, either is fine. I tend to prefer keeping the columns in a file because *) other programs like Lotus or MS-Access that read CSV files can use the field names *) if you forget what the names in the file are, you can either use SQL to query for them or just do a 'head' on the file.
[reply]

In Section Seekers of Perl Wisdom