If they choose to sort by deadline, doesn't the page run the query again, this time sorting by date? Your query will need to be dynamic. You can do it with a direct DBMS action.
Mike Prasad Ramalingam wrote: > The problem I have I fetch the values from the database with names,ids and > there respective deadlines.so when I fetch the results the resultset will > look something like this. > > Project Name : Project ID : Deadline > Prasad 100 Feb 05, 2003 03:10:00 > Gauthier 101 Apr 10, 2004 02:00:00 > Mike 102 Apr 24, 2002 02:10:00 > > so when a customer chose the project name it easily gets sorted through the > <@SORT> tag .Simmilarly it happens for Project ID .But when I want to sort > the deadline I am not able to do that because <@SORT> doesn't support dates > and everyone know this point. > > The problem I face is I have to use the same array for all the sorting for > either the Project Name or Project ID or Deadline. > Because the customer can choose anything to sort with.I can't use separate > arrays because I have to display all these values together within a table > tag in HTML in the form of rows at the same place. > > I hope I am clear enough. > > thanx in Advance. > Prasad > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of [Gauthier] > Sent: Tuesday, May 07, 2002 10:10 PM > To: Multiple recipients of list witango-talk > Subject: Re: Witango-Talk: Sort by date > > For my case I only use seconds timestamp, so you can order it as any numeric > column. > Could you give us an example of what your date column look like? > if you want to do the same thing from another date format look at > <@TSTOSECS> (for processing date sorting) and <@SECSTOTS> (for display > purpose) > > Gauthier > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
