View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Populate Recordset only if current DATE and TIME matches

Thread began 10/30/2009 10:01 am by info305726 | Last modified 11/02/2009 7:32 pm by info305726 | 2010 views | 17 replies

info305726

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.

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...