Debugging SQL

CodeCharge Studio

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Debugging SQL

Author

Message

Kaynos5

Posted: 11/01/2004, 11:38 AM

I am trying to debug sql on codecharge. I set
'response.write "SQL: " & GridLeadView.datasource.SQL & "<br>"
in the beforeexecuteselect event..

I get back a sql statement with none of the parameters that we pass to it, only the parameter names.. like where active = {s_active} instead of where active = 1.

I need to see actual sql..

Benjamin Krajmalnik

Posted: 11/01/2004, 1:18 PM

Best way is to set up SQL Profiler and see exactly what is going on on the
back end.

"Kaynos5" <Kaynos5@forum.codecharge> wrote in message
news:6418690c45b22f@news.codecharge.com...
>

> I am trying to debug sql on codecharge. I set
> 'response.write "SQL: " & GridLeadView.datasource.SQL & "<br>"
> in the beforeexecuteselect event..
>
> I get back a sql statement with none of the parameters that we pass to it,
only
> the parameter names.. like where active = {s_active} instead of where
active =
> 1.
>
> I need to see actual sql..
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

Carlos A. Alfaro

Posted: 04/04/2005, 5:12 AM

But what if I'm using MSAccess, does SQL Profiler work?

Quote Benjamin Krajmalnik:
Best way is to set up SQL Profiler and see exactly what is going on on the
back end.

"Kaynos5" <Kaynos5@forum.codecharge> wrote in message
news:6418690c45b22f@news.codecharge.com...
>
> I am trying to debug sql on codecharge. I set
> 'response.write "SQL: " & GridLeadView.datasource.SQL & "<br>"
> in the beforeexecuteselect event..
>
> I get back a sql statement with none of the parameters that we pass to it,
only
> the parameter names.. like where active = {s_active} instead of where
active =
> 1.
>
> I need to see actual sql..
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

rbaldwin

Posts: 172

Posted: 04/04/2005, 1:25 PM

in the before execute update or insert events do something like

response.write yourform.Command.SQL
response.end

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login