0

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

eg

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="Display1">

<!--- quer data  -->
 <select id="getAll"  parameterClass="long" resultClass="Display1">
   select * from account
WHERE pass ='vatri'

</select>
</sqlMap>

okay now i tried to fetch the record using form inputs from jsp via pass variable in ibatis-servlets, it keeps on returning
error message irrespective of whether correct pass value is entered or not.
when i used input form my query becomes

select * from account
WHERE pass = #pass#

I equally try this query below but it does not work

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

I think the problem is from the query. any help please

Edited by peter_budo: Removing old code formatting and moving to JSP

2
Contributors
1
Reply
2
Views
4 Years
Discussion Span
Last Post by peter_budo
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.