Catch
additional
Struct
pattern
stringlistgetat(list:string, position:number, [delimiters:string, [includeEmptyFields:boolean]]):string
Detail
string
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringinvalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [4]
StackTrace
stringinvalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [4] at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:46):46 at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:40):40 at views.shop.product_inline_cfm$cf.call(/local/views/shop/product_inline.cfm:141):141 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:959):959 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:863):863 at webshop.framework.viewscope_cfc$cf.udfCall(/itools/webshop/framework/ViewScope.cfc:26):26 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:745):745 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1601):1601 at webshop.framework.viewscope_cfc$cf.udfCall(/itools/webshop/framework/ViewScope.cfc:21):21 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:745):745 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1601):1601 at webshop.framework.view_cfc$cf.udfCall2(/itools/webshop/framework/View.cfc:68):68 at webshop.framework.view_cfc$cf.udfCall(/itools/webshop/framework/View.cfc):-1 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:745):745 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1601):1601 at webshop.framework.site_cfc$cf.udfCall4(/itools/webshop/framework/Site.cfc:410):410 at webshop.framework.site_cfc$cf.udfCall(/itools/webshop/framework/Site.cfc):-1 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:745):745 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1601):1601 at butikk_cfm$cf.call(/butikk.cfm:25):25 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:959):959 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:863):863 at index_cfm$cf.call(/index.cfm:38):38 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:959):959 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:863):863 at application_cfc$cf.udfCall(/Application.cfc:126):126 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414 at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2276):2276 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2239):2239 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:460):460 at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219):219 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518):518 at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844):844 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668):668 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1527):1527 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1484):1484 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61 at java.lang.Thread.run(Thread.java:745):745
TagContext
Array
1
Struct
codePrintHTML
string139: &lt;select name=&quot;#field#&quot; class=&quot;product_inline_selectbox&quot; onChange=&quot;changeprice()&quot;&gt;<br> 140: &lt;cfloop from=&quot;1&quot; to=&quot;#listlen(values, '+')#&quot; index=&quot;st&quot;&gt;<br> <b>141: &lt;option pris=&quot;#listgetat(felt2,st,'+')#&quot; value=&quot;#HTMLEditFormat(listgetat(values,st, '+'))#&quot;&gt;#HTMLEditFormat(Trim(listgetat(values,st, '+')))#&lt;/option&gt;</b><br> 142: &lt;/cfloop&gt;<br> 143: &lt;/select&gt;<br>
codePrintPlain
string139: <select name="#field#" class="product_inline_selectbox" onChange="changeprice()"> 140: <cfloop from="1" to="#listlen(values, '+')#" index="st"> 141: <option pris="#listgetat(felt2,st,'+')#" value="#HTMLEditFormat(listgetat(values,st, '+'))#">#HTMLEditFormat(Trim(listgetat(values,st, '+')))#</option> 142: </cfloop> 143: </select>
column
number0
id
string??
line
number141
Raw_Trace
stringviews.shop.product_inline_cfm$cf.call(/local/views/shop/product_inline.cfm:141)
template
stringE:\www\www.helseshoppen.no\wwwroot\local\views\shop\product_inline.cfm
type
stringcfml
2
Struct
codePrintHTML
string24: <br> 25: &lt;cffunction name=&quot;_include&quot; returntype=&quot;void&quot;&gt;<br> <b>26: &lt;cfinclude template=&quot;#variables._view.getResolvedTemplate()#&quot;&gt;</b><br> 27: &lt;/cffunction&gt;<br> 28: <br>
codePrintPlain
string24: 25: <cffunction name="_include" returntype="void"> 26: <cfinclude template="#variables._view.getResolvedTemplate()#"> 27: </cffunction> 28:
column
number0
id
string??
line
number26
Raw_Trace
stringwebshop.framework.viewscope_cfc$cf.udfCall(/itools/webshop/framework/ViewScope.cfc:26)
template
stringE:\cfc\itools\webshop\framework\ViewScope.cfc
type
stringcfml
3
Struct
codePrintHTML
string19: &lt;cfset variables.site = arguments.view.getSite()&gt;<br> 20: &lt;cfset variables.modules = variables.site.getModules()&gt;<br> <b>21: &lt;cfsavecontent variable=&quot;content&quot;&gt;&lt;cfoutput&gt;#this._include()#&lt;/cfoutput&gt;&lt;/cfsavecontent&gt;</b><br> 22: &lt;cfreturn content&gt;<br> 23: &lt;/cffunction&gt;<br>
codePrintPlain
string19: <cfset variables.site = arguments.view.getSite()> 20: <cfset variables.modules = variables.site.getModules()> 21: <cfsavecontent variable="content"><cfoutput>#this._include()#</cfoutput></cfsavecontent> 22: <cfreturn content> 23: </cffunction>
column
number0
id
string??
line
number21
Raw_Trace
stringwebshop.framework.viewscope_cfc$cf.udfCall(/itools/webshop/framework/ViewScope.cfc:21)
template
stringE:\cfc\itools\webshop\framework\ViewScope.cfc
type
stringcfml
4
Struct
codePrintHTML
string66: &lt;cfset var rendered = &quot;&quot;&gt;<br> 67: &lt;cfset var viewScope = variables.site.getFactory().create(&quot;framework.ViewScope&quot;)&gt;<br> <b>68: &lt;cfset rendered = viewScope._render(this)&gt;</b><br> 69: &lt;cfreturn rendered&gt;<br> 70: &lt;/cffunction&gt;<br>
codePrintPlain
string66: <cfset var rendered = ""> 67: <cfset var viewScope = variables.site.getFactory().create("framework.ViewScope")> 68: <cfset rendered = viewScope._render(this)> 69: <cfreturn rendered> 70: </cffunction>
column
number0
id
string??
line
number68
Raw_Trace
stringwebshop.framework.view_cfc$cf.udfCall2(/itools/webshop/framework/View.cfc:68)
template
stringE:\cfc\itools\webshop\framework\View.cfc
type
stringcfml
5
Struct
codePrintHTML
string408: <br> 409: &lt;cfset getDebugger().startGroup(&quot;View&quot;, view.getTemplate())&gt;<br> <b>410: &lt;cfoutput&gt;#view.render()#&lt;/cfoutput&gt;</b><br> 411: &lt;cfset getDebugger().endGroup(&quot;View&quot;)&gt;<br> 412: <br>
codePrintPlain
string408: 409: <cfset getDebugger().startGroup("View", view.getTemplate())> 410: <cfoutput>#view.render()#</cfoutput> 411: <cfset getDebugger().endGroup("View")> 412:
column
number0
id
string??
line
number410
Raw_Trace
stringwebshop.framework.site_cfc$cf.udfCall4(/itools/webshop/framework/Site.cfc:410)
template
stringE:\cfc\itools\webshop\framework\Site.cfc
type
stringcfml
6
Struct
codePrintHTML
string23: &lt;cfset request.site.handleRequest(url.a)&gt;<br> 24: &lt;cfelse&gt;<br> <b>25: &lt;cfset request.site.handleRequest(&quot;shop/&quot; &amp; url.a)&gt;</b><br> 26: &lt;/cfif&gt; <br> 27: <br>
codePrintPlain
string23: <cfset request.site.handleRequest(url.a)> 24: <cfelse> 25: <cfset request.site.handleRequest("shop/" & url.a)> 26: </cfif> 27:
column
number0
id
string??
line
number25
Raw_Trace
stringbutikk_cfm$cf.call(/butikk.cfm:25)
template
stringE:\www\www.helseshoppen.no\wwwroot\butikk.cfm
type
stringcfml
7
Struct
codePrintHTML
string36: &lt;cfelse&gt;<br> 37: &lt;cfsavecontent variable=&quot;hoved&quot;&gt;<br> <b>38: &lt;cfinclude template=&quot;#Trim(path.template)#&quot;&gt;</b><br> 39: &lt;/cfsavecontent&gt;<br> 40: &lt;/cfif&gt;<br>
codePrintPlain
string36: <cfelse> 37: <cfsavecontent variable="hoved"> 38: <cfinclude template="#Trim(path.template)#"> 39: </cfsavecontent> 40: </cfif>
column
number0
id
string??
line
number38
Raw_Trace
stringindex_cfm$cf.call(/index.cfm:38)
template
stringE:\www\www.helseshoppen.no\wwwroot\index.cfm
type
stringcfml
8
Struct
codePrintHTML
string124: &lt;cfinclude template=&quot;html_newsletter_Helseshoppen.cfm&quot;&gt; <br> 125: &lt;cfelse&gt;<br> <b>126: &lt;cfinclude template=&quot;index.cfm&quot;&gt;</b><br> 127: &lt;/cfif&gt; <br> 128: <br>
codePrintPlain
string124: <cfinclude template="html_newsletter_Helseshoppen.cfm"> 125: <cfelse> 126: <cfinclude template="index.cfm"> 127: </cfif> 128:
column
number0
id
string??
line
number126
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:126)
template
stringE:\www\www.helseshoppen.no\wwwroot\application.cfc
type
stringcfml
type
stringexpression
Form:
Scope
Url:
Scope
a
stringproduct_inline
b_id
string99374
b_kid
string820691
tmpl
stringbutikk
Session:
Session Scope (Memory)
__DEBUGGER
Struct
REQUESTINDEX
number1
REQUESTS
Array
1
Struct
__TYPE
stringlog
ITEMS
Array
Rows: 17
1
Struct
__TYPE
stringproperties
PROPERTIES
Struct
form
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
session
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
cfid
stringeae2fd94-cf88-4579-bd5c-a25e549ee707
cftoken
string0
DEV
booleanfalse
lastvisit
Date Time (Europe/Berlin)
{ts '2019-03-19 21:48:31'}
sessionid
stringHelseshoppen.no11_eae2fd94-cf88-4579-bd5c-a25e549ee707_0
timecreated
Date Time (Europe/Berlin)
{ts '2019-03-19 21:48:31'}
urltoken
stringCFID=eae2fd94-cf88-4579-bd5c-a25e549ee707&CFTOKEN=0
url
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
a
stringproduct_inline
b_id
string99374
b_kid
string820691
tmpl
stringbutikk
2
Struct
__TYPE
stringstartgroup
DESCRIPTION
string
NAME
stringAction
3
Struct
__TYPE
stringproperties
PROPERTIES
Struct
action
stringproduct_inline
module
stringshop
4
Struct
__TYPE
stringstartgroup
DESCRIPTION
string - beforeActionHook
NAME
stringHook
5
Struct
__TYPE
stringproperties
PROPERTIES
Struct
implementors
Array
scope_before
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
ACTION
stringproduct_inline
MODULE
stringshop
6
Struct
__TYPE
stringendgroup
NAME
stringHook
TIME
number0
7
Struct
__TYPE
stringproperties
PROPERTIES
Struct
actions
Struct
__recursion
booleanfalse
__type
stringcomponent
functions
Array
1
Struct
args
Array
1
Struct
name
stringtext
type
stringany
name
stringconfirmEmailPadding
2
Struct
args
Array
1
Struct
name
stringview
type
stringany
name
stringvlist
3
Struct
args
Array
1
Struct
name
stringview
type
stringany
name
stringorderitem
4
Struct
args
Array
1
Struct
name
stringview
type
stringany
name
stringcheckout2
5
Struct
args
Array
1
Struct
name
stringview
type
stringany
2
Struct
name
stringconfig
type
stringany
3
Struct
name
stringordre_id
type
stringany
4
Struct
name
stringqOrder
type
stringany
name
stringsendConfirmationAndSayThanks
6
Struct
args
Array
1
Struct
name
stringview
type
stringany
2
Struct
name
stringconfig
type
stringany
3
Struct
name
stringordre_id
type
stringany
4
Struct
name
stringqOrder
type
stringany
name
stringsendConfirmationAndSayThanksVerify
hint
string
name
stringlocal.modules.shop.Actions
path
stringE:\www\www.helseshoppen.no\wwwroot\local\modules\shop\actions.cfc
method
stringproduct_inline
8
Struct
__TYPE
stringstartgroup
DESCRIPTION
string - productTabsHook
NAME
stringHook
9
Struct
__TYPE
stringproperties
PROPERTIES
Struct
implementors
Array
1
stringreviews
scope_before
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
TABS
Array
10
Struct
__TYPE
stringproperties
PROPERTIES
Struct
scope_after
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
TABS
Array
1
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
BLOCK
stringreviews/productTab
ID
stringreviews
TITLE
stringAnmeldelser
11
Struct
__TYPE
stringendgroup
NAME
stringHook
TIME
number0
12
Struct
__TYPE
stringstartgroup
DESCRIPTION
string - afterActionHook
NAME
stringHook
13
Struct
__TYPE
stringproperties
PROPERTIES
Struct
implementors
Array
scope_before
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
VIEW
Struct
__recursion
booleanfalse
__type
stringcomponent
functions
Array
Rows: 15
1
Struct
args
Array
name
stringinit
2
Struct
args
Array
1
Struct
name
stringsite
type
stringAny
name
stringsetSite
3
Struct
args
Array
name
stringgetSite
4
Struct
args
Array
1
Struct
name
stringactionScope
type
stringAny
name
stringsetActionScope
5
Struct
args
Array
name
stringgetActionScope
6
Struct
args
Array
1
Struct
name
stringtemplate
type
stringstring
name
stringsetTemplate
7
Struct
args
Array
name
stringgetTemplate
8
Struct
args
Array
name
stringgetResolvedTemplate
9
Struct
args
Array
1
Struct
name
stringlayout
type
stringAny
name
stringsetLayout
10
Struct
args
Array
name
stringhasLayout
11
Struct
args
Array
name
stringgetLayout
12
Struct
args
Array
1
Struct
name
stringmodule
type
stringstring
name
stringgetHelper
13
Struct
args
Array
name
stringrender
14
Struct
args
Array
1
Struct
name
stringregion
type
stringstring
name
stringrenderRegion
15
Struct
args
Array
1
Struct
name
stringpath
type
stringstring
2
Struct
name
stringoptions
type
stringStruct
name
stringrenderBlock
hint
string
name
stringitools.webshop.framework.View
path
stringE:\cfc\itools\webshop\framework\View.cfc
14
Struct
__TYPE
stringendgroup
NAME
stringHook
TIME
number0
15
Struct
__TYPE
stringproperties
PROPERTIES
Struct
view_template
string/local/views/shop/product_inline.cfm
view_variables
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
Entries: 11
CONFIG
Struct
__recursion
booleanfalse
__type
stringcomponent
functions
Array
Rows: 39
1
Struct
args
Array
name
stringbootstrap
2
Struct
args
Array
name
stringgetFreightHandler
3
Struct
args
Array
name
stringgetDataSource
4
Struct
args
Array
name
stringgetURLPrefix
5
Struct
args
Array
name
stringgetCustomerID
6
Struct
args
Array
name
stringgetReviewMail
7
Struct
args
Array
name
stringgetProductMail
8
Struct
args
Array
name
stringgetSelectFields
9
Struct
args
Array
name
stringgetPaymentMethods
10
Struct
args
Array
name
stringgetBasketText
11
Struct
args
Array
name
stringgetAbbId
12
Struct
args
Array
name
stringgetMerchant
13
Struct
args
Array
name
stringgetDibsCodeUno
14
Struct
args
Array
name
stringgetDibsCodeDos
15
Struct
args
Array
name
stringgetHasPrivateOrderNr
16
Struct
args
Array
name
stringgetPopupPrefix
17
Struct
args
Array
name
stringgetPopupOptions
18
Struct
args
Array
name
stringhasShop
19
Struct
args
Array
name
stringGetExtraImages
20
Struct
args
Array
name
stringitemnoTitle
21
Struct
args
Array
name
stringgetCloseWindowImage
22
Struct
args
Array
name
stringsplitPriceAndBasket
23
Struct
args
Array
name
stringlistSortOrder
24
Struct
args
Array
name
stringgetInventoryField
25
Struct
args
Array
name
stringgetInventoryDecrement
26
Struct
args
Array
1
Struct
name
strings
type
stringany
name
stringgetInventoryText
27
Struct
args
Array
name
stringviewProductInline
28
Struct
args
Array
name
stringgetDefaultCategoryTemplate
29
Struct
args
Array
name
stringgetRequiredFields
30
Struct
args
Array
1
Struct
name
stringi
type
stringany
name
stringgetRequiredMessage
31
Struct
args
Array
name
stringgetPriceExtra
32
Struct
args
Array
1
Struct
name
stringbasket
type
stringany
2
Struct
name
stringbetaling
type
stringany
name
stringgetExtraItems
33
Struct
args
Array
name
stringsendConfirmEmailToCustomer
34
Struct
args
Array
name
stringconfirmEmailSubject
35
Struct
args
Array
name
stringconfirmEmailPart1
36
Struct
args
Array
name
stringconfirmEmailPart2
37
Struct
args
Array
name
stringTrackECommerce
38
Struct
args
Array
name
stringEcommerceTransactioncode
39
Struct
args
Array
1
Struct
name
stringordre_id
type
stringany
2
Struct
name
stringquery
type
stringany
3
Struct
name
stringtransactioncode
type
stringany
4
Struct
name
stringdiscountamount
type
stringany
name
stringgetEcommercescript
hint
string
name
stringlocal.Config
path
stringE:\www\www.helseshoppen.no\wwwroot\local\Config.cfc
FIELDSMETA
Struct
__TYPE
stringquery
COLUMNS
Array
1
stringKUNDEID
2
stringFELT
3
stringTITTEL
4
stringNAVN
5
stringSORTERING
6
stringTYPE
7
stringDATA1
8
stringDATA2
9
stringVIS_ORDRE
QUERY
Query
Template: E:\cfc\itools\webshop\modules\shop\Model.cfc
Execution Time: 1.44 ms
Record Count: 7
Cached: No
Lazy: No
SQL:
select * from butikk_metadata_felt
where kundeid = 397
order by sortering
 kundeidfelttittelnavnsorteringtypedata1data2vis_ordre
13971Enheterkapsler11502500
23972Pris pr enhetbokspris21502500
33973Produkt merkeprodmerke31502500
43974Produkt typeprodtype41502500
53975Størrelsestorrelse51502501
63976Fargefarge61502501
73977Enhetenhet71502500
PRODUCTFEEDBACK
booleantrue
PRODUCTTABS
Array
1
Struct
__recursion
booleanfalse
__type
stringstruct
struct
Struct
BLOCK
stringreviews/productTab
ID
stringreviews
TITLE
stringAnmeldelser
qimages
Struct
__TYPE
stringquery
COLUMNS
Array
1
stringFILNAVN
2
stringHFILNAVN
QUERY
Query
Template: E:\cfc\itools\webshop\modules\shop\Model.cfc
Execution Time: 2.87 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
select filnavn,hfilnavn
from butikk_produktbilde
where butikk_kategori_fk=99374
order by rank
 filnavnhfilnavn
qKategori
Struct
__TYPE
stringquery
COLUMNS
Array
1
stringTITTEL
2
stringBRODTEKST
3
stringPARENT_ID
4
stringBUTIKK_KATEGORI_ID
5
stringMAL
6
stringKATEGORI_BILDE
7
stringKATEGORIBESKRIVELSE
QUERY
Query
Template: E:\cfc\itools\webshop\modules\shop\Model.cfc
Execution Time: 1.26 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT tittel,brodtekst,parent_id,butikk_kategori_id,mal,kategori_bilde,kategoribeskrivelse
FROM butikk_kategori k
WHERE k.kundeid = 397
AND butikk_kategori_id = 820691
AND type=1
 tittelbrodtekstparent_idbutikk_kategori_idmalkategori_bildekategoribeskrivelse
1Tilbud0820691list
qProduct
Struct
__TYPE
stringquery
COLUMNS
Array
Rows: 79
1
stringBUTIKK_KATEGORI_ID
2
stringKUNDEID
3
stringPARENT_ID
4
stringTYPE
5
stringTITTEL
6
stringBRODTEKST
7
stringMAL
8
stringKATEGORI_BILDE
9
stringSORTERING
10
stringREGDATE
11
stringTMP_KUNDE_CATEGORY_ID
12
stringKATEGORIBESKRIVELSE
13
stringTMP_KUNDE_VARENR
14
stringKNETT
15
stringTITTEL_ENGELSK
16
stringKAT_LISTE
17
stringVARENR_FOR_IMPORT
18
stringKATEGORI_FIL
19
stringPATH
20
stringLVL
21
stringMETADATA_DESCRIPTION
22
stringMETADATA_KEYWORDS
23
stringKATEGORI_PRIORITET
24
stringSMARTLINK
25
stringLASTCHANGEDDATE
26
stringSMARTLINK_EXTRA1
27
stringKFRADATO
28
stringKTILDATO
29
stringBUTIKK_KATEGORI_FK
30
stringVARENR
31
stringBESKRIVELSE
32
stringBESKRIVELSE2
33
stringKORT_BESKRIVELSE
34
stringPRIS
35
stringPRIS2
36
stringBILDE
37
stringFIL
38
stringFELT1
39
stringFELT2
40
stringFELT3
41
stringFELT4
42
stringFELT5
43
stringFRADATO
44
stringTILDATO
45
stringNETT
46
stringPRIORITET
47
stringFELT6
48
stringFELT7
49
stringFORSIDE_PRIORITET
50
stringFOKUS
51
stringMOMS
52
stringVEKT_FOR_PORTO
53
stringFIL2
54
stringFK_FRAKTKATEGORI
55
stringLAGER_ANTALL
56
stringLAGER_DATO
57
stringVOLUM
58
stringLENGTH
59
stringWIDTH
60
stringHEIGHT
61
stringTMP_KUNDEID
62
stringFELT8
63
stringFELT9
64
stringFELT10
65
stringHBILDE
66
stringTAX
67
stringPROD_SORTERING
68
stringBARE_PRIVATKUNDER
69
stringFELT11
70
stringPRICE_TYPE
71
stringBILDE2
72
stringBILDE3
73
stringBILDE4
74
stringBILDE5
75
stringNYSTED_SEIROM
76
stringISVARIANT
77
stringCAT_TITTEL
78
stringLEV_TITTEL
79
stringLEVERANDOR_ID
QUERY
Query
Template: E:\www\www.helseshoppen.no\wwwroot\local\modules\shop\Model.cfc
Execution Time: 1.84 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT k.*, p.* ,cat.tittel as cat_tittel, bl.title as lev_tittel, bl.id as leverandor_id
FROM butikk_kategori k
JOIN butikk_produkt p ON k.butikk_kategori_id = p.butikk_kategori_fk
JOIN butikk_kategori cat ON cat.butikk_kategori_id=k.parent_id
LEFT JOIN butikk_produkt_rel_leverandor br ON k.butikk_kategori_id=br.fk_produkt_id
LEFT JOIN butikk_leverandor bl ON bl.id=br.fk_leverandor_id
WHERE k.kundeid = 397
AND k.butikk_kategori_id = 99374
AND (fradato <= {d '2019-03-19'} OR fradato IS NULL)
AND (tildato >= {d '2019-03-19'} OR tildato IS NULL)
AND nett=1
AND k.type=0
 butikk_kategori_idkundeidparent_idtypetittelbrodtekstmalkategori_bildesorteringregdatetmp_kunde_category_idkategoribeskrivelsetmp_kunde_varenrknetttittel_engelskkat_listevarenr_for_importkategori_filpathlvlmetadata_descriptionmetadata_keywordskategori_prioritetsmartlinklastChangedDatesmartlink_extra1kfradatoktildatobutikk_kategori_fkvarenrbeskrivelsebeskrivelse2kort_beskrivelseprispris2bildefilfelt1felt2felt3felt4felt5fradatotildatonettprioritetfelt6felt7forside_prioritetfokusmomsvekt_for_portofil2fk_fraktkategorilager_antalllager_datovolumlengthwidthheighttmp_kundeIdfelt8felt9felt10hbildetaxprod_sorteringbare_privatkunderfelt11price_typebilde2bilde3bilde4bilde5nysted_seiromisVariantcat_tittellev_tittelleverandor_id
