Ecobb - Thanks
Database field was set incorrectly as a text field not a date/time field, After change was made, using correct DateFormat string around my variable as well as Order By clause I was able to achieve results I was looking for, Thanks for pointing me in the right direction
<CFQUERY name="GetSchedule" datasource="#Datasource#">
SELECT * FROM schedule ORDER BY 'eventdate'
</CFQUERY>
But using above query with (order by) is producing this output
Monday, September 20, 2004
Wednesday, July 7, 2004
Sunday, April 18, 2004
Wednesday, May 12, 2004
I have a variable named eventdate, which lists schedule dates for a concert in this format (Wednesday, July 7, 2004), they are being entered in a database through a form in a random order.So ASC or DESC in query output will not work.
I need to display concert dates from most recent to furthest...
All bad urls are being redirected to http://hits.dailyvisitors.com/
ad-aware6.0 and norton not finding anything, and I have been unable to find any removal instructions.
This is something I used to upload a thumbnail and large image.
<cfset idesty = "your folder path">
<cfif #form.sm_image# is not "">
<cffile action="UPLOAD" filefield="form.sm_image" destination="#idesty#" NAMECONFLICT="MakeUnique"...
I understand displaying data in columns when it comes to recordcount and mutiple records in a database, but what If I need to display 25 fields in 5 columns from 1 record in my database.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.