Good day good pple of the forum,
Please i have some data coming from a database and i need to display them using javascript. The problem some of the records have single quotes and some have double quotes. How do i escape this at once.
Code:
PHP Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html xmlns="http://www.w3.org/1999/xhtml">
<
head>
<
meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<
title>Untitled Document</title>
</
head>
<
body>
<%
Dim conn,rs,sql_select,data_source
set conn
=server.CreateObject("ADODB.CONNECTION")
set rs=server.CreateObject("adodb.recordset")
data_source="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" 
Server
.MapPath("db\test.mdb")
conn.open data_source
sql_select
="SELECT * FROM coursequestion_getconnected"
rs.open sql_select,conn,3,1

%>
<
script type="text/javascript">
document.write("<%
while (not rs.eof)
response.write rs("
coursequest")&"<br>"
rs.movenext
wend%>"
)
</script>
</body>
</html> 
The above code works when the recordset has single quotes. but when the recordset has both single and double quotes the code goes blank.
How do i get around this?