Retrieving data from a combo box

[hsh_636]

Hello, Im new to using combo boxes I already figured out how to populate it with data from mysql database. However, but how can I determine or retrieve the selected option on the combo box, thanks.

[Klaus]

Hi hsh_636,

you are looking for:
...
put the label of btn "your combo box here..." into tCurrentSelection
...



Best

Klaus

[hsh_636]

Thanks for your reply the thing is I did exactly what you told me to do but when I retrieve it and insert it into my table nothing is inserted which means nothing is retrieved does the field type of the column (int) of the table Im inserting it to have anything to do with it?

[Klaus]

Hm, int = integer, right? That will surely not work if your label is a STRING!

[hsh_636]

The combobox retrieved the value from the database and in the database its a number (integer), so the value for the combobox label is a number which means its in fact an integer, is there a command that will retrieve the value chosen because Im not sure how the label command work.

[Klaus]

Well, then it should work!

Hint:
There is no "label command" in Livecode!
But you can simply retrieve this "property" like in my example.

So if it does not work for you then the error must be somewhere else!
I need more info/scripts etc. to be more helpful.

[hsh_636]

Thanks Klaus for all your help.

[hsh_636]

Solved it!!! the problem was in other piece of the code!!!

[hsh_636]

Hello, everybody I have a similar question similar to the combobox one I already finished retrieving data from the combobox and I was thinking can I do the same thing for the scrolling list field I mean how can I retrieve the data selected in the scrolling list field and if its possible to begin with.
Thanks, in advance.

[Klaus]

Hi,

you want to:
...
put the selectedtext of fld "your listfield here..." into tUserSelection
...


Best

Klaus

[hsh_636]

Thanks for all the help again.

[hsh_636]

I have one more question about the scrolling list field is it possible to activate an action once the user clicks on a choice in the scrolling list field and if so how?,
Thanks appreciate all the help.

[Simon]

Here you go hsh_636,

Code: Select all

on mouseUp
   put the selectedText
end mouseUp

Make sense?

Simon

[hsh_636]

What I meant by an action I meant for example going to another card, the code that you gave me only put the selected choice into a variable I want a way that allow the user that once he/she clicks on a choice the user goes to another card.

[Klaus]

Hi hsh_636,

...the code that you gave me only put the selected choice into a variable I want a way that allow the user that once he/she clicks on a choice the user goes to another card.

maybe replacing
...
put the selectedtext of me into tVar
...
In the mouseup handler with
...
go cd "whatever"
...
will do what you want?



Best

Klaus