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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]