Another approach might be to globally replace your SqlExec calls to WrapSqlExec(nHandle, cSQL, nLog, nTime,uOther)
and build your own function with sensible defaults for logging, timing and so on which can be overridden at each call through optional parameters. In the long run it will give you more flexibility and information for a tiny effort.
>Hi
>Assuming i have the following:
>myVar = "test"
>mySql = "select * from myTable where someField=?myVar"
>=sqlExec( Handle, mySql )
>
>
>How can i see the actual query sent to the backend DB? I need this to build an auditlog. Afterwards, i will cursortoxml() the resulting sqlresult cursor for the saved response, but i need the actual values sent...
>
>Many thanks
>Jaime