ad_tpl list search

gistfile1.js

*View
<label class="control-label" for="txtName">Username</label>
    <input type="text" class="form-control" id="txtName" name="txtName" value="<%=typeof(sess.search)!='undefined'&&typeof(sess.search.uName)!='undefined'?sess.search.uName:''%>" placeholder="Username" autofocus autocomplete="off"></th>
---
<th>Username <a href="/ad_user/search?uName=ASC">▲</a><a href="/ad_user/search?uName=DESC">▼</a></th>
---
<td><%=ml.uName?ml.uName:''%></td>
*Route
search['name'] = req.body.txtName?req.body.txtName:'';
---
var where = " WHERE uName LIKE " + conn.escape('%'+search['name']+'%');
---
if(req.query.JobId)
    sort = ' ORDER BY JobId ' + req.query.JobId;