View Single Post
  #2 (permalink)  
Old 02-01-2008, 03:21 PM
jelly's Avatar
jelly jelly is offline
Member
 
Join Date: Jan 2008
Location: Somerset, UK
Posts: 46
jelly is on a distinguished road
Assuming name2 is declared as varchar it will require string to be passed in the where clause, try:

Code:
rs=stmt.executeQuery("select name2 from table1 where name1='derik' ");
If that doesn't work then please post what the failure is that you are getting
__________________
-- Hope that helps
Reply With Quote