CODEWITHSUNDEEP
asp-classic
user3348952
user3348952

Reputation: 1

Unable to perform Response.write

I have a classic asp page for which I would like to perform the parametrized style asp debugging. The debugging is for finding the SQL used. I am trying to debug in Visual Web developer 2010 but the debug options are grayed out. When I put in Response.Write I am getting the asp page as usual. Kindly assist.

The code snippet is below:

'//Create Recordset
Set SKUOutput=Server.CreateObject("ADODB.Recordset")
'//Open Recordset

SKUOutput.Open SKUQuery, SKUConnection, adOpenDynamic, adLockOptimistic
recordCount=SKUOutput.RecordCount
SKUOutput.Close
Set SKUOutput=Nothing

'//Create Recordset
Set SKUOutput=Server.CreateObject("ADODB.Recordset")

SKUOutput.Open SKUQuery, SKUConnection, adOpenDynamic, adLockOptimistic
response.Write SKUQuery
response.End

Upvotes: 0

Views: 89

Answers (1)

John
John

Reputation: 4638

I'd put your response.write statement before skuoutput.open

I think the greyed out options are for .net only - the way to debug classic asp is to run it on your server (or development server) and read the error message in the output.

Upvotes: 1

Related Questions