Member Avatar for mutago

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 because: Removing old code formatting and moving to JSP
  • 2 Contributors
  • 1 Reply
  • 118 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by peter_budo
Member Avatar for peter_budo

ibatis is closed as project by apache foundation, however you can get lot of help at mybatis

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.