Re: sql statement

[Lambert Behnke]

Hello dude,   if Tax Number isn't a number but a char or varChar than it needs to be in single quotes ...   Just a thought,       Lambert >>> [EMAIL PROTECTED] 22/04/2002 16:38:16 >>> Hi,   I have a servlet that gets a parameter from a HTML form and execute a query. But my sql statement incorrect. I think following red part should be changed. Can anyone check it? ------------------------------------------------------------------------- . . String tno = request.getParameter("vergi_numaras�"); . . . String sql="SELECT  FirstNname, LastName, TaxNumber, SUM(Debt) As Total  FROM " +        "Arsa_beyan WHERE TaxNnumber=tno GROUP BY TaxNumber, Fname, Lname "; *********************************************************************** This transmission contains information which may be confidential and which may also be privileged. It is intended for the named addressee only. Unless you are the named addressee, or authorised to receive it on behalf of the addressee you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please contact the sender. Thank you for your cooperation. *********************************************************************** For more information about AEA Technology please visit our website at http://www.aeat.co.uk AEA Technology plc registered office 329 Harwell, Didcot, Oxfordshire OX11 0QJ. Registered in England and Wales, number 3095862.