2 svar · 227 visningar · startad av mikul
Hej!
Jag vill kolla om det finns någon bokning av på en lägenhet mellan två datum.
Jag skulle vilja ha det ungefär så här:
sql = "SELECT * FROM ApartmentBooking WHERE EXISTS (select * from ApartmentBooking where "&_
"startdate between #" & cDate(fromdate) & "# and #" & cDate(todate) & "# and "&_
"AND Rel_ApartmentNO = "& request.QueryString("checkApartment") &") OR EXISTS "&_
"(select * from ApartmentBooking where "&_
"startdate between #" & cDate(fromdate) & "# and #" & cDate(todate) & "# and "&_
"AND Rel_ApartmentNO = "& request.QueryString("checkApartment") &")"
Men det funkar inte :( Får felmeddelandet:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error. in query expression
'EXISTS (select * from ApartmentBooking where startdate between #2003-12-12# and #2003-12-17# and AND Rel_ApartmentNO = 23) OR EXISTS (select * from ApartmentBooking where startdate between #2003-12-12# and #2003-12-17# and AND Rel_ApartmentNO = 23)'./webbdesign/europeanvillage/bib/apartments.asp, line 47
Hur skall jag gå tillväga för att få det som jag vill? :q
Jag förmodar att det finns en kolumns som heter endDate också.
sql = "SELECT * FROM ApartmentBooking " & _
" WHERE Rel_ApartmentNO = " & request.QueryString("checkApartment") & _
" and ( #" & fromdate & "# between startDate and endDate " & _
" or #" & toDate & "# between startDate and endDate )"
Du har ett where för mycket i din kod.
Tack så mycket! Nu funkar det finfint :)