• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Ibatis servlets query

 
muntago Richard
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tried querying database records using pass variable from ibatis servlets
it works fine and fetch the records if correct pass value is entered but return error message if wrong pass value is entered
using if statement.
eg








Display1.java







ibatis servlet Display2.java




okay now i tried to fetch the record using form inputs from jsp via pass variable, it keeps on returning
error message irrespective of whether correct pass is entered or not.
it seems that Display2.java is no seeing the pass variable from Jsp form.

can someone tell me what is wrong in the Display2.java
thanks
 
muntago Richard
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
when i used input form my query becomes

any help please
 
muntago Richard
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i also try this but is not working

select * from account
WHERE pass = #pass:VARCHAR#


any help
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic