Advertisement
Guest User

Untitled

a guest
Jun 6th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.    
  2.     <!--- Using Coldfusion's cfquery tag --->
  3.     <cfquery name="properties" datasource="#dsn#" username="#uname#" password="#pword#">
  4.         SELECT * FROM Listing WHERE
  5.                 Price > <cfqueryparam cfsqltype="cf_sql_money" value="10" /> AND
  6.                 Price < <cfqueryparam cfsqltype="cf_sql_money" value="1000" />
  7.     </cfquery>
  8.    
  9.     <!--- using my awesome helper --->
  10.     <cf_query result="properties" MinPrice="10" MaxPrice="1000">
  11.         SELECT * FROM Listing WHERE Price > ?money:MinPrice AND Price < ?money:MaxPrice
  12.     </cf_query>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement