how to mpass a integer value to the query,
February 25, 2008 at 11:10 AM
dear all, im using a servlet. here in the servlet im executing a mysql query , which will retrieve the values in the table, now with the help of rs.getstring("categoryid");, im able to retrieve the category id, the problem here is while im passing this integer value as an input to another query, im getting error value, my question is what is the synatx to pass the integer value as an input to the query. the query that im using is below boolean Secresults = stmt.execute("select ProductID, ProductName,FinalPrice from productsInfo where CategoryID='" + Catid + "'");
View All Comments
| View Tutorial