Friday Puzzler: Finding a meeting time

Here is an interesting problem, and one I admit I’m not sure what the best answer is. You have two people who want to meet. However, both are quite busy and have a day full of meetings. Can you use ColdFusion to find a time where both are available? I’ve created a simple data set that contains a query of 4 rows. Person ID is the FK of the user. Name is the name. Start and End are the times of a meeting. Each row then is one meeting, or a busy time. Your solution needs to find a time where users 1 and 2 can meet up (on 6/16 obviously). Your solution should only search from 8AM to 6PM, and, potentially, handle a case where a meeting is impossible.

Here is some code that will generate the data for you. By the way - notice how I commit one of the cardinal sins of UDFs - accessing outside data from a UDF. Also notice how I don’t care - it was a handy way to manipulate the core query quickly and easily. Anyway, here is the code:

<cfscript> function addEvent(personid, name, start, end) { queryAddRow(data); querySetCell(data, "personid", arguments.personid); querySetCell(data, "name",; querySetCell(data, "start", arguments.start); querySetCell(data, "end", arguments.end); } </cfscript>

<cfset data = queryNew(“personid,name,start,end”)> <cfset addEvent(1, “Ray”, “6/16/06 8:00 AM”, “6/16/06 10:00 AM”)> <cfset addEvent(1, “Ray”, “6/16/06 2:00 PM”, “6/16/06 4:00 PM”)> <cfset addEvent(2, “Lynn”, “6/16/06 8:00 AM”, “6/16/06 9:00 AM”)> <cfset addEvent(2, “Lynn”, “6/16/06 10:00 AM”, “6/16/06 12:00 PM”)> </code>

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

Lafayette, LA