Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 29th, 2008, 02:56 AM
Registered User
Join Date: Dec 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using ORDER BY in SQL query 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 usiang 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

Old February 29th, 2008, 09:19 AM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

X-Post: http://p2p.wrox.com/topic.asp?TOPIC_ID=69415

================================================== =========
Read this if you want to know how to get a correct reply for your question:
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using ORDER BY in SQL on date field in ASP page saifi4u Classic ASP Professional 3 March 1st, 2008 07:40 PM
Sql Query Help - ASP cancer10 Classic ASP Databases 8 November 7th, 2006 03:19 PM
Loading query data onto ASP page rweide Classic ASP Databases 9 October 13th, 2004 07:33 AM
Sql Query in ASP mateenmohd SQL Server 2000 3 October 29th, 2003 12:16 AM
ASP SQL fields in order ALoPresto Classic ASP Databases 2 July 25th, 2003 02:54 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.