Offene Stellen

Zur Ergänzung unseres Teams haben wir folgende Stellen offen.
  • Lernende Strassenbauer EFZ, 3 Jährige Grundbildung
  • Lernende Strassenbauer EFZ, 2 Jährige Zweitausbildung

BEWERBUNGSUNTERLAGEN

Bitte senden Sie Ihre vollständigen Bewerbungsunterlagen an „untenstehende" Adresse oder per Mail an info@hrbauag.ch


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 07:26 PM
Locale German (Swiss)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 18.194.150.228
Host Name 18.194.150.228


Execution Time

Total Time Avg Time Count Template
135 ms 135 ms 1 top level D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
124 ms 124 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
93 ms 93 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
60 ms 30 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
57 ms 29 ms 2 D:/Web/dynasite_codebase/output/_dsinclude.cfm
54 ms 27 ms 2 D:/Web/Web-Aktiv10/hrbauag/project/_default.cfm
28 ms 14 ms 2 D:/Web/dynasite_codebase/output/_dscommand.cfm
27 ms 27 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
24 ms 24 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
19 ms 10 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
11 ms 3 ms 4 D:/Web/dynasite_codebase/cached.cfm
9 ms 5 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
9 ms 9 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
8 ms 4 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
8 ms 8 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
7 ms 4 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(cimagepool_imagepool_imagepool_slide, 5270, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
6 ms 3 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
4 ms 2 ms 2 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
4 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(731C63B14B55F3B2DCAC18AE66ED2C86) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
4 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(E309F54BA001F4B33D79B9FA2B9F2CC8) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(519612, 9602, 9602, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
3 ms 2 ms 2 D:/Web/Web-Aktiv10/hrbauag/cimagepool/_imagepool_action.cfm
2 ms 2 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9602, 519612, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
2 ms 2 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 1,2,3,4,5,6, News.Row,News.Sorting, 9602, 519612, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
2 ms 2 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
1 ms 0 ms 5 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
1 ms 0 ms 5 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | init([complex value]) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
1 ms 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(dynasite9,9602,519612,0,global,dynasite,CV475friendly_path_info=/offene-stellen&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/hrbauag/dsinit.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/hrbauag/project/_init.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/output/_dslayout_footeroutside.cfm
0 ms 0 ms 5 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/memcachedfactory.cfc | getMemcached() ] from C:/ColdFusion9/CustomTags/memcached-v2/memcachedfactory.cfc
0 ms 0 ms 1 CFC[ D:/Web/application.cfc | onRequestEnd(/dynasite.cfm) ] from D:/Web/application.cfc
0 ms 0 ms 1 CFC[ D:/Web/application.cfc | onRequestStart(/dynasite.cfm) ] from D:/Web/application.cfc
0 ms 0 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSIsEditable(dsaid) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
0 ms 0 ms 2 D:/Web/Web-Aktiv10/hrbauag/cimagepool/_imagepool.cfm
0 ms 0 ms 2 D:/Web/Web-Aktiv10/hrbauag/project/_dsarticle_titletag.cfm
0 ms 0 ms 2 D:/Web/Web-Aktiv10/hrbauag/project/_script.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/customer/creanet/_dscustinit.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_app.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_array.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_article.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_asset.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_buttonbar.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_calendar.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_category.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_command.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_contact.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_content.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_content_article_form.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_content_explorer.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_contextmenu.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_date.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_designer.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_distributor.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_editor.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_finance.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_form.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_form_control.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_google_maps.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_gui_navigator.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_gui_tree.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_htmlbuilder.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_item.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_list.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_localisation.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_log.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_login.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_menu.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_message.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_note.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_number.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_orm.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_paging.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_popup.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_print.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_query.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_security.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_snippet.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_sql.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_tagging.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_util.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_various.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_view.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_xobject.cfm
9 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
144 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

19:26:04.004 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/hrbauag/cimagepool/_udf.cfm.
	    
19:26:04.004 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/hrbauag/cimagepool/_udf.cfm.
	    


SQL Queries

QSeo (Datasource=dynasite9_modules, Time=1ms, Records=0) in D:\Web\Web-Aktiv10\hrbauag\dsinit.cfc @ 19:26:04.004
	Select DsmidNeu, DsmidAlt FROM hrbauag_seo
	WHERE 1=2
	
		OR DsmidAlt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = offene-stellen

GetInclude (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 19:26:04.004
		SELECT Status, CFParam, CFSET, CacheThis, TemplateName FROM Includes 
		WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5934

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 19:26:04.004
	SELECT Placeholder, Content
	FROM hrbauag
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:26:04.004
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5270

QSlide (Datasource=dynasite9_modules, Time=1ms, Records=3) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 19:26:04.004
		SELECT
			imagepool.Label, imagepool.Bildname
		FROM
			hrbauag_imagepool AS imagepool
			INNER JOIN hrbauag_imagepool_bereich AS imagepool_bereich ON imagepool.ID = imagepool_bereich.ImagePoolID
		WHERE
			imagepool_bereich.Bereich = ?
		ORDER BY
			imagepool_bereich.Sort, newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519612

GetMenus (Datasource=dynasite9, Time=3ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:26:04.004
				SELECT 
					ID as ItemID, DSPMID as ParentItemID, ID, LFT, RGT, Language,
					CASE WHEN id=(select language_dsmid from Menus AS A where language_dsmid=Menus.id and language='global') THEN (select language from Menus AS B where language_dsmid=Menus.id and language='global') ELSE language END as reallang,
					id as langdsmid, Menutext, Menutext AS Name, MNHTML, DSRole, 
						LinkType, LinkDSSID,LinkDSMID, LinkDSPAID,LinkTarget, URLLInk,URLTarget,
						Schedule,PubDate,ExpDate,						
						DSFrames, Image, TempLive,AImage, OverImage, DSPMID, OnOver, OnOut, Live, Depth
						
						, Sort, Linked, OpenMenu, DSInclude, DSTname, DSDID, HTMLActive
						,DSJSFrameWork,JSFramework, Command, Command_Trigger, Command_Role, Command_Element, Command_URL, Command_XHR, Command_Icon, Taglist, DSTTIDList				
					
				FROM 
					Menus
				WHERE 
					Menus.DSSID=? 
						and Menus.Language = ? 
						AND (DSPMID IN ( SELECT ID FROM dbo.DSGetTreeMenuID (?,?)))
					
						AND (SCHEDULE=0 OR (SCHEDULE=1 AND (PubDate <= GetDate() AND ExpDate >= GetDate())))
									
				ORDER BY 
					Lft
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9602
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 9602
Parameter #4(cf_sql_integer) = 519612

DSGetArticles (Datasource=dynasite9, Time=1ms, Records=0) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:26:04.004
				SELECT 			
			Asset.Filename as Dateiname,Asset.Subfolder,Asset.Description as AssetImageDescription,Asset.Width as ImageWidth,Asset.Height as ImageHeight,
				 
				News.id as LangDSAID,
				News.Live,News.Prefix_Option,News.Prefix_Code,
				News.Date_Created,News.Date_Modified,News.Date_Custom,
				News.LastModify_Date,News.LastModify_Role,News_Content.Status,
				News.Taglist, News.DSTTIDList, 
				News_Content.MetaName as Title_Internal,News_Content.Teaser,News_Content.SSubject as Title,News_Content.ShortBody as Body,
				News_Content.Metaname,News_Content.Schedule,News_Content.SSubject,News_Content.ShortBody,
				News_Content.Linklist_XML,News_Content.BText,News_Content.ImageDescription,News_Content.BImageOver,
				News_Content.PubDate,News_Content.ExpDate,News_Content.BImage,
				News_Content.DSRID, News_Content.ImageProps, 
				News_Content.URLS, News_Content.URLS as URLLink, News_Content.URLTarget, News_Content.LinkProps, 
				News_Content.LinkType, News_Content.LinkDSSID, News_Content.LinkDSMID, News_Content.LinkDSPAID, News_Content.LinkTarget, 
				News_Content.CFPARAM,News_Content.CFSET,

				
				News.Des, News.Row, News.DSSID, News.Sorting, News.DSPAID, News.DSMID, News.NCID, News.HasRef, 
				News.id AS NewsID, News.Row AS Col, News.Des AS Design, News.ID, News.Numberation, News.Language,
				
				
					News.Language AS RealLang,
				
								
				News_Content.FieldType, News_Content.DSAID, News_Content.BStyle, News_Content.BAlign,
				News_Content.DSInclude, News_Content.DSTName, News_Content.DSACMDID , News_Content.DSIncludePos
				
				
					,Sites.DSCID
									
				
			FROM 
				News 
			INNER JOIN 
				News_Content ON News.NCID = News_Content.DSAID
								
			LEFT OUTER JOIN 
				Asset ON News_Content.DSRID = Asset.ID 
			LEFT OUTER JOIN 
				Menus ON News.DSMID = Menus.ID 
			
				INNER JOIN 
					Sites ON News.DSSID = Sites.ID
							
			WHERE 
				
					News.DSMID IN (?)
				
				
				and News.language = ? 
					AND News.Row = ? 
					AND News.DSPAID < 2
				
					
					AND News.Live = ? 
						AND (Menus.SCHEDULE=0 OR (Menus.SCHEDULE=1 AND (Menus.PubDate <= GetDate() AND Menus.ExpDate >= GetDate())))					
						AND (News_Content.SCHEDULE=0 OR (News_Content.SCHEDULE=1 AND (News_Content.PubDate <= GetDate() AND News_Content.ExpDate >= GetDate())))
					
				ORDER BY News.Row,News.Sorting 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519612
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) = 1

DSGetArticles (Datasource=dynasite9, Time=2ms, Records=2) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:26:04.004
				SELECT 			
			Asset.Filename as Dateiname,Asset.Subfolder,Asset.Description as AssetImageDescription,Asset.Width as ImageWidth,Asset.Height as ImageHeight,
				 
				News.id as LangDSAID,
				News.Live,News.Prefix_Option,News.Prefix_Code,
				News.Date_Created,News.Date_Modified,News.Date_Custom,
				News.LastModify_Date,News.LastModify_Role,News_Content.Status,
				News.Taglist, News.DSTTIDList, 
				News_Content.MetaName as Title_Internal,News_Content.Teaser,News_Content.SSubject as Title,News_Content.ShortBody as Body,
				News_Content.Metaname,News_Content.Schedule,News_Content.SSubject,News_Content.ShortBody,
				News_Content.Linklist_XML,News_Content.BText,News_Content.ImageDescription,News_Content.BImageOver,
				News_Content.PubDate,News_Content.ExpDate,News_Content.BImage,
				News_Content.DSRID, News_Content.ImageProps, 
				News_Content.URLS, News_Content.URLS as URLLink, News_Content.URLTarget, News_Content.LinkProps, 
				News_Content.LinkType, News_Content.LinkDSSID, News_Content.LinkDSMID, News_Content.LinkDSPAID, News_Content.LinkTarget, 
				News_Content.CFPARAM,News_Content.CFSET,

				
				News.Des, News.Row, News.DSSID, News.Sorting, News.DSPAID, News.DSMID, News.NCID, News.HasRef, 
				News.id AS NewsID, News.Row AS Col, News.Des AS Design, News.ID, News.Numberation, News.Language,
				
				
					News.Language AS RealLang,
				
								
				News_Content.FieldType, News_Content.DSAID, News_Content.BStyle, News_Content.BAlign,
				News_Content.DSInclude, News_Content.DSTName, News_Content.DSACMDID , News_Content.DSIncludePos
				
				
					,Sites.DSCID
									
				
			FROM 
				News 
			INNER JOIN 
				News_Content ON News.NCID = News_Content.DSAID
								
			LEFT OUTER JOIN 
				Asset ON News_Content.DSRID = Asset.ID 
			LEFT OUTER JOIN 
				Menus ON News.DSMID = Menus.ID 
			
				INNER JOIN 
					Sites ON News.DSSID = Sites.ID
							
			WHERE 
				
					News.DSMID IN (?)
				
				
				and News.language = ? 
					AND News.Row <> 0
				
					AND News.DSPAID < 2
				
					
					AND News.Live = ? 
						AND (Menus.SCHEDULE=0 OR (Menus.SCHEDULE=1 AND (Menus.PubDate <= GetDate() AND Menus.ExpDate >= GetDate())))					
						AND (News_Content.SCHEDULE=0 OR (News_Content.SCHEDULE=1 AND (News_Content.PubDate <= GetDate() AND News_Content.ExpDate >= GetDate())))
					
				ORDER BY News.Row,News.Sorting 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519612
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 1

getxmlColumnData (Datasource=dynasite9, Time=2ms, Records=0) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 19:26:04.004
				SELECT
					columnDefault.value('@row','integer') as XMLRow, columnDefault.query('.') as ArticleColumnXML
				FROM
					Menus
				CROSS APPLY
					XMLData.nodes('/DSXMLRoot/columndefaults/columndefault') as XMLTree(COLUMNDEFAULT)
				CROSS APPLY
					COLUMNDEFAULT.nodes('./date') as XMLDateTree(DATE)
				WHERE
					ID=? AND (COLUMNDEFAULT.value('@active','int')=1 or DATE.value('@position','varchar(127)')<>'0')
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519612

GetInclude (Datasource=dynasite9, Time=2ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 19:26:04.004
		SELECT Status, CFParam, CFSET, CacheThis, TemplateName FROM Includes 
		WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5935

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 19:26:04.004
	SELECT Placeholder, Content
	FROM hrbauag
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:26:04.004
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5270

QSlide (Datasource=dynasite9_modules, Time=2ms, Records=3) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 19:26:04.004
		SELECT
			imagepool.Label, imagepool.Bildname
		FROM
			hrbauag_imagepool AS imagepool
			INNER JOIN hrbauag_imagepool_bereich AS imagepool_bereich ON imagepool.ID = imagepool_bereich.ImagePoolID
		WHERE
			imagepool_bereich.Bereich = ?
		ORDER BY
			imagepool_bereich.Sort, newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519612


Stored Procedures

DSVariableInit2 (Datasource=dynasite9, Time=2ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 19:26:04.004

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  519612    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_VARCHAR  global    
 OUT  CF_SQL_INTEGER    URL.DSCID = URL.DSCID  
 OUT  CF_SQL_INTEGER    URL.DSSID = URL.DSSID  
 OUT  CF_SQL_INTEGER    URL.DSMID = URL.DSMID  
 OUT  CF_SQL_INTEGER    URL.DSPAID = URL.DSPAID  
 OUT  CF_SQL_VARCHAR    Request.DSSPCharset = Request.DSSPCharset  
 OUT  CF_SQL_INTEGER    Variables.SPCacheVersion = Variables.SPCacheVersion  
 OUT  CF_SQL_VARCHAR    Request.DSCLANG = Request.DSCLANG  
 OUT  CF_SQL_TINYINT    DSUnauthorized = DSUnauthorized  
 OUT  CF_SQL_TINYINT    Request.DSSecured = Request.DSSecured  
 OUT  CF_SQL_VARCHAR    Request.DSFURL = Request.DSFURL  
    
resultsets
nameresultset
DSInit2 (Datasource=dynasite9, Time=2ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 19:26:04.004
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  9602    
 IN  CF_SQL_INTEGER  519612    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_VARCHAR  global    
 OUT  CF_SQL_INTEGER    URL.DSCID = URL.DSCID  
 OUT  CF_SQL_INTEGER    URL.DSSID = URL.DSSID  
 OUT  CF_SQL_INTEGER    URL.DSMID = URL.DSMID  
 OUT  CF_SQL_INTEGER    URL.DSPAID = URL.DSPAID  
 OUT  CF_SQL_INTEGER    Request.DSDID = Request.DSDID  
 OUT  CF_SQL_BIT    Request.DSIsCSS = Request.DSIsCSS  
 OUT  CF_SQL_INTEGER    Request.DSDIDCV = Request.DSDIDCV  
    
resultsets
nameresultset
 GetDSCID  1
 GetDSSID  2
 GetDSMID  3
DSContent (Datasource=dynasite9, Time=2ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 19:26:04.004
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9602    
 IN  CF_SQL_Integer  519612    
 IN  CF_SQL_Integer  0    
 IN  CF_SQL_Integer  0    
 IN  CF_SQL_Integer  1    
 IN  CF_SQL_Integer  1    
 OUT  CF_SQL_VarChar    DSInitLinkType = DSInitLinkType  
 OUT  CF_SQL_Integer    DSInitLinkDSSID = DSInitLinkDSSID  
 OUT  CF_SQL_Integer    DSInitLinkDSMID = DSInitLinkDSMID  
 OUT  CF_SQL_Integer    DSInitLinkDSPAID = DSInitLinkDSPAID  
 OUT  CF_SQL_VarChar    DSURL = DSURL  
 OUT  CF_SQL_Integer    ColCount = ColCount  
 OUT  CF_SQL_Integer    MaxSpa = MaxSpa  
 OUT  CF_SQL_Integer    MaxCol = MaxCol  
    
resultsets
nameresultset
 GetSnippet  1


Scope Variables

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=D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.hrbauag.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/dynasite.cfm
PATH_TRANSLATED=D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
QUERY_STRING=friendly_path_info=/offene-stellen&
REMOTE_ADDR=18.194.150.228
REMOTE_HOST=18.194.150.228
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/dynasite.cfm
SERVER_NAME=www.hrbauag.ch
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Client Variables:
cfid=11620065
cftoken=14339706
hitcount=1
lastvisit={ts '2019-03-26 19:26:04'}
timecreated={ts '2019-03-26 19:26:04'}
urltoken=CFID=11620065&CFTOKEN=14339706
Cookie Variables:
CFID=11620065
CFTOKEN=14339706
Form Fields:
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11620065
cftoken=14339706
menuslist=514443,519612
sessionid=DYNASITE_CREANET_5270_11620065_14339706
urltoken=CFID=11620065&CFTOKEN=14339706
vmenuid=514443
URL Parameters:
friendly_path_info=/offene-stellen
Debug Rendering Time: 31 ms