Sql Query
hi all ..please help me ....what's wrong in this query ..i'm using it in java
:String sql="insert into Etudiant(Nbetudiant, Pass, Nom , Prenom , Adress , Tel , Email , Sexe , Fax , Diplome , Date) values('"+ Nbetudiant +
"','"+ pass +"','"+ Prenom +"','"+ Adress +"','"+ Telephone +"','"+ E_mail +"','"+ Sexe +"','"+ Fax +"','"+ DateUtils.now("dd MMMMM yyyy") + "')";
and thnx for help
Software/Hardware used:
Software/Hardware used:
ASKED:
February 6, 2009 6:47 PM
UPDATED:
February 10, 2009 9:10 AM
Answer Wiki:
I think a value is missing for field <i><b>Diplome</b></i>
This might not be the only error. If you are getting some error message, please post it.
(kccrosser)
You are missing two data fields - "Nom" and "Diplome", so your value fields don't match the list of field names.
(techy001)
If you would like to enter only specific columns then use (Nbetudiant, Pass, Prenom , Adress , Tel , Email , Sexe , Fax , Date) before "values". To provide values for all columns then no need to provide the column names before "values".
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
