Scope Arguments
exception1
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT * FROM abo WHERE (abo.abo_firma_id='50698' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='50698' AND abo.dtaboablauf>now());
DatabaseName
stringUCanAccess driver for Microsoft Access databases using HSQLDB
DatabaseVersion
stringV2003 [VERSION_4]
DriverName
stringUcanaccess
DriverVersion
string5.0.1
Datasource
stringhandwerk
DataSource
stringhandwerk
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringUCAExc:::5.0.1 user lacks privilege or object not found: NOWWA
NativeErrorCode
number-5501
queryError
stringSELECT * FROM abo WHERE (abo.abo_firma_id='50698' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='50698' AND abo.dtaboablauf>now());
Sql
stringSELECT * FROM abo WHERE (abo.abo_firma_id='50698' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='50698' AND abo.dtaboablauf>now());
SQLState
string42501
StackTrace
stringlucee.runtime.exp.DatabaseException: UCAExc:::5.0.1 user lacks privilege or object not found: NOWWA at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:159) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:298) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at h_seldata_cfm$cf$3wa.call(/h_seldata.cfm:125) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at h_kprofil_cfm$cf$3w9.call(/h_kprofil.cfm:6) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at cms_default_cfm$cf$3va.call(/cms_default.cfm:99) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:215) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:128) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:165) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:77) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:113) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:424) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1778) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:946) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:480) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:57) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string123: &nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;abo<br> 124: &nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;(abo.abo_firma_id='#session.firma_id#'&nbsp;AND&nbsp;abo.dtaboablauf&nbsp;Is&nbsp;Null)&nbsp;OR&nbsp;(abo.abo_firma_id='#session.firma_id#'&nbsp;AND&nbsp;abo.dtaboablauf&gt;now());<br> <b>125: &lt;/cfquery&gt;</b><br>
codePrintPlain
string123: FROM abo 124: WHERE (abo.abo_firma_id='#session.firma_id#' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='#session.firma_id#' AND abo.dtaboablauf>now()); 125: </cfquery>
column
number0
id
string??
line
number125
Raw_Trace
stringh_seldata_cfm$cf$3wa.call(/h_seldata.cfm:125)
template
stringI:\WWW\handwerk.ch\h_seldata.cfm
type
stringcfml
2
Struct
codePrintHTML
string4: <br> 5: &lt;cfinclude&nbsp;template=&quot;cms_top.cfm&quot;&gt;<br> <b>6: &lt;CFINCLUDE&nbsp;TEMPLATE=&quot;h_seldata.cfm&quot;&gt;</b><br> 7: &lt;cfif&nbsp;cgi.script_name&nbsp;is&nbsp;&quot;/h_kprofil.cfm&quot;&nbsp;and&nbsp;Session.h_logton_userid&nbsp;EQ&nbsp;&quot;&quot;&gt;<br> 8: &nbsp;&nbsp;&lt;cflocation&nbsp;url=&quot;/h_login.cfm&quot;&gt;<br>
codePrintPlain
string4: 5: <cfinclude template="cms_top.cfm"> 6: <CFINCLUDE TEMPLATE="h_seldata.cfm"> 7: <cfif cgi.script_name is "/h_kprofil.cfm" and Session.h_logton_userid EQ ""> 8: <cflocation url="/h_login.cfm">
column
number0
id
string??
line
number6
Raw_Trace
stringh_kprofil_cfm$cf$3w9.call(/h_kprofil.cfm:6)
template
stringI:\WWW\handwerk.ch\h_kprofil.cfm
type
stringcfml
3
Struct
codePrintHTML
string97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;selH_firma_id&nbsp;=&nbsp;#URL_Parameter_wert2#&gt;<br> 98: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Session.Profil&nbsp;=&nbsp;&quot;true&quot;&gt;<br> <b>99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;h_kprofil.cfm&quot;&gt;</b><br> 100: &nbsp;&nbsp;&nbsp;&lt;cfelseif&nbsp;URL_Parameter_aktion2&nbsp;is&nbsp;&quot;A&quot;&gt;<br> 101: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;ArtikelID&nbsp;=&nbsp;#URL_Parameter_wert2#&gt;<br>
codePrintPlain
string97: <cfset selH_firma_id = #URL_Parameter_wert2#> 98: <cfset Session.Profil = "true"> 99: <cfinclude template="h_kprofil.cfm"> 100: <cfelseif URL_Parameter_aktion2 is "A"> 101: <cfset ArtikelID = #URL_Parameter_wert2#>
column
number0
id
string??
line
number99
Raw_Trace
stringcms_default_cfm$cf$3va.call(/cms_default.cfm:99)
template
stringI:\WWW\handwerk.ch\cms_default.cfm
type
stringcfml
type
stringdatabase
where
string
onApplicationStart2
string
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT * FROM abo WHERE (abo.abo_firma_id='50698' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='50698' AND abo.dtaboablauf>now());
DatabaseName
stringUCanAccess driver for Microsoft Access databases using HSQLDB
DatabaseVersion
stringV2003 [VERSION_4]
DriverName
stringUcanaccess
DriverVersion
string5.0.1
Datasource
stringhandwerk
DataSource
stringhandwerk
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringUCAExc:::5.0.1 user lacks privilege or object not found: NOWWA
NativeErrorCode
number-5501
queryError
stringSELECT * FROM abo WHERE (abo.abo_firma_id='50698' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='50698' AND abo.dtaboablauf>now());
Sql
stringSELECT * FROM abo WHERE (abo.abo_firma_id='50698' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='50698' AND abo.dtaboablauf>now());
SQLState
string42501
StackTrace
stringlucee.runtime.exp.DatabaseException: UCAExc:::5.0.1 user lacks privilege or object not found: NOWWA at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:159) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:298) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at h_seldata_cfm$cf$3wa.call(/h_seldata.cfm:125) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at h_kprofil_cfm$cf$3w9.call(/h_kprofil.cfm:6) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at cms_default_cfm$cf$3va.call(/cms_default.cfm:99) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:215) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:128) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:165) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:77) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:113) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:424) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1778) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:946) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:480) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:57) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string123: &nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;abo<br> 124: &nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;(abo.abo_firma_id='#session.firma_id#'&nbsp;AND&nbsp;abo.dtaboablauf&nbsp;Is&nbsp;Null)&nbsp;OR&nbsp;(abo.abo_firma_id='#session.firma_id#'&nbsp;AND&nbsp;abo.dtaboablauf&gt;now());<br> <b>125: &lt;/cfquery&gt;</b><br>
codePrintPlain
string123: FROM abo 124: WHERE (abo.abo_firma_id='#session.firma_id#' AND abo.dtaboablauf Is Null) OR (abo.abo_firma_id='#session.firma_id#' AND abo.dtaboablauf>now()); 125: </cfquery>
column
number0
id
string??
line
number125
Raw_Trace
stringh_seldata_cfm$cf$3wa.call(/h_seldata.cfm:125)
template
stringI:\WWW\handwerk.ch\h_seldata.cfm
type
stringcfml
2
Struct
codePrintHTML
string4: <br> 5: &lt;cfinclude&nbsp;template=&quot;cms_top.cfm&quot;&gt;<br> <b>6: &lt;CFINCLUDE&nbsp;TEMPLATE=&quot;h_seldata.cfm&quot;&gt;</b><br> 7: &lt;cfif&nbsp;cgi.script_name&nbsp;is&nbsp;&quot;/h_kprofil.cfm&quot;&nbsp;and&nbsp;Session.h_logton_userid&nbsp;EQ&nbsp;&quot;&quot;&gt;<br> 8: &nbsp;&nbsp;&lt;cflocation&nbsp;url=&quot;/h_login.cfm&quot;&gt;<br>
codePrintPlain
string4: 5: <cfinclude template="cms_top.cfm"> 6: <CFINCLUDE TEMPLATE="h_seldata.cfm"> 7: <cfif cgi.script_name is "/h_kprofil.cfm" and Session.h_logton_userid EQ ""> 8: <cflocation url="/h_login.cfm">
column
number0
id
string??
line
number6
Raw_Trace
stringh_kprofil_cfm$cf$3w9.call(/h_kprofil.cfm:6)
template
stringI:\WWW\handwerk.ch\h_kprofil.cfm
type
stringcfml
3
Struct
codePrintHTML
string97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;selH_firma_id&nbsp;=&nbsp;#URL_Parameter_wert2#&gt;<br> 98: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;Session.Profil&nbsp;=&nbsp;&quot;true&quot;&gt;<br> <b>99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;h_kprofil.cfm&quot;&gt;</b><br> 100: &nbsp;&nbsp;&nbsp;&lt;cfelseif&nbsp;URL_Parameter_aktion2&nbsp;is&nbsp;&quot;A&quot;&gt;<br> 101: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfset&nbsp;ArtikelID&nbsp;=&nbsp;#URL_Parameter_wert2#&gt;<br>
codePrintPlain
string97: <cfset selH_firma_id = #URL_Parameter_wert2#> 98: <cfset Session.Profil = "true"> 99: <cfinclude template="h_kprofil.cfm"> 100: <cfelseif URL_Parameter_aktion2 is "A"> 101: <cfset ArtikelID = #URL_Parameter_wert2#>
column
number0
id
string??
line
number99
Raw_Trace
stringcms_default_cfm$cf$3va.call(/cms_default.cfm:99)
template
stringI:\WWW\handwerk.ch\cms_default.cfm
type
stringcfml
type
stringdatabase
where
string

Debugging Information
Lucee (Gelert) Os 6.2.5.48 (CFML Version 2016,0,03,300357)
Template http://test.handwerk.ch/cms_default.cfm?404;http://test.handwerk.ch:80/de/Suche/H/50698
I:\WWW\handwerk.ch\cms_default.cfm
Time Stamp 6 Apr 2026 03:50
Time Zone Europe/Zurich
Locale En_ch
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 216.73.216.40
Host Name test.handwerk.ch
Architecture 64bit

Execution Time

Total Time Avg Time Count Template
1.56ms 1.56ms 1 I:\WWW\handwerk.ch\cms_top.cfm
1.40ms 1.40ms 1 I:\WWW\handwerk.ch\h_seldata.cfm
1.10ms 1.10ms 1 I:\WWW\handwerk.ch\cms_select.cfm
1.58ms 1.58ms 1 I:\WWW\handwerk.ch\Application.cfc$onError
1.31ms 0.66ms 2 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc$onStartTag
0.66ms 0.66ms 1 I:\WWW\handwerk.ch\admin\spam\com_user_counter.cfm
0.49ms 0.49ms 1 I:\WWW\handwerk.ch\admin\spam\com_error_check.cfm
0.41ms 0.41ms 1 I:\WWW\handwerk.ch\admin\common\cms_sprachwahl.cfm
0.20ms 0.20ms 1 I:\WWW\handwerk.ch\admin\spam\com_block_check.cfm
0.18ms 0.18ms 1 I:\WWW\handwerk.ch\com_security.cfm
0.08ms 0.08ms 1 I:\WWW\handwerk.ch\com_head.cfm
0.11ms 0.05ms 2 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc$DOOUTPUT
0.10ms 0.05ms 2 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc
0.04ms 0.04ms 1 I:\WWW\handwerk.ch\Application.cfc
0.03ms 0.01ms 2 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc$init
1.87ms 0.01ms 200 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc$html
0.01ms 0.01ms 1 I:\WWW\handwerk.ch\cms_sprachwahl.cfm
0.07ms 0.01ms 12 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc$DARKENCOLOR
0.01ms 0.00ms 3 C:\lucee\tomcat\lucee-server\context\components\org\lucee\cfml\Component.cfc
0.02ms 0.00ms 5 I:\WWW\handwerk.ch\cms_top.cfm$recordCount
0.35ms 0.00ms 102 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc$CREATEID
1.00ms 0.00ms 372 C:\lucee\tomcat\lucee-server\context\library\tag\Dump.cfc$DOHIGHLIGHT
0.00ms 0.00ms 1 I:\WWW\handwerk.ch\cms_default.cfm
0.00ms 0.00ms 1 I:\WWW\handwerk.ch\h_kprofil.cfm
0.00ms 0.00ms 1 I:\WWW\handwerk.ch\Application.cfc$onrequeststart
0.85ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1.28ms  APPLICATION EXECUTION TIME
3.64ms  QUERY EXECUTION TIME
5.02ms  TOTAL EXECUTION TIME
red = over 250.00ms average execution time

Exceptions

Type Message Detail Template
missinginclude Page [/com_redirecter.cfm] [I:\WWW\handwerk.ch\com_redirecter.cfm] not found I:\WWW\handwerk.ch\cms_top.cfm:7

Implicit variable Access

Scope Template Line Var Count
variables I:\WWW\handwerk.ch\Application.cfc 62 TEMPLATE 1
variables I:\WWW\handwerk.ch\Application.cfc 106 TEMPLATE 1
arguments I:\WWW\handwerk.ch\Application.cfc 114 EXCEPTION 1
variables I:\WWW\handwerk.ch\admin\spam\com_block_check.cfm 32 LOGFILE 1
variables I:\WWW\handwerk.ch\admin\spam\com_block_check.cfm 34 ATTRIBUTES 1
variables I:\WWW\handwerk.ch\admin\spam\com_error_check.cfm 19 attributes 2
variables I:\WWW\handwerk.ch\admin\spam\com_error_check.cfm 20 attributes 1
variables I:\WWW\handwerk.ch\admin\spam\com_error_check.cfm 28 LOGFILE 1
variables I:\WWW\handwerk.ch\admin\spam\com_error_check.cfm 30 ATTRIBUTES 1
variables I:\WWW\handwerk.ch\admin\spam\com_user_counter.cfm 11 logDir 1
variables I:\WWW\handwerk.ch\admin\spam\com_user_counter.cfm 63 ENCODING 1
variables I:\WWW\handwerk.ch\admin\spam\com_user_counter.cfm 64 ENCODING 2
variables I:\WWW\handwerk.ch\admin\spam\com_user_counter.cfm 65 ENCODING 1
variables I:\WWW\handwerk.ch\admin\spam\com_user_counter.cfm 66 ENCODING 1
cgi I:\WWW\handwerk.ch\cms_default.cfm 33 QUERY_STRING 1
cgi I:\WWW\handwerk.ch\cms_default.cfm 50 QUERY_STRING 1
cgi I:\WWW\handwerk.ch\cms_default.cfm 51 QUERY_STRING 1
cgi I:\WWW\handwerk.ch\cms_default.cfm 53 QUERY_STRING 1
query I:\WWW\handwerk.ch\cms_top.cfm 211 THEMANAME 1
query I:\WWW\handwerk.ch\cms_top.cfm 211 THEMAID 1
query I:\WWW\handwerk.ch\cms_top.cfm 212 ANZSUBKAT 1
query I:\WWW\handwerk.ch\cms_top.cfm 262 THEMANAME 6
query I:\WWW\handwerk.ch\cms_top.cfm 262 THEMAID 6
query I:\WWW\handwerk.ch\cms_top.cfm 263 ANZSUBKAT 6
query I:\WWW\handwerk.ch\cms_top.cfm 267 THEMAID 3
query I:\WWW\handwerk.ch\cms_top.cfm 271 THEMAID 5
query I:\WWW\handwerk.ch\cms_top.cfm 276 THEMANAME 14
query I:\WWW\handwerk.ch\cms_top.cfm 276 THEMAID 14
cgi I:\WWW\handwerk.ch\cms_top.cfm 426 SCRIPT_NAME 1
cgi I:\WWW\handwerk.ch\com_security.cfm 24 REQUEST_METHOD 1

SQL Queries

GetThema (Datasource=handwerk_cms, Time=3.44ms, Records=1) in I:\WWW\handwerk.ch\cms_select.cfm:11
the following colum(s) are never read within the request:ThemaID,AuthObject,HauptThema,ThemaLink,ThemaTemplate,ThemaBild,Description,AnzSubKat
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE, AuthObject, AnzSubKat, Description AuthObject
				FROM         Themen 
				where ThemaID='Suche' and Phase='online'
GetTopMenu (Datasource=handwerk_cms, Time=2.59ms, Records=7) in I:\WWW\handwerk.ch\cms_select.cfm:17
the following colum(s) are never read within the request:ThemaLink,ThemaText,ThemaBild
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, AnzSubKat, AuthObject
				FROM         Themen 
				where Hauptthema='TopMenu' and Phase='online' order by ThemaPrio
GetArtikel (Datasource=handwerk_cms, Time=4.86ms, Records=0) in I:\WWW\handwerk.ch\cms_select.cfm:22
the following colum(s) are never read within the request:Bild1,Link2,Text1,Titel,Link1,BIld2,ArtikelID,Text2
SELECT      
				Artikel.ArtikelID, 
				Artikel.Titel, 
				Artikel.Link1,
				Artikel.Link2, 
				Artikel.Bild1,
				Artikel.Bild2, 
				Artikel.Text1, 
				Artikel.Text2
				FROM Artikel RIGHT JOIN (Themen LEFT JOIN Themen_Artikel ON Themen.ThemaID = Themen_Artikel.ThemaID) ON Artikel.ArtikelID = Themen_Artikel.ArtikelID
				where Themen.ThemaID = 'Suche'
				AND Artikel.Phase = 'online' 
				AND (Artikel.OnlineVon is null or Artikel.OnlineVon < {ts '2026-04-06 03:50:28'})
				AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2026-04-06 03:50:28'})
				Order By Themen_Artikel.SortPos asc;
GetSubKat (Datasource=handwerk_cms, Time=4.37ms, Records=6) in I:\WWW\handwerk.ch\cms_top.cfm:264
the following colum(s) are never read within the request:AuthObject,ThemaLink,ThemaTemplate,ThemaText,ThemaBild,AnzSubKat
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat
                            FROM         Themen 
                            Where Themen.HauptThema = 'Angebot' and Themen.Phase='online'
                            order by ThemaPrio
GetSubKat (Datasource=handwerk_cms, Time=4.33ms, Records=2) in I:\WWW\handwerk.ch\cms_top.cfm:264
the following colum(s) are never read within the request:AuthObject,ThemaLink,ThemaTemplate,ThemaText,ThemaBild,AnzSubKat
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat
                            FROM         Themen 
                            Where Themen.HauptThema = 'Ausschreibungen' and Themen.Phase='online'
                            order by ThemaPrio
GetSubKat (Datasource=handwerk_cms, Time=4.33ms, Records=6) in I:\WWW\handwerk.ch\cms_top.cfm:264
the following colum(s) are never read within the request:AuthObject,ThemaLink,ThemaTemplate,ThemaText,ThemaBild,AnzSubKat
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat
                            FROM         Themen 
                            Where Themen.HauptThema = 'Ratgeber' and Themen.Phase='online'
                            order by ThemaPrio
GetEigenesFirmenprofil (Datasource=handwerk, Time=9.02ms, Records=1) in I:\WWW\handwerk.ch\h_seldata.cfm:1
the following colum(s) are never read within the request:firma_homepage2,firma_titelzusatz_en,firma_titelzusatz_it,firma_titelzusatz_ru,firma_crm_ru,firma_adresse2,firma_eintritt,firma_titel_en,firma_titel_ru,firma_pager,firma_titel_de,firma_mod_user,firma_austritt,firma_FaxG,firma_titel_fr,firma_crm_it,firma_plz2,firma_crm_fr,firma_titelzusatz_de,firma_refid,firma_telD,firma_modifiziert,firma_titelzusatz_fr,firma_adresse_privat,firma_ort2,firma_titel_it,firma_kanton2,firma_land2,firma_adresszusatz2,firma_telG
SELECT * FROM firmen 
	
				WHERE firma_id = 50698
GetPortrait (Datasource=handwerk, Time=2.26ms, Records=1) in I:\WWW\handwerk.ch\h_seldata.cfm:52
the following colum(s) are never read within the request:firma_status,firma_crm_de,firma_Feld2,firma_Feld1,firma_crm_en,firma_id,firma_mitglied,firma_Feld3
select firma_id, firma_crm_de, firma_crm_en, firma_portrait, firma_Feld1, firma_Feld2, firma_Feld3, firma_status, firma_mitglied from firmen where firmen.firma_id = 50698
GetPortraitLogo (Datasource=handwerk, Time=1.23ms, Records=0) in I:\WWW\handwerk.ch\h_seldata.cfm:56
the following colum(s) are never read within the request:doc_DateiName,doc_PathName
select doc_dateiname, doc_pathname from _Docs where Doc_name = 'brunnerelektro'

Scope Variables

Application Variables:
ADMINURL=Admin
ADMINVERSION=2024051601
applicationname=Handwerk
AUFTRAGURL=http://test.handwerk.ch//docs/A/
COLLECTIONPATH=I:\WWW\handwerk.ch\verity
COOKIECONSENTPOPUP=true
CURRENCY2=EUR
DATASOURCE=handwerk_cms
DATASOURCE2=handwerk
DATASOURCE_ADM=handwerk_cms
DIRHM=I:\WWW\handwerk.ch\
DocsPath=docs
FIRMAURL=http://test.handwerk.ch//docs/H/
FROM=handwerk.ch <news@handwerk.ch>
HM=/
LZ=999
MaxRows=50
MENU=cms_MMenu.cfm
MWST_INOROUT=Inklusive
MYEMAIL=info@handwerk.ch
MYPOS_URL=https://www.mypos.eu/vmp/checkout-test
MYPOSSID=000000000000010
MYPOSURLCANCEL=http://test.handwerk.ch/shop_myPos_response.cfm?Cancel
MYPOSURLNOTIFY=https://test.handwerk.ch/shop_myPos_response.cfm?Notify
MYPOSURLOK=http://test.handwerk.ch/shop_myPos_response.cfm?OK
MYPOSWALLETNUMBER=61938166610
MYURL=http://test.handwerk.ch/
NAME=Handwerk
NMPATH=nm
ORDERDOCUMENTBASEPATH=I:\WWW\handwerk.ch\orders
ORDERDOCUMENTBASEURL=/orders
PortoCH=0
PortoEU=0
RABATTBEZEICHNUNG=SuperDuper
RABATTSATZ=0.33
REFCURRENCY=CHF
REFLAND=CHE
REFSPRACHE=-ch
SHOP_MYPOS_KEYINDEX=1
SHOP_MYPOS_PRIVATECERT_PATH=converted_handwerk_mypos_private_key.pem
SHOP_MYPOS_PUBLICCERT_PATH=converted_handwerk_mypos_public_key.pem
SHOP_MYPOS_STOREID=114219
SHOP_MYPOS_URL=https://www.mypos.com/vmp/checkout
SHOP_MYPOS_WALLETID=40071437194
SHOP_PAYPAL_MERCHID=AcXYX6RW241B2O0UbCVPtjx5j7zIy6yiRTV1T8-Royaw3trDYE4EaA6m4weD9_3MGR-ilTG8FJe655C2
SHOP_PAYPAL_SECRET=EG-UQGcYPJp8JfG6F6qXD9BL7qDrwpC2q2-FLdAsVYwDiaQCZfQIW8CQLXCBT11Q_lbPQKZBm-6_tUrO
SHOP_PAYPAL_URL=https://api-m.paypal.com
SHOP_RECHNUNG_BILD=docs/Angebot.png
SHOP_RECHNUNG_CREDITORADDRESS1=Seefeldstrasse 94
SHOP_RECHNUNG_CREDITORCITY=Zurich
SHOP_RECHNUNG_CREDITORLAND=CH
SHOP_RECHNUNG_CREDITORNAME=Handwerk.ch GmbH
SHOP_RECHNUNG_CREDITORNO=
SHOP_RECHNUNG_CREDITORPOSTCODE=8008
SHOP_RECHNUNG_QRIBAN=CH0530000001607931348
SHOP_RECHNUNG_TEXT=PHN0eWxlPg0KLnN1YnRpdGxlMSB7DQoJZm9udC13ZWlnaHQ6MTAwOw0KCWZvbnQtc2l6ZToxM3B4CTsNCgljb2xvcjpibGFjazsNCgl0ZXh0LWFsaWduOiByaWdodDsNCgljbGVhcjpyaWdodDsNCn0NCi5zdWJ0aXRsZTIgew0KCWZvbnQtd2VpZ2h0OjEwMDsNCglmb250LXNpemU6MTNweAk7DQoJY29sb3I6IzgwODA4MDsNCgl0ZXh0LWFsaWduOiByaWdodDsNCgljbGVhcjpyaWdodDsNCn0NCjwvc3R5bGU+DQo8ZGl2Pg0KCQkJPGltZyBzcmM9Ii9kb2NzL0xvZ28tZGlyZWN0b3J5LXJnYi5qcGciIHN0eWxlPSJ3aWR0aDogMjAwLjAwcHg7IGhlaWdodDogNTAuMDBweDsgZmxvYXQ6bGVmdCIgdGl0bGU9IiI+DQoJCQk8cCBjbGFzcz0ic3VidGl0bGUxIj5IYW5kd2Vyay5jaCBHbWJIPC9wPg0KCQkJPHAgY2xhc3M9InN1YnRpdGxlMiI+U2VlZmVsZHN0cmFzc2UgOTQsIDgwMDggWsO8cmljaDwvcD4NCgkJCTxwIGNsYXNzPSJzdWJ0aXRsZTIiPlRlbC4gMDQ0IDM4MyAwMSAwMzwvcD4NCgkJCTxwIGNsYXNzPSJzdWJ0aXRsZTIiPmluZm9AaGFuZHdlcmsuY2ggPC9wPg0KCQkJPGJyPjxicj48YnI+DQoJCQkNCiAgICAgICAgPC9kaXY+
SHOPAKTION=n
SHOPBCC=ap@trenka.ch
shopFaceProperties=pdf editOrder report
SHOPFROM=ap@trenka.ch
SHOPPATH=shop
SHOPTOCC=ap@trenka.ch
SPAMcheckemail=Array (0)
SPAMcheckIPs=Array (0)
SPRACHEN=DE
sprachen_lang_DE=Struct (382)
STATUS=Open
SURVEYACCOUNT=www.handwerk.ch
SURVEYDB=handwerk_Survey
SURVEYEMAIL=info@handwerk.ch
SURVEYVIEW=survey.cfm
TaxRate=0
TimeoutcheckIPs=Array (0)

CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=I:\WWW\handwerk.ch\cms_default.cfm
content_length=
content_type=
context_path=
gateway_interface=CGI/1.1
http_accept=*/*
http_accept_encoding=gzip, br, zstd, deflate
http_accept_language=
http_connection=keep-alive
http_cookie=CF_CLIENT_HANDWERK_HC=2; CF_CLIENT_HANDWERK_LV=1775440227354; cfid=8a05d40b-28e4-4235-8edc-bdfafac0d267; cftoken=0; CF_CLIENT_HANDWERK_TC=1775440227354
http_host=test.handwerk.ch
http_referer=
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
https=off
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=193.16.211.5
local_host=Notos
path_info=
path_translated=I:\WWW\handwerk.ch\cms_default.cfm
query_string=404;http://test.handwerk.ch:80/de/Suche/H/50698
remote_addr=216.73.216.40
remote_host=216.73.216.40
remote_user=
request_method=GET
request_url=http://test.handwerk.ch/cms_default.cfm?404;http://test.handwerk.ch:80/de/Suche/H/50698
script_name=/cms_default.cfm
server_name=test.handwerk.ch
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=

Client Variables:
cfid=8a05d40b-28e4-4235-8edc-bdfafac0d267
cftoken=0
hitcount=2
lastvisit={ts '2026-04-06 03:50:27'}
timecreated={ts '2026-04-06 03:50:27'}
urltoken=CFID=8a05d40b-28e4-4235-8edc-bdfafac0d267&CFTOKEN=0

Cookie Variables:
cf_client_handwerk_hc=2
cf_client_handwerk_lv=1775440227354
cf_client_handwerk_tc=1775440227354
cfid=8a05d40b-28e4-4235-8edc-bdfafac0d267
cftoken=0

Server Variables:
CMSMASTER=Struct (2)
coldfusion=Struct (9)
counters=Struct (5)
form_ipaddress=
form_value=
java=Struct (9)
lucee=Struct (9)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
SPAM_App_Blacklist_Query=Query (0)
SPAM_Blacklist_Query=Query (1598)
SPAM_RequestBlock_Query=Query (8)
SPAM_Sync=Struct (4)
SPAM_Whitelist_Query=Query (13)
system=Struct (2)

Session Variables:
ActAppl=CMSmaster
Address1=
Address2=
ADS=Query (0)
Bemerkungen=
CardName=
CardNum=0000 0000 0000 1234
CardNum2=000
CardTyp=
CartID=5F016A95-F578-4AAC-AA821B4DBCF004AD
cfid=8a05d40b-28e4-4235-8edc-bdfafac0d267
cftoken=0
City=
CompanyName=
DocsPath=I:\WWW\handwerk.ch\docs\H\50698\
DOCSURL=http://test.handwerk.ch/docs/H/50698/
dollarkurs=1
dtOrdDate=
EditMode=fckeditor
Email=
Eurokurs=1
Expires={ts '2026-04-06 03:50:27'}
Fax=
firma_adresse=Bürgstrasse 66
firma_adresszusatz=Postfach 5
firma_anrede=Herr
FIRMA_BRIEFANREDE=
firma_crm_de=<p>
	Nachhaltigkeit und ein verantwortungsvoller Umgang mit Energie und den Ressourcen ist uns ein grosses Anliegen. Wir verstehen uns als Ihren Probleml&ouml;ser und Ihren administrativen und technischen Treuh&auml;nder.</p>
<p>
	Wir verf&uuml;gen &uuml;ber eigenen Messmitteln f&uuml;r folgende Aufgabenstellungen:</p>
<ul>
	<li>
		Energie- und Netzqualit&auml;tsmessungen nach EN</li>
	<li>
		Beleuchtungsmessungen</li>
	<li>
		Messungen f&uuml;r elektrische- und magnetische Felder</li>
	<li>
		Elektro- Geb&auml;ude- und Industriethermografie</li>
</ul>

firma_crm_en=
firma_email=info@brueleng.ch
FIRMA_EMAIL2=
firma_fax=055 263 17 04
firma_faxG=
firma_feld1=Kompetenzzentrum für Elektrotechnik
firma_feld2=Logo_brunner.gif
firma_feld3=
firma_feld4=47.266121, 8.796503
firma_feld5=
firma_homepage=http://www.brueleng.ch
firma_homepage2=
firma_id=50698
firma_kanton=ZH
firma_land=
firma_mitglied=false
firma_mob=079 216 10 37
firma_nachname=Brunner
firma_name=Brunner Elektro-Engineering GmbH 
firma_ort=Bubikon
firma_passwort=brueleng97
firma_plz=8608
firma_portrait=brunnerelektro
firma_portrait_id=E5527DF5-9F99-B523-5D2E6913196A144D
firma_sprache=
FIRMA_SPRACHEN=de
firma_status=H7S11
firma_tel=055 263 17 00
firma_telD=
firma_telG=
firma_userid=info@brueleng.ch
firma_vorname=Walter
FirstName=
h_logton_Attribute=
h_logton_userid=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
IPADDR=216.73.216.40
JumpBack2=shop_payment.cfm
LAddress1=
LAddress2=
Land=
LastName=
lastvisit={ts '2026-04-06 03:50:28'}
LCity=
LCompanyName=
LFirstName=
LLand=
LLastName=
logton=
LPostCode=
NEXTSTART=261
Password=
payart=Rechnung
Phone=
PostCode=
PREVSTART=221
Profil=true
Profilfound=true
PswdConfirm=brueleng97
RabattSatz=20
SaveKkA=0
SearchPremium=[47.286417799999995,7.934982190158436,"/1/logo-header.png","A&L Gipserunternehmen","Zofingen","gl-real-estate-icon",54261],[47.2812184,7.525434588656799,"/1/logo-header.png","German Allround Handmade","Welschenrohr","gl-real-estate-icon",54257],[47.5440243,8.0480029,"/1/logo-header.png","Garten und Trockenbau Scheuer","Kaisten","gl-real-estate-icon",54256],[47.2382868,7.8298097707536645,"/1/logo-header.png","Multi Handling AG","Roggwil","gl-real-estate-icon",54254],[47.474079,9.483668399999999,"/54253/avatar.jpg","1000sassa Bau","Rorschach","gl-real-estate-icon",54253],[51.5208247,7.4769820791185175,"/1/logo-header.png","Caroldachdeckerei ","Dortmund ","gl-real-estate-icon",54252],[47.407084850000004,8.55088521642442,"/1/logo-header.png","Perrin Malerhandwerk","Zürich","gl-real-estate-icon",54251],[47.5025086,8.0183062,"/1/logo-header.png","","Frick","gl-real-estate-icon",54250],[47.3246332,8.1625048,"/1/logo-header.png","Arcom Beschattungen GmbH","Dürrenäsch","gl-real-estate-icon",54248],[46.738991,7.6227729,"/1/logo-header.png","Scupola Bau GmbH","Thun","gl-real-estate-icon",53967],[47.513049949999996,7.723021857482541,"/1/logo-header.png","H&L Gebäudetechnik GmbH","Füllinsdorf","gl-real-estate-icon",54247],[47.47025265,9.587702533383688,"/1/logo-header.png","Ablaufservice-profi","Rheineck","gl-real-estate-icon",54246],[47.5615446,8.9090048,"/1/logo-header.png","Costa Ihr Handwerker","Frauenfeld","gl-real-estate-icon",54245],[47.0249906,8.28676563102941,"/53409/Foto.jpg","Ercolani GmbH, Gipser-/Malerhandwerk","Kriens","gl-real-estate-icon",53409],[47.51368415,8.52768737455796,"/1/logo-header.png","Mustafi hauswartung ","Bülach","gl-real-estate-icon",54244],[46.9549705,7.4270629,"/1/logo-header.png","Stefan Stocker Malerei","bern","gl-real-estate-icon",54243],[47.1871481,7.379127002962964,"/1/logo-header.png","","Grenchen","gl-real-estate-icon",54242],[47.49136735,8.711495997502956,"/1/logo-header.png","ÖKO-LIFE KLG","Zürich ","gl-real-estate-icon",54241],[47.3976252,8.44117126457316,"/54240/avatar.jpg","Sozialdienst Limmattal, Arbeitsintegration","Schlieren","gl-real-estate-icon",54240],[47.146710350000006,8.232076846610951,"/1/logo-header.png","Reers","Hildisrieden ","gl-real-estate-icon",54239],[47.462287700000005,8.324761049999996,"/1/logo-header.png","KILLER HANDWERK","Wettingen","gl-real-estate-icon",54238],
sel_branche=0
sel_kanton=
sel_keyword=
sel_ort=
sel_sub_branche=0
sel_typ=
sessionid=Handwerk_8a05d40b-28e4-4235-8edc-bdfafac0d267_0
SESSSTARTTIME={ts '2026-04-06 03:50:27'}
sprache=de
STARTROW=241
strCustID=
THEMAID=Suche
timecreated={ts '2026-04-06 03:50:27'}
urltoken=CFID=8a05d40b-28e4-4235-8edc-bdfafac0d267&CFTOKEN=0
UserName=---
whitelisted=true

URL Variables:
404;http://test=Struct (1)
404;http://test.handwerk.ch:80/de/Suche/H/50698=
Debug Rendering Time: 0.00ms