What our customers have to say

SELECT sPageName, pkiPageID 
	FROM tPages 
	WHERE fkiParent = 0 
		AND iPosition = 1 
	ORDER BY iOrder

SELECT sPageName, pkiPageID, sIncludeFile, vcContent
	FROM tPages 
	WHERE fkiParent = 0 
		AND iPosition = 0 
		AND bIsAdmin = 0 
		AND bIsMenuItem = 1
	ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 108 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 232 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 1 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 342 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 5 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 124 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 177 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 224 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 242 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 244 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 17 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT 
	    bIsAdmin,
		fkiParent,
		sPagename,
		sPageTitle,
		sIncludeFile,
		vcContent 
	FROM tPages 
	WHERE pkiPageID = 108

SELECT vcCountryname,pkiCountryid 

	FROM tCountries

	WHERE bActive = 1 AND bFromOrTo = 0 AND bActiveToClient = 1

		AND pkiCountryID IN

			(

				SELECT DISTINCT fkiCountry

				FROM tLocations

				WHERE bActive = 1

					AND pkiLocationID IN 

						(

							SELECT DISTINCT fkiLocationFromID

							FROM tRoutes

						)

			)

	ORDER BY vcCountryName

SELECT fkiCountry,vcLocationName,pkiLocationID

	FROM tLocations

	WHERE bActive = 1

		AND pkiLocationID IN 

			(

				SELECT DISTINCT fkiLocationFromID

				FROM tRoutes

			)

	ORDER BY fkiCountry, vcLocationName

SELECT sCourierCityName,pkiCourierCityID,pkiCountryID 

	FROM tCourierCities 

	INNER JOIN tCountryCouriers 

		ON tCountryCouriers.pkiCourierID = tCourierCities.fkiCourierID 

	INNER JOIN tCountries 

		ON tCountries.fkiCollectCourierID = tCountryCouriers.pkiCourierID 

	WHERE tCountries.bActive = 1 AND bFromOrTo = 0 AND bActiveToClient = 1

	ORDER BY pkiCountryID, sCourierCityName

Application Variables:
applicationname=u-bag.14x0x0
APPLICATIONURLPATH=/ubag.skybags365.com
BASEPATH=/home/skybagsc/public_html/ubag.skybags365.com/
BLNDEBUGMODE=false
BLNUNDERCONSTRUCTION=false
cfcLocation=CFC.FinalQuote
cfcRealLocation=CFC
DIRECTORYPATH=/home/skybagsc/public_html/ubag.skybags365.com/
DOCUMENTSFOLDER=/home/skybagsc/public_html/ubag.skybags365.com/documents
EmailAddress=info@u-bag.com
EXTRASFOLDER=/home/skybagsc
EXTRASFOLDER01=/home/skybagsc/public_html/ubag.skybags365.com
IMAGEBASEPATH=/home/skybagsc/public_html/ubag.skybags365.com/
IMAGEWEBPATH=https://ubag.skybags365.com/images/
PROJECTFOLDER=/home/skybagsc/public_html/ubag.skybags365.com/
ROOTCODEPATH=/home/skybagsc/
ROOTCODEPATHDEV=/home/skybagsc/code
ROOTDIR=/home/skybagsc/public_html/ubag.skybags365.com/
smsLink=253
STRDEFUALTCURR=ZAR
STRFOLDERDELIMITER=/
strSmsService=u-bag@sms.entelligence.co.za
thisDSN=UBag_14x0x0

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=/home/skybagsc/public_html/ubag.skybags365.com/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=*/*
http_accept_encoding=gzip, br, zstd, deflate
http_accept_language=
http_connection=close
http_cookie=cftoken=0; cfid=47247afa-9014-43de-8055-c988e957ff8a
http_host=ubag.skybags365.com
http_referer=
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
https=on
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=178.159.5.243
local_host=greyhound.dnshostnetwork.com
path_info=
path_translated=/home/skybagsc/public_html/ubag.skybags365.com/index.cfm
query_string=url=ubag.skybags365.com
remote_addr=216.73.217.23
remote_host=216.73.217.23
remote_user=
request_method=GET
request_url=https://ubag.skybags365.com/index.cfm?url=ubag.skybags365.com
script_name=/index.cfm
server_name=ubag.skybags365.com
server_port=443
server_port_secure=1
server_protocol=HTTP/1.1
server_software=
web_server_api=

Cookie Variables:
cfid=47247afa-9014-43de-8055-c988e957ff8a
cftoken=0

Form Variables:
quantity=
weight=

Request Variables:
org.apache.catalina.AccessLog.Protocol=HTTP/1.1
org.apache.catalina.AccessLog.RemoteAddr=216.73.217.23
org.apache.catalina.AccessLog.RemoteHost=216.73.217.23
org.apache.catalina.AccessLog.ServerName=ubag.skybags365.com
org.apache.catalina.AccessLog.ServerPort=443
org.apache.tomcat.remoteAddr=216.73.217.23
org.apache.tomcat.request.forwarded=true

Server Variables:
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.0.6=Complex type
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.1=Complex type
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.2=Complex type
CACHE=Struct (190)
CACHE_TIMESTAMPS=Struct (190)
cbox-javaloader-1B50254DE719A76B2ADC708B9F6D56EE=Component (modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-52B877CA0494DF462AFAE4B19932AA27=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-554E0B2DF76810BDA83FB33DA8A8ABE9=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-757114FCCFB5C490D952526BFDF3987E=Component (modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-7C624209BA64FDFA88C5C8208DA20E5C=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-8E03551109DB0559698D811C86B103EB=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-AEAAE1EF90B4BB57161501BD525097AE=Component (modules.BCrypt.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-D3D5EEDE3F35A4658B10897E5F82E29A=Component (modules.relax.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-D98F90619134ECE764EC062DCA91FCE0=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-DDCEE58D59F22F146C90D6E97C07CA45=Component (modules.relax.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-F4E336252BF14F02E265FDC3C6BA95E1=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
coldfusion=Struct (9)
java=Struct (8)
LOGIN_BRIDGE=Struct (0)
lucee=Struct (8)
os=Struct (8)
PRODSTRUCT=Struct (1)
RECENT_ORDERS=Array (16)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)
ZONESTR=Struct (0)

Session Variables:
blnDebugMode=false
cfid=47247afa-9014-43de-8055-c988e957ff8a
cftoken=0
email=
firstname=
isAdmin=0
isCountry=0
lastvisit={ts '2026-08-07 05:35:22'}
sessionid=u-bag.14x0x0_47247afa-9014-43de-8055-c988e957ff8a_0
surname=
timecreated={ts '2026-08-07 04:14:32'}
toCountry=0
urltoken=CFID=47247afa-9014-43de-8055-c988e957ff8a&CFTOKEN=0
username=
validated=0

URL Variables:
pageid=108
url=ubag.skybags365.com