sqldatasource view sql statement

[boysenberry]

Hi.
Is there a way to view the SQL statement after the parameters have been replaced with their respective values.

ie. SELECT UserId, Firstname, Surname FROM tblStaff WHERE UserId = @LoginId

After setting @LoginId to 100
I want to be able to retrieve the modified statement that is passed to the Database - so it would return this

SELECT UserId, Firstname, Surname FROM tblStaff WHERE UserId = 100


I am using C# in the code behind - and this is where I want to access the sql.
Many thanks

[jhardman]

bberry,

generally I do it like this:

response.write "<!-- query: " & query & " -->" & vbNewLine

"query" is of course the variable that I use to hold the sql query. I am using vbscript, I don't know how well this will translate to your system.

Jared

[boysenberry]

bberry,

generally I do it like this:

response.write "<!-- query: " & query & " -->" & vbNewLine

"query" is of course the variable that I use to hold the sql query. I am using vbscript, I don't know how well this will translate to your system.

Jared

Thanks Jared.

I am looking to extract the sql statement from the sqldatasource into a variable after the parameters have been entered, which I can then display.

Kind regards
bb

[jhardman]

bb,

Yeah, like I said. I generally do it like this:

dim query
query = "SELECT * FROM "
query = query & currentTable
query = query & " WHERE "
query = query & request.form("searchField")
query = query & " = '"
query = query & request.form("searchData")
query = query & "' ORDER BY date"
 
response.write "<!-- query: " & query & " -->" & vbNewLine
 
objRS.open query, objConn, adOpenDynamic, adLockOptimistic

does this not answer your question?

Jared