<sql:wasNotEmpty >
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Pat_Quinn
Posted On:   Saturday, November 16, 2002 06:02 PM

Untitled Document Hi, I'm having a problem with the DBTag Library. I have a simple select statement which takes values from the repsonse to populate the where clause. My problem is when the the statement is executed and it returns record(s) it seems to cache the result statement. And when i execute the page again from another browser with values that i know shouldn't return a record it executes both the and . always returns 1 when i know it should return 0. My Code is as follows: <%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags" prefix="sql" %> Jdbc:Odbc:MyDataBase sun.jdbc.odbc.JdbcOdbc   More>>
Untitled Document

Hi,

I'm having a problem with the DBTag Library. I have a simple select statement which takes values from the repsonse to populate the where clause. My problem is when the the statement is executed and it returns record(s) it seems to cache the result statement. And when i execute the page again from another browser with values that i know shouldn't return a record it executes both the and . always returns 1 when i know it should return 0. My Code is as follows:


			
<%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags" prefix="sql" %>












Jdbc:Odbc:MyDataBase
sun.jdbc.odbc.JdbcOdbcDriver






select username
from userprofile
where username = ' <%=request.getParameter("username") %>' and
password = ' <%=request.getParameter("password") %>'








Valid Password



Invalid Password


Row Count:







   <<Less
About | Sitemap | Contact