Debug SQL Statement

[Newsgroup_User]

Hi,

Can anyone tell me how I can debug a sql statement.
Ideally the execute.cmd would not run but rather output to the screen.

Thanks folks.

XP, Dreamweaver CS3, ASP VBScript.

[Newsgroup_User]

I use query analyzer is the problem is only with the sql statement



> Hi,
>
> Can anyone tell me how I can debug a sql statement.
> Ideally the execute.cmd would not run but rather output to the screen.
>
> Thanks folks.
>
> XP, Dreamweaver CS3, ASP VBScript.



--

[Newsgroup_User]

I should have said

I use query analyzer IF the problem is only with the sql statement.

Philo wrote:

> I use query analyzer is the problem is only with the sql statement
>
>
>
> > Hi,
> >
> > Can anyone tell me how I can debug a sql statement.
> > Ideally the execute.cmd would not run but rather output to the
> > screen.
> >
> > Thanks folks.
> >
> > XP, Dreamweaver CS3, ASP VBScript.



--

[MikeL7]

Comment out the
Set rsName = rsName_cmd.Execute
line the try this on your page
<%=rsName_cmd.CommandText%>
Change rsName to the name of your rs
That should write the SQL to your page.