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
'where clause'"
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
