TryCF Gist

trycf-gist-1703958546880-d3997693-8544-a308-9a80-1c57223b9af3.cfm

<cfset content=querynew("url, rownum") >
<cfset queryaddrow(content, 1) >

<cfdump var="#url#">

<cfquery name="url_as_object" dbtype="query">
        SELECT url  FROM content WHERE ROWNUM <= 1
        <!---SELECT url as url2 FROM content WHERE ROWNUM <= 1--->
</cfquery>
<cfset my_str="a string">

<cfloop query="url_as_object">
  <cfdump var="#url#">
  <cfoutput>
  <pre>
        expected data for url:     #getMetadata(my_str)#
        actual meta data for url: #getMetadata(url)#
        <!---actual meta data for url: #getMetadata(url2)#--->
  </pre>
  </cfoutput>
</cfloop>

<cfdump var="#url#">

<cfoutput>
<pre>
        expected data for url:     #getMetadata(my_str)#
        actual meta data for url: #getMetadata(url)#
</pre>
</cfoutput>