try use Statement String vno = request.getParameter("vergino"); String Query="Select malik.VerginNo From ParselMalik Where Malik.VergiNo=?"; PreparedStatement st=mysql.prepareStatement(Query); st.setString(1,vno);
-----Original Message----- From: Halil AKINCI [mailto:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 4:14 PM To: Tomcat Users List; servlet-interest group; jakarta-tomcat yahoo groups Subject: another sql error Hi all , When I want to run following sql statement in a servlet, I receive following error message in tomcat's DOS console [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. In this sql statement, the "vno" variable is read from a HTML form by using following statement String vno = request.getParameter("vergino"); Other informations are gotten from MS Access tables (Malik, ParselMalik, KatMalik tablolarından). This sql statement is running correct within the access. I wonder how can I organize this sql? Can anyone help? ("SELECT Malik.VergiNo,Malik.Adı,Malik.Soyadı,ParselMalik.TasınmazID,ParselMalik.Hiss e " + "FROM ParselMalik,Malik WHERE Malik.VergiNo="+vno+" AND Malik.VergiNo=ParselMalik.VergiNo " + "UNION SELECT Malik.VergiNo,Malik.Adı,Malik.Soyadı,KatMalik.TasınmazID,KatMalik.PayMiktarı " + "FROM KatMalik,Malik WHERE Malik.VergiNo="+vno+" AND Malik.VergiNo=KatMalik.VergiNo"); -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>