Accessing value from radio and text box in WHERE clause

billcoke 13 Oct, 2011
I am trying to set up my form to display fields from a db table. Fields in the table are:
part_name - text
description - text
owner_id - int

I have a radio box, called input_radio_owner, where I list the various owners with the options set up like this:
1=Bob
2=Ted
3=Joe

I would like to set up the WHERE clause in the "DB Multi Record Loader" structured so that when the user selects the different radio selections [Bob, Ted, Joe] that the "DB Multi Record Loader" WHERE clause sorts based on:
owner_id = input_radio_owner

But this does not work.

When I use:
owner_id = 2

I get all of Ted's stuff.


So my question is how to I pull the value out of the radio [or text box for that matter] box and use it in the WHERE clause. I have tried putting tick (') marks around the name. I know this is probably simple, but not so much when I can't find it.

Any possibility there is one place that lays out this type of info and provides a bunch of WHERE examples?

Also, I'm not sure that when I change the selected radio button or content of a text box if it will update the WHERE query. Do I need to tell the form to repaint somehow?

Thanks,
Bill
This topic is locked and no more replies can be posted.