Polls

CFCATCH

Town Meeting Saturday May 4
Take a guess on when Town Meeting will end on Saturday, May 4th. The meeting starts at 9:00 AM and breaks for lunch at or around noon.
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT *, (select count(*) from pollanswer where pollanswer.polloptionid = polloption.polloptionid) as pc FROM [wws_montaguema].dbo.polloption WHERE pollID = 23 AND type = 'radio' ORDER BY pc desc, answer
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.5058
DriverName
stringMicrosoft JDBC Driver 4.0 for SQL Server
DriverVersion
string4.0.2206.100
Datasource
stringManager_WWS
DataSource
stringManager_WWS
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringInvalid object name 'pollanswer'.
NativeErrorCode
number208
queryError
stringSELECT *, (select count(*) from pollanswer where pollanswer.polloptionid = polloption.polloptionid) as pc FROM [wws_montaguema].dbo.polloption WHERE pollID = 23 AND type = 'radio' ORDER BY pc desc, answer
Sql
stringSELECT *, (select count(*) from pollanswer where pollanswer.polloptionid = polloption.polloptionid) as pc FROM [wws_montaguema].dbo.polloption WHERE pollID = 23 AND type = 'radio' ORDER BY pc desc, answer
SQLState
stringS0002
StackTrace
stringlucee.runtime.exp.DatabaseException: Invalid object name 'pollanswer'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:319) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:227) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1112) at lucee.runtime.tag.Query._doEndTag(Query.java:686) at lucee.runtime.tag.Query.doEndTag(Query.java:553) at box_poll_cfm$cf$111.call(/box_poll.cfm:246) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:829) at lucee.runtime.tag.CFTag.doInclude(CFTag.java:319) at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:245) at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:179) at poll_cfm$cf$273.call(/poll.cfm:4) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381) at lucee.runtime.engine.Request.exe(Request.java:43) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:432) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
TagContext
Array
1
Struct
codePrintHTML
string244: AND type = '#tt#'<br> 245: ORDER BY pc desc, answer<br> <b>246: &lt;/CFQUERY&gt;</b><br> 247: &lt;cfif qs_po.recordCount and tt eq &quot;checkbox&quot;&gt;<br> 248: &lt;tr&gt;&lt;th colspan=&quot;2&quot; bgcolor=&quot;##ddddee&quot; align=&quot;left&quot;&gt;Additional Options (all that apply):&lt;/th&gt;&lt;/tr&gt;<br>
codePrintPlain
string244: AND type = '#tt#' 245: ORDER BY pc desc, answer 246: </CFQUERY> 247: <cfif qs_po.recordCount and tt eq "checkbox"> 248: <tr><th colspan="2" bgcolor="##ddddee" align="left">Additional Options (all that apply):</th></tr>
column
number0
id
string??
line
number246
Raw_Trace
stringbox_poll_cfm$cf$111.call(/box_poll.cfm:246)
template
stringE:\Sites\WWS\box_poll.cfm
type
stringcfml
2
Struct
codePrintHTML
string2: &lt;cfsavecontent variable=&quot;request.pagecontent&quot;&gt;<br> 3: &lt;cfif val(url.g)&gt;<br> <b>4: &lt;cf_box_poll mode=&quot;full&quot; show=&quot;this&quot;&gt;</b><br> 5: &lt;cfelse&gt;<br> 6: &lt;cf_box_poll mode=&quot;full&quot; show=&quot;all&quot;&gt;<br>
codePrintPlain
string2: <cfsavecontent variable="request.pagecontent"> 3: <cfif val(url.g)> 4: <cf_box_poll mode="full" show="this"> 5: <cfelse> 6: <cf_box_poll mode="full" show="all">
column
number0
id
string??
line
number4
Raw_Trace
stringpoll_cfm$cf$273.call(/poll.cfm:4)
template
stringE:\Sites\WWS\poll.cfm
type
stringcfml
type
stringdatabase
where
string

SESSION

Session Scope (Memory)
Entries: 22
cfid
stringf18f372f-5664-4c4f-b052-7615b4072a6f
cftoken
string0
email
string
foreignkey
string
groupallot
string0
L_BANNERAD
string
L_DIRECTORY
number0
L_GROUP
number0
lastvisit
Date Time (America/New_York)
{ts '2022-05-21 21:06:45'}
loggedin
stringno
login
string
MEMBERGROUPS
string
PUB
number1
ROLE
Struct
Bad_Email
number0
Banned
number0
EDITOR
number0
G
Struct
Entries: 15
ArchiveArticle
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
calendar
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
corkboard
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
directory
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
files
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
forms
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
groupAdmin
number0
images
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
mediamixer
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
Member
number0
pages
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
poll
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
SplashEditor
number0
Subscriber
number0
video
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
Locked
number0
MANAGER
number0
Moderated
number0
siteAdmin
number0
Verified
number0
sessionid
stringwws_montaguema_f18f372f-5664-4c4f-b052-7615b4072a6f_0
SHOWEDIT
number1
showmember
string0
SHOWTOOLBAR
number1
timecreated
Date Time (America/New_York)
{ts '2022-05-21 21:06:45'}
times_on
string0
urltoken
stringCFID=f18f372f-5664-4c4f-b052-7615b4072a6f&CFTOKEN=0
userID
string0

URL

Scope
Entries: 77
adv
string0
b
string0
bookmark
string0
c
number0
cache
string
clearpoll
string0
close
string0
cs
number0
datefrom
string
daterequest
string05/21/2022
datestat
string
dateto
string
debug
string0
digest
number0
dt
number0
edit
string
end
string
error
string
f
string0
feID
string0
fiu
string
foreignkey
string
g
number201
gg
string201
gm
string
gpt
number34
gs
string
gsort
stringsitesort
ID
number0
keyfind
string
locationID
string0
m
number0
ma
string0
member
string
msg
string
mt
string0
n
number0
name
string
new
stringno
newthread
string0
num
number25
p
string0
page
string
path
string201
pid
string0
planID
number0
print
number0
pupID
string0
pw
string
repid
string
return
stringdisplay
return_url
string
scope
number201
searchterm
string
show
string
showcal
number1
siteerror
string
sortorder
string[date] DESC, [time] DESC
st
string1
start
string0
stats
stringfull
subject
string
subjectID
string0
submit
string
success
string0
t
number0
tg
number201
thispage
string
thread
number0
u
number0
un
string
userID
number0
vardump
string0
vcid
number0
view
string
window
stringmainPage
wrap
string1

FORM

Scope
Entries: 11
edit
string
emailTest
string0
groupid
number201
ID
stringurl.id
planID
string0
published
string0
return_url
string
run
string0
run_poll
string0
text
string
upload_file
string