×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sorting Dropdown List???

Sorting Dropdown List???

Sorting Dropdown List???

(OP)
I have created a report that has parameter inputs from a dropdown box on an HTML page.  The dropdown box is dynamic input from a field in a database table.  The problem I have is that the dropdown list, after returning the values from the table, is not sorted and I can't figure out how to sort the values.  Can anyone provide some assistance?

Thanks,
JB

RE: Sorting Dropdown List???

The first question is "HOW are you creating the dropdown list?" If it's created by a secondary TABLE, then you should use a BY field, to sort the returning records.

RE: Sorting Dropdown List???

(OP)
I'm somewhat new to WebFocus, so my appologies if I don't make sense.  The dropdown is not being created from a secondary table.  I'm developing in 7.1 by the way.  I am going directly against a master file which is tied directly to a database table.

RE: Sorting Dropdown List???

What tool are you using to create the HTML page? That will better direct us on how to respond to your question.

RE: Sorting Dropdown List???

(OP)
Thanks for the help, but just yesterday I figured out that it was sorting based on the data (a number value) and not the display value for the numbers.  I was using a name field for display and the ID for the underlying data, therfore the sort was by the ID and not the name.  I changed to just use the name field for both data and display and it works.

JB

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close