tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felipe Leme <jakartalis...@felipeal.net>
Subject Re: SQL / Date query
Date Mon, 19 Jan 2004 00:56:06 GMT
Hi Jack,

Looks like you forgot to user parentesis in the first CURDATE. Your WHERE 
statement should be:

WHERE date BETWEEN CURDATE() and CURDATE() + INTERVAL 6 DAY

Regards,

Felipe


On Sunday 18 January 2004 22:48, Jack Lauman wrote:
> I'm trying to create a JSP page the will display rows of a table
> beginning on the current date and ending at a total of 7 days.
>
> The following query works in MySQL but returns the following error
> when attempting to run the jsp:
>
>
> org.apache.jasper.JasperException:
>    SELECT date, time, am_pm, height, cond
>    FROM cherry_point_tides
>    WHERE date BETWEEN CURDATE and CURDATE() + INTERVAL 6 DAY
>
> : Column not found,  message from server: "Unknown column 'CURDATE' in


---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org


Mime
View raw message