close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Validate if the selected date and time is free to choose.

Thread began 10/05/2022 11:34 am by Jonas | Last modified 10/06/2022 1:51 pm by Ray Borduin | 117 views | 3 replies |

Jonas

Validate if the selected date and time is free to choose.

The user selects a date and a time (datetime) in a form field.
The user will then receive a message if this time is available or occupied. If it is busy, an error will occur.

The idea is that when a user has filled in a start time and an end time, this time cannot be used by anyone else.

I imagine that the database table should contain a start time (datetime) and an end time. And I am now wondering if there is any way to validate this.

Sign in to reply to this post

Ray BorduinWebAssist

You can create a recordset to check if that time is available and then validate if that recordset has any results.

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

Can you explain a little more clearly? Do you mean that the recordset should contain the columns or should I filter it somehow?

Sign in to reply to this post

Ray BorduinWebAssist

Your recordset would look to see if there is already a record that has a start time that is after the requested start time that is between the requested start and end time, or an end time that is between the requested start time and end time. Then you can check the TotalRows of the recordset to see if there is a conflict based on if that recordset has a result or not.

Sign in to reply to this post
Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...