show add query

This topic is locked

show add query	8/23/2011 1:27:57 PM
ASPRunnerPro General questions
T Tim author Hello, For troubleshooting purposes I need to see the insert query being generated on the add page when I hit save. How can I write this to the screen? I tried changing dDebug = true in the aspsetting.asp file, but this just shows the query used while opening the page, not after hitting save. thanks, Tim


	Sergey Kornilov admin 8/24/2011
	Tim, this will require you to make change in generated files. Open incilude/aspfunctions.asp file in any text editor and fund function ExecuteUpdate. Make the following change (see in bold): error_happened=false on error resume next conn.Execute strSQL message = strSQL ExecuteUpdate=false exit function If err.Number=0 Then ExecuteUpdate=true exit function end if Besides that I recommend to add the following line to AfterAppInit event: `SQLUpdateMode = true` This is to force SQL update mode.