Hi,
First, sorry for the wrap on the lines below, and my apologies if this
message has been seen already- I appear to be having problems sending
to nntp.perl.org (I didn't realise you had to be subscribed to
[EMAIL PROTECTED] to send).
I am trying to insert some values into a mySQL database, all of the
scalars below have a value(none are undefined). I keep getting errors
similar to the one below and despite being instructed to read the mySQL
manual, I cannot find anything that relates to the problem I'm
experiencing.
Is the problem with my Perl (likely), or mySQL?
Can anyone offer a solution or pointers towards possible solutions?
Thank you in advance for any help you may be able to provide.
CODE:
my $dbh = DBI->connect("DBI:mysql:database","username","password");
my $result = $dbh->prepare("INSERT INTO table(
sitename,siteurl,category,description,country,region,city,added,expires
,submitted) VALUES
(?,?,?,?,?,?,?,?,?,?)");$result->execute($sitename,$siteurl,$category,$
description,$country,$region,$city,$added,$expires,$submitted); print
$dbh->errstr(),"\n" unless ($result);$dbh->disconnect();
ERROR:
DBD::mysql::st execute failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near
database(sitename,siteurl,category,description,country,region, at
/home/gl/httpd/index.pl line 403., referer: http://gl.example.com/
--
Gavin Laking - Web Development Daemon
http://www.gavinlaking.co.uk/
--
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
