Hey Roland, Just checked it out and realized I made a mistake. Funny how time clouds a memory. Sorry if I mislead you.
Cheers, Jonah On Wed, 20 Oct 2004 22:36:46 -0700 (PDT), witango man <[EMAIL PROTECTED]> wrote: > the custom column will only allow you to specify the > column - unfortunately it will not allow you to > dynamically specify the direction (asc/desc). > > I logged this as a feature request a few months back - > I wanted to have a form whereby the user could select > how they wanted the columns to be ordered by but also > the direction the order would be in. In the end I used > a direct DBMS... > > > > --- Jonah Simpson <[EMAIL PROTECTED]> wrote: > > > Indeedly do. > > > > From what I understand that would the code that gets > > inserted in the > > sort by portion. > > > > ie. Select * from blah_db.blah_table order by > > table.column @@ > > request$sort_order. > > > > I could be wrong though, I haven't used it for > > awhile. You might want > > to experiment by putting variables in and then right > > clicking on the > > query and choosing sql query to see what kind of > > query it actually > > generates. > > > > Good luck, > > Jonah > > > > On Wed, 20 Oct 2004 22:21:09 -0700, Roland Dumas > > <[EMAIL PROTECTED]> wrote: > > > > > > Yes, I see that. So what do I put in that free > > form box, something like > > > 'table.column ASC' or 'table.column > > @@request$sort_order'? > > > > > > On 10/20/04 10:14 PM, "Jonah Simpson" > > <[EMAIL PROTECTED]> wrote: > > > > > > > Hey Roland, > > > > > > > > I don't know if you're using Windows or OS X, > > but if you right click > > > > in the sort order window of a search action, you > > can choose custom > > > > criteria or something of that nature, which will > > give you the ability > > > > to input a variable to choose the sort order. > > > > > > > > Hope this helps. > > > > > > > > Cheers, > > > > Jonah Simpson > > > > > > > > > > > > On Wed, 20 Oct 2004 22:03:50 -0700, Roland Dumas > > <[EMAIL PROTECTED]> wrote: > > > >> In a search action, one sets the sort fields > > and the ASC DESC sort orders. > > > >> > > > >> Is there any way to control the sort order (ASC > > DESC) by a variable? > > > >> > > > >> One can always sort the resultset, but that's > > only sorting the piece of the > > > >> totalrows > > > >> > > > ----------------------------------------- > > > Roland Dumas > > > Roberts Information Services > > > 310 W. Bellevue Avenue > > > San Mateo CA 94402 > > > 650-347-1373 > > > 415-412-9300 (cell) > > > [EMAIL PROTECTED] > > > SMS: http://new.servqual.com/html/sms.tml > > > > > > > > > ________________________________________________________________________ > > > > > > > > > TO UNSUBSCRIBE: Go to > > http://www.witango.com/developer/maillist.taf > > > > > > ________________________________________________________________________ > > > > TO UNSUBSCRIBE: Go to > > http://www.witango.com/developer/maillist.taf > > > > _______________________________ > Do you Yahoo!? > Declare Yourself - Register online to vote today! > http://vote.yahoo.com > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
