Last post Nov 06, 2008 07:37 PM by hans_v
Nov 01, 2008 09:01 PM|rigin|LINK
Just wondering if its possilbe to do the following
having a drop down list which the selected value is the column which my sql command queries by?
cheers, heres my code atm
Nov 01, 2008 10:13 PM|hans_v|LINK
SelectCommand="SELECT * FROM [Assets2008] WHERE ([@columz] = 'RECORD_NO' AND [RECORD_NO] like '%' + @searching + '%') OR ([@columz] = 'Location' AND [Location] like
'%' + @searching + '%') OR ([@columz] = 'TEST_CODES' AND [TEST_CODES] like '%' + @searching + '%') OR ([@columz] = 'WORK_ORDER_#' AND [WORK_ORDER_#] like '%' + @searching + '%')">
Nov 06, 2008 06:29 PM|hans_v|LINK
It would be nice if you let us know whether or not your problem has been resolved, and if so, mark the answer?
Nov 06, 2008 06:59 PM|rigin|LINK
Nov 06, 2008 07:37 PM|hans_v|LINK