Need help with sql statement

[princekwame]

Hi, can anyone please help me with this problem I keep getting everytime i try to preview a Customer submission form i created.

this is the error msg it keeps coming up

MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

and this is the SQL statement
SQL INSERT INTO booking_info ("Customer First Name","Customer Last Name","Phone Number","Mobile Phone number","E-mail Address","Customers Address", Service, Problems,"Time","Date","Month","Year") VALUES ( 'Prince ' , 'Asamoah' , 96379915 , 0421474641 , 'princekwame@hotmail.com' , 'sdasd' , 'Computers - Application Software' , 'Windows Update/Installation' , '9:30 am' , 03 , March , 2004 )
DATASOURCE customer_booking_info
VENDORERRORCODE -3010
SQLSTATE 07002

thank you sooo much
:thumbsup:

[Tuemmel]

Hi there,

you should check your ", " and ',' . However, I prefer mysql database. It's fast, free and easy to use. Try apachefriends. In that package, you get a good mysql database constructur include php mysql code generation. There's always trouble with obcd.

Hope this will help.

[raf]

Please, choose a meaningfull title (see our posting guidelines) and post it in the right forum (the 'other databases subforum)

The re are quite some errors in your statement.
There is a value to much (12 while you only have 11 fields), the fieldnames should not be enclosed in quotes, yhere are stringvalues that are not enclosed in single quotes (march)

coud also be other errors since this should call a stored procedure where we don't see the code from.