1993743979210Vogel Echinaforce - solhatt ekstrakt37{ts '2005-12-01 10:33:28'}1694,921,99374,30{ts '2019-03-06 07:02:17'}99374100966+21981+21278<p><span style="font-family: 'times new roman'; font-size: medium;">Forkj&oslash;lelse er den hyppigst forekommende av alle sykdommer. En slik infeksjon i de &oslash;vre luftveiene fremkalles hovedsakelig av virus, men kan ogs&aring; skyldes bakterier eller samspill mellom virus og bakterier. Konvensjonell behandling av forkj&oslash;lelse er oftest rettet mot ren symptomlindring. I mange tilfeller er "behandlingen&ldquo; ogs&aring; uten effekt, som ved antibiotikabruk (antibiotika er som kjent bare virksom ved bakterielle infeksjoner).&nbsp;</span></p> <p><span style="font-family: 'times new roman'; font-size: medium;">Mange opplever forkj&oslash;lelsessymptomene ogs&aring; om v&aring;ren og sommeren, og det er i disse tider ekstra viktig &aring; ta vare p&aring; immunforsvaret. A.Vogel Echinaforce solhatt tinktur inneholder Echinacea ekstrakter, og er vel s&aring; mye utviklet til &aring; forebygge forkj&oslash;lelsessymtomer som til akutt behandling.</span></p> <p><span style="font-family: 'times new roman'; font-size: medium;">Echinaforce er det originale solhattproduktet fra A.Vogel, og er et av markedets best dokumenterte solhattprodukter. Den har v&aelig;rt p&aring; markedet i over 50 &aring;r, og selges i over 20 land.&nbsp;</span></p> <p><span style="font-family: 'times new roman'; font-size: medium;">I l&oslash;pet av de senere &aring;rene har naturmidler med immunaktiverende virkning blitt stadig mer popul&aelig;re. Flere vitenskapelige studier viser at slike produkter, f&oslash;rst og fremst solhattpreparater, har god effekt.&nbsp;En metaanalyse utf&oslash;rt av Boforce AG og Prof. Johnston (Imperial College of London) viste at risikoen for &aring; f&aring; en forkj&oslash;lelse er 55% st&oslash;rre dersom man ikke brukte Echinacea forebyggende. Analysen viste ogs&aring; at forebyggende bruk av Ecinacea, reduserte antall forkj&oslash;lelser per &aring;r med 1-2 forkj&oslash;lelser (basert p&aring; at voksne i gjennomsnitt har 2-4 forkj&oslash;lelser per &aring;r).</span></p> <p><span style="font-family: 'times new roman'; font-size: medium;">Echinaforce&nbsp; Hot Drink er en velsmakende solhattoddy med &oslash;kologisk solhatt og svarthyll. Hjelper b&aring;de forebyggende og kurativt ved forkj&oslash;lelse.</span></p> <p><span style="font-family: 'times new roman'; font-size: medium;">Ved irritert hals, pr&oslash;v ogs&aring; Echinaforce halsspray.</span></p> <p><span style="font-family: 'times new roman'; font-size: medium;">Hele Echinaforce solhattserien fra A. Vogel har dokumentert effekt mot forkj&oslash;lelse og styrkker immunforsvaret.</span></p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p>Prøv Vogels solhatt når du er forkjølet. Den virker! Fåes både som enkel- og dobbelpakning samt som halsspray og hot drink.155ecinaforce.jpg50ml+50mlx2+halsspray+hot drink155,00+174,00+195,00A. VogelSolhatt10014org_ecinaforce.jpg01peritemImmunforsvaretA.VOGEL229
qProductsRelated
Struct
__TYPE
stringquery
COLUMNS
Array
Rows: 27
1
stringBUTIKK_KATEGORI_ID
2
stringTITTEL
3
stringVARENR
4
stringKORT_BESKRIVELSE
5
stringPRIS
6
stringPRIS2
7
stringLAGER_ANTALL
8
stringBILDE
9
stringBESKRIVELSE
10
stringBESKRIVELSE2
11
stringFELT1
12
stringFELT2
13
stringFELT3
14
stringFELT4
15
stringFELT5
16
stringFELT6
17
stringFELT7
18
stringFELT8
19
stringFELT9
20
stringFELT10
21
stringPARENT_ID
22
stringFIL
23
stringFIL2
24
stringHBILDE
25
stringTAX
26
stringPRICE_TYPE
27
stringSMARTLINK
QUERY
Query
Template: E:\cfc\itools\webshop\modules\shop\Model.cfc
Execution Time: 1.14 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
SELECT top 5 butikk_kategori_id,tittel,varenr,kort_beskrivelse,pris,pris2,lager_antall,bilde,beskrivelse,beskrivelse2,felt1,felt2,felt3,felt4,felt5,felt6,felt7,felt8,felt9,felt10,parent_id,fil,fil2,hbilde,tax,price_type,smartlink
FROM butikk_kategori k JOIN butikk_produkt p ON butikk_kategori_id = butikk_kategori_fk
WHERE k.kundeid = 397
AND butikk_kategori_id in (
select butikk_produkt_fk
from butikk_produkt_produkt
where butikk_produkt_fk_parent=99374
and firmakunde_fk=397)
AND (fradato <= {d '2019-03-19'} OR fradato IS NULL)
AND (tildato >= {d '2019-03-19'} OR tildato IS NULL)
AND nett=1
AND type=0
 butikk_kategori_idtittelvarenrkort_beskrivelseprispris2lager_antallbildebeskrivelsebeskrivelse2felt1felt2felt3felt4felt5felt6felt7felt8felt9felt10parent_idfilfil2hbildetaxprice_typesmartlink
qProdukter
Struct
__TYPE
stringquery
COLUMNS
Array
Rows: 78
1
stringBUTIKK_KATEGORI_ID
2
stringKUNDEID
3
stringPARENT_ID
4
stringTYPE
5
stringTITTEL
6
stringBRODTEKST
7
stringMAL
8
stringKATEGORI_BILDE
9
stringSORTERING
10
stringREGDATE
11
stringTMP_KUNDE_CATEGORY_ID
12
stringKATEGORIBESKRIVELSE
13
stringTMP_KUNDE_VARENR
14
stringKNETT
15
stringTITTEL_ENGELSK
16
stringKAT_LISTE
17
stringVARENR_FOR_IMPORT
18
stringKATEGORI_FIL
19
stringPATH
20
stringLVL
21
stringMETADATA_DESCRIPTION
22
stringMETADATA_KEYWORDS
23
stringKATEGORI_PRIORITET
24
stringSMARTLINK
25
stringLASTCHANGEDDATE
26
stringSMARTLINK_EXTRA1
27
stringKFRADATO
28
stringKTILDATO
29
stringBUTIKK_KATEGORI_FK
30
stringVARENR
31
stringBESKRIVELSE
32
stringBESKRIVELSE2
33
stringKORT_BESKRIVELSE
34
stringPRIS
35
stringPRIS2
36
stringBILDE
37
stringFIL
38
stringFELT1
39
stringFELT2
40
stringFELT3
41
stringFELT4
42
stringFELT5
43
stringFRADATO
44
stringTILDATO
45
stringNETT
46
stringPRIORITET
47
stringFELT6
48
stringFELT7
49
stringFORSIDE_PRIORITET
50
stringFOKUS
51
stringMOMS
52
stringVEKT_FOR_PORTO
53
stringFIL2
54
stringFK_FRAKTKATEGORI
55
stringLAGER_ANTALL
56
stringLAGER_DATO
57
stringVOLUM
58
stringLENGTH
59
stringWIDTH
60
stringHEIGHT
61
stringTMP_KUNDEID
62
stringFELT8
63
stringFELT9
64
stringFELT10
65
stringHBILDE
66
stringTAX
67
stringPROD_SORTERING
68
stringBARE_PRIVATKUNDER
69
stringFELT11
70
stringPRICE_TYPE
71
stringBILDE2
72
stringBILDE3
73
stringBILDE4
74
stringBILDE5
75
stringNYSTED_SEIROM
76
stringISVARIANT
77
stringCAT_TITTEL
78
stringLEV_TITTEL
QUERY
Query
Template: E:\www\www.helseshoppen.no\wwwroot\local\modules\shop\Model.cfc
Execution Time: 5.21 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT k.*,p.*, beskrivelse, cat.tittel as cat_tittel, bl.title as lev_tittel
FROM butikk_kategori k JOIN butikk_produkt p ON k.butikk_kategori_id = p.butikk_kategori_fk
JOIN butikk_kategori cat ON cat.butikk_kategori_id=k.parent_id
LEFT JOIN butikk_produkt_rel_leverandor br ON k.butikk_kategori_id=br.fk_produkt_id
LEFT JOIN butikk_leverandor bl ON bl.id=br.fk_leverandor_id
WHERE k.kundeid = 397
AND (k.parent_id = 820691
OR EXISTS (SELECT * FROM butikk_kategori_rel_kategori WHERE fk_parent_butikk_kategori = 820691
AND fk_child_butikk_kategori = k.butikk_kategori_id))
AND (fradato <= {d '2019-03-19'} OR fradato IS NULL)
AND (tildato >= {d '2019-03-19'} OR tildato IS NULL)
AND nett=1
AND k.type=0
ORDER BY sortering
 butikk_kategori_idkundeidparent_idtypetittelbrodtekstmalkategori_bildesorteringregdatetmp_kunde_category_idkategoribeskrivelsetmp_kunde_varenrknetttittel_engelskkat_listevarenr_for_importkategori_filpathlvlmetadata_descriptionmetadata_keywordskategori_prioritetsmartlinklastChangedDatesmartlink_extra1kfradatoktildatobutikk_kategori_fkvarenrbeskrivelsebeskrivelse2kort_beskrivelseprispris2bildefilfelt1felt2felt3felt4felt5fradatotildatonettprioritetfelt6felt7forside_prioritetfokusmomsvekt_for_portofil2fk_fraktkategorilager_antalllager_datovolumlengthwidthheighttmp_kundeIdfelt8felt9felt10hbildetaxprod_sorteringbare_privatkunderfelt11price_typebilde2bilde3bilde4bilde5nysted_seiromisVariantcat_tittellev_tittel
