Notice! Our Patient Parking Lot has Moved!

With the completion of the new Health and Biomedical Sciences Building II (HBSB), the University Eye Institute patient parking lot has relocated.
For information on where to park go to https://www.opt.uh.edu/parking

The Latest

From The University of Houston College of Optometry

UHCO Alumnus Named SECO International President

SECO International has announced that J. Max Ernst, OD, '86, will become the organization’s next President. Dr. Ernst will officially accept the honor during the House of Delegates meeting, held during SECO 2019 in New Orleans.
 

Read More


2019 TOA Honor UHCO Alumns

The Texas Optometric Association (TOA) is proud to announce the 2019 TOA Award Winners. Of the seven awards, four are UHCO alum. Congratulations to; Jenny Terrell Feenstra, OD, '03; Eric Ketchum, OD, '11; Matt Valdes, OD, '11; and Heidi Sticksel-Hawkins, OD, '98!

Read More


UHCO Faculty Featured in Review of Optometry

UHCO's Erin Tomiyama, OD, and Kathryn Richdale, OD, PhD, were recently featured in an article for Review of Optometry. Their article is titled, How Environment and Genetics Give Rise to Myopia. To read full piece click here.

Read More

View All News

Dean's Holiday Message

Quick Links

Applying to UHCO

Doctor of Optometry Program Admissions

Applications for admission from OptomCAS and the UHCO Supplemental Application will be accepted starting July 1st through March 30th prior to the fall semester in which the applicant expects to enter.

Learn More About Applying to UHCO

Debugging Information
ColdFusion Server Standard 11,0,13,303668
Template /index.cfm
Time Stamp 18-Feb-19 09:41 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.21.44.240
Host Name 172.21.44.240

Exceptions

21:41:18.018 - Expression Exception - in D:/UHCOcms/requirements/mura/backport/backport.cfm : line 12
	    Variable ESAPIENCODE is undefined.
21:41:20.020 - Expression Exception - in D:/UHCOcms/requirements/mura/settings/settingsManager.cfc : line 393
	    Element opt-uh-edu is undefined in a CFML structure referenced as part of an expression.

SQL Queries

rsCommands (Datasource=UHCOcms, Time=94ms, Records=0) in D:\UHCOcms\requirements\mura\cluster\clusterManager.cfc @ 21:41:18.018
		select * from tclustercommands where instanceID=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 1B5CFDB1-0B73-42BF-384C21FAF86A6FD2

find (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\Portcullis.cfc @ 21:41:18.018
			SELECT blocked 
			FROM variables.internal.iplog
			WHERE IP = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 172.21.44.240

rsSites (Datasource=UHCOcms, Time=78ms, Records=7) in D:\UHCOcms\requirements\mura\settings\settingsGateway.cfc @ 21:41:18.018
				SELECT * FROM tsettings ORDER BY 
				orderno asc
rs (Datasource=UHCOcms, Time=875ms, Records=0) in D:\UHCOcms\plugins\URLTools\eventHandler.cfc @ 21:41:19.019
			SELECT
				tcontent.contentID,
				tcontent.filename,
				(
					SELECT TOP 1
						a.attributeValue
					FROM
						tclassextenddata a
					INNER JOIN
						tclassextendattributes b ON a.attributeID = b.attributeID
					WHERE
						b.name = ?
					AND
						a.baseID = tclassextenddata.baseID
					
				) AS redirectType,
				(
					SELECT TOP 1
						a.attributeValue
					FROM
						tclassextenddata a
					INNER JOIN
						tclassextendattributes b ON a.attributeID = b.attributeID
					WHERE
						b.name = ?
					AND
						a.baseID = tclassextenddata.baseID
					
				) AS overwriteTag,
				(
					SELECT TOP 1
						a.attributeValue
					FROM
						tclassextenddata a
					INNER JOIN
						tclassextendattributes b ON a.attributeID = b.attributeID
					WHERE
						b.name = ?
					AND
						a.baseID = tclassextenddata.baseID
					 
				) AS overwriteCategory,
				tclassextenddata.attributeValue AS alternateURLList
			FROM
				tclassextenddata
			INNER JOIN
				tclassextendattributes ON tclassextenddata.attributeID = tclassextendattributes.attributeID
			INNER JOIN
				tcontent ON tclassextenddata.baseID = tcontent.contentHistID
			WHERE
				(
					tclassextenddata.attributeValue = ?
					OR
					tclassextenddata.attributeValue LIKE ?
					OR
					tclassextenddata.attributeValue LIKE ?
					OR
					tclassextenddata.attributeValue LIKE ?
				)
			AND
				tclassextendattributes.name = ?
			AND
				tcontent.active = 1
			AND
				tclassextenddata.siteID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = alternateURLRedirect
Parameter #2(cf_sql_varchar) = overwriteTag
Parameter #3(cf_sql_varchar) = overwriteCategory
Parameter #4(cf_sql_varchar) =
Parameter #5(cf_sql_varchar) = %
Parameter #6(cf_sql_varchar) = %
Parameter #7(cf_sql_varchar) = % %
Parameter #8(cf_sql_varchar) = alternateURL
Parameter #9(cf_sql_varchar) = UHCO

rsUser (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\user\userDAO.cfc @ 21:41:19.019
			select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName,tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.ContactForm, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt
			from tusers 
			left join tfiles on tusers.photoFileId=tfiles.fileid
			where tusers.userid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) =

rsExtended (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\extend\extendData.cfc @ 21:41:19.019
			select tclassextenddatauseractivity.baseid, tclassextendattributes.name, tclassextendattributes.type, tclassextendattributes.validation, 
			
				tclassextendattributes.label
			, 
			tclassextendattributes.attributeID,tclassextendattributes.defaultValue,tclassextendattributes.extendSetID,
			
			tclassextenddatauseractivity.attributeValue
			
			from tclassextenddatauseractivity with (nolock) 
			inner join tclassextendattributes with (nolock) On (tclassextenddatauseractivity.attributeID=tclassextendattributes.attributeID)
			where tclassextenddatauseractivity.baseID=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 266FA89B-085C-4772-16743E6577A6AA43

rsModulePerm (Datasource=UHCOcms, Time=0ms, Records=33) in D:\UHCOcms\requirements\mura\permission.cfc @ 21:41:19.019
			select tusers.groupname,isPublic from tusers INNER JOIN tpermissions ON (tusers.userid = tpermissions.groupid) where tpermissions.contentid=? and tpermissions.siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 00000000000000000000000000000000000
Parameter #2(cf_sql_varchar) = UHCO

rsFeeds (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:19.019
	select * from tcontentfeeds
	where siteID= ?
	and Type= ? 
	and isPublic=1
	
	and isactive=1
	
	order by name
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = Local

rsExtended (Datasource=UHCOcms, Time=0ms, Records=28) in D:\UHCOcms\requirements\mura\extend\extendData.cfc @ 21:41:19.019
			select tclassextenddata.baseid, tclassextendattributes.name, tclassextendattributes.type, tclassextendattributes.validation, 
			
				tclassextendattributes.label
			, 
			tclassextendattributes.attributeID,tclassextendattributes.defaultValue,tclassextendattributes.extendSetID,
			
			tclassextenddata.attributeValue
			
			from tclassextenddata with (nolock) 
			inner join tclassextendattributes with (nolock) On (tclassextenddata.attributeID=tclassextendattributes.attributeID)
			where tclassextenddata.baseID=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 365517EB-EF2E-AC89-BD7AE1670DF622EA

rsCombine (Datasource=UHCOcms, Time=0ms, Records=29) in D:\UHCOcms\requirements\mura\extend\extendData.cfc @ 21:41:19.019
			select baseID, name, type, validation, label, attributeID, defaultValue, extendSetID, attributeValue
			from rsExtended
			
			union all
			
			select '' baseID, attributename, type, validation, label, attributeID, defaultValue, extendSetID, '' attributeValue
			from rsDefinitions
			where siteID=?
			and (
				type=? 
					or type='Base'
				
				)
          	and (
                 
                  subtype=?
                 
				  or
                  
                 subtype='Default'
                  )
			
			and attributeID not in (554,625,626,627,628,629,630,631,633,634,635,636,637,638,639,640,646,681,682,683,684,698,699,1761,1762,1763,1764,1765)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = Page
Parameter #3(cf_sql_varchar) = PatientCare

rsExtended (Datasource=UHCOcms, Time=0ms, Records=28) in D:\UHCOcms\requirements\mura\extend\extendData.cfc @ 21:41:19.019
			select tclassextenddata.baseid, tclassextendattributes.name, tclassextendattributes.type, tclassextendattributes.validation, 
			
				tclassextendattributes.label
			, 
			tclassextendattributes.attributeID,tclassextendattributes.defaultValue,tclassextendattributes.extendSetID,
			
			tclassextenddata.attributeValue
			
			from tclassextenddata with (nolock) 
			inner join tclassextendattributes with (nolock) On (tclassextenddata.attributeID=tclassextendattributes.attributeID)
			where tclassextenddata.baseID=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 369A26CE-B831-BA0C-FED4A41A82B8FC8C

rsCombine (Datasource=UHCOcms, Time=0ms, Records=30) in D:\UHCOcms\requirements\mura\extend\extendData.cfc @ 21:41:19.019
			select baseID, name, type, validation, label, attributeID, defaultValue, extendSetID, attributeValue
			from rsExtended
			
			union all
			
			select '' baseID, attributename, type, validation, label, attributeID, defaultValue, extendSetID, '' attributeValue
			from rsDefinitions
			where siteID=?
			and (
				type=? 
					or type='Base'
				
				)
          	and (
                 
                  subtype=?
                 
				  or
                  
                 subtype='Default'
                  )
			
			and attributeID not in (554,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,646,680,698,1645,1646,1747,1761,1762,1763,1764,1765)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = Page
Parameter #3(cf_sql_varchar) = Neighborhood Clinics

rsContent (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\contentDAO.cfc @ 21:41:19.019
					select tcontent.Active,tcontent.Approved,tcontent.audience,tcontent.Body,tcontent.ContentHistID,
tcontent.ContentID,tcontent.Credits,tcontent.Display,tcontent.DisplayStart,tcontent.DisplayStop,tcontent.featureStart,
tcontent.featureStop,tcontent.FileID,tcontent.Filename,tcontent.forceSSL,tcontent.inheritObjects,tcontent.isFeature,
tcontent.IsLocked,tcontent.IsNav,tcontent.keyPoints,tcontent.lastUpdate,tcontent.lastUpdateBy,tcontent.lastUpdateByID,
tcontent.MenuTitle,tcontent.MetaDesc,tcontent.MetaKeyWords,tcontent.moduleAssign,tcontent.ModuleID,tcontent.nextN,
tcontent.Notes,tcontent.OrderNo,tcontent.ParentID,tcontent.displayTitle,tcontent.ReleaseDate,tcontent.RemoteID,
tcontent.RemotePubDate,tcontent.RemoteSource,tcontent.RemoteSourceURL,tcontent.RemoteURL,tcontent.responseChart,
tcontent.responseDisplayFields,tcontent.responseMessage,tcontent.responseSendTo,tcontent.Restricted,tcontent.RestrictGroups,
tcontent.searchExclude,tcontent.SiteID,tcontent.sortBy,tcontent.sortDirection,tcontent.Summary,tcontent.Target,
tcontent.TargetParams,tcontent.Template,tcontent.Title,tcontent.Type,tcontent.subType,tcontent.Path,tcontent.tags,
tcontent.doCache,tcontent.created,tcontent.urltitle,tcontent.htmltitle,tcontent.mobileExclude,tcontent.changesetID,
tcontent.imageSize,tcontent.imageHeight,tcontent.imageWidth,tcontent.childTemplate,tcontent.majorVersion,tcontent.minorVersion,tcontent.expires,tcontent.displayInterval
, tfiles.fileSize,
					tfiles.contentType, tfiles.contentSubType, tfiles.fileExt,tfiles.filename as assocFilename,
				tapprovalrequests.status as approvalStatus, tapprovalrequests.requestID,tapprovalrequests.groupid as approvalGroupID
					from tcontent 
					left join tfiles on (tcontent.fileid=tfiles.fileid)
					left join tapprovalrequests on (tcontent.contenthistid=tapprovalrequests.contenthistid)
					where tcontent.contentid=? 
			and tcontent.active = 1	
		
					and tcontent.siteid=?
					and type in ('Page','Folder','File','Calendar','Link','Gallery','Component','Form','Variation')
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 2E149259-76CD-43D9-AF9A308391980BB5
Parameter #2(cf_sql_varchar) = UHCO

rsExtended (Datasource=UHCOcms, Time=16ms, Records=0) in D:\UHCOcms\requirements\mura\extend\extendData.cfc @ 21:41:19.019
			select tclassextenddata.baseid, tclassextendattributes.name, tclassextendattributes.type, tclassextendattributes.validation, 
			
				tclassextendattributes.label
			, 
			tclassextendattributes.attributeID,tclassextendattributes.defaultValue,tclassextendattributes.extendSetID,
			
			tclassextenddata.attributeValue
			
			from tclassextenddata with (nolock) 
			inner join tclassextendattributes with (nolock) On (tclassextenddata.attributeID=tclassextendattributes.attributeID)
			where tclassextenddata.baseID=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 266FAF1E-A675-BEA4-7008294EE9E48AAA

rsCombine (Datasource=UHCOcms, Time=0ms, Records=7) in D:\UHCOcms\requirements\mura\extend\extendData.cfc @ 21:41:19.019
			select baseID, name, type, validation, label, attributeID, defaultValue, extendSetID, attributeValue
			from rsExtended
			
			union all
			
			select '' baseID, attributename, type, validation, label, attributeID, defaultValue, extendSetID, '' attributeValue
			from rsDefinitions
			where siteID=?
			and (
				type=? 
					or type='Base'
				
				)
          	and (
                 
                 subtype='Default'
                  )
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = Page

rs (Datasource=UHCOcms, Time=16ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = [Home] Features-fade
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 364E07DB-A37C-4525-8E0BC5A1AFDE0C39
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 364E07DB-A37C-4525-8E0BC5A1AFDE0C39
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=16ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 364E07DB-A37C-4525-8E0BC5A1AFDE0C39

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\extend\extendManager.cfc @ 21:41:19.019
				select validation from tclassextendattributes 
				where 
				
					siteID=?
					and name=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = random

rsFeed (Datasource=UHCOcms, Time=15ms, Records=4) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:19.019
			SELECT 
				top 20 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
					LEFT JOIN (
						SELECT 
							stringvalue extendedSort,
							tclassextenddata.baseID 
						FROM tclassextenddata with (nolock) 
							inner join tclassextendattributes with (nolock)
								on (tclassextenddata.attributeID=tclassextendattributes.attributeID)
						WHERE tclassextendattributes.siteid in (?)
							AND tclassextendattributes.name=?
					) qExtendedSort
						ON (tcontent.contenthistid=qExtendedSort.baseID)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.isNav = 1
				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				

				AND tcontent.type <>'Module'

				
				
					and tcontent.parentid in (
					?, 
					'')
					    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
						
						order by
						
						
							    		newID()
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = random
Parameter #3(cf_sql_varchar) = UHCO
Parameter #4(cf_sql_varchar) = 653C1482-5657-4576-837960F379B840AF
Parameter #5(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #6(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #7(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #8(cf_sql_timestamp) = 2019-02-18 21:41:00.0

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 5043A4AC-A1B3-0DEA-275DB45141B7B8AE

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 5043A4AC-A1B3-0DEA-275DB45141B7B8AE

rs (Datasource=UHCOcms, Time=16ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 5027D57B-D8EE-FEC4-CAD4A215B3511B1D

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 232C8891-C728-2729-27882BAB8CF6E440

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 23E821A5-F1E2-18E5-12486528CEE59BD1

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 2286E78C-B0F4-6FB4-F33F65ABFC30D331

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 228620D3-FC32-29F2-72A9B65F37BD9476

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = D29AD49D-09BB-AD19-00F7D504B94DD122

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\file\fileDAO.cfc @ 21:41:19.019
		SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 1E0FEC86-A170-155D-17849966C05E7933

rsObjects (Datasource=UHCOcms, Time=15ms, Records=0) in D:\UHCOcms\requirements\mura\content\contentGatewayAdobe.cfc @ 21:41:19.019
	select tcontentobjects.object,tcontentobjects.name,tcontentobjects.objectid, tcontentobjects.orderno, tcontentobjects.params, tplugindisplayobjects.configuratorInit from tcontentobjects 
	inner join tcontent On(
	tcontentobjects.contenthistid=tcontent.contenthistid
	and tcontentobjects.siteid=tcontent.siteid) 
	left join tplugindisplayobjects on (tcontentobjects.object='plugin' 
										and tcontentobjects.objectID=tplugindisplayobjects.objectID)
	where tcontent.siteid='UHCO' 
	and tcontent.contenthistid ='652F6363-BAF6-FF72-D368CFFC6AA42FB8'
	and tcontentobjects.columnid=4 
	order by tcontentobjects.orderno
rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = College News
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = E1699601-5DE1-4109-9F6B6F5C59DA3E83
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=16ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = E1699601-5DE1-4109-9F6B6F5C59DA3E83
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = E1699601-5DE1-4109-9F6B6F5C59DA3E83

rsFeed (Datasource=UHCOcms, Time=31ms, Records=3) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:19.019
			SELECT 
				top 3 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.isNav = 1
				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				 
					AND tcontent.searchExclude = 0
				

				AND tcontent.type <>'Module'

				
				
						AND tcontent.contenthistID in (
							select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign with (nolock)
							inner join tcontentcategories with (nolock)
							ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID) 
							where (
									tcontentcategories.path like ? )
						)
						    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
						
						order by
						
						
										tcontent.releaseDate desc
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = %40A99682-0A52-D6AF-1832764FA3116132%
Parameter #3(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #4(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #5(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #6(cf_sql_timestamp) = 2019-02-18 21:41:00.0

rsObjects (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\contentGatewayAdobe.cfc @ 21:41:19.019
	select tcontentobjects.object,tcontentobjects.name,tcontentobjects.objectid, tcontentobjects.orderno, tcontentobjects.params, tplugindisplayobjects.configuratorInit from tcontentobjects 
	inner join tcontent On(
	tcontentobjects.contenthistid=tcontent.contenthistid
	and tcontentobjects.siteid=tcontent.siteid) 
	left join tplugindisplayobjects on (tcontentobjects.object='plugin' 
										and tcontentobjects.objectID=tplugindisplayobjects.objectID)
	where tcontent.siteid='UHCO' 
	and tcontent.contenthistid ='652F6363-BAF6-FF72-D368CFFC6AA42FB8'
	and tcontentobjects.columnid=3 
	order by tcontentobjects.orderno
rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = [HOME] Quick Links
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 19EB6A0B-93D6-42F9-A436395AC51F19AC
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 19EB6A0B-93D6-42F9-A436395AC51F19AC
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:19.019
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 19EB6A0B-93D6-42F9-A436395AC51F19AC

rsFeed (Datasource=UHCOcms, Time=15ms, Records=17) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:19.019
			SELECT 
				top 20 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				 
					AND tcontent.searchExclude = 0
				

				AND tcontent.type <>'Module'

				
				
						AND tcontent.contenthistID in (
							select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign with (nolock)
							inner join tcontentcategories with (nolock)
							ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID) 
							where (
									tcontentcategories.path like ? )
						)
						    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
						
						order by
						
						
										tcontent.menuTitle asc
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = %4C4B72A1-87FF-4B93-9401893A0BAA318E%
Parameter #3(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #4(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #5(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #6(cf_sql_timestamp) = 2019-02-18 21:41:00.0

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = [SEMINARS] NextSeminar
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = C6C7B541-CEBB-E3C6-9976BBFF33196AAA
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = C6C7B541-CEBB-E3C6-9976BBFF33196AAA
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = C6C7B541-CEBB-E3C6-9976BBFF33196AAA

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\extend\extendManager.cfc @ 21:41:20.020
				select validation from tclassextendattributes 
				where 
				
					siteID=?
					and name=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = SeminarDate

rsFeed (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:20.020
			SELECT 
				top 1 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
					LEFT JOIN (
						SELECT 
							datetimevalue extendedSort,
							tclassextenddata.baseID 
						FROM tclassextenddata with (nolock) 
							inner join tclassextendattributes with (nolock)
								on (tclassextenddata.attributeID=tclassextendattributes.attributeID)
						WHERE tclassextendattributes.siteid in (?)
							AND tclassextendattributes.name=?
					) qExtendedSort
						ON (tcontent.contenthistid=qExtendedSort.baseID)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.isNav = 1
				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				 
					AND tcontent.searchExclude = 0
				

				AND tcontent.type <>'Module'

				
				
								and (
							
								tcontent.contentHistID IN (
									SELECT tclassextenddata.baseID 
									FROM tclassextenddata with (nolock) 
										WHERE 
											tclassextenddata.attributeID= ? 

										AND 

											stringvalue >= ? 
								)
								) 
					and tcontent.parentid in (
					?, 
					'')
					    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
						
						order by
						
						
										qExtendedSort.extendedSort asc
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = SeminarDate
Parameter #3(cf_sql_varchar) = UHCO
Parameter #4(cf_sql_numeric) = 1215
Parameter #5(cf_sql_varchar) = {ts '2019-02-16 21:41:20'}
Parameter #6(cf_sql_varchar) = EC8467F9-BAA1-FB2B-24D9AE1F5AF2416A
Parameter #7(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #8(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #9(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #10(cf_sql_timestamp) = 2019-02-18 21:41:00.0

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = [FOOTER] Optometry Links - Top
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 6EA6BB33-AE77-835B-A48B4A17D622D3A7
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 6EA6BB33-AE77-835B-A48B4A17D622D3A7
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 6EA6BB33-AE77-835B-A48B4A17D622D3A7

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\extend\extendManager.cfc @ 21:41:20.020
				select validation from tclassextendattributes 
				where 
				
					siteID=?
					and name=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) =

rsFeed (Datasource=UHCOcms, Time=31ms, Records=5) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:20.020
			SELECT 
				top 6 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
					LEFT JOIN (
						SELECT 
							stringvalue extendedSort,
							tclassextenddata.baseID 
						FROM tclassextenddata with (nolock) 
							inner join tclassextendattributes with (nolock)
								on (tclassextenddata.attributeID=tclassextendattributes.attributeID)
						WHERE tclassextendattributes.siteid in (?)
							AND tclassextendattributes.name=?
					) qExtendedSort
						ON (tcontent.contenthistid=qExtendedSort.baseID)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.isNav = 1
				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				 
					AND tcontent.searchExclude = 0
				

				AND tcontent.type <>'Module'

				
				
						AND tcontent.contenthistID in (
							select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign with (nolock)
							inner join tcontentcategories with (nolock)
							ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID) 
							where (
									tcontentcategories.path like ? )
						)
						    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) =
Parameter #3(cf_sql_varchar) = UHCO
Parameter #4(cf_sql_varchar) = %6EC689A3-9AD8-9A8C-E00CF2B7B9E53D72%
Parameter #5(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #6(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #7(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #8(cf_sql_timestamp) = 2019-02-18 21:41:00.0

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = [FOOTER] Optometry Links - Bottom
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 6FFC262D-E71F-DDD2-DFFAA47083D7D293
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 6FFC262D-E71F-DDD2-DFFAA47083D7D293
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=15ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 6FFC262D-E71F-DDD2-DFFAA47083D7D293

rsFeed (Datasource=UHCOcms, Time=32ms, Records=5) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:20.020
			SELECT 
				top 6 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.isNav = 1
				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				 
					AND tcontent.searchExclude = 0
				

				AND tcontent.type <>'Module'

				
				
						AND tcontent.contenthistID in (
							select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign with (nolock)
							inner join tcontentcategories with (nolock)
							ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID) 
							where (
									tcontentcategories.path like ? )
						)
						    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
						
						order by
						
						
										tcontent.lastUpdate desc
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = %70479F36-A180-7166-0CD0D7A630473676%
Parameter #3(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #4(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #5(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #6(cf_sql_timestamp) = 2019-02-18 21:41:00.0

rsSites (Datasource=UHCOcms, Time=0ms, Records=7) in D:\UHCOcms\requirements\mura\settings\settingsGateway.cfc @ 21:41:20.020
				SELECT * FROM tsettings ORDER BY 
				orderno asc
rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = More UH
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 0FF4B329-6A45-4077-8776CEB26F5E0CAB
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 0FF4B329-6A45-4077-8776CEB26F5E0CAB
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 0FF4B329-6A45-4077-8776CEB26F5E0CAB

rsFeed (Datasource=UHCOcms, Time=0ms, Records=7) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:20.020
			SELECT 
				top 20 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.isNav = 1
				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				 
					AND tcontent.searchExclude = 0
				

				AND tcontent.type <>'Module'

				
				
					and tcontent.parentid in (
					?, 
					'')
					    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
						
						order by
						
						
										tcontent.orderno asc
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = F04724EE-9DCD-40C3-B3BA0AE6B819741A
Parameter #3(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #4(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #5(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #6(cf_sql_timestamp) = 2019-02-18 21:41:00.0

rs (Datasource=UHCOcms, Time=15ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
	Select 
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid
	from tcontentfeeds where 
	name= ?
	and siteid=?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UH Legal Info
Parameter #2(cf_sql_varchar) = UHCO

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 8B6528E9-5177-405D-80DD630F1ABC6B30
Parameter #2(cf_sql_varchar) = contentID

rs (Datasource=UHCOcms, Time=0ms, Records=0) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select itemID from tcontentfeeditems
		where feedID=? and type = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 8B6528E9-5177-405D-80DD630F1ABC6B30
Parameter #2(cf_sql_varchar) = categoryID

rs (Datasource=UHCOcms, Time=0ms, Records=1) in D:\UHCOcms\requirements\mura\content\feed\feedDAO.cfc @ 21:41:20.020
		select * from tcontentfeedadvancedparams
		where feedID=? order by param
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 8B6528E9-5177-405D-80DD630F1ABC6B30

rsFeed (Datasource=UHCOcms, Time=16ms, Records=9) in D:\UHCOcms\requirements\mura\content\feed\feedGateway.cfc @ 21:41:20.020
			SELECT 
				top 20 
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups, 
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, 
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,  null as kids,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText
					

			FROM 
				 tcontent with (nolock) 
					left Join tfiles with (nolock) on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats with (nolock) on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent with (nolock) on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1) 
					Left Join tcontentfilemetadata with (nolock) on (tcontent.fileid=tcontentfilemetadata.fileid 
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid)
				
				

			WHERE
				tcontent.siteid in (?)
					
				and tcontent.active = 1
				and tcontent.Approved = 1 
					AND tcontent.isNav = 1
				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				 
					AND tcontent.searchExclude = 0
				

				AND tcontent.type <>'Module'

				
				
					and tcontent.parentid in (
					?, 
					'')
					    
					AND (
						tcontent.Display = 1
						OR
							(		
								tcontent.Display = 2
								
								
								AND
								(	

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										
										
										and tcontent.DisplayStart <= ? 
										and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null)
									)
								)			 
							)		
					
					) 

					AND (
						tcontent.mobileExclude is null
						OR 
						
							tcontent.mobileExclude in (0,1)
						
					)
						
						order by
						
						
										tcontent.orderno asc
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = UHCO
Parameter #2(cf_sql_varchar) = D898CFBF-48E7-4FE0-9E69845EC80CD538
Parameter #3(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #4(cf_sql_timestamp) = 2019-02-18 21:41:00.0
Parameter #5(cf_sql_timestamp) = 2020-02-18 21:41:00.0
Parameter #6(cf_sql_timestamp) = 2019-02-18 21:41:00.0

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=DigiCert Inc, OU=www.digicert.com, CN=GeoTrust RSA CA 2018
CERT_SERVER_SUBJECT=C=US, S=Texas, L=Houston, O=University of Houston, CN=*.OPT.UH.EDU
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\UHCOcms\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=DigiCert Inc, OU=www.digicert.com, CN=GeoTrust RSA CA 2018
HTTPS_SERVER_SUBJECT=C=US, S=Texas, L=Houston, O=University of Houston, CN=*.OPT.UH.EDU
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.opt.uh.edu
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=www.opt.uh.edu
PATH_INFO=/index.cfm
PATH_TRANSLATED=D:\UHCOcms\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.21.44.240
REMOTE_HOST=172.21.44.240
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.opt.uh.edu
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Cookie Variables:
CFID=18586602
CFTOKEN=93f24139ad649da2-266F7CB7-E1A9-F794-0350C5BDEDA39767
MOBILEFORMAT=false
ORIGINALURLTOKEN=266F8023-00F3-7821-0F939806FDF225E0

Session Variables:
blockloginuntil=
cfid=18586602
cftoken=93f24139ad649da2-266F7CB7-E1A9-F794-0350C5BDEDA39767
datekey=<script type="text/javascript">
	var dtExample="11/10/2018";
	var dtCh="/";
	var dtFormat =[0,1,2];
	var dtLocale="en-US";
	</script> 
datekeyformat=MM/DD/YYYY
locale=en_US
localehasdayparts=10
loginattempts=0
mura=Struct (20)
rb=en_US
rememberme=0
sessionid=MURA66BD4F6F46EC930F0B6552169D8DC9D7_18586602_93f24139ad649da2-266F7CB7-E1A9-F794-0350C5BDEDA39767
siteid=UHCO
trackingid=266F8023-00F3-7821-0F939806FDF225E0
urltoken=CFID=18586602&CFTOKEN=93f24139ad649da2-266F7CB7-E1A9-F794-0350C5BDEDA39767
userfilespath=/UHCO/assets/

URL Parameters:
path=/UHCO/
Debug Rendering Time: 0 ms