Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1662543244940-35ddfffa-2359-fe41-f97d-5715d77102b6.cfm

Created September 7, 2022 09:35
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/be157d54599d6a08f051d9023d3f10db to your computer and use it in GitHub Desktop.
Save trycf/be157d54599d6a08f051d9023d3f10db to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1662543244940-35ddfffa-2359-fe41-f97d-5715d77102b6.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'>
<cfset queryAddRow(testQ)>
<cfset testQ['test'][5] = '1659 '>
<cfquery dbtype="query" name="res">
SELECT * from testQ
where test = '2571'
</cfquery>
<cfdump var="#res#">
<br />
<cfquery dbtype="query" name="res">
SELECT * from testQ
where test = '02571'
</cfquery>
<cfdump var="#res#">
<br />
<cfquery dbtype="query" name="res">
SELECT * from testQ
where test = '1659'
</cfquery>
<cfdump var="#res#">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment