I am using cfquery result attribute to get the sql, but how can i get the full sql along with the parameters, i tried this function but it seems to be creating a problem, it dooes not return anything but instead says, complex queries cannot return data

<cffunction name="getRealSQL" returntype="string">
    <cfargument name="qryResult" type="any">
    <cfset realSQL = QueryExecute("#arguments.qryResult#",{},{datasource="#Application.DSN#"})>
    <cfloop array="#arguments.qryResult.sqlParameters#" index="a">
        <cfscript>
            if (NOT isNumeric(a)) a = "'#a#'";
            realSQL = Replace(realSQL, "?", a);
        </cfscript>
    </cfloop>
    <cfreturn realSQL>
  </cffunction>

if the function is right, what should i pass an argument, a query object or query results or what?

What exactly are you passing in as your

qryResult

argument?

i need full query along with parameters, not ? marks

How did you determine the original query that you used to get the results?

i am passing the cfquery result attribute of sql to it, its failing, then i am passing a whole cfquery name to it its failing

1.) what data type is the result? 2.) what does queryExecute take for its first argument?

as per functions, it expects query

What's the documentation show?

documentation is there to fetch a query but not along with parameters

"The SQL is in the result struct"

I guess to back up a step (as Myka asked), what do you need the query to give you the sql and parameters for? What are you going to do with it?

Are you trying to QueryExecute the results of a query and not a string? Here is a sample of what comes back with results you will see that there are ? in place for where the parameterized SQL is placed... and there is an array of sqlparameters in the result that corresponds with the ? marks... https://trycf.com/gist/90a195c01fe34598ef6cc46efa5ddf28/lucee5?theme=monokai

ok, take this WriteDump(res); how you get the realsql from it

What is preventing you from using the sql from the original query?

preventing ?

We're trying to get to the root of the problem. You seem to have picked a methodology that is more difficult than it needs to be.

we are overcomplicating it, i posted a stackoverflow where the guy has same problem and i am trying to get the same value

The function you posted is not the same as the one given in an answer on SO.

its same, i copied from there

Unless you meant a different function? Black is what you posted; white is on SO.

As has already been mentioned, what is in the

arguments.qryResult

that's different from what you're trying to extract after the fact? But… Looking away from that, what you're doing to fill in the parameters to the sql string returned from queryExecute doesn't appear to be correct. Calling replace on

realSql

, if it is in fact a query object, won't give you the desired result as you need to access the

sql

key in the object:

realSql.sql

. Here’s an SO question I answered a while back with code demonstrating what could be done. It’s very similar to the SO post already shared. https://stackoverflow.com/q/64767251/985709