dynamic ordering of tables

Hi,

I have admin panel in angular and every sub-menu has identical table component. I've set asc and desc icon to every th tag and I like to emit asc and desc values depending whch asc-desc icon next to th tag is clicked.

How I can implement this step in node.js when I send asc or desc and the name of the column dynamically as string?

const result = await mysql.select( myquery, ['columnA', 'desc'], );

The order in the sql query for now I've set as order by ? ?, but I can't make it work. I've tried also to wrap the input params withing escape or unescape function, but still not luck.

The query does not return error, but everytime input params force the query to sort asc, like it send the strings together with the single quotes.

BR, Igor

The issue names no repository file or test. Start by reproducing the shown mysql.select call with a dynamic column and direction, then inspect the query-parameter documentation; done would require a clear supported resolution or a documentation update.