Sort by 2 fields; user picks 1?

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sort by 2 fields; user picks 1?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Sort by 2 fields; user picks 1?

Page: [1]

Botcollector

Posts: 69
From: None
Status: offline

Sort by 2 fields; user picks 1? - 3/20/2001 20:08:00

Okay, I think I've got this thing working where the surfer can choose which field to sort by in the results using a combo box to choose it. What I would LIKE to do is have FrontPage sort FIRST by the uer's choice, THEN by a consistent field name that I choose. For instance, the results would always be sorted by user's choice, then by Name. So, if they want the results sorted by Year instead of Genre, they would get the sort by Year, then by Name. Am I describing this clearly?

Also, does anyone know how to do group headers and that sort of thing? I tried running reports to the DRW instead of queries and views, but that doesn't work.

Any help appreciated, and thanks.

PS: I'm still working on getting that page uploaded where I want to use DRW links without repeating them for every record returned in the DRW region; should be up for peeks within a week.

Vince from Spain

Posts: 658
From: Madrid Spain
Status: offline

RE: Sort by 2 fields; user picks 1? - 3/20/2001 20:49:00

To order by more than 1 field, just separate them by commas. For instance . . .
SELECT * FROM mytable ORDER BY field1, field2

Which will sort first on field1, then on field2.

So, if you want the first to be input, and the second static as the Name field . . .

SELECT * FROM mytable ORDER BY ::myinput::, Name

. . . For instance

Vince

------------------
Internet Business Solutions S.L.(Spain)

(in reply to Botcollector)

Botcollector

Posts: 69
From: None
Status: offline

RE: Sort by 2 fields; user picks 1? - 3/20/2001 23:09:00

Many thanks, Vince. I tried copy/pasting the SQL from a multyi-field sort into the FP DRW code, and it did not match what you gave me here. I appreciate the correct format.

Until I can't figure something else out, folks.

...which means you'll hear from me again in about 4 hours, probably:> ).

Thanks again!

The 'Bot Collector

(in reply to Botcollector)