>>>> myquery = myConnectionCFC.execute(sql, stParameters) >> What's this all about, then, eh??
At a guess (trying to remember Elliots' post from about a month ago).. this is an alternative to using CFQUERY by accessing the java db connection classes directly. those that have used ADO are familiar with this idea. By using the connection, command and recordset intrinsic objects the code ends up looking very much like this. you build a command and then fire it against a connection object, returning a recordset. set rs = conn.Execute(strSQL) '-- vbscript/asp classic the benefits are (were?) that debugging the SQL is very easy - it's just a string. the additional code that Elliot has posted seems to be an interesting way to, not only use for debugging, but also abstract the SQL sufficently so you could "swap-out" one db specific SQL for another (eg: T-SQL for ANSISQL) with a minimum of fuss (although it'll need a clearer head in the morn to appreciate it). He's even catered for cfqueryparam (which is part of out standards here). >> if you are interested i can put the files together for you yes please Elliot (esp. if my guess is close) thanx barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adam Cameron Sent: Wednesday, 1 September 2004 5:09 PM To: CFAussie Mailing List Subject: [cfaussie] Re: capturing the executed query? > myquery = myConnectionCFC.execute(sql, stParameters) What's this all about, then, eh?? Adam --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
