> -----Original Message-----
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 20, 2004 11:23 AM
> To: Hardy Merrill; [EMAIL PROTECTED]
> Subject: RE: Need some MySQL query help...
> *** OUTPUT ***
> syntax error at ./passwd2db.pl line 34, near ""Adding $key1
> to password
> database
> . \n";"
> Execution of ./passwd2db.pl aborted due to compilation errors.
That's a Perl syntax error, not an SQL syntax error.
> $dbh->do("INSERT INTO acct_db
VALUES('$key1','$uid','$gid','$gcos','$home','$shell',NOW())")
or print "Error updating database: ", $dbh->errstr, "\n";(
> print "Adding $key1 to password database. \n";
You have a spurious left parenthesis at the end of the $dbh->do() line.
Right
where the syntax error was reported.
Ronald
