Tag Archive: CFQUERYPARAM

Sep 12

Como recuperar o SQL gerado por uma query?

Most queries written in ColdFusion will contain one or more dynamic portions. If you want to get the SQL that was actually passed to the database, use the result attribute of the <cfquery> tag: <cfset name = "e"> <cfquery name="getIt" datasource="cfartgallery" result="result"> select artistid from artists where lastname like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#name#%" maxlength="255"> </cfquery> <cfdump var="#result#"> The …

Continue reading »

Permanent link to this article: http://ensina.me/coldfusion/como-recuperar-o-sql-gerado-por-uma-query/