Perl-Sensitive Sunglasses | |
PerlMonks |
Updating Specific Fields in MS Accessby Anonymous Monk |
on Apr 17, 2003 at 01:14 UTC ( [id://251099]=perlquestion: print w/replies, xml ) | Need Help?? |
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
I have researched this on the Net for about a week now and after having some good and bad luck, have come to the Monks for their wisdom. I am new to Perl and had never programmed anything until about a month ago. Additionally, I have no experience with SQL or databases in general, so please have patience. I have a CSV file consisting of two values per line, a server name and a NIC driver version. I need to find the corresponding server name within an Access database and insert the driver value into the proper field in the same row. When I run my script, I get the following errors: Bareword found in conditional at C:\Perl\scripts\test\newer.pl line 43. Use of uninitialized value in split at C:\Perl\scripts\test\newer.pl line 26. Use of uninitialized value in concatenation (.) or string at C:\Perl\scripts\test\newer.pl line 33. Use of uninitialized value in concatenation (.) or string at C:\Perl\scripts\test\newer.pl line 35. "DBD::ODBC::db prepare failed: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (SQL-42000)(DBD: st_prepare/SQLPrepare err=-1) at C:\Perl\scripts\test\newer.pl line 36. Can't call method "execute" on an undefined value at C:\Perl\scripts\test\newer.pl line 37." here is my amateur code: Any suggestions will be greatly appreciated. 2003-04-16 edit ybiC: replace square bracket chars with appropriate html entities, to eliminate unintended PM links
Back to
Seekers of Perl Wisdom
|
|