Sort by 2 fields; user picks 1? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Botcollector -> 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 -> 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)




Botcollector -> 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




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875