Jump to content

is there anyway to pass parameter as col name after 'where' in custom query


chris liu

Recommended Posts

basically, i have a dropdown list. all diferent col is uder it.

so user select the col then want to query by like :

select *

from execute_command

where data_type in ('154cgdbv')

so this data_type will be col, eg. serialNmber, productFamily,productNameand so on.

so i can just use one table to query the data by user selection.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...