Advertisement
sqlninja1

Untitled

Feb 15th, 2015
557
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <cfif structkeyExists(url,'event_date')>
  2. <cfscript>
  3. qryGetEventResults = new Query(
  4.         datasource="db9",
  5.         sql = "
  6.         SELECT *
  7.         FROM nDataAll
  8.         WHERE nDate=:eventDate
  9.         ");    
  10.         qryGetEventResults.addParam(name="eventDate",value=arguments.event_date, cfsqltype="cf_sql_timestamp");
  11.         resultset = qryGetEventResults.execute().getResult();
  12.         abort;
  13. </cfscript>
  14.  
  15. <cfdump  var="#resultset#">
  16.  
  17.     </cfif>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement