Too few parameters HELP

yvo

Hi,

Problem with MS Access query.

$req="INSERT INTO action (ID,Libelle) values (12,"Création pdf")";
$resultat =odbc_exec($link_id,$req);

Error:
SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in c:\inetpub\wwwroot\pgm\ajout_enr_fichier_bd.php on line 260

Thanks
Yvo😕

yvo

If i change " in the query an replace with ', it's other error
$req="INSERT INTO action (ID,Libelle) values (12,' Création pdf' )";
$resultat =odbc_exec($link_id,$req);

Error:
SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:\inetpub\wwwroot\pgm\ajout_enr_fichier_bd.php on line 260

Help me please..

Yvo 😕

ccgorman

Does the table only have 2 fields? You may want to check this, if it has more then 2 fields then one or more may be set to be not null, which means you must supply a value for it.

yvo

Yes, this tables have only 2 fields.

ccgorman

I just remembered, Access is a bit different for quotes you need 2"

your query should be:

$req="INSERT INTO action (ID,Libelle) values (12,""Création pdf"")";

but you may have problems with slashes so your query may be:

$req="INSERT INTO action (ID,Libelle) values (12,\"\"Création pdf\"\")";

$req="INSERT INTO action (ID,Libelle) values (12,''Création pdf'')"; (two single quotes)

Hope this is it,
Chris

yvo

I have one erro with all querys

$req="INSERT INTO action (ID,Libelle) values (12,""Création pdf"")";
//Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in c:\inetpub\wwwroot\pgm\ajout_enr_fichier_bd.php on line 260

$req="INSERT INTO action (ID,Libelle) values (12,\"\"Création pdf\"\")";
//Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[]Création pdf[]'., SQL state 37000 in SQLExecDirect in c:\inetpub\wwwroot\pgm\ajout_enr_fichier_bd.php on line 260

$req="INSERT INTO action (ID,Libelle) values (12,''Création pdf'')"; //(two single quotes)

//Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '''Création pdf'''., SQL state 37000 in SQLExecDirect in c:\inetpub\wwwroot\pgm\ajout_enr_fichier_bd.php on line 260

ccgorman

Scrap what I said in the last post. I looked up some old code and realised you need double quotes within text if there is a quote character (but this is when using ASP), so it is not applicable for what you are doing.

But for your problem, what may be the error is setting the ID, did you set the ID as auto? If so, you will only insert what is not auto

$req="INSERT INTO action (Libelle) values ("Création pdf")";

I hope this is it, sorry for the run around.

yvo

Thanks for your help.

I have the same with
$req="INSERT INTO action (Libelle) values ("Création pdf")";

//parse error
and
$req="INSERT INTO action (Libelle) values (\"Création pdf\")";
//Too few parameters. Expected 1

I can not understand.
Read-only is not selected
Is it possible one other error with the DSN?

Yvo

ccgorman

Sorry I don't know the problem either, it could be permissions, I found this on a site:

http://www.macromedia.com/support/ultradev/ts/documents/80004005update.htm

It may help.

-Chris