Say I have a recordset that brings values from 1 to 18. I bind the values of the recordset to the list option (list/menu). However the cursor or value shows 18. I want it to show 1. Any one know how to show the first value 1 ?

Thanks


asp, sql 2000, windows 2000 server, ud 4,vbscript

Try adding an "ORDER BY" clause to your SQL statement to list the numbers in the desired order. In addition when you create a dynamic list/menu you will see "select value equivalent to" at the bottom of the dialogue box, use this to have the value equivalent to 1 initially selected.


Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thanks you led me to the answer.

Although the "Label", "value" and "Select value equal to" are just showing the binding value, I can choose the First Index record to make it show up at 1 or the first record.

The "order by" didn't work as the cursor or pointer stops at the last record in the menu option.

Thanks again