Welcome Guest, Not a member yet? Register   Sign In
Any means of getting back the SQL query string before submitting it?
#1

[eluser]behdesign[/eluser]
I have a rather complex SQL search query that I'm creating through conditionals, and I want to see what the finished product looks like, and more importantly possibly modify it before I send it on to the server. Is there any way to get the SQL query string?
#2

[eluser]skunkbad[/eluser]
Why do you need to get it back? Don't you have control over the query in the first place?

If you don't know what your query is, you could use the profiler.
#3

[eluser]jedd[/eluser]
[quote author="behdesign" date="1273999788"]I have a rather complex SQL search query that I'm creating through conditionals, and I want to see what the finished product looks like, and more importantly possibly modify it before I send it on to the server. Is there any way to get the SQL query string?[/quote]

There certainly is.

But you would have to read all the way through the first question & answer in the [url="/wiki/FAQ"]FAQ[/url] to find it.

Modifying it before you send it to the server .. is something that you do in your code already, by definition. I'm confused about what you mean here.




Theme © iAndrew 2016 - Forum software by © MyBB