sorting

Results 1 to 2 of 2

Thread: sorting

  1. #1
    Join Date
    Dec 1969
    Posts
    309

    Default sorting

    I want to do a sort on the asp file.<BR>What I really want is click on the column and it sorts by that column. Does anyone have an idea on this?<BR>thanks in advance<BR>Ken

  2. #2
    omc Guest

    Default RE: sorting

    Yes, you can do that. Say the columns are Name, Title, Company. In your database you have fields name, title, company. Link the headers like &#060;a href=myasp.asp?sort=title"&#062;Title&#060;/a&#062;<BR><BR>Then on the asp page have<BR>if request.form("title")=title then<BR> qrySelect=" order by title"<BR>end if<BR>Then your select string could be<BR>"select * from tblTable where whatever=whatever" & qrySelect<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •