selectbox function in tornado

[mick_asp]

does anyone have the codes to populate the pull down menu with their own data.

i want the user to be select the word "Active" or "Expired" from the pull down menu.

this is what i have right now and it's not working.

fi=status|Ty=SelectBox| Val={{Active,Expired}}

any help will be appreciated.

thanks!

[Frank]

Pulldown in Sbox, Edit, Filter, CommonTable ? Which one ?

Goto site's Tornado Demo Page -

* Display Modes - Third example from the bottom (T_displaymodes_selectbox.aspx). you can see {{user list}} also.


* Input - Last example - a lot of drop down including {{user}}

If stil have problem, use a NWIND example to illustrate the problem. As usual, I'll put this example in the Code section of TED4.


FK

[mick_asp]

hi frank

is the example the same as using it in an input form?

i was using this link as an example but i want to be able to enter my own data.

http://www.aspdb.net/tornadodemo/T_myinput_4.aspx

thanks!

[Frank]

yes, this feature enables a quickie input form with all the drop, look, upload and other built-in capabilities. Which one you have problem with? Need to identify whether you are in edit, filter, sbox, input etc...

Frank

[Frank]

Overall,the common mistake is delimiter conflict for defining drop lists. Look at the following ->

.dbEditUpdateFlds = "(;!~)fi=0|ty=RONOUPdate! fi=titleofcourtesy|ty=SELECTBOX|Tex={{Mr,Ms,Mrs}}"

If you do not re-define the [,] to [!] then the Mr,Ms,Mrs will conflict.


FK

[mick_asp]

hi frank

when i use your code from the previous message, it doesn't work. there isn't anything from the drop down menu.

thanks!

[Frank]

try this working code ->

<script language='vb' runat='server'>
Sub Page_Load(Source as Object, E as EventArgs)
Dim Update As New Tornado.Z()
'...DropDown
With Update
.dbQP="U=5|S=3|D=Nwind|Q=employees|gdf=0,1,4|ni=b5 ,Filter|bm=employees;0|Th=Title=Search DropDown"
.dbFilterFlds = "(;!~)fi=0|ty=RONOUPdate!fi=4|ty=SELECTBOX|Tex={{M r,Ms,Mrs}}"
.ASPdbNET()
End With
End Sub
</script>


Frank