TrueIncorrect syntax near '-'.

[thanasis_gt]

<%
set conn = CreateObject("ADODB.Connection")
conn.open strConnection
sql = sql="Select t.hotels_id,t.roomtype_id, t.startdate, t.enddate, t.capacity, count(t.room_no) as total_room from h_room t where t.hotels_id=" &request("id")&" and t.capacity="&request("capacity")&"and (('" & request("startdate") & "' Between t.startdate And t.enddate)) and (('" & DateAdd("d",-1,request("closingdate")) & "' Between t.startdate And t.enddate)) and not exists (SELECT DISTINCT b.room_id FROM h_bookinfo a,h_room_booked b WHERE a.bookinfo_id=(b.bookinfo_id) and hotels_id="&request("id")&" and b.room_id=t.room_id and ((manual_booking='"&true&"' or status='"&true&"') or (manual_booking='"&true&"' and status='"&true&"')) and (('" & request("startdate") & "' Between checkin_date And checkout_date Or checkin_date between '" & request("startdate") & "' and '" & DateAdd("d",-1,request("closingdate")) & "') Or ('" & DateAdd("d",-1,request("closingdate")) & "' Between checkin_date And checkout_date Or checkout_date between '" & request("startdate") & "' and '" &DateAdd("d",-1,request("closingdate")) & "') ))group by t.hotels_id,t.roomtype_id,t.capacity,t.startdate,t.enddate"
on error resume next
conn.execute(sql)
if err.number <> 0 then
response.write(sql)
if conn.errors.count > 0 then
for each e in conn.errors
response.write e.description & "<br>"
next
end if
response.end
end if

[techgnome]

<?asp

If you.HaveErrors Then
threadpost = New Message
threadpost.coherently = True
threadpost.askquestion = True
threadpost.Description = "Clear message"
threadpost.Post(ToVBForums)
End If

If threadpost.style = clear Then
threadpost.WillGetAnswers = True
You.Rejoice()
Else
threadpost.WillGetAnswers = False
threadpost.Replies = New threapost(style.NonSensical, "Remove Eels from Hovercraft")
End if



-tg

[LaVolpe]

... threadpost.Replies = New threapost(style.NonSensical, "Remove Eels from Hovercraft")-tg

Cute
The OP may not get it, but if he looks in your signature links, maybe he will

[honeybee]

What's the value stored in the variable sql? If you could post that, the error would be more obvious to spot.

<Sigh> and please remember we are geeks/nerds who can't read English. We are better at reading code.

.