??Response.write/Response.end implementation

[pabby]

HI,

How do I implement response.write/response.end pairs to look at debugging a problem? Where in the code do you put it - can anyone provide sample code to illustrate?

thanks,

Paul

 

[FesterSXS]

<%
strConn = "your connection string here"

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConn

strSQL = "SELECT field1, field2 FROM mytable WHERE id='" & Request.QueryString("id") & "'"

[red]Response.Write strSQL
Response.End[/red]

Set objRS = objConn.Execute(strSQL)
%>

This will Response.Write your SQL statement then do a Response.End before it gets a chance to Execute the SQL statement

Tony
[red]_________________________________________________________________[/red]
Webmaster -

http://www.SpiraxSarco.com/