Try this also Check the spelling of FirstName.. in select you had given as FirstNname and in where condition its given as FirstName.
-saravanan >===== Original Message From "A mailing list for discussion about Sun Microsystem's Java Servlet API Technology." <[EMAIL PROTECTED]> ===== >Hi, > > Sorry for my previous reply (Thought tno was a string as someone asked it >before) > > replace: .....TaxNumber=tno...... > > with : ....TaxNumber= "+tno+" GROUP BY ....... > > and try it. > > >String sql="SELECT FirstNname, LastName, TaxNumber, SUM(Debt) As Total FROM >" + > "Arsa_beyan WHERE TaxNumber=tno GROUP BY TaxNumber, Firstname, Lastname "; > >following is a error message: > > >Srinivas > >>___________________________________________________________________________ >>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body >>of the message "signoff SERVLET-INTEREST". >> >>Archives: http://archives.java.sun.com/archives/servlet-interest.html >>Resources: http://java.sun.com/products/servlet/external-resources.html >>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > >___________________________________________________________________________ >To unsubscribe, send email to [EMAIL PROTECTED] and include in the body >of the message "signoff SERVLET-INTEREST". > >Archives: http://archives.java.sun.com/archives/servlet-interest.html >Resources: http://java.sun.com/products/servlet/external-resources.html >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
