' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
If (MM_editRedirectUrl <> "") Then
Response.Redirect(MM_editRedirectUrl)
End If
End If
End If
%>

What exactly do you want to Response.Write?

I tried this but didnt work...

Response.Write MM_editCmd.Source <-----
Response.End() <-----

I am supposed to add a line to write the output of my update sql.

Put it immediately before that block of code. As in the line right before it.

your going to have to comment out the Response.Redirect(MM_editRedirectUrl) so that it doesn't send you somewhere else before you see the output. try this

' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
'The following line will show your SQL
Response.Write(MM_editCmd.CommandText)
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
If (MM_editRedirectUrl <> "") Then
'Response.Redirect(MM_editRedirectUrl)

Thanks for the replys.

Mally.

What Dan said. I forgot about that line.