Gerom7
06-12-2006, 09:36 AM
I tryed this form of code and it looks very promissing but I have a stupid sintax error that blows up my code. Guys please help to find it. Java script compiler sad "line 9 char 29". I had put this line in Bold and underline.
Please help.
Thank You.
<html>
<head>
<title>ADO</title>
<%
Dim AMDEcon
Dim conn
Dim VBResults
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:/DSA-Erie/data.mdb"
sSQL = "SELECT partName, partDescription FROM AMDEconomy"
set AMDEcon = conn.Execute(sSQL)
%>
<%
do while Not AMDEcon.EOF
VBResults = VBResults & AMDEcon("partDescription")
AMDEcon.MoveNext
loop
AMDEcon.close
conn.close
%>
<script type ="text/javascript">
function writeMe(){
var TableResults = <%=VBResults%>;
document.write(TableResults);
}
</script>
</head>
<body>
<div>
<a href="JavaScript:writeMe()">Write Me</a>
</div>
</body>
</html>
Please help.
Thank You.
<html>
<head>
<title>ADO</title>
<%
Dim AMDEcon
Dim conn
Dim VBResults
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:/DSA-Erie/data.mdb"
sSQL = "SELECT partName, partDescription FROM AMDEconomy"
set AMDEcon = conn.Execute(sSQL)
%>
<%
do while Not AMDEcon.EOF
VBResults = VBResults & AMDEcon("partDescription")
AMDEcon.MoveNext
loop
AMDEcon.close
conn.close
%>
<script type ="text/javascript">
function writeMe(){
var TableResults = <%=VBResults%>;
document.write(TableResults);
}
</script>
</head>
<body>
<div>
<a href="JavaScript:writeMe()">Write Me</a>
</div>
</body>
</html>