F
Fred
I have the following code working properly, but when I copy pase it to
another page (that is also working properly and was generated by a MS
product) I get this error:
Microsoft JScript compilation error '800a03ec'
Expected ';'
/PS_kh/Tasks/NewTaskPage.asp, line 1265
set con = Server.CreateObject("ADODB.Connection")
----^
============================================================
<html>
<body>
<p>This is a view on the database</p>
<%
set con = Server.CreateObject("ADODB.Connection")
con.ConnectionString = "DRIVER={SQL Server};SERVER=pcgdev1"
con.Open()
sql = "SELECT * FROM MSP_TASKS where task_name <> ''"
set CurrentRecordset = con.Execute(sql)
%>
<select>
<%
do while (Not (CurrentRecordset.EOF))
%>
<option> <% = CurrentRecordset("task_name") %> </option>
<%
CurrentRecordset.MoveNext()
Loop
%>
</select>
</body>
</html>
=======================================================================
can someone please tell me what is going on?
thanks
another page (that is also working properly and was generated by a MS
product) I get this error:
Microsoft JScript compilation error '800a03ec'
Expected ';'
/PS_kh/Tasks/NewTaskPage.asp, line 1265
set con = Server.CreateObject("ADODB.Connection")
----^
============================================================
<html>
<body>
<p>This is a view on the database</p>
<%
set con = Server.CreateObject("ADODB.Connection")
con.ConnectionString = "DRIVER={SQL Server};SERVER=pcgdev1"
con.Open()
sql = "SELECT * FROM MSP_TASKS where task_name <> ''"
set CurrentRecordset = con.Execute(sql)
%>
<select>
<%
do while (Not (CurrentRecordset.EOF))
%>
<option> <% = CurrentRecordset("task_name") %> </option>
<%
CurrentRecordset.MoveNext()
Loop
%>
</select>
</body>
</html>
=======================================================================
can someone please tell me what is going on?
thanks