You can pass the value from your search form to the page which you have
listed in your email. For example: You have a search form with a text box
titled search
Here's what the page that queries the db would look like now
> <sql:query var="productQuery" dataSource="${productDS}" >
> SELECT * FROM CD WHERE CDTITLE = ?
<sql:param value="${param.search}"/>
> </sql:query>
You can also expand on this by using the OR statement in your query. For
example:
> <sql:query var="productQuery" dataSource="${productDS}" >
> SELECT * FROM CD WHERE CDTITLE = ? OR ARTIST = ?
<sql:param value="${param.search}"/>
<sql:param value="${param.search}"/>
> </sql:query>
For every condition in your query you must add a <sql;param/> tag.
Hope this helps. I really do recomend that you get Shawn Bayern's book
titled JSTL in Action. It explains all this in great detail, plus
everything else.
----- Original Message -----
From: "Scott Taylor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 9:31 AM
Subject: Tag List
> I am trying to find a list of tags to help me modify the CD Shop Cart web
> application from Sun One.
>
> For example, how do I insert tags that provide a search form (and entry
> form) rather than simply list everything.
>
> Here is what the code looks like so far:
>
> <%@page contentType="text/html"%>
> <html>
> <head><title>CD Catalog List</title></head>
> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core"; %>
> <%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql"; %>
> <body>
> <h1> CD Catalog List </h1>
> <sql:setDataSource var="productDS"
> url="jdbc:postgresql://localhost:5432/recruitment"
> driver="org.postgresql.Driver"
> user="scott" password="" />
>
> <sql:query var="productQuery" dataSource="${productDS}" >
> SELECT * FROM CD
> </sql:query>
>
> <TABLE border=1>
> <TR>
> <TH>ID</TH>
> <TH>CD Title</TH>
> <TH>Artist</TH>
> <TH>Country</TH>
> <TH>Price</TH>
> </TR>
>
> <c:forEach var="row" items="${productQuery.rows}">
> <TR>
> <TD><c:out value="${row.ID}"/></TD>
> <TD><c:out value="${row.CDTITLE}"/></TD>
> <TD><c:out value="${row.ARTIST}"/></TD>
> <TD><c:out value="${row.COUNTRY}"/></TD>
> <TD><c:out value="${row.PRICE}"/></TD>
> <TD>
> <form method=get action="ShopCart.jsp">
> <input type=hidden name=cdId value="<c:out value="${row.ID}"/>">
> <input type=hidden name=cdTitle value="<c:out
> value="${row.CDTITLE}"/>">
> <input type=hidden name=cdPrice value="<c:out
value="${row.PRICE}"/>">
> <input type=submit name=operation value=Add>
> </form>
> </TD>
> </TR>
> </c:forEach>
> </TABLE>
> </body>
> </html>
>
> Regards
>
> Scott
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
