May I know how to insert single quote in html textbox without typing the single quote on it, I had tried use HTML Character ' but not work ?
Eg. type M10500000003 in textbox, error ORA-00904 : "M10500000003": invalid identifier
Eg. type 'M10500000003' in textbox, ok
<label for="txtName">Member Number</label><br>
<input type="text" id="txtName">
<a href="javascript:;"></a>
<a href="javascript:;" onclick="this.href='http://myIP/apex/epos.db_sql?P_SQL=select memberno,nameoncard from c19u.psm_member@c19 where memberno=' + document.getElementById('txtName').value">Check</a>
Your help is much appreciated.