Populate Recordset only if current DATE and TIME matches
I would like to create a task application using WA DataAssist and JQuery to produce the page overlay (lightbox style) dialogue
box which will blank out the rest of the page and focus the user to the dialogue box.
I'm going to use a fixed position div along the bottom of the web site on every page (like facebook). I will then use Ajax which will reload
the content of the div along the bottom of the web site every 10 seconds which is pulling its content from a seperate page
which contains a recordset similar to the following:
(The jQuery code to generate the popup lightbox style dialogue box will only execute if the recordSet is NOT empty)
SELECT * FROM tasksTable
WHERE tasksTable.userId = sessionUserId
AND tasksTable.TaskDateTime = {current date and time} <<Not sure what I would put here to get it to filter by date and time.
AND tasksTable.taskStatus <> "completed"
Is their anyway for the recordset to only display data from the above query if the current dateTime is equal to the current
server date and time?
So if a user sets a task to remind them at say 10am on Monday 1st September 2010 the recordset will only show the contents
of that recordset (ie the recordset will not be empty) at 10am on Monday 1st September 2010?
I know you can do this with dates but I would like to be specific to the time as well.
The web application will only sit on a local machine anyway so the server time will be identical to the users computers time.
Any advice would be appreciated.
I'm currently using WA Data Assist, Security Assist etc and I can subscribe to your monthly toolkit if I need to to achieve this.