Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1662375349283-1540d6e8-937a-4cf7-50ea-33dce866155d.cfm

Created September 5, 2022 11:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save trycf/68d138449a32eab68ca756d427cc3754 to your computer and use it in GitHub Desktop.
Save trycf/68d138449a32eab68ca756d427cc3754 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1662375349283-1540d6e8-937a-4cf7-50ea-33dce866155d.cfm
<cfset testQ = queryNew('test', 'CF_SQL_VARCHAR')>
<cfset queryAddRow(testQ)>
<cfset testQ['test'][1] = '2571'>
<cfset queryAddRow(testQ)>
<cfset testQ['test'][2] = '02571'>
<cfset queryAddRow(testQ)>
<cfset testQ['test'][3] = '1356'>
<cfset queryAddRow(testQ)>
<cfset testQ['test'][4] = '1659'>
<cfdump var="#testQ#" >
<cfquery dbtype="query" name="res">
SELECT * from testQ
where test = '2571'
</cfquery>
<cfdump var="#res#">
<cfquery dbtype="query" name="res">
SELECT * from testQ
where test = '02571'
</cfquery>
<cfdump var="#res#">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment