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 New...