I am working with SQLServer 6.5.
I am writing ASP using ADO Connections.
The Sql statements appear twice in TRACE and the time looks like they are
being run twice to return data to my web page.
below is an example:
<%
Session("ConnectionString") = "dsn=XXXX;uid=YYYY;pwd=ZZZ;"
Set arfsConn = Server.CreateObject("ADODB.Connection")
Server.ScriptTimeOut = 99999
arfsConn.ConnectionTimeout = 9999
arfsConn.CommandTimeout = 9999
arfsConn.Open Session("ConnectionString")
sqlstring = "Select lname,fname from nametable order by lname,fname"
%>
<HTML>
<HEAD><TITLE>Title</Title></Head>
<BODY>
<%
set rs = arfsConn.execute(sqlstring)
if rs.eof then
%>NO DATA RETURNED<BR>
<% else
rs.movefirst
do while not rs.eof
%>Name: <%=rs.fields("lname").value + "," + rs.fields("fname").value
%><BR>
<%
rs.movenext
loop
end if
rs.close
set rs = nothing
</body>
</html>
THIS SHOWS THE SQL STATEMENT EXECUTING TWICE in SQL TRACE.
does anyone know why this could be ?
Thanks
View Cart
