kindly help I am making some fundam

[da21]

kindly help I am making some fundamnetal querying error below !
Thanks!
Ihave just created a text field, taking user input there and querying the database in the pet table.

String nam = request.getParameter("tex"
rs = statement.executeQuery("select *" + "from pet" + "where name = '"nam"' "

Kindly guide me for syntax error.
Thanks!

 

[sleipnir214]

The query your concatenation would produce is:

select *from petwhere name = '[some nam value]'

You have some missing spaces in there.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!