16318923978520FEMARELLE - BEDRE OVERGANG UTEN ØSTROGEN. FAST LAVPRIS OG SPESIALTILBUD V/KJØP AV 3 STK2{ts '2010-01-19 18:49:52'}1694,852,631892,30{ts '2018-08-21 20:20:40'}63189222365<p><strong>Fra 2000 har Femarelle gitt effektiv hjelp til kvinner i Norge som ikke vil, eller kan, bruke &oslash;strogenmedisin i overgangsalderen. Femarelle er markedsleder i mange land, ogs&aring;&nbsp;i Norge.</strong></p> <p>Dokumentert effekt og dokumentert trygt i bruk.<br /><br />Det er dokumentert at&nbsp;<strong>Femarelle</strong> styrker benbygningen, kan trygt brukes i forhold til blodpropp, p&aring;virker ikke blodets hormonprofil og har ingen virkning p&aring; brystvev eller livmorvev.<br /><br />Selve kapselen er fremstilt av cellulose ("Vegicaps").<br />Hver eske innholder 56 kapsler, nok til en m&aring;neds forbruk ved normaldosering. Virkningen er stabil over tid n&aring;r du fortsetter med <strong>Femarelle</strong>.<strong>&nbsp;Femarelle</strong> er et vegetabilsk kosttilskudd - inneholder ikke hormoner.<br /><br />Fyto&oslash;strogenet i <strong>Femarelle</strong>&reg; utvinnes i en naturlig enzymprosess uten bruk av kunstige tilsetnings- eller hjelpestoffer. Soyab&oslash;nnene som brukes i prosessen er ikke genmodifiserte.<br /><br /><strong>Indikasjoner<br /></strong>Ved symptomer p&aring; menopause s&aring; som hetetokter, t&oslash;rrhet i skjeden, lettere hodepine, s&oslash;vnforstyrrelser og annet.<br /><br /><strong>Dosering<br /></strong>2 kapsler daglig etter m&aring;ltider.<br />Virkning: Plagene avhjelpes normalt fra behandlingens annen uke.<br />Anbefales brukt s&aring; lenge symptomene p&aring; overgangsalder vedvarer.<br />Ingen kjente, u&oslash;nskede virkninger ved langtidsbruk</p>Vær bevisst hva du bruker. Det er du som bestemmer. Femarelle demper overgangsplager og styrker skjelettet ditt. Et rent kosttilskudd uten kjente bivirkninger. På tilbud! Spar kr.350,- på veil. butikkpris v/kjøp av 3 mndrs. forbruk. Fritt tilsendt!745Femarelle - 3 stk.1.jpg56 kpsl. x 3+56kpsl745,00+299,00FemarelleOvergangsalder11014org_Femarelle - 3 stk.1.jpg01peritemOvergangsalderARCON NORWAY
TIPAFRIEND
booleanfalse
TXT
Struct
__recursion
booleanfalse
__type
stringcomponent
functions
Array
hint
string
name
stringitools.webshop.modules.shop.cfc.lang_no
path
stringE:\cfc\itools\webshop\modules\shop\cfc\lang_no.cfc
16
Struct
__TYPE
stringendgroup
NAME
stringAction
TIME
number18
17
Struct
__TYPE
stringstartgroup
DESCRIPTION
string - shop/product_inline
NAME
stringView
2
Empty:null
3
Empty:null
4
Empty:null
5
Empty:null
6
Empty:null
7
Empty:null
8
Empty:null
9
Empty:null
10
Empty:null
cfid
stringeae2fd94-cf88-4579-bd5c-a25e549ee707
cftoken
string0
DEV
booleanfalse
lastvisit
Date Time (Europe/Berlin)
{ts '2019-03-19 21:48:31'}
sessionid
stringHelseshoppen.no11_eae2fd94-cf88-4579-bd5c-a25e549ee707_0
timecreated
Date Time (Europe/Berlin)
{ts '2019-03-19 21:48:31'}
urltoken
stringCFID=eae2fd94-cf88-4579-bd5c-a25e549ee707&CFTOKEN=0
Cgi:
CGI Scope (writable)
Entries: 68
auth_password
string
auth_type
string
auth_user
string
cert_cookie
string
cert_flags
string
cert_issuer
string
cert_keysize
string256
cert_secretkeysize
string2048
cert_serialnumber
string
cert_server_issuer
stringC=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
cert_server_subject
stringCN=www.helseshoppen.no
cert_subject
string
cf_template_path
stringE:\www\www.helseshoppen.no\wwwroot\index.cfm
content_length
string0
content_type
string
context_path
string
gateway_interface
stringCGI/1.1
http_accept
stringtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding
stringgzip
http_accept_language
string
http_appl_physical_path
stringe:\www\www.helseshoppen.no\wwwroot\
http_cert_keysize
string256
http_cert_secretkeysize
string2048
http_cert_server_issuer
stringC=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
http_cert_server_subject
stringCN=www.helseshoppen.no
http_connection
stringKeep-Alive
http_content_length
string0
http_cookie
string
http_gateway_interface
stringCGI/1.1
http_host
stringwww.helseshoppen.no
http_https
stringon
http_https_keysize
string256
http_https_server_issuer
stringC=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
http_https_server_subject
stringCN=www.helseshoppen.no
http_If_Modified_Since
stringThu, 17 Jan 2019 23:02:45 GMT
http_local_addr
string77.241.100.189
http_path_info
string/index.cfm
http_referer
string
http_remote_port
string46086
http_script_name
string/index.cfm
http_server_port
string443
http_server_port_secure
string1
http_user_agent
stringCCBot/2.0 (https://commoncrawl.org/faq/)
http_x_tomcat_docroot
stringe:\www\www.helseshoppen.no\wwwroot\
http_x_webserver_context
stringW3SVC17
http_xajp_path_info
string
https
stringon
https_keysize
string256
https_secretkeysize
string
https_server_issuer
stringC=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
https_server_subject
stringCN=www.helseshoppen.no
local_addr
string77.241.100.189
local_host
stringCHALDENE
path_info
string/index.cfm
path_translated
stringE:\www\www.helseshoppen.no\wwwroot\index.cfm
query_string
stringtmpl=butikk&a=product_inline&b_kid=820691&b_id=99374
remote_addr
string3.91.79.74
remote_host
string3.91.79.74
remote_user
string
request_method
stringGET
request_url
stringhttps://www.helseshoppen.no/index.cfm?tmpl=butikk&a=product_inline&b_kid=820691&b_id=99374
script_name
string/index.cfm
server_name
stringwww.helseshoppen.no
server_port
string443
server_port_secure
string1
server_protocol
stringHTTP/1.1
server_software
string
web_server_api
string