Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!--- Using Coldfusion's cfquery tag --->
- <cfquery name="properties" datasource="#dsn#" username="#uname#" password="#pword#">
- SELECT * FROM Listing WHERE
- Price > <cfqueryparam cfsqltype="cf_sql_money" value="10" /> AND
- Price < <cfqueryparam cfsqltype="cf_sql_money" value="1000" />
- </cfquery>
- <!--- using my awesome helper --->
- <cf_query result="properties" MinPrice="10" MaxPrice="1000">
- SELECT * FROM Listing WHERE Price > ?money:MinPrice AND Price < ?money:MaxPrice
- </cf_query>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement