Hi,
Im trying to query my access database using Dreamweaver MX. I would like to search BETWEEN two dates and am usnig the following SQL Query
SELECT Plot.Plot_No, Plot.Current_Build_Stage, Build_Stage.Description, Plot.Forecast_Completion, Reservation.Reservation_Date, Reservation.Exchange_Due, Reservation.Estimated_Completion_Date
FROM Reservation, Plot, Build_Stage
WHERE Reservation.Development_ID = Plot.Development_ID AND Reservation.Plot_No = Plot.Plot_No AND Plot.Current_Build_Stage = Build_Stage.Current_Build_Stage AND Plot.Development_ID = 'BIDE001' AND Reservation.Reservation_Date BETWEEN 'datefrom' AND 'dateto'
ORDER BY Plot.Plot_No

I know that the dates must be enclosed within ## when sent to Access but i dont know how to do this...
can anyone help, please... its been driving me mad all day..

Many thanks..
Also im looking for an extension or tutorial that allows Insert with Identity (the ones on this site do not work) i dont know about the OLE DB jet thing..
Thanks!!

WHERE Reservation.Development_ID = Plot.Development_ID AND Reservation.Plot_No = Plot.Plot_No AND Plot.Current_Build_Stage = Build_Stage.Current_Build_Stage AND Plot.Development_ID = 'BIDE001' AND Reservation.Reservation_Date BETWEEN '#datefrom#' AND '#dateto#'
ORDER BY Plot.Plot_No

There you go.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

THANKYOU.... im in the final stages of my last year at university... and thats helped me loads....

thanks!!!

Hi...

I put the code in as specified, but now i get a data type mismatch error???

whats going wrong..??