RE: Need some MySQL query help...
From: Ronald Kimball (rjk_at_focalex.com)
Date: 01/20/04
- Next message: John W. Herbold: "RE: Quick DBI:ODBC question..."
- Previous message: David N Murray: "Re: Quick DBI:ODBC question..."
- Maybe in reply to: Scott V Nipp: "Need some MySQL query help..."
- Next in thread: Scott V Nipp: "RE: Need some MySQL query help..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 20 Jan 2004 13:34:15 -0500 To: "NIPP, SCOTT V \(SBCSI\)" <sn4265@sbc.com>, "Hardy Merrill" <HMerrill@dhcr.state.ny.us>, <dbi-users@perl.org>
> -----Original Message-----
> From: NIPP, SCOTT V (SBCSI) [mailto:sn4265@sbc.com]
> Sent: Tuesday, January 20, 2004 11:23 AM
> To: Hardy Merrill; dbi-users@perl.org
> 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
- Next message: John W. Herbold: "RE: Quick DBI:ODBC question..."
- Previous message: David N Murray: "Re: Quick DBI:ODBC question..."
- Maybe in reply to: Scott V Nipp: "Need some MySQL query help..."
- Next in thread: Scott V Nipp: "RE: Need some MySQL query help..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
