2. ASPRunnerPro General questions
  3. How to set value for fields?
This topic is locked

How to set value for fields?

 		10/27/2003 12:36:32 PM
ASPRunnerPro General questions
swat author

hi,
how can I set some values for my datafields, for example; I have priority section and I would like to display "High,Mid,Low" and I would like to set those character as number , which means the user will choose either High,Mid or Low in the form but I will set up this characters as integers;

High = 1

Mid = 2

Low = 3

so I can sort them....
I need something like this in asprunner but ...edit.asp page does not allow me to do so;

<input name=High value="1">
500064 10/30/2003

Swat,

I had a similar but dealing with hours. The user choses one hour and thirty minutes but I store 1:30 in the cell. I ended up have a table hours: hourID, hours, details. It ends up being a lookup value field. In that webpage it has id and details but in the database I have it defined as id and hours the same with the list page.
Hope this helps,

Bandit
Sergey Kornilov admin 10/30/2003

Swat,
you can create a new table in the database with two fields.
ID DisplayName

---------------------

1 Low

2 Medium

3 High
After that you can use this table as a source for Lookup Wizard field.
Best regards,

Sergey Kornilov