Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <cfquery name="getResults" datasource="#application.dsn#">
  2.     SELECT S.*
  3.     FROM Sessions S INNER JOIN Agenda A. ON S.Agenda_ID = S.Agenda_ID
  4.     WHERE S.Event_ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#attributes.event_id#">
  5.   AND S.Status = 'Active'
  6.     <!--- AND S.Track_ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#attributes.track_id#"> --->
  7.   AND (S.Track = '#preserveSingleQuotes(attributes.track)#'
  8.     OR A.Track = '#preserveSingleQuotes(attributes.track)#')
  9.   <!--- AND (S.Track = <cfqueryparam value="#preserveSingleQuotes(attributes.track)#" cfsqltype="CF_SQL_VARCHAR">
  10.    OR A.Track = <cfqueryparam value="#preserveSingleQuotes(attributes.track)#" cfsqltype="CF_SQL_VARCHAR">) --->
  11.     ORDER BY S.Title
  12. </cfquery>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement