Retrieving data from database which contain single quotes.
I want to retrieve data from database ( MS-Access ) which contains single quotes in it.
eg.There is a payee id as "Test's123" in payee table.I want to fetch this record.
My script is
Name = "Test's123";
db_execute_query ( "sess", "SELECT * From Payee Where Payee_ID='" & Name & "'", rec_cnt );
db_disconnect ( "sess" );
but the above script didn't work for this condition.ie, variable having single quotes.
Can anyone help me?