Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfquery name="getResults" datasource="#application.dsn#">
- SELECT S.*
- FROM Sessions S INNER JOIN Agenda A. ON S.Agenda_ID = S.Agenda_ID
- WHERE S.Event_ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#attributes.event_id#">
- AND S.Status = 'Active'
- <!--- AND S.Track_ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#attributes.track_id#"> --->
- AND (S.Track = '#preserveSingleQuotes(attributes.track)#'
- OR A.Track = '#preserveSingleQuotes(attributes.track)#')
- <!--- AND (S.Track = <cfqueryparam value="#preserveSingleQuotes(attributes.track)#" cfsqltype="CF_SQL_VARCHAR">
- OR A.Track = <cfqueryparam value="#preserveSingleQuotes(attributes.track)#" cfsqltype="CF_SQL_VARCHAR">) --->
- ORDER BY S.Title
- </cfquery>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement