This is a multi-part message in MIME format.



------=_NextPart_000_0034_01C05CBD.FB0420E0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Hi,

I am trying to Response.Write() an SQL String that I created before 

executing the command. But as there is some error in the SQL Statement, 

it does not get executed and takes me to an error page to display the 

error message. Due to this I am not able to view the SQL String that I 

had written out.

How do I make it work like the classic ASP pages where I can see 

whatever I had written out as well as the error message?

I have a feeling that as this stuff is compiled now, it will not be 

possible.  If so then is there some other way by which I can see the 

content of the SQL Strin before trying to execute the Command?



Thanks,

Ajay

--=====================_83208577==_.ALT

Content-Type: text/plain; charset="us-ascii"; format=flowed



Method 1:



problem.text =sqlstmt

in the code



<asp:label id=problem runat="server"/>

in the document.



Method 2:

  At top of page =>

<%@Page Language="VB" Trace="True" %>



trace.write("query", SQLstmt)

...

trace.write("query", "done with query")





http://www.aspng.com/quickstart/aspplus/doc/tracelogpage.aspx

has more details.







At 12:14 AM 12/3/2000 +0530, you wrote:

>Hi,

>I am trying to Response.Write() an SQL String that I created before 

>executing the command. But as there is some error in the SQL Statement, it 

>does not get executed and takes me to an error page to display the error 

>message. Due to this I am not able to view the SQL String that I had 

>written out.

>How do I make it work like the classic ASP pages where I can see whatever 

>I had written out as well as the error message?

>I have a feeling that as this stuff is compiled now, it will not be 

>possible.  If so then is there some other way by which I can see the 

>content of the SQL Strin before trying to execute the Command?

>

>Thanks,

>Ajay

>

>

>---

>Wrox Professional Web Developer Conference II

>http://www.wroxconferences.com/WebDevEurope

>November 29th - December 1st 2000, Amsterdam, Netherlands

>Create powerful distributed web applications serving you now and

>in the future. From ASP+ and VB.NET to XML and SQL Server 2000