I have only used DBD::CSV a little, but discovered the following:
o SELECT works
o DROP table works
o DELETE works
o UPDATE works
o APPEND works
No real field data type info is preserved. Dates are treated like text. A
missing column at the end of a record is treated as a NULL, but if a middle
column is empty it is treated as an empty string, not a NULL.
One annoying feature (I use CYGWIN): The owner of the file becomes the
owner of the table and when you get the list of tables via DBI, you may get
something like "username".tablename as the table name. That is great, but
you cannot select from that table without dropping the username or you get
a syntax error in your SQL.
Also, do not have spaces or periods in your filenames. Example: You have a
file named EMPLOYEES.CSV. It wont work. You have to take the ".CSV" off the
filename.
Read the documentation carefully, as it explains important things like how
to change the separator from a comma to a semicolon or something else, and
other neat things.
- Paul
At 02:53 PM 4/19/2001 +0200, you wrote:
>Hi,
>
>I'd like to do something using DBD::CSV, it's like a good system but does
>he understand DELETE, UPDATE, DROP reuquest (in sql statement...) ?
>
>There's no information about this kind of things....
>
>Well thnks...
>
>
>Ps : an other question, in the same way but, i'd like to do a a report
>system that should generate one file with a lot of page (one page per
>client), like tim's report system in ingram group, no ? It's should
>generate a lot of invoice in a file, and then print (using a printer) all
>the invoice... any thing can do that, or any module can generate
>staroffice files ?
>
>
>Thanks,
>
>--
>
>=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
>Nicolas JOURDEN - [EMAIL PROTECTED] - #41100039 - +33 0681940905
>http://www.wedoo.com/ - La Nouvelle Facon de Surfer...
>http://ddx.wedoo.com/ - Mon site perso.
>Programmeur, Integrateur | Perl, CGI, Mysql/PostgreSQL, HTML, Design
>=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
>
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Paul Anton Chernoch
Zeborg, Inc.
500 West Cummings Park
Woburn, MA 01801
t: 781.759.0105
f: 781.935.5090
c: 781.606.7382
http://www.zeborg.com
This message is a personal and confidential communication. If you are not
the intended recipient, please do not read, copy, or use it, and do not
disclose it to others. Please notify the sender of the delivery error by
replying to this message, and then delete it from your system. Thank you.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
