RE: Capturing executed SQL in CF

2006-06-08 Thread Leon Oosterwijk
Have you tried using profiler? That way you don't need to change a line of code. Leon -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 11:13 AM To: CF-Talk Subject: RE: Capturing executed SQL in CF ... #BoyGeorg

RE: Capturing executed SQL in CF

2006-06-07 Thread Ian Skinner
... #BoyGeorge.sql# -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message includ

Re: Capturing executed SQL in CF

2006-06-07 Thread Neil Middleton
whilst handy, I need something that I can use without having to change the code I already have (~3 mil lines). I am trying to get a stack of the SQL executed in a request from within an error handler. Neil On 6/7/06, Nick Tong - TalkWebSolutions.co.uk <[EMAIL PROTECTED]> wrote: > > cfquery... res

Re: Capturing executed SQL in CF

2006-06-07 Thread Neil Middleton
Got any examples? On 6/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > On CF7 + I believe its queryname.sql > > > > > -Original Message- > > From: Neil Middleton [mailto:[EMAIL PROTECTED] > > Sent: 07 June 2006 14:59 > > To: CF-T

RE: Capturing executed SQL in CF

2006-06-07 Thread kola.oyedeji
On CF7 + I believe its queryname.sql > -Original Message- > From: Neil Middleton [mailto:[EMAIL PROTECTED] > Sent: 07 June 2006 14:59 > To: CF-Talk > Subject: Capturing executed SQL in CF > > Does anyone know if there is a way of getting the SQL strings executed

RE: Capturing executed SQL in CF

2006-06-07 Thread Dawson, Michael
With CF7, you can use the result attribute of the cfquery tag. M!ke -Original Message- From: Neil Middleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 9:59 AM To: CF-Talk Subject: Capturing executed SQL in CF Does anyone know if there is a way of getting the SQL strings

Re: Capturing executed SQL in CF

2006-06-07 Thread Nick Tong - TalkWebSolutions.co.uk
cfquery... result="" > ? http://succor.co.uk/index.cfm/2006/3/21/The-cfquery-result-structure http://www.forta.com/blog/index.cfm?mode=e&entry=1520 On 07/06/06, Neil Middleton <[EMAIL PROTECTED]> wrote: > > Does anyone know if there is a way of getting the SQL strings executed > within a request

Capturing executed SQL in CF

2006-06-07 Thread Neil Middleton
Does anyone know if there is a way of getting the SQL strings executed within a request at runtime without directly effecting the code (ie doing it from within an error handler)? I seem to have a vague recollection of Ben commenting on it in the past but can't find anything. -- Neil Middleton V