There's more than one way to do things | |
PerlMonks |
Re: Updating Specific Fields in MS Accessby pfaut (Priest) |
on Apr 17, 2003 at 01:40 UTC ( [id://251101]=note: print w/replies, xml ) | Need Help?? |
Bareword found in conditional at C:\Perl\scripts\test\newer.pl line 43. In your while statement, I think you want to read from INPUT so put it in brackets like while (<INPUT>)Use of uninitialized value in split at C:\Perl\scripts\test\newer.pl line 26. You get this error because of the one above. Since you didn't read from INPUT into $_, it was undefined when you attempted to use it as input to split. Use of uninitialized value in concatenation (.) or string at C:\Perl\scripts\test\newer.pl line 33. You've never assigned anything to $row Update:$row and @row are two different variables. Your SELECT returned data to @row which is an array. $row is a scalar that just happens to share a name with the @row array but is otherwise a different variable. Use of uninitialized value in concatenation (.) or string at C:\Perl\scripts\test\newer.pl line 35.
"DBD::ODBC::db prepare failed: MicrosoftODBC 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. Since $field2 doesn't have a value, the field list in your insert statement equates to an empty list which is not allowed. Can't call method "execute" on an undefined value at C:\Perl\scripts\test\newer.pl line 37." Since the prepare failed, $sth2 is undefined. Non-syntax errors: Move your database connect and statement prepares outside the loop. They only have to be done once. You stated that you wanted to update a field. INSERT adds records to the database. I think you want an UPDATE statement instead. Unless you include a WHERE clause in your SQL statements, they will act on all rows in the table. Your SELECT statement will return every row from the table. I think you want to add a WHERE clause to limit the returned data to the server that you just read from the file. The same applies to the UPDATE. Also, the SELECT isn't necessary. You don't need to read a record before updating it.
In Section
Seekers of Perl Wisdom
|
|