Solved

Too few parameters

Posted on 2004-04-07
10
342 Views
Last Modified: 2010-03-31
Hey guys, im trying to run an update statement in java, my insert statement works fine...  below is the error im getting:

UPDATE Items set stockLevel = '99', isRedordered = 'false' Where items.ItemID = ID496; <-- values
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2



code: .....

String token = st.nextToken(); //Start the SQL statement
      SQLString = "UPDATE Items set stockLevel = '"; //First cell a string so has ' on either side of sql
      SQLString +=token + "',"; // data stock level


        token = st.nextToken(); // Read is third token
      SQLString +=" isRedordered = '" +token+"' Where ItemID = ";      //ordered?

     
        token = st.nextToken(); // Read is second token
      SQLString +="'" +token + "'";      //id

      SQLString +=";";      //end cell end with a bracket as it the last cell

0
Comment
Question by:mattdye
  • 5
  • 4
10 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 50 total points
ID: 10774048
Surely that should be

UPDATE Items set stockLevel = '99', isRedordered = 'false' Where items.ItemID = 'ID496'

?

and is there a typo here?

>>sRedordered<<

0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10774054
i.e. shouldn't it probably be

isReordered

?
0
 
LVL 37

Expert Comment

by:zzynx
ID: 10774103
Sure
           where items.ItemID = ID496

is right?

Shouldn't that be
           where items.ItemID = 496
or
           Where items.ItemID = 'ID496'
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 37

Expert Comment

by:zzynx
ID: 10774116
Just as small remark: Why use a string field to express a boolean?  (cf. isRedordered = 'false')
0
 

Author Comment

by:mattdye
ID: 10774119
ok ok fair play, dont suppose u can help me with another prob... how can i enter a null for a date datatype in access, ive tried null but doesnt work
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10774128
statement.setNull(1);
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10774136
(where 'statement' is a PreparedStatement)
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10774176
0
 
LVL 37

Expert Comment

by:zzynx
ID: 10774192
>> how can i enter a null for a date datatype in access
Doesn't  

            UPDATE Items set stockLevel = '99', isRedordered = 'false', myDate = NULL where ....

work, then?
0
 
LVL 37

Expert Comment

by:zzynx
ID: 10774210
Hey, hey, that's a quicky.
What was the solution now?

Did
       items.ItemID = 'ID496'

generate the error?
What about your null value then?
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question