Need help with ORDER BY statement - Webmaster Forum - Web Design, Programming and SEO forums

04-02-2006, 12:43 PM

nickmc

Status: I'm new around here
Join date: Mar 2005
Location:
Expertise:
Software:

Posts: 23

iTrader: 0 / 0%

nickmc is on a distinguished road

Need help with ORDER BY statement

I need your expert help with this, im trying to sort the following by "Date" ive tried adding code here and there but nothing seems to work! the code below works fine and extracts data from the database but I can't see to get it to output by date order. This is connected to a MS Access database and the date format is short date format (dd/mm/yyyy). Im sure its pretty simple to do but I am new to ASP so please help me!

<%

Dim DBConn
Dim sDBString

sDBString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("chamber.mdb") & ";"

set DBConn = Server.CreateObject("ADODB.Connection")

'' Note: Open the database
DBConn.Open(sDBString)

SQLQuery = "SELECT * FROM Events"

Set DBOutput = DBConn.Execute(SQLQuery)
%>
<body text="#000000">

<%Do While Not DBOutput.Eof%>

 

<%=DBOutput("Date")%>
<%=DBOutput("Event")%>

<%=DBOutput("Time_held")%>
<%=DBOutput("Members_price")%>

<%=DBOutput("Non_members_price")%>
<%=DBOutput("Address")%>

<%=DBOutput("Speaker")%>
 
 

<%
DBOutput.Movenext
Loop

DBConn.Close
Set DBOutput = Nothing
Set DBConn = Nothing
%>
 
</body>
</html>

04-03-2006, 12:42 AM

PCGuru

Status: I'm new around here
Join date: Apr 2006
Location:
Expertise:
Software:

Posts: 3

iTrader: 0 / 0%

PCGuru is on a distinguished road

off the top of my head - SQLQuery = "SELECT * FROM Events ORDER BY Date DESC"

If you want date in ascending order change DESC to ASC.

Theory is to order the result set in the basic query, then use the asp to output the result set as it stands.

Hope this helps, at least points you in the right direction!

04-03-2006, 10:23 AM

nickmc

Status: I'm new around here
Join date: Mar 2005
Location:
Expertise:
Software:

Posts: 23

iTrader: 0 / 0%

nickmc is on a distinguished road

PC Guru you are a guru! that worked perfectly! I was just writting the code slightly wrong but what you said worked! Thanks!