select * from #PopupCal_DetailsDB# where ID='#ID#' AND EvtDate='#getevtdate#' AND Repeat=1 ORDER by EvtDate,SeqNo select * from #PopupCal_DetailsDB# where ID='#ID#' AND DAYOFWEEK(EvtDate)=#getdayofweek# AND Repeat=2 ORDER by EvtDate,SeqNo select * from #PopupCal_DetailsDB# where ID='#ID#' AND DAYOFMONTH(EvtDate)=#url.day# AND Repeat=3 ORDER by EvtDate,SeqNo Events for #monthname# #url.day#, #url.year#:

#EvtTitle#
#EvtTitle#
#EvtDetails# Contact: #ContactName#. Phone: #ContactPhone# or send e-mail to #ContactEMail# send e-mail to #ContactEMail#
#EvtTitle#
#EvtTitle#
#EvtDetails# Contact: #ContactName#. Phone: #ContactPhone# or send e-mail to #ContactEMail# send e-mail to #ContactEMail#
#EvtTitle#
#EvtTitle#
#EvtDetails# Contact: #ContactName#. Phone: #ContactPhone# or send e-mail to #ContactEMail# send e-mail to #ContactEMail#
select ID,ImageURL from #PopupCal_ProfileDB# where ID='#Trim(ID)#' <cfoutput>#ID#</cfoutput> <cfoutput>#imageurl_query.RecordCount# - #Trim(imageurl_query.ID)#- [#Trim(imageurl_query.ImageURL)#]</cfoutput>