Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
bigreddastud #1
CFPOP sorting by date
I'm trying to sort emails off my email server for a basic web interface, but am
having problems sorting the messages by date.
I am using a query of query and can sort by messageNumber, but when I try to
sort by date, it dies on me. Here's my code:
<cfpop
action="getheaderonly"
name="tempqGetMessages"
server="#mailServer#"
timeout="90"
username="#session.username#"
password="#session.userpass#">
<cfquery name="qGetMessages" dbtype="query">
select *
from tempqGetMessages
order by tempqGetMessages.date desc
</cfquery>
Please help !
bigreddastud Guest
-
Sorting a date column
Sekhar, I think you have run across a known bug where the order by ignores the table prefix POProjects. and orders by the result column called... -
Formatting and sorting date
I have an asp page which displays records from an access table. One of the fields in the table is a date field. The regional settings on the... -
File sorting by a specific date
I want to search a directory of log files and populate a list of those log files ONLY if they match today's date (localtime). $logs =... -
date sorting module
Hello I just came from cpan, after doing some searches and before I get a module, wanted to ask if any one out there knows of a module that takes... -
Grouping and sorting by date
If you convert your date without the time in datetime format, sql will take it and put 00:00:00 as the time everywhere. That will make grouping...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
