Ask a Question related to Coldfusion Database Access, Design and Development.
-
fluiter #1
Sort dates by month
On my access data base, i've got date in "01-Jan-05" format.
Now i do need to quiry that sort the data by month, i'.e Jan-05 Feb-05 ect.
I hope that some one can help me with ssuth a quiry
fluiter Guest
-
memory sort and disk sort
I check the sysprofile table and find there are 700 times disk sort, I think it is lack of sort memory. I want to turn all the disk sort into the... -
to convert a month to previous month
How to convert a month to previous month in a very easy way? For example, I have AUGUST, but I want JULY to return. Thanks. *** Sent via... -
Dates won't sort properly
01/01/01 02/02/00 03/01/01 My file is sorting dates on the month, not the year. What am I doing wrong? -- = -
Ado sort error-Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB.
Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB. hi, guys i have asp... -
Sort - Month then day without year
How's about "Sort" Month / Day without year in birthday date field? Daniel R. Sloan -
alagukannan #2 Re: Sort dates by month
Hi
Coldfsuion ahs some function which u can use and read this article
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18324[/url]
Check the MS Access Documentation for date formats.It will be there.
Thx
Al
<!---query HR db to retrieve employee information--->
<CFQUERY NAME="EmpList" DATASOURCE="HR">
SELECT FirstName, LastName, StartDate
FROM Employees
</CFQUERY>
<!--- display page heading --->
<h4>Employee Start Date Listing</h4>
<!--- Output query results--->
<CFOUTPUT QUERY="EmpList">
#FirstName# #LastName#
#DateFormat(StartDate)#
<br>
</CFOUTPUT>
alagukannan Guest
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
