Many thanks!
-----Original Message-----
From: Henner Kollmann [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 3:09 PM
To: 'Julio Ortuzar O.'
Cc: [EMAIL PROTECTED]
Subject: AW: [dbforms] Sort fields in within query
>
> The problem is:
>
> whereClause="<%= strWherePart %>" ?
>
>
> Could you please explain a bit more. Thanks!
See taglib doc:
whereClause
Replaces the filter attribute in situations where the whereClause is
more complex. Allows a developer to specify a free form conditional
clause (where Clause + order + etc).
Also, the whereClause can not be used with orderBy or filter attributes.
They will be ignored. Order by should be used within the whereClause
instead.
Example:
<% StringBuffer whereClause = new StringBuffer();
whereClause.append("WHERE (FIELD1>'25' AND FIELD1<'50' ) OR FIELD2 NOT
NULL ORDERBY FIELD7"); %>
<db:dbform table="TABLE1" followUp="this.jsp" whereClause =
"<%whereClause.toString()%>">
If you use the whereClause searching and sorting will not work!
Regards,
Henner
-------------------------------------------------------
This SF.net email is sponsored by OSDN developer relations
Here's your chance to show off your extensive product knowledge
We want to know what you know. Tell us and you have a chance to win $100
http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
