passing parameter to sql query 1

[welshone]

hello,
how do I pass a parameter to an sql query ?
I can type into a text box then submit it to a servlet, then open another jsp showing the typed parameter, but if I try to add the parameter like below no data is displayed :

String queryString = "SELECT name, Postcode, County FROM Establishments WHERE Postcode = "+Est_Postcode+" ORDER BY name ";


any ideas ?

 

[mmaz]

if Est_Postcode is a string, there should be single quotes around it as such:

String queryString = "SELECT name, Postcode, County FROM Establishments WHERE Postcode = '" + Est_Postcode + "' ORDER BY name ";

 

[welshone]

damn, I shoulod have known that. (same as ASP)

cheers mmaz !