RE: PreparedStatement

Hi there again

I'm repling to myself: and realize my problems came from a stupid coding mistake, having nothing to do with PreparedStatement

Forget it !

Francois

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Hi there
I'm using connector J 5.0.4. Lets say I have a preparedStatement with 4 parameters for an
insert command. I wish I could do the following: 
1) set all the 4 parameters to null with preparedStatement.setNull(pos, type) 
2) set some of them (say 1 and 2) to a non null value.

When I call preparedStatement.executeUpate() I have an SQLException saying parameter 3 is
not set. what's the problem here ?

Thanks for any advice

François