Thanks...how about an entry form?
Also, if I want to do JSP's easier are Struts better?
I will get the book though
Thanks
Scott
----- Original Message -----
From: "Eddie Barna" <[EMAIL PROTECTED]>
To: "Tag Libraries Users List" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 6:01 PM
Subject: Re: Tag List
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
