You need to specify into which column you want to enter your series of
"yes" values.
Again, go back and read the documents available for your database i.e.
mysql = www.mysql.com
Your syntax should be:
$sth = $dbh->prepare(qq(INSERT INTO $stable8 (col1, col2, col3, col4, col5,
col6, col7, col8) values(?,?,?,?,?,?,?,?)))||
ErrTemp::Insert($dbh,$dbh->errstr);
$sth->execute(yes,yes,yes,yes,yes,yes,yes,yes) ||
ErrTemp::Execute($dbh,$dbh->errstr);
$sth->finish();
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------
|---------+--------------------------->
| | "anthony" |
| | <awards |
| | @wanadoo.fr> |
| | |
| | 06/05/03 10:19 |
| | AM |
| | |
|---------+--------------------------->
>---------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: Insert Statment
|
>---------------------------------------------------------------------------------------------------------------|
Hi,
well i tried something else:
This
$sth = $dbh->prepare(qq(INSERT INTO $stable8 values(?,?,?,?,?,?,?,?)))||
ErrTemp::Insert($dbh,$dbh->errstr);
$sth->execute(yes,yes,yes,yes,yes,yes,yes,yes) ||
ErrTemp::Execute($dbh,$dbh->errstr);
$sth->finish();
I tried around each yes single or double quotes and nothing and i get the
same error
DBD::mysql::st execute failed: You have an error in your SQL syntax near
'seltable values('yes','yes','yes','yes','yes','yes','yes','yes')' at line
1
at test.pl line 153.
now I'm completely lost!!!
