[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Regards, Rene Larsen
Rene Larsen wrote:Just to translate the error for the English reading people in here: "Parametri insufficienti. Previsto 1" = "Too few parameters. Expected 1"
Antony Amicone wrote:loool i didnt noticed, thank you my wife is from san francisco so i read both languages naturally :P
are you italian?
Regards, Rene Larsen
Regards, Rene Larsen
Rene Larsen wrote:Ok, back to your question...
This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried.
Are you sure that you have the level column in your Access DB - and that it is spelled correct??
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
OCUP UML fundamental and ITIL foundation
Jan Cumps wrote:Doesn't your database expect:
?
Antony Amicone wrote:yes i did this, recipeName, servins and timeToEat, are the name of the variable containing the value for the database, and are the name of field of db too
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Antony Amicone wrote:INSERT INTO Recipes(Recipe,servings,timeToEat) VALUES (test,4,15)
this is the query that is made
Regards, Rene Larsen
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Jeanne Boyarsky wrote:
This is a problem. It calls both executeUpdate and executeQuery for an insert. I think you want to add an else here.
~ Neil (SCJP)
ID ( number )
INSERT INTO Recipes(ID,Recipe,Servings,timeToEat,howTo) VALUES ('7','Peanutbutter and banana','4','15','Insert here your recipe')
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
~ Neil (SCJP)
~ Neil (SCJP)
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |