HTML Code ClinicDo you have some HTML code you'd like to share and get suggestions from others for tweaking or improving it? This discussion is the place.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the HTML Code Clinic 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
My Question is related to SQL Query. Let me explain it using an example.
Suppose an access table having records 001,002,003,004,005
Now what I want to do is using Select Query sort the records in such a way that it first display 004 and then the remaining records
So the list will display something like this
004
001
002
004
005
I can only use ONE sql query to sort and display the records in above mentioned format
Select count(*) from "your tab-name" where "fiel-name" <> "004"
...and later on in the script when you want to write the list to the screen, start with 004 (if this is current every time) and then you "response.write" the querry!