ColdFusion – SQL iz Query-a

Problem: Imamo neki kompleksan npr. dimanički generiran query i zanima nas kako izgleda njegov SQL

Rješenje: Dodati parametar “result”. Kasnije iz structa izvučemo SQL.

<cfquery name="Rs_proba" datasource="DSN" result="mojRezultat">
   SELECT * FROM tbl_tablica
</cfquery>

<CFSET mojSQL =  mojRezultat.SQL>

Vrijednost varijable mojSQL je tada: “SELECT * FROM tbl_tablica”

This entry was posted on Thursday, June 12th, 2014 at 1:21 pmand is filed under Coldfusion. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.