P.S. Actions are "helper" classes in the Struts framework, generally used to extend controller (servlet) functionality.
> -----Original Message----- > From: Morrow, Steve D. [mailto:[EMAIL PROTECTED] > Sent: Monday, November 10, 2003 9:33 AM > To: 'Tag Libraries Users List' > Subject: RE: embedding <sql:query> > > > SQL tags are great for doing quick-n-dirty test stuff, but > data access in a production environment is probably best left > out of the View layer (i.e., the *.jsp) of a > Model-View-Controller setup. Send the request to a servlet, > have the servlet call a data access method to populate a data > bean, and send the data bean (or List of beans) back to the > *.jsp for display. > > That's pretty high-level, but I hope it gives you the idea. :o) > > > -----Original Message----- > > From: Peter Choe [mailto:[EMAIL PROTECTED] > > Sent: Monday, November 10, 2003 9:29 AM > > To: Tag Libraries Users List > > Subject: Re: embedding <sql:query> > > > > > > i am relatively new to using the jstl. what do you mean > > putting it in > > Action? > > > > [EMAIL PROTECTED] wrote: > > > > > > > > > > > > > >Did you know you could get much better performance out of > > putting that > > >sql stuff in the Action? Savan Thongvanh > > >Berkley Technology Services > > >515.278.7725 > > > > > > > > > > > > > > > > Peter Choe > > > > > > > <[EMAIL PROTECTED] To: Tag > > Libraries Users List <[EMAIL PROTECTED]> > > > > > ing.com> cc: > > > > > > > Subject: > > embedding <sql:query> > > > > > 11/10/2003 09:25 > > > > > > > AM > > > > > > > Please respond to > > > > > > > "Tag Libraries > > > > > > > Users List" > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >is it possible to embed a <sql:query> tag inside a <sql:query>? > > > > > >i am trying to use the result of one sql to look up data > > with another > > >sql: > > > > > ><sql:query var="waitList" sql="SELECT discipline, course_num, > > >days_of_week, time_slot, crs_id, is_available, > > >wait_list_course.semester FROM wait_list_course, time_slots WHERE > > >time_slots.time_id=wait_list_course.time_id AND > school_id=? ORDER BY > > >discipline, course_num, time_slot, is_available"> <sql:param > > >value="${sessionScope.school}" /> </sql:query> > > ><c:forEach var="listRec" items="${waitList.rows}"> > > ><tr><td><c:out value="${listRec.discipline}" /> <c:out > > >value="${listRec.course_num}" /></td><td><c:out > > >value="${listRec.days_of_week}" /></td><td><c:out > > >value="${listRec.time_slot}" /></td><td><c:out > > >value="${listRec.is_available}" /></td><td><c:out > > >value="${listRec.semester}" /></td> > > ><sql:query var="count" sql="SELECT count(*) FROM > student_status WHERE > > >add IS NOT NULL AND crs_id=?"> > > ><sql:param value="${listRec.crs_id}" /> > > ></sql:query> > > ><td><c:forEach var="act_count" items="${count.rowsByIndex}"><c:out > > >value="${act_count[0]}" /></c:forEach></td> > > ><td><input type="button" name="close" value="Close" > > >onClick="doAction('<c:out value="${listRec.crs_id}" />', 'close', > > >'No')"><input type="button" name="open" value="Open" > > >onClick="doAction('<c:out value="${listRec.crs_id}" />', 'close', > > >'Yes')"><input type="button" name="recycle" value="Recycle" > > >onClick="doAction('<c:out value="${listRec.crs_id}" />', > > 'recycle')"></tr> > > ></c:forEach> > > > > > > > > > > > > >--------------------------------------------------------------------- > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > > >For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > >CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents > > >contain private, privileged and confidential information > > belonging to > > >the sender. The information therein is solely for the use of the > > >addressee. If your receipt of this transmission has > occurred as the > > >result of an error, please immediately notify us so we can > > arrange for > > >the return of the documents. In such circumstances, you are advised > > >that you may not disclose, copy, distribute or take any > > other action in > > >reliance on the information transmitted. > > > > > > > > > > > > >--------------------------------------------------------------------- > > >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] > > > > > This message and any files transmitted with it are > confidential and are intended solely for the use of the > individual or entity to whom they are addressed. If you have > received this email in error, please delete the email and any > files transmitted with it entirely from your computer. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > This message and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete the email and any files transmitted with it entirely from your computer. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
