Passing string to asp page to be placed as ORDER BY column in SELECT 2

[Varmit]

Rephrase of earlier question

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/31/pid/333/qid/134621

Hyperlinking to -- view.asp?sortcol=company_name

in the asp section <!--webbot DatabaseRegionStart .... s-criteria s-sql=&quot;SELECT * FROM company_table ORDER BY ??????? &quot; .... -->

where ?????? is the syntax that takes the passed variable and puts it into this <!--webbot --> declaration after 'ORDER BY'

suggested methods produced various errors.. see original Thread.

 

[FengShui1998]

varmit,

Here are two examples:

sql = &quot;SELECT * FROM company_table ORDER BY EmployeeID ASC&quot;

sql = &quot;SELECT * FROM company_table WHERE Employee_FirstName = 'John'&quot;


Hope this helps,
fengshui1998