Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1611161134607-c87c47c4-bd4b-37d4-4444-04892e12361e.cfm

Created January 20, 2021 16:49
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/b4b5028ca4b02443696c571d6da60604 to your computer and use it in GitHub Desktop.
Save trycf/b4b5028ca4b02443696c571d6da60604 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1611161134607-c87c47c4-bd4b-37d4-4444-04892e12361e.cfm
<cfset news = queryNew("id,title,datePublished",
"integer,varchar,Timestamp",
{"id":1,"title":"Dewey defeats Truman", "datePublished":now()})>
<cfquery dbtype="query" name="sub">
SELECT * FROM news
WHERE datePublished <= <cfqueryparam value="#now()#" cfsqltype="timestamp" maxlength="1">
</cfquery>
<cfdump var="#news#">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment