Guest User

Untitled

a guest
Jan 23rd, 2019
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. <cfquery name="tableElements" datasource="TestSQLServer">
  2. SELECT * FROM tableElements
  3. </cfquery>
  4.  
  5. <cfdump var="#tableElements#" /> <!--- Shows object having "SQL" property --->
  6. <cfoutput>SQL: #tableElements.SQL#</cfoutput> <!--- Error: Element SQL is undefined in TABLEELEMENTS. --->
  7.  
  8. <cfquery name="tableElements" datasource="TestSQLServer" result="r">
  9. SELECT * FROM tableElements
  10. </cfquery>
  11.  
  12. <cfdump var="#tableElements#" /> <!--- Shows object having "SQL" property --->
  13. <cfoutput>SQL: #r.SQL#</cfoutput>
  14.  
  15. <cffunction name="getRealSQL" returntype="string">
  16. <cfargument name="qryResult" type="any">
  17. <cfset realSQL = arguments.qryResult.sql>
  18. <cfloop array="#arguments.qryResult.sqlParameters#" index="a">
  19. <cfscript>
  20. if (NOT isNumeric(a)) a = "'#a#'";
  21. realSQL = Replace(realSQL, "?", a);
  22. </cfscript>
  23. </cfloop>
  24. <cfreturn realSQL>
  25. </cffunction>
  26.  
  27. <cfset stx={}>
  28. <cfquery name="stx.q" datasource="myDataSource">
  29. select emp_id from employees where 1=2
  30. </cfquery>
  31. <cfdump var="#stx.q#">
  32. <cfdump var="#stx.q#" metainfo="yes">
Add Comment
Please, Sign In to add comment