Contact Schrupp Excavating

Mailing Address:

Schrupp Excavating LLC
P.O. Box 49
Pine River, MN 56474

Physical Address:

1529 36th Ave. SW
Backus, MN 56435

Phone Number:
(218) 587-4038

Please complete the form below to request more information from Schrupp Excavating.
* Required field

First Name:

Last Name:

Email Address:

Company Name:

Address 1:

Address 2:

City:

State:

Postal Code:

Phone:

Fax:

Comments:

Word Verification:

TESTIMONIALS

It has been our pleasure to work with Schrupp Excavating on construction projects for the past 12 years. We have developed a great working relationship with Ray and Wendy Schrupp and their employees. Their quick response to calls and questions is surpassed only by their service and ability to get the job done right and on time. Schrupp Excavating always has the right machine with talented operators for any job. We would recommend Schrupp Excavating for any job, large or small, without reservation. They are simply one of the best.

Baratto Brothers Construction, Inc.

So happy with your Class 5 and having the black dirt moved into the garden. He did a great job. Thanks for your advice. Next time, I'll know who to call! And you came so quickly!!!! Appreciate it.

Pat O'Connell

Debugging Information

ColdFusion Server Standard	2018,0,13,329786
Template	/index.cfm
Time Stamp	24-Sep-22 07:00 PM
Locale	English (US)
User Agent	Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote IP	24.111.43.158
Host Name	24.111.43.158

Execution Time

Total Time	Avg Time	Count	Template
94 ms	94 ms	1	C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\index.cfm
62 ms	62 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfm
62 ms	62 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/website.cfm
47 ms	47 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/contact.cfm
31 ms	31 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runapp.cfm
31 ms	31 ms	1	C:/inetpub/wwwroot/partners/seriouslyfunmarketing.com/schruppexcavating.com/Application.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/rundetectSQLinjection.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runscroll.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runslideshow.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/scroll.cfm
15 ms	15 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/fw_bootstrap3/_inc_contact_form_bootstrap3.cfm
15 ms	8 ms	2	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runjQueryValidate.cfm
15 ms	15 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/webapp.cfm
15 ms	15 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getSiteURLs(bIncludeDocuments = false, stSession = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
15 ms	15 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| RCInitSite(domain = schruppexcavating.com, bForceReload = true) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/content.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/fw_bootstrap3/_inc_captcha_form_bootstrap3.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runBootstrap3.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcaptcha.cfm
0 ms	0 ms	4	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runjQuery.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runmain.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runmetatags.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runnavulli.cfm
0 ms	0 ms	9	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runscriptinclude.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runstats.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runtextlinks.cfm
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| CustomURLsToULLI(argumentcollection = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?about-us) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?contact-us) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?home) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?links-numbers) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?services) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotURL(pageid = 13, spidersafe = 1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| parseRunSpotSpiderSafeURL() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc \| NavTreeAddAttributes(argumentcollection = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc \| NavTreeToULLI_render(arrNavTreeWithAttributes = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc \| doVPVGroupsExist(1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc \| doVPVGroupsExist(WebsiteID = 1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc \| doVPVTablesExist(dsn_override = schruppexcavating.com, WebsiteID = 1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcCommonDBPageTypes.cfc \| SelectByPK(PageTypeID = 1, dsn_override = common) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcCommonDBPageTypes.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcCommonDBPageTypes.cfc \| SelectByPK(PageTypeID = 5, dsn_override = common) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcCommonDBPageTypes.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBPages.cfc \| SelectByPK(13, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBPages.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBPages.cfc \| SelectByPK(PageID = 13) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBPages.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc \| SelectByPK(5, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc \| getCOLUMNSCOLUMNTYPESstruct() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUserData.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUserData.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUserInterests.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUserInterests.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUserSignUp.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUserSignUp.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUsers.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBUsers.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBWebsites.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBWebsites.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBWebsites.cfc \| SelectByPK(1, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBWebsites.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc \| isSpider() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsConfigDB.cfc \| GetConfigGroupStruct(vcGroup = SystemSetup1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsConfigDB.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsConfigDB.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsConfigDB.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsEMail.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsEMail.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsList.cfc \| ListRemoveDupes(list = Pine River,Backus,Hackensack,Akeley,Park Rapids,Walker,Longville,Pequot Lakes,Outing,Fifty Lakes,Emily,Crosslake,Cross lake,Nisswa,Staples,Crosby,Emily,Excavating,Schrupp Excavating,septic systems,sewer systems,rock,gravel,demolition,black dirt,sand,fill,dirt,driveways,clearing,brushing,grading,sewer,septic,excavating pequot lakes,excavating crosslake,excavating nisswa,septic pequot lakes,septic pine river,septic crosslake) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsList.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsSQLInjectionDetect.cfc \| SQLInjectionDetected() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsSQLInjectionDetect.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsString.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsString.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsString.cfc \| getRandomString(bIncludeAlphaUpper = false, bIncludeAlphaLower = true, nStringLen = 5, bIncludeNumbers = true) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsString.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsStruct.cfc \| structRemoveEmptyKeys(structure = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsStruct.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsTCPIP.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsTCPIP.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsTCPIP.cfc \| IPv4ToUInt32(vcIPv4 = 24.111.43.158) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsTCPIP.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsURL.cfc \| SanitizeXSSQS(vcQS = ) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsURL.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsURL.cfc \| isXSS(vcContent = ) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsURL.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| SelectMediaByTypeIDIDValue(15, 5, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| SelectMediaByTypeIDIDValue(dsn_override = schruppexcavating.com, MediaTypeID = 23, IDValue = 2) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| TableColumnExists(vcColumnName = Target, dsn_override = schruppexcavating.com, vcTableName = Pages) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| cleanUpMetaKeywords(meta_keywords = Pine River, Backus, Hackensack, Akeley, Park Rapids, Walker, Longville, Pequot Lakes, Outing, Fifty Lakes, Emily, Crosslake, Cross lake, Nisswa, Staples, Crosby, Emily, Excavating, Schrupp Excavating, septic systems, sewer systems, rock, gravel, demolition, black dirt, sand, fill, dirt, driveways, clearing, brushing, grading, sewer, septic, excavating pequot lakes, excavating crosslake, excavating nisswa, septic pequot lakes, septic pine river, septic crosslake) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| getCountries() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| getStates() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| init() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| isProductsMeta_KeywordsDefined(dsn_override = schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
125 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

local.qryGetWebSiteByDomain (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT * FROM websites WHERE domain = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = schruppexcavating.com

local.qryTableColumnExist (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ? AND COLUMN_NAME = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = AdminNav

			    
			        Parameter #2(CF_SQL_VARCHAR) = WebsiteID

local.qryEcommerceTools (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT TOP 1
	AN.WebsiteID, AN.CustomTool, AN.CommonTool, AN.AdminNavID,
	MG.M_GroupID, GroupName = MG.Name,
	MT.M_ToolID, ToolName = MT.Name, MT.TagName, MT.OrderBy
FROM
	AdminNav AN
	JOIN common.dbo.M_Tools MT ON AN.M_ToolID = MT.M_ToolID
	JOIN common.dbo.M_Groups MG ON MT.M_GroupID = MG.M_GroupID
WHERE
	AN.WebsiteID = 1
	AND AN.commontool = 1
	AND MG.M_GroupID = 4

local.qryConfigSGroupByGroup (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\jcsConfigDB.cfc @ 19:00:51.051

SELECT
	[nConfigID], [vcGroup], [vcKey], [vcValue]
FROM
	[Config]
WHERE
	[vcGroup] = ?
ORDER BY
	[vcKey]

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = SystemSetup1

getpreset (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

				select pageid from pages where pagepresetid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = contact-us

verifycart (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

			select count(*) as total from [orders] where ordernum=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = 0

local.qryVPVPageGroups (Datasource=schruppexcavating.com, Time=15ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSNav.cfc @ 19:00:51.051

SELECT
	pg.*
FROM
	VPVPageGroup pg
	JOIN VPVGroup g ON pg.nVPVGroupID = g.nVPVGroupID
WHERE
	g.WebsiteID = ?
ORDER BY
	pg.PageID, pg.nVPVGroupID

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

local.qryTableColumnExist (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ? AND COLUMN_NAME = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = Pages

			    
			        Parameter #2(CF_SQL_VARCHAR) = Target

local.qryGetAllURLs (Datasource=schruppexcavating.com, Time=0ms, Records=5) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSNav.cfc @ 19:00:51.051

SELECT
	p.PageID, p.[Name], p.PagePresetID, p.OrderBy, p.location
	,COALESCE(p.target, '_self') AS target, p.secure
	,p.PageDisplay, p.MenuDisplay, p.[meta_descrip], p.PageNonLinkable
	,COALESCE(po.PageID, 0) AS ParentID, COALESCE(po.OrderBy, 0) AS ChildOrderBy
	,(SELECT TOP 1 m.filename FROM media m WHERE m.mediatypeid = 2 AND m.idvalue = p.PageID) AS ImageFilename
	,(SELECT COUNT(*) FROM pageorder po1 WHERE po1.pageid = p.PageID AND po1.childid IN (SELECT DISTINCT p1.pageid FROM pages p1 WHERE p1.menudisplay=1 AND p1.pagedisplay=1)) AS childtotal
FROM
	pages p LEFT JOIN pageorder po ON p.PageID = po.ChildID
WHERE
	p.websiteid = ?
	AND COALESCE(p.[name],'') <> ''
ORDER BY
	COALESCE(po.PageID, 0) DESC,
	CASE
		WHEN COALESCE(po.PageID, 0) = 0 THEN p.OrderBy
		ELSE COALESCE(po.OrderBy, 0)
	END DESC

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

qryGetOrderedURLs (Datasource=, Time=0ms, Records=5) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSNav.cfc @ 19:00:51.051

SELECT
	*
FROM
	[local].qryGetAllURLs
ORDER BY
	Ancestry

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBPages.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Pages]
WHERE
	[PageID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 13

getpagemeta (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runmetatags.cfm @ 19:00:51.051

select pageid,meta_title,meta_descrip,meta_keywords from pages where

pageid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 13

getproductmeta (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runmetatags.cfm @ 19:00:51.051

SELECT
	CAST(p.Meta_Keywords AS VARCHAR(MAX)) AS Meta_Keywords
FROM
	Products p
WHERE
	COALESCE(CAST(p.Meta_Keywords AS VARCHAR(MAX)), '''') <> ''''
	AND p.ProductID IN (SELECT idvaluetext FROM pageproducts WHERE idtype=2 AND (pageid=? OR pageid IN (SELECT pageid FROM pages WHERE websiteid=? AND mainpage=1)))
UNION
SELECT
	CAST(p.Meta_Keywords AS VARCHAR(MAX)) AS Meta_Keywords
FROM
	Products p
WHERE
	COALESCE(CAST(p.Meta_Keywords AS VARCHAR(MAX)), '''') <> ''''
	AND p.FamilyID IN (SELECT idvalue FROM pageproducts WHERE idtype=1 AND (pageid=? OR pageid IN (SELECT pageid FROM pages WHERE websiteid=? AND mainpage=1)))

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 13

			    
			        Parameter #2(CF_SQL_INTEGER) = 1

			    
			        Parameter #3(CF_SQL_INTEGER) = 13

			    
			        Parameter #4(CF_SQL_INTEGER) = 1

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBWebsites.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Websites]
WHERE
	[WebsiteID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

qryGALogin (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runstats.cfm @ 19:00:51.051

SELECT TOP 1 * FROM stats ORDER BY StatID

qrySlideShow (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runslideshow.cfm @ 19:00:51.051

SELECT TOP 1 * FROM [SlideShow] WHERE [name] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = slides-banner

qrySlideShowItem (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runslideshow.cfm @ 19:00:51.051

SELECT
	ssi.*
FROM
	SlideShowItem AS ssi LEFT JOIN SlideShowPage AS ssp ON ssi.nSlideShowItemID = ssp.nSlideShowItemID
WHERE
	ssi.nSlideShowID = ?
	AND (ssp.PageID IS NULL OR ssp.PageID = ?)
ORDER BY
	ssi.orderby ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 13

local.qryMediaByTypeIDIDValue (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT
	*
FROM
	[media]
WHERE
	[MediaTypeID] = ?
	AND [IDValue] = ?
ORDER BY
	[OrderBy], [MediaID]

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 23

			    
			        Parameter #2(CF_SQL_INTEGER) = 2

local.qryVPVGroupsExist (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSVPV.cfc @ 19:00:51.051

SELECT
	1
FROM
	[VPVGroup]
WHERE
	[WebsiteID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

local.qryVPVGroupsExist (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSVPV.cfc @ 19:00:51.051

SELECT
	1
FROM
	[VPVGroup]
WHERE
	[WebsiteID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBPages.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Pages]
WHERE
	[PageID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 13

getsections (Datasource=schruppexcavating.com, Time=0ms, Records=2) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\website.cfm @ 19:00:51.051

select
  *
from
  pagedisplay
where
  pageid=?
order by
  orderby

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 13

local.qrySelectByPK (Datasource=common, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcCommonDBPageTypes.cfc @ 19:00:51.051

SELECT
	*
FROM
	[PageTypes]
WHERE
	[PageTypeID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

chkcustom (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\website.cfm @ 19:00:51.051

					select * from websiteoptions where websiteid=? and pagetypeid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 1

getitem (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\content.cfm @ 19:00:51.051

select
  body
from 
  pagetext 
where
  websiteid = ?
  and pageid = ?
  and pagedisplayid = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 13

			    
			        Parameter #3(CF_SQL_INTEGER) = 0

local.qrySelectByPK (Datasource=common, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcCommonDBPageTypes.cfc @ 19:00:51.051

SELECT
	*
FROM
	[PageTypes]
WHERE
	[PageTypeID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5

chkcustom (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\website.cfm @ 19:00:51.051

					select * from websiteoptions where websiteid=? and pagetypeid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 5

getCountryByIP (Datasource=ip2location, Time=32ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\contact.cfm @ 19:00:51.051

SELECT *
FROM IPCountry
WHERE
	IP_FROM <= ?
	AND ? <= IP_TO

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_DECIMAL) = 409938846

			    
			        Parameter #2(CF_SQL_DECIMAL) = 409938846

getform (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\contact.cfm @ 19:00:51.051

select formid from contactforms where pageid = ? and pagedisplayid = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 13

			    
			        Parameter #2(CF_SQL_INTEGER) = 0

getitem (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\contact.cfm @ 19:00:51.051

select * from contactforms where formid = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

getfields (Datasource=schruppexcavating.com, Time=0ms, Records=12) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\contact.cfm @ 19:00:51.051

select * from contactfields where formid = ? order by orderby,fieldtype asc,label

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

local.qryStates (Datasource=common, Time=0ms, Records=57) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT
	*
FROM
	[States]
ORDER BY
	[Abrv]

local.qryCountries (Datasource=common, Time=0ms, Records=212) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Countries]
ORDER BY
	[Name]

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBPages.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Pages]
WHERE
	[PageID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 13

local.qqLT (Datasource=, Time=0ms, Records=31) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\jcsURL.cfc @ 19:00:51.051

SELECT * FROM [local].qryLT ORDER BY ltEncLen DESC

local.qryStates (Datasource=common, Time=0ms, Records=57) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT
	*
FROM
	[States]
ORDER BY
	[Abrv]

qryScroll (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\scroll.cfm @ 19:00:52.052

select * from scroll
where
	websiteid = ? 
	AND name = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_VARCHAR) = testimonials

chk (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\scroll.cfm @ 19:00:52.052

		select count(*) as total from scrollitems where scrollid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

getnums (Datasource=schruppexcavating.com, Time=0ms, Records=9) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\scroll.cfm @ 19:00:52.052

					select scrollitemid from scrollitems where scrollid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBScrollItems.cfc @ 19:00:52.052

SELECT
	*
FROM
	[ScrollItems]
WHERE
	[ScrollItemID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5

local.qryMediaByTypeIDIDValue (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:52.052

SELECT
	*
FROM
	[media]
WHERE
	[MediaTypeID] = ?
	AND [IDValue] = ?
ORDER BY
	[OrderBy], [MediaID]

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 15

			    
			        Parameter #2(CF_SQL_INTEGER) = 5

gettl (Datasource=schruppexcavating.com, Time=0ms, Records=5) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runtextlinks.cfm @ 19:00:52.052

SELECT pageid,[name],location,target,PagePresetID FROM pages 
WHERE NOT pageid IN (SELECT childid FROM pageorder) AND menudisplay=1 AND pagedisplay=1
ORDER BY orderby

Scope Variables

Application Variables:
abspath=/
address1=3003 - 36th Street SW
address2=
applicationname=schruppexcavating.com
arrsiteurls=Array (5)
baseurl=index.cfm
bdebug=true
bgcolor=FFFFFF
bmobileuseragent=false
bpagenonlinkabledefined=Yes
bproductsmeta_keywordsdefined=Yes
brunshop=false
bvpvtablesexist=Yes
cachedwithin=0.00694444444444
cart_fontcolor=000000
cart_hicolor=DDDDDD
cart_lowcolor=EEEEEE
cartpath=http://schruppexcavating.com/cart
cc=
cgi_domain=schruppexcavating.com
checkoutsecure=https://runspot.biz/partners/seriouslyfunmarketing.com/schruppexcavating.com/secure/
city=Pine River
companyname=Schrupp Excavating, LLC
contentwidth=760
country=United States
debuggingipaddresses=Array (2)
domain=schruppexcavating.com
dsn=schruppexcavating.com
dtcreatednav={ts '2022-09-20 22:14:25'}
email=contact@schruppexcavating.com
fax=
fontcolor=000000
fontface=Arial
fontsize=2
hicolor=
iconpath=https://runspot.biz/!admin/soeditor/
imagedisplay=/media/content/
imagepath=/partners/seriouslyfunmarketing.com/schruppexcavating.com/media/content/
imageupload=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\media\content\
imagewrite=http://schruppexcavating.com/media/content/
lowcolor=EEEEEE
lstdebugips=10.10.1.158,24.111.43.158
maindsn=schruppexcavating.com
media=media
mediafilepath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\media
mediaurl=http://schruppexcavating.com/media
meta_descrip=Excavating, Septic System, Demolition
meta_keywords=Pine River,Backus,Hackensack,Akeley,Park Rapids,Walker,Longville,Pequot Lakes,Outing,Fifty Lakes,Emily,Crosslake,Cross lake,Nisswa,Staples,Crosby,Excavating,Schrupp Excavating,septic systems,sewer systems,rock,gravel,demolition,black dirt,sand,fill,dirt,driveways,clearing,brushing,grading,sewer,septic,excavating pequot lakes,excavating crosslake,excavating nisswa,septic pequot lakes,septic pine river,septic crosslake
midcolor=DDDDDD
phone=218-587-4038
productpath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\media\products
producturl=http://schruppexcavating.com/media/products
reloadfilepath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\admin\reload
rootfilepath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\
scriptpath=/!admin/soeditor/
secureabspath=/partners/seriouslyfunmarketing.com/schruppexcavating.com/
sfontsize=1
shipaddress=
shipcity=
shippingbypercent=0
shippingid=1
shipstate=
shipzip=
showpriceid=0
siteframework=Bootstrap 3.x
spchurl=http://schruppexcavating.com
spidersafe=1
state=MN
tollfree=
url=http://schruppexcavating.com
urlssl=https://runspot.biz
webpalette=
websiteid=1
zip=56474

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=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\index.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,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=en, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=16120770; $Path=/; CFTOKEN=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7; $Path=/
HTTP_HOST=schruppexcavating.com
HTTP_REFERER=http://schruppexcavating.com/
HTTP_URL=/index.cfm/contact-us
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=64.73.214.25
PATH_INFO=/contact-us
PATH_TRANSLATED=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\index.cfm
QUERY_STRING=
REMOTE_ADDR=24.111.43.158
REMOTE_HOST=24.111.43.158
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=schruppexcavating.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Cookie Variables:
CFID=16120770
CFTOKEN=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7

Form Fields:
formpass=
srcCountryCode=US

Request Parameters:
additional_methods_min=true
blogwebpages=true
bootstrap_min_js=true
bootstrapcssurlpath=/css/bootstrap/
bootstrapthemecssurl_inc=true
bootstrapthemefn=bootstrap.min.css
bootstrapversion=3.3.7
bspider=false
dsnconfig=schruppexcavating.com
dsnrunspot=schruppexcavating.com
jquery_cycle_all=true
jquery_form=true
jquery_validate_min=true
jqueryincluded=true
jqueryuiincluded=false
lstdebugips=10.10.1.158,24.111.43.158
samesite_value=
server_name=https://runspot.biz
server_name_no_protocol=//runspot.biz
stjqmigratescriptattribs=Struct (15)
stjqscriptattribs=Struct (79)
stsession=Struct (74)
useragent=mozilla/4.5 (compatible; httrack 3.0x; windows 98)

Session Variables:
adminlevel=none
adminlogin=notcool
arrsiteurls=Array (5)
cfid=16120770
cftoken=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7
formpass2=202292444
lastform2={ts '2022-09-24 17:59:51'}
loginname=
mainpage=0
orderid=0
ordernum=0
page_title=Contact Us
pageid=13
scrollitemid=0
sessionid=SCHRUPPEXCAVATING.COM_16120770_87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7
t_pageid=0
t_websiteid=0
toolpageid=0
totalcart=0
totalqty=0
urltoken=CFID=16120770&CFTOKEN=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7
userid=0
userlogin=notcool
websiteid=0
welcome=

URL Parameters:
PageID=13
preset=contact-us

Debug Rendering Time: 16 ms