select * from states where stateshort = '#url.state#' select * from states where stateshort = '#form.state#' Trail Run -- <cfoutput>#titledisplay#</cfoutput>
 #titledisplay# Search Again    Show all events  
select * from event Where lstate = '#getstate.statelong#' eventid >= 0 eventid >= 0 order by #url.sort#, caldate order by caldate select * from event where lstate = '#getstate.statelong#' and month = '#form.month#' and year = '#form.year#' and eventid >= 0 order by #url.sort#, caldate order by caldate select event.*, subevent.* from event, subevent Where event.eventid = subevent.eventid and event.lstate = '#getstate.statelong#' and event.month = '#form.month#' and event.year = '#form.year#' and subevent.racetype = '#form.type#' and event.eventid >= 0 order by #url.sort#, caldate order by caldate
Event Date City State
select monthname from months where monthnumber = '#monthcur#' #getm.monthname#
select monthname from months where monthnumber = '#monthcur#' #getm.monthname#
#gete.Eventname# #gete.displaydate# #gete.lcity# #gete.lstate#
#gete.Eventname# #gete.displaydate# #gete.lcity# #gete.lstate#
Sorry there are currently no events scheduled in this area.