ODBC insert into MS Access

[Anon]

My PHP code generates the following SQL:

insert into studentChanges (studentID, homeCountry, termAddressCorrect, ethnicity, disability, disabilityAllowance, tuitionFees, slcApplication, sponsorCorrect, yearOut) values ("0000424", "698", "yes", "12", "00", "1", "01", "yes", "yes", "No");

When I execute it I get the following error message -

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 8., SQL state 07001 in SQLExecDirect in C:\Program Files\BadBlue\PE\ren\RecordChanges.php on line 31

I don't understand which "parameters" it is referring to, or why is should be expecting 8 parameters.

Could someone please explain.
Many thanks,
Garrie

[bastien]

for your yes/no items, are they check boxes? if so, try setting them to 0 for No and -1 for Yes. the DB might be having an issue with yes / no instead of the values...

you will need to code to make the changes

if ($disability="yes"){
$disability=-1
}else{
$disability = 0
}

something like that anyway.

hth
Bastien