Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › Filtering recordset result containing DATE_FORMAT by logged in user id

View all replies to this thread

Filtering recordset result containing DATE_FORMAT by logged in user id

Thread began 11/25/2013 11:22 am by Mysite07430650 | Last modified 11/26/2013 9:27 am by Mysite07430650 | 6236 views | 8 replies

11/25/2013 11:22 amMysite07430650

Filtering recordset result containing DATE_FORMAT by logged in user id

Hello Jason,

I am trying to filter the recordset result generated by the query below based on login UserID in order to display date and time the user last downloaded PDF files. I am finding it challenging to set a runtime value that either does not work and produces error or works but displays no data.

SELECT download_users.UserdownloadID, download_users.DownloadID, download_users.DownloadFileName, download_users.DownloadAllowed, download_users.DownloadCount, download_users.DownloadTime, pcms2_users.UserID, DATE_FORMAT(download_users.DownloadTime, '%W %D %M %Y') AS DownloadDate, DATE_FORMAT(download_users.DownloadTime, '%h:%i:%s %p') AS DeliveredTime
FROM download_users, pcms2_users
WHERE download_users.UserID = pcms2_users.UserID
ORDER BY download_users.UserdownloadID DESC

Any help is most appreciated.

Thanks.

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.