View Single Post
  #1 (permalink)  
Old February 29th, 2008, 02:52 AM
saifi4u saifi4u is offline
Registered User
Join Date: Dec 2006
Location: Islamabad, , Pakistan.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using ORDER BY in SQL on date field in ASP page

Dear All
I am using ASP for getting data from database and display now i want to sort my data while i am displaying it on webpage by date the existing query i am using is
strSQLAcc = "SELECT Accounts.* FROM Accounts WHERE Accounts.RegNo = " & rsSociety.Fields("RegNo").Value
any one can help me to rewrite this query according to my new requirement
thank you

Reply With Quote