query
RESULTSET
query
  ID MAILINGADDRESSDISPLAY NAMECUSTOMIZE NAMEDISPLAY NAMEDISPLAYLABEL NAMEREQUIRED NAMEREQUIREDMESSAGE ORGCUSTOMIZE ORGDISPLAY ORGDISPLAYLABEL ORGREQUIRED ORGREQUIREDMESSAGE PHONECUSTOMIZE PHONEDISPLAY PHONEDISPLAYLABEL PHONEREQUIRED PHONEREQUIREDMESSAGE RSVPID RSVPSERVER TITLECUSTOMIZE TITLEDISPLAY TITLEDISPLAYLABEL TITLEREQUIRED TITLEREQUIREDMESSAGE
CACHED false
EXECUTIONTIME 5
SQL SELECT * FROM RSVP_CUSTOM WHERE RSVPID = ?
SQLPARAMETERS
array
1 352

Online registration is closed.

Online registration is closed.

Event not found


Debugging Information
ColdFusion Server Enterprise 2023,0,0,330468
Template /online_sales/rsvp_ticket_purchasebt.cfm
Time Stamp 15-Apr-26 03:41 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.3.88.1
Host Name 10.3.88.1


Execution Time

Total Time Avg Time Count Template
541 ms 541 ms 1 CFC[ D:/_BlacktieSites/_newlookCLASS/application.cfc | onApplicationStart() ] from D:/_BlacktieSites/_newlookCLASS/application.cfc
340 ms 340 ms 1 D:/_BlacktieSites/_newlookCLASS/settingsHighSchool.cfm
213 ms 213 ms 1 CFC[ D:/_BlacktieSites/_newlookCLASS/application.cfc | onRequest(/online_sales/rsvp_ticket_purchasebt.cfm) ] from D:/_BlacktieSites/_newlookCLASS/application.cfc
160 ms 160 ms 1 top level D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm
93 ms 93 ms 1 CFC[ D:/_BlacktieSites/_newlookCLASS/application.cfc | onRequestStart(/online_sales/rsvp_ticket_purchasebt.cfm) ] from D:/_BlacktieSites/_newlookCLASS/application.cfc
68 ms 68 ms 1 CFC[ D:/_BlacktieSites/_newlookCLASS/application.cfc | onRequestEnd(/online_sales/rsvp_ticket_purchasebt.cfm) ] from D:/_BlacktieSites/_newlookCLASS/application.cfc
12 ms 12 ms 1 D:/_BlacktieSites/_newlookCLASS/footer.cfm
1 ms 1 ms 1 D:/_BlacktieSites/_newlookCLASS/newHeaderReunion.cfm
1 ms 1 ms 1 D:/_BlacktieSites/_newlookCLASS/online_sales/_countTicketLevels.cfm
0 ms 0 ms 1 D:/_BlacktieSites/_newlookCLASS/online_sales/_settings.cfm
0 ms 0 ms 1 D:/_BlacktieSites/_newlookCLASS/settingsStores.cfm
3198 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
4113 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getPREFVendorsAd (Datasource=classreu, Time=163ms, Records=0) in D:\_BlacktieSites\_newlookCLASS\application.cfc @ 03:41:28.028
SELECT partnerID,logofile, CASE WHEN gotourl = '1' THEN weburl ELSE '/event-planning/details.cfm?id=' + partnerID END as href 
		  ,case when showncount is null then 0 else showncount end as counter 
		  FROM vnd_partners
          WHERE hidden = '0'
rs (Datasource=classreu, Time=24ms, Records=1) in D:\_BlacktieSites\_newlookCLASS\application.cfc @ 03:41:28.028
SELECT m.state 
	FROM members m left join nonprofits n on m.username = n.username
	WHERE n.id = 
	(SELECT memberID FROM rsvp WHERE rsvpid = 
	?)
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 352

qCustomFields (Datasource=classreu, Time=5ms, Records=0) in D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm @ 03:41:29.029
SELECT * FROM RSVP_CUSTOM 
WHERE RSVPID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 352

control (Datasource=classreu, Time=12ms, Records=0) in D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm @ 03:41:29.029
SELECT *
    FROM RSVP
    WHERE rsvpid = ? AND (public_exp IS NULL OR public_exp > {ts '2026-04-15 03:41:29'})
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 352

control2 (Datasource=classreu, Time=26ms, Records=1) in D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm @ 03:41:29.029
SELECT *
    FROM RSVP
    WHERE rsvpid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 352

getRegLevels (Datasource=classreu, Time=40ms, Records=5) in D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm @ 03:41:29.029
select ID, rsvpID, RegNumber, Title, TopText, color, note, description, cost, priceChangeDate, newprice, levelsize, donation, donationText, excludeFromPromo,
	COALESCE(limit,0) as [limit],
	 cutoffDate,groupQTY, groupPrice, groupOnly, createDate, private
	,(select COALESCE(sum(tl.qty),0)  from  tickets t inner join TicketRegLevels tl on tl.ticketid = t.id where tl.reglevelID = RRL.ID and t.cc_approval_code != '' and t.cc_approval_code != '000000')
	+(select COALESCE(sum(qty),0)  from rsvpofflinePaymentRegLevels where reglevelID = RRL.ID )
	 as totalsold
	 ,displayHowManyLeft
	 
    from rsvpRegLevels RRL
    WHERE RRL.rsvpid = ?
    and (cutoffdate is NULL or cutoffdate > getDate())
	
	
    order by RegNumber
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 352

message (Datasource=classreu, Time=3ms, Records=1) in D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm @ 03:41:29.029
SELECT exp_notice
	FROM RSVP
	WHERE rsvpid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 352

q (Datasource=classreu, Time=4ms, Records=0) in D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm @ 03:41:29.029
SELECT userlogo,nonprofile,EventName,CalendarDate,location,locationaddress
    From denver

    WHERE FuseCalendar_ID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0


Scope Variables

Application Variables:
addtocalendarabs=D:\_BlacktieMedia\classreunions\vCal\
addtocalendarurl=/vCal/
applicationname=classreunionsz
auctionimagesabs=D:\_BlacktieSites\_newlookCLASS\auctions_images\
auctionimagesrel=/auctions_images/
auctionsectionad=
auctionsectionadurl=
auctionsectionswfad=
auctionuploadsabs=D:\_BlacktieSites\_newlookCLASS\auctions\upload\
auctionuploadsrel=/auctions/uploads/
auctionuploadsrel2=/auctions/upload/
blacktieservicesmemberid=0
blacktieservicesnonprofitid=0
blacktieservicesusername=nnnnnnn
btcommunitysectionad=
btcommunitysectionadurl=
calendarad=/_ads/VenHub.png
calendarad2=
calendarad2url=
calendaradurl=https://www.spotlightvendordirectory.com/
chairssectionswfadfile=hyatt_flash_600x300
contactcity=Denver
contactcitystatezip=Denver, CO 80220
contactemail=info@highschoolreunions.us
contactfax=832.8311
contactofficename=High School Reunions - Colorado Corporate Office
contactphone=303.918.2763
contactstate=CO
contactstreet=244 Albion St.
contactzip=80220
currbt=HighSchool
currentstateorcity=Colorado
currenttimestate=Denver, Colorado
currenttimezone=US/Mountain
customattirelist=Cocktail;Masquerade;Black Tie Preferred;Black Tie Required;Black Tie Invited or Black Tie Optional;Black Tie Western;Business;Business Casual;Casual Attire;Come as you are;Costume;Golf Attire;Dressed to Kill;Evening Attire, Business Formal or Cocktail Attire;White Tie;Vintage Dress;Luncheon Attire;Garden;Western;Service Dress Blues;Tennis Attire;Party Casual;Football Attire;
default_state=CO
dsn=classreu
earliestpurchasepicturedate=2003-04-01
emailaddedeventswithrsvpto=info@highschoolreunions.us;
emailcontactusto=info@highschoolreunions.us
emaildonationerrorto=info@highschoolreunions.us
emaildonationto=info@highschoolreunions.us
emailpicturepurchaseerrorto=info@highschoolreunions.us
emailpicturepurchaseto=info@highschoolreunions.us
emailrsvpsetup=info@highschoolreunions.us;
emailstorepurchaseerrorto=info@highschoolreunions.us
emailstorepurchaseto=info@highschoolreunions.us
emailticketpurchaseerrorto=info@highschoolreunions.us
emailticketpurchaseto=info@highschoolreunions.us
enforceservername=highschoolreunions.us
facebookappid=124057288492
facebookid=f41fd0ac6f6d7fb35e22b0aadb9b390b
freelanceimageabs=E:\_BlacktieMedia\classreunions\admin\image_conversion\modifyfolder\
galleryad=
hasssl=true
isdevtestmode=false
mediasourcesite=highschoolreunions.us
nonprofinewsletterrel=/nonprofit_newsletter_documents/
nonprofitcalendarinvitationabs=D:\_BlacktieMedia\classreunions\btimages\calendar\invitation\
nonprofitcalendarinvitationrel=/btimages/calendar/invitation/
nonprofitcalendaruserlogoabs=D:\_BlacktieMedia\classreunions\btimages\calendar_userlogo\
nonprofitcalendaruserlogorel=/btimages/calendar_userlogo/
nonprofitmailblastaddressabs=D:\_BlacktieMedia\classreunions\etools_06\AddressBookFiles\
nonprofitmailblastattachmentabs=D:\_BlacktieMedia\classreunions\iImages\u184ZZZ\
nonprofitmailblastattachmentrel=/iImages/u184ZZZ/
nonprofitmailblastmessageabs=D:\_BlacktieMedia\classreunions\iMessages\
nonprofitmailblastmessagefromsiterel=/iMessagesSite/
nonprofitmailblastmessagerel=/iMessages/
nonprofitmembercontractcurrenturl=
nonprofitnametagslogoabs=D:\_BlacktieSites\_newlookCLASS\nonprofit\nametags\logoImages\
nonprofitnametagslogorel=/nonprofit/nametags/logoImages/
nonprofitnewsletterabs=D:\_BlacktieSites\_newlookCLASS\nonprofit_newsletter_documents\
nonprofitpressreleaseabs=D:\_BlacktieSites\_newlookCLASS\nonprofit_press_documents\
nonprofitpressreleaserel=/nonprofit_press_documents/
partypicdir=/captured_events_pictures/
photocoverage=info@highschoolreunions.us
photosectionad=
photosectionad2=
photosectionad2url=
photosectionadurl=
photosectionsmallad=
photosectionsmalladurl=
photosectionswfadfile=
photosectionswfadfile2=
photosectionswfadfile3=
photourl=
showbtcomunity=false
showfacebook=true
showgoogleanalytics=false
showhaveyouheard=true
showhaveyoumet=true
showregions=true
showsavethedate=true
showvendoradsonhomepage=false
site_abbr=CO
storeitemimgdir=
storesthisn=4
storestoshow=4,5,6
storez=Struct (12)
strvendors=Struct (0)
ticketsectionad=
ticketsectionadurl=
ticketsectionswfad=
timezone=Complex type
vaultmode=production
watermarkadd=true
watermarkdeleteorigfile=false
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=3072
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R13
CERT_SERVER_SUBJECT=CN=highschoolreunions.us
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=3072
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R13
HTTPS_SERVER_SUBJECT=CN=highschoolreunions.us
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=highschoolreunions.us
HTTP_REFERER=
HTTP_URL=/online_sales/rsvp_ticket_purchasebt.cfm?rsvpid=352
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.3.88.10
PATH_INFO=
PATH_TRANSLATED=D:\_BlacktieSites\_newlookCLASS\online_sales\rsvp_ticket_purchasebt.cfm
QUERY_STRING=rsvpid=352
REMOTE_ADDR=10.3.88.1
REMOTE_HOST=10.3.88.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/online_sales/rsvp_ticket_purchasebt.cfm
SERVER_NAME=highschoolreunions.us
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=12400
CFTOKEN=eee0c635baa62c75-A52BEF90-FF5E-27D4-116A3C7721CB7354
Form Fields:
DONATIONAMOUNT=
Request Parameters:
cfdumpinited=true
cfdumpinitedforfunc=FALSE
chargetest=false
curl=https://highschoolreunions.us/
errormessage=
ht=https
rurl=https://highschoolreunions.us/
samesite_value=Strict
skipads=false
Session Variables:
sessionid=1E7CE1D5B284E5681BA404EB43DADB96.cfusion
urltoken=CFID=12400&CFTOKEN=eee0c635baa62c75-A52BEF90-FF5E-27D4-116A3C7721CB7354&jsessionid=1E7CE1D5B284E5681BA404EB43DADB96.cfusion
URL Parameters:
rsvpid=352
Debug Rendering Time: 31 ms