>>select * from v_avail;
>>where villa_id=villas.idcode ;
>>and DATE>=thisform.fdate and DATE
>
>if Date is a date field, then i don't understand: "and DATE>=thisform.fdate and DATE" part of your sql query.
>
>is it a date or logical? either way optimize, optimize, optimize, and set optimze on
It's a UT parser thing, Andy. If you view source of the message, it's
and DATE >= thisform.fdate AND DATE < thisform.tdate
He posted without a space and the parser tried to make the last part an HTML tag.