asp.net

[Edward Gillan]

Hi there,

I need some feedback on this page

http://www.thephoenixgroupuk.com/selfdrive_hire.aspx

I have build my database and now uploaded to my hosts server. And this
form on this page gets information from it (obviously), but what i
have a problem with is, if you select a vehicle, lets say the Ford KA,
and then select a start date and an end date, then click submit, you
will always get a response saying this vehicle is not available on
this date, no matter if its never been selected before, what could be
the problem?

thanks

edd

 

[alex]

i select start date 1 Jan 04 and end date 1 Jan 05

your sql says:

.... and ( rentStartDate > #1/1/2005# or rentEndDate < #1/1/2004# ) ...

you need to switch the field names or the values