how do in go about in order to check availabili in a form..

Recommended Answers

Are you wanting to validate a form or do something else? Your question isn't very clear.

Jump to Post

All 3 Replies

Are you wanting to validate a form or do something else? Your question isn't very clear.

i want to create an form to check availability of a room, i have something like this,
select rt.RoomName from Room rt, [Availability] rd
where rt.RoomName-rd.RoomName (FORMAT([rd.CheckIn], 'MM/dd/yyyy')) not between 'selectdate' and 'selectdate' and (FORMAT([rd.CheckOut],'MM/dd/yyyy'))
not between 'selectdate' and'selectdate'
but the problem is "i dont know how to go about in excecuting it in the form

On your form you would need two text boxes (as the simplest solution) or two calendar controls that the user can use to enter the two dates.
On form submission you then read those two values and make them parameters in your query.
If you have done any code around the form, post it up. We work better with examples.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.