Heinz
|
| Posted: 02/11/2008, 12:01 PM |
|
Hello together
I read few days in a thread how it is possible to get a complete SQL as a
response.
But I forgot where I read it and how it works.
I know the possibility to do it like
response.Write "SQL: " & grid.DataSource.SQL & "<br>
response.Write "SQL: " & grid.DataSource.Wherer & "<br>
response.Write "SQL: " & grid.DataSource.Orderr & "<br>
But I saw an other code like
response.Write ????...sender..??..SQL.....????????
With this I got the complete SQL-String.
I searched again through the forums but without success
It would be great if someone is able to give me short tip
Thank you in advance
Regards
Heinz
|
|
|
 |
martinc
Posts: 5
|
| Posted: 02/11/2008, 3:01 PM |
|
See my post
http://forums.codecharge.com/posts.php?post_id=93196
|
 |
|
Heinz
|
| Posted: 02/12/2008, 1:57 AM |
|
Hello martinc,
thank you very much.
I saw an other solution with a single line of code.
It includes the word ...sender...
Further ideas ?
Thank you in advance
regards
Heinz
"martinc" <martinc@forum.codecharge> schrieb im Newsbeitrag
news:647b0d3cde8330@news.codecharge.com...
> See my post
> http://forums.codecharge.com/posts.php?post_id=93196
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Heinz
|
| Posted: 02/12/2008, 3:32 AM |
|
Hello together
I am happy, because I found the solution.
It is:
Response.write Sender.Connection.lastSQL
in AfterExecuteSelect event.
It is out of :
http://forums.codecharge.com/posts.php?post_id=75456&s_...er+sql+response
Thank you to all
Regards
Heinz
"Heinz" <heinz.rieder@de.bosch.com> schrieb im Newsbeitrag
news:foq9jm$k3s$1@news.codecharge.com...
> Hello together
>
> I read few days in a thread how it is possible to get a complete SQL as a
> response.
> But I forgot where I read it and how it works.
>
> I know the possibility to do it like
> response.Write "SQL: " & grid.DataSource.SQL & "<br>
> response.Write "SQL: " & grid.DataSource.Wherer & "<br>
> response.Write "SQL: " & grid.DataSource.Orderr & "<br>
>
> But I saw an other code like
>
> response.Write ????...sender..??..SQL.....????????
>
> With this I got the complete SQL-String.
> I searched again through the forums but without success
>
> It would be great if someone is able to give me short tip
>
> Thank you in advance
> Regards
> Heinz
>
>
|
|
|
|
martinc
Posts: 5
|
| Posted: 02/13/2008, 12:52 AM |
|
Maybe my code is an over kill, but its handy to examine every SQL string being ran on a page.
its good if you have a page with a lot of heavy SQL and your not sure where the problems lie.
|
|
|
|
