Re: Select (ing) data based upon todays date

[Lyndon Durham]

Define a java.sql.Date object. You should be able to do this with a <jsp:useBean> declaration. Then simply pass the declared object using its id attribute as a <sql:param value="${beandID}"/>. Your select statement should be "Select * from rbh.prjhdr Where end <= ?"



Kevin Passey wrote:

Hi all,

I am building a small site for a charity, which I am doing for free. I have
question I am struggling with..

Here is my query using the database tags.

<sql:query> select ref, descr , start , end
from rbh.prjhdr </sql:query>

"start" and "end" are defined as date fields within a mySQL database.

My question is - what is the best way to select all recored WHERE "end" is
<= "today"

Thanks in advance

Kevin

--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>