topic Re: drop-down boxes. in Application Development and Automation Discussions

drop-down boxes.

Former Member — Mon, 08 Jun 2009 02:51:09 GMT

i have a selection screen with 4 select-options and 4 dropdown boxes.

i need to retrive data from the db table according to the user choice..

here my problem is

one drop down box is having 4 values atleast...

in that cast how to select data from db table ..according to user choice satisfying all the iput parameters..

inclcuing..4 dropdown boxes.

thanks,

usha.

Re: drop-down boxes.

Former Member — Mon, 08 Jun 2009 04:01:37 GMT

Though each dropdown list has atleast 4 values, at run time it will contain the value that is selected in the selection screen.

So do not worry, go ahead with writing query on the desired DB table using dropdown list in the where clause.

Regards

Balu

Re: drop-down boxes.

Former Member — Mon, 08 Jun 2009 04:29:29 GMT

thanks balu,

but my problem is lil bit deep..

suppose Ticket type is the dropdown list box....

Values in Ticket Type are: Paper Ticket, E Ticket, Both, Unaware. If user selects Paper tickets, then it has to refer the field: P_TKT; if user selects E Tickets, then it has to refer the field: E_TKT; if user selects Both, then it has to refer the field: B_TKT and if user selects Unaware, then it has to refer the field: U_TKT

in one database table..

like this I have 3 more drop down boxes...

So please suggest the solution...

thanks...

usha.