select * from event where eventid = #url.event# Trail Run -- <cfoutput>#getevent.eventname#</cfoutput>
 #getevent.eventname# Go Back    Search Again    All events  

  #getevent.overalldesc#  

  Date of event: #getevent.displaydate#  
  Location: #getevent.location#  
  Location City/State: #getevent.lcity#,  #getevent.lstate#  
  Contact: #getevent.contact1# or #getevent.contact2#  
  Adress: #getevent.addr1#
#getevent.addr2#

#getevent.city#
#getevent.state#,  #getevent.zip#
 
  Phone: #getevent.phone1# (Home)
#getevent.phone2# (Mobile)
#getevent.phone3# (Fax)
 
  Email: #getevent.email#  
  Web Address: #getevent.website#  

select * from subevent where eventid = #url.event#

 #getsub.racetype# Go Back    Search Again    All events  

  #getsub.description#  

  #getsub.title#  

  Start Time: #getsub.starttime#  
  Early Entry Fee:
#getsub.earlydeadline#
#getsub.earlyfee#  
  Late Entry fee: #getsub.latefee#  
  Event Day: #getsub.eventday#