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