ALDO

			SELECT 	pathCss,group_id,group_name
			FROM   	b2c_groups
			WHERE 	url like ? 

			SELECT store_id,url,ckey
			FROM   b2c_stores
			WHERE store_id not in (0,37,38)
			AND group_id =? 

			INSERT INTO b2c_users
			(	User_ID
			,	store_id
			, 	Password
			, 	visiting_ip
			, 	visiting_host
			, 	visiting_browser_type
			, 	visiting_http
			,	icongo_sid
			,	language_id
			,	address_1
			,	city
			,	state_id
			,	Country_id
			,	postal_code
			,	email_1
			,	first_name
			,	last_name
			,	date_last_accessed
			,	date_modified
			,	date_created
			,	no_of_logins
			,	require_login_ind
			,	terms_accepted_ind
			)
			VALUES
			(	''
			,	?
			,	''
			, 	?
			, 	?
			,	?
			, 	?
			,	?
			,	?
			,	''
			,	''
			,	''
			,	''
			,	''
			,	''
			,	''
			,	''
			,	GETDATE()
			,	GETDATE()
			,	GETDATE()
			,	0
			,	'Y'
			,	'Y'
			)

			SELECT @@IDENTITY AS 'Identity'
		

	select	first_name
	,	last_name
	,	email_1
	from	b2c_users with (nolock)
	where	ukey = ? 

	select	order_id
	,	extended_price
	from	b2c_orders
	where	ukey = ?
	and	order_status_id = 1  -- OPEN

			SELECT 	 parameter_value as newsletter_category_id
			FROM   	b2c_store_parameters with (nolock)
			WHERE 	store_Id = ?
			AND   parameter_id  = ? 

				select	member_company_id
				,		banner_id
				,		banner_name
				,		brand_id
				,		banner_placeholder_id
				,		alt_tag_message
				,		onclick_url
				,		onclick_new_window_ind
				,		active_ind
				,		language_id
				,		parent_section_id
				,		section_id
				,		location_id
				,		date_created
				,		date_modified
				,		supplier_id
				,		store_id
				,		categoryId
				,		upper(banner_key_1) as banner_key_1
				,		upper(banner_key_2) as banner_key_2
				,		image_map
				,		start_date
				,		end_date
				,		ext
				,		banner_tracking
				,		archived
				,		banner_type_id
				,		track_conversion
				,		keywords
				,		default_banner_ind
				,		cast(banner_id as varchar) + '_1.' + ext as source
				,		(CASE WHEN (banner_type_id = 3 OR banner_type_id = 4 OR banner_type_id = 5)
						THEN 	(
						'1'
								)
						ELSE    (
						'0'
								)

						END	) as productDisplay
				,		no_follow_ind
				,		banner_campaign_id
				,	0 	as IMP
				,	'N' as LOC
				, 	(isNull(banner_weight,1)) as WEI
				,	0 as ROWNUM
				,  product_tags
				from   banners WITH (NOLOCK)
				where  archived = 'N'
				and active_ind = 'Y'
				and	   getdate() between start_date and end_date
				order by banner_placeholder_id
		

select banner_id, image_map, ROWNUM, banner_type_id from getAllBannersQry where productDisplay = '1' 

			select *
			from  banner_placeholders
			where  archived = 'N'
		

						select distinct
							level1ID
						,	level2ID
						,	level3ID
						,	engLevel1 as level1Desc
						,	engLevel2 as level2Desc
						,	engLevel3 as level3Desc
						,	LEVEL1ID_sequence as level1Sec
						,	LEVEL2ID_sequence as level2Sec
						,	LEVEL3ID_sequence as level3Sec
						,	level3_pop as pop
						,	store_id
						,	LEVEL1ID_sequence
						,	Level2ID_sequence
						,	level3ID_sequence
						,	nameMaskLevel1_eng as level1MaskDesc
						,	nameMaskLevel2_eng as level2MaskDesc
						,	nameMaskLevel3_eng as level3MaskDesc
						from search_b2c_store_item_item_categories
						where
						
						store_id = ?
						and item_id != 'GIFT_CARD'
						
						order by LEVEL1ID_sequence,LEVEL2ID_sequence,LEVEL3ID_sequence
					

						select 	distinct
								level1ID
						,		level2ID
						,		level3ID
						,		level1Desc
						,		level2Desc
						,		level3Desc
						,		level1Sec
						,		level2Sec
						,		level3Sec
						,		pop
						,		level1MaskDesc
						,		level2MaskDesc
						,		level3MaskDesc
						from 	getCatsQuery
						where	store_id = 36 
					    order by level1ID_sequence,level2ID_sequence,level3ID_sequence
					

						select 	distinct
								level1ID as ID
						,		level1Desc as DESCR
						,		level1MaskDesc as MASKDESCR
						,		level1Sec as SEC
						from	getCatsFromCache
						where level1ID is not null
						order By SEC
					

Select ACTIVE_IND,ALT_TAG_MESSAGE,ARCHIVED,BANNER_CAMPAIGN_ID,BANNER_ID,BANNER_KEY_1,BANNER_KEY_2,BANNER_NAME,BANNER_PLACEHOLDER_ID,BANNER_TRACKING,BANNER_TYPE_ID,CATEGORYID,DATE_CREATED,DATE_MODIFIED,DEFAULT_BANNER_IND,END_DATE,EXT,IMAGE_MAP,IMP,KEYWORDS,LANGUAGE_ID,LOC,LOCATION_ID,MEMBER_COMPANY_ID,NO_FOLLOW_IND,ONCLICK_NEW_WINDOW_IND,ONCLICK_URL,PARENT_SECTION_ID,PRODUCTDISPLAY,ROWNUM,SECTION_ID,SOURCE,START_DATE,STORE_ID,SUPPLIER_ID,TRACK_CONVERSION,WEI,PRODUCT_TAGS from application.banners.qry where 'aldo2' = 'aldo2' and banner_placeholder_id in (335) and language_id = 'eng' and active_ind = 'Y' and member_company_id = 100000 and store_id in (0,36) and  (banner_key_1 = 'ALL' or banner_key_1 is null or banner_key_1 = '') OR (default_banner_ind = 'Y') order by banner_placeHolder_id
		

select ACTIVE_IND,ALT_TAG_MESSAGE,ARCHIVED,BANNER_CAMPAIGN_ID,BANNER_ID,BANNER_KEY_1,BANNER_KEY_2,BANNER_NAME,BANNER_PLACEHOLDER_ID,BANNER_TRACKING,BANNER_TYPE_ID,CATEGORYID,DATE_CREATED,DATE_MODIFIED,DEFAULT_BANNER_IND,END_DATE,EXT,IMAGE_MAP,IMP,KEYWORDS,LANGUAGE_ID,LOC,LOCATION_ID,MEMBER_COMPANY_ID,NO_FOLLOW_IND,ONCLICK_NEW_WINDOW_IND,ONCLICK_URL,PARENT_SECTION_ID,PRODUCTDISPLAY,ROWNUM,SECTION_ID,SOURCE,START_DATE,STORE_ID,SUPPLIER_ID,TRACK_CONVERSION,WEI,PRODUCT_TAGS from qry where banner_id = 7403 

				select item_category_id, eng_description as DESCR
				,lower(mask_description_eng) MASKDESCR
				,item_category_id as ID
				,enable_menu_expand
				from b2c_catalog_item_categories with (NOLOCK)
				where active_ind='Y'
				and   store_id	= ?
				and parent_item_category_id = ? 
				and item_category_id != parent_item_category_id
				
				and exists (
				select 1 from
				
					b2c_cached_search_item_colors items with (NOLOCK)
				
				where store_id = ?
				and level2ID = b2c_catalog_item_categories.item_category_id
				and  Exists ( Select 1
				              FROM b2c_catalog_size_availabilities sizeInventory  with (NOLOCK)
		                        WHERE items.store_id = sizeInventory.store_id
						    and items.item_id = sizeInventory.item_id

		                        and items.color_id = sizeInventory.color_id

		                        and sizeInventory.qty_on_hand - sizeInventory.qty_to_be_shipped  - sizeInventory.qty_pending_in_store_order - sizeInventory.qty_backordered - sizeInventory.qty_not_available > 0
		                        and store_id = ?
		                        and sizeInventory.qty_on_hand > sizeInventory.qty_to_be_shipped
		                      )
		        
		        and items.item_color_image_2 is not null
				)

				order by sequence
			

			select distinct a.flag_id, a.engDescription as Descr,a.sequence
			from b2c_Catalog_flags a with (nolock),
			b2c_catalog_item_flags b with (nolock)
			where a.include_in_navigation_categories like (?)
			and a.flag_id = b.flag_id
			and a.store_id = b.store_id
			and getdate() BETWEEN b.start_date  and b.end_date
			and a.store_id = ?
			order by a.sequence
		

				select item_category_id, eng_description as DESCR
				,lower(mask_description_eng) MASKDESCR
				,item_category_id as ID
				,enable_menu_expand
				from b2c_catalog_item_categories with (NOLOCK)
				where active_ind='Y'
				and   store_id	= ?
				and parent_item_category_id = ? 
				and item_category_id != parent_item_category_id
				
				and exists (
				select 1 from
				
					b2c_cached_search_item_colors items with (NOLOCK)
				
				where store_id = ?
				and level2ID = b2c_catalog_item_categories.item_category_id
				and  Exists ( Select 1
				              FROM b2c_catalog_size_availabilities sizeInventory  with (NOLOCK)
		                        WHERE items.store_id = sizeInventory.store_id
						    and items.item_id = sizeInventory.item_id

		                        and items.color_id = sizeInventory.color_id

		                        and sizeInventory.qty_on_hand - sizeInventory.qty_to_be_shipped  - sizeInventory.qty_pending_in_store_order - sizeInventory.qty_backordered - sizeInventory.qty_not_available > 0
		                        and store_id = ?
		                        and sizeInventory.qty_on_hand > sizeInventory.qty_to_be_shipped
		                      )
		        
		        and items.item_color_image_2 is not null
				)

				order by sequence
			

			select distinct a.flag_id, a.engDescription as Descr,a.sequence
			from b2c_Catalog_flags a with (nolock),
			b2c_catalog_item_flags b with (nolock)
			where a.include_in_navigation_categories like (?)
			and a.flag_id = b.flag_id
			and a.store_id = b.store_id
			and getdate() BETWEEN b.start_date  and b.end_date
			and a.store_id = ?
			order by a.sequence
		

				select item_category_id, eng_description as DESCR
				,lower(mask_description_eng) MASKDESCR
				,item_category_id as ID
				,enable_menu_expand
				from b2c_catalog_item_categories with (NOLOCK)
				where active_ind='Y'
				and   store_id	= ?
				and parent_item_category_id = ? 
				and item_category_id != parent_item_category_id
				
				and exists (
				select 1 from
				
					b2c_cached_search_item_colors items with (NOLOCK)
				
				where store_id = ?
				and level2ID = b2c_catalog_item_categories.item_category_id
				and  Exists ( Select 1
				              FROM b2c_catalog_size_availabilities sizeInventory  with (NOLOCK)
		                        WHERE items.store_id = sizeInventory.store_id
						    and items.item_id = sizeInventory.item_id

		                        and items.color_id = sizeInventory.color_id

		                        and sizeInventory.qty_on_hand - sizeInventory.qty_to_be_shipped  - sizeInventory.qty_pending_in_store_order - sizeInventory.qty_backordered - sizeInventory.qty_not_available > 0
		                        and store_id = ?
		                        and sizeInventory.qty_on_hand > sizeInventory.qty_to_be_shipped
		                      )
		        
		        and items.item_color_image_2 is not null
				)

				order by sequence
			

			select distinct a.flag_id, a.engDescription as Descr,a.sequence
			from b2c_Catalog_flags a with (nolock),
			b2c_catalog_item_flags b with (nolock)
			where a.include_in_navigation_categories like (?)
			and a.flag_id = b.flag_id
			and a.store_id = b.store_id
			and getdate() BETWEEN b.start_date  and b.end_date
			and a.store_id = ?
			order by a.sequence
		

				select item_category_id, eng_description as DESCR
				,lower(mask_description_eng) MASKDESCR
				,item_category_id as ID
				,enable_menu_expand
				from b2c_catalog_item_categories with (NOLOCK)
				where active_ind='Y'
				and   store_id	= ?
				and parent_item_category_id = ? 
				and item_category_id != parent_item_category_id
				
				and exists (
				select 1 from
				
					b2c_cached_search_item_colors items with (NOLOCK)
				
				where store_id = ?
				and level2ID = b2c_catalog_item_categories.item_category_id
				and  Exists ( Select 1
				              FROM b2c_catalog_size_availabilities sizeInventory  with (NOLOCK)
		                        WHERE items.store_id = sizeInventory.store_id
						    and items.item_id = sizeInventory.item_id

		                        and items.color_id = sizeInventory.color_id

		                        and sizeInventory.qty_on_hand - sizeInventory.qty_to_be_shipped  - sizeInventory.qty_pending_in_store_order - sizeInventory.qty_backordered - sizeInventory.qty_not_available > 0
		                        and store_id = ?
		                        and sizeInventory.qty_on_hand > sizeInventory.qty_to_be_shipped
		                      )
		        
		        	and items.sale_price_ind = 'Y'
		        
		        and items.item_color_image_2 is not null
				)

				order by sequence
			

			select distinct a.flag_id, a.engDescription as Descr,a.sequence
			from b2c_Catalog_flags a with (nolock),
			b2c_catalog_item_flags b with (nolock)
			where a.include_in_navigation_categories like (?)
			and a.flag_id = b.flag_id
			and a.store_id = b.store_id
			and getdate() BETWEEN b.start_date  and b.end_date
			and a.store_id = ?
			order by a.sequence
		

				select item_category_id, eng_description as DESCR
				,lower(mask_description_eng) MASKDESCR
				,item_category_id as ID
				,enable_menu_expand
				from b2c_catalog_item_categories with (NOLOCK)
				where active_ind='Y'
				and   store_id	= ?
				and parent_item_category_id = ? 
				and item_category_id != parent_item_category_id
				
				and exists (
				select 1 from
				
					b2c_cached_search_item_colors items with (NOLOCK)
				
				where store_id = ?
				and level2ID = b2c_catalog_item_categories.item_category_id
				and  Exists ( Select 1
				              FROM b2c_catalog_size_availabilities sizeInventory  with (NOLOCK)
		                        WHERE items.store_id = sizeInventory.store_id
						    and items.item_id = sizeInventory.item_id

		                        and items.color_id = sizeInventory.color_id

		                        and sizeInventory.qty_on_hand - sizeInventory.qty_to_be_shipped  - sizeInventory.qty_pending_in_store_order - sizeInventory.qty_backordered - sizeInventory.qty_not_available > 0
		                        and store_id = ?
		                        and sizeInventory.qty_on_hand > sizeInventory.qty_to_be_shipped
		                      )
		        
		        and items.item_color_image_2 is not null
				)

				order by sequence
			

			select distinct a.flag_id, a.engDescription as Descr,a.sequence
			from b2c_Catalog_flags a with (nolock),
			b2c_catalog_item_flags b with (nolock)
			where a.include_in_navigation_categories like (?)
			and a.flag_id = b.flag_id
			and a.store_id = b.store_id
			and getdate() BETWEEN b.start_date  and b.end_date
			and a.store_id = ?
			order by a.sequence
		

Select ACTIVE_IND,ALT_TAG_MESSAGE,ARCHIVED,BANNER_CAMPAIGN_ID,BANNER_ID,BANNER_KEY_1,BANNER_KEY_2,BANNER_NAME,BANNER_PLACEHOLDER_ID,BANNER_TRACKING,BANNER_TYPE_ID,CATEGORYID,DATE_CREATED,DATE_MODIFIED,DEFAULT_BANNER_IND,END_DATE,EXT,IMAGE_MAP,IMP,KEYWORDS,LANGUAGE_ID,LOC,LOCATION_ID,MEMBER_COMPANY_ID,NO_FOLLOW_IND,ONCLICK_NEW_WINDOW_IND,ONCLICK_URL,PARENT_SECTION_ID,PRODUCTDISPLAY,ROWNUM,SECTION_ID,SOURCE,START_DATE,STORE_ID,SUPPLIER_ID,TRACK_CONVERSION,WEI,PRODUCT_TAGS from application.banners.qry where 'aldo2' = 'aldo2' and banner_placeholder_id in (278) and language_id = 'eng' and active_ind = 'Y' and member_company_id = 100000 and store_id in (0,36) and  (banner_key_1 = 'ALL' or banner_key_1 is null or banner_key_1 = '') OR (default_banner_ind = 'Y') order by banner_placeHolder_id
		

select ACTIVE_IND,ALT_TAG_MESSAGE,ARCHIVED,BANNER_CAMPAIGN_ID,BANNER_ID,BANNER_KEY_1,BANNER_KEY_2,BANNER_NAME,BANNER_PLACEHOLDER_ID,BANNER_TRACKING,BANNER_TYPE_ID,CATEGORYID,DATE_CREATED,DATE_MODIFIED,DEFAULT_BANNER_IND,END_DATE,EXT,IMAGE_MAP,IMP,KEYWORDS,LANGUAGE_ID,LOC,LOCATION_ID,MEMBER_COMPANY_ID,NO_FOLLOW_IND,ONCLICK_NEW_WINDOW_IND,ONCLICK_URL,PARENT_SECTION_ID,PRODUCTDISPLAY,ROWNUM,SECTION_ID,SOURCE,START_DATE,STORE_ID,SUPPLIER_ID,TRACK_CONVERSION,WEI,PRODUCT_TAGS from qry where banner_id = 7088 

Select ACTIVE_IND,ALT_TAG_MESSAGE,ARCHIVED,BANNER_CAMPAIGN_ID,BANNER_ID,BANNER_KEY_1,BANNER_KEY_2,BANNER_NAME,BANNER_PLACEHOLDER_ID,BANNER_TRACKING,BANNER_TYPE_ID,CATEGORYID,DATE_CREATED,DATE_MODIFIED,DEFAULT_BANNER_IND,END_DATE,EXT,IMAGE_MAP,IMP,KEYWORDS,LANGUAGE_ID,LOC,LOCATION_ID,MEMBER_COMPANY_ID,NO_FOLLOW_IND,ONCLICK_NEW_WINDOW_IND,ONCLICK_URL,PARENT_SECTION_ID,PRODUCTDISPLAY,ROWNUM,SECTION_ID,SOURCE,START_DATE,STORE_ID,SUPPLIER_ID,TRACK_CONVERSION,WEI,PRODUCT_TAGS from application.banners.qry where 'aldo2' = 'aldo2' and banner_placeholder_id in (509) and language_id = 'eng' and active_ind = 'Y' and member_company_id = 100000 and store_id in (0,36) and  (banner_key_1 = 'ALL' or banner_key_1 is null or banner_key_1 = '') OR (default_banner_ind = 'Y') order by banner_placeHolder_id
		

select ACTIVE_IND,ALT_TAG_MESSAGE,ARCHIVED,BANNER_CAMPAIGN_ID,BANNER_ID,BANNER_KEY_1,BANNER_KEY_2,BANNER_NAME,BANNER_PLACEHOLDER_ID,BANNER_TRACKING,BANNER_TYPE_ID,CATEGORYID,DATE_CREATED,DATE_MODIFIED,DEFAULT_BANNER_IND,END_DATE,EXT,IMAGE_MAP,IMP,KEYWORDS,LANGUAGE_ID,LOC,LOCATION_ID,MEMBER_COMPANY_ID,NO_FOLLOW_IND,ONCLICK_NEW_WINDOW_IND,ONCLICK_URL,PARENT_SECTION_ID,PRODUCTDISPLAY,ROWNUM,SECTION_ID,SOURCE,START_DATE,STORE_ID,SUPPLIER_ID,TRACK_CONVERSION,WEI,PRODUCT_TAGS from qry where banner_id = 8561 

				INSERT INTO banner_tracking (banner_id,tracking_type)
				
					SELECT	?
						,	? 
						UNION ALL
					
					SELECT	?
						,	? 
						UNION ALL
					
					SELECT	?
						,	? 

Application Variables:
applicationname=aldo2_www_parent
banners=Struct (4)
bannerspath=/static/webUpload/33
basepath=
basephysicalpath=D:\websites\aldoshoes_trunk\aldoshoes\
basephysicalpathinc=D:\websites\aldoshoes_trunk\aldoshoes\
basewwwphysicalpath=D:\websites\aldoshoes_trunk\aldoshoes\
cachedxmldocsstruct=Struct (0)
clusterlist=
contentpathinc=/aldoshoes/frontEndComponents/specificComponents/
contesttemplatespublicationfileprefix=contestTemplateRedirect_
contesttemplatespublicationfolder=publishedContestTemplates
dbcolumncheck=Struct (2)
encryptionkey=pPgcrpfjOOY=
frontendcomponentspath=/frontEndComponents/specificComponents/
generic=Struct (103)
getallsstore=Query (12)
lastcategorygenerationdate={ts '2012-05-21 00:20:03'}
memcachedfacade=Struct (9)
mycaptcha=Struct (15)
privatenetworkid=1234569781
redirecturl=http://littleburgundy.icongostaging.com
sitename=Aldo
store26=Struct (357)
store27=Struct (373)
store28=Struct (358)
store29=Struct (249)
store30=Struct (346)
store31=Struct (343)
store32=Struct (248)
store34=Struct (357)
store35=Struct (342)
store36=Struct (354)
store37=Struct (283)
store38=Struct (283)
storeobj=Struct (1)
xmlparser=Struct (2)
xmlpath=D:\websites\aldoshoes_trunk\aldoshoes\/frontEndComponents\xml

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\websites\aldoshoes_trunk\aldoshoes\littleBurgundy\store.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=littleburgundy.icongostaging.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/store.cfm
PATH_TRANSLATED=D:\websites\aldoshoes_trunk\aldoshoes\littleBurgundy\store.cfm
QUERY_STRING=ckey=ca&lang=eng&landingPage=&Homepage=Y&
REMOTE_ADDR=38.107.179.217
REMOTE_HOST=38.107.179.217
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store.cfm
SERVER_NAME=littleburgundy.icongostaging.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Request Parameters:
addtourl=&var=d&ckey=CA
admingenericcomponentspathpath=/admin/content/genericComponents
adminpath= /admin
adminurl=http://aldo.icongostaging.com
advancedsurveyadmincustomtagdir=/websiteTags/admin/advanced_survey/
advancedsurveyfrontendcustomtagdir=/websiteTags/frontEnd/advanced_survey/
ajaxpath=/icongoFrameWork//cfajax/core/
aldocanadastorehomepagewsession=/store.cfm?CKEY=CA
aldoukstorehomepagewsession=/store.cfm?CKEY=UK
aldousstorehomepagewsession=/store.cfm?CKEY=US
appname=aldo2
authenticatedimagespath=/_static/images/www/Authenticated
authenticationpath=/frontEndComponents/authentication
authenticationpathinc=/aldoshoes/frontEndComponents/authentication
b2c_ups_package_type=P
b2c_ups_terms_of_sale=NULL
b2ccachinglevel_1=0
b2ccachinglevel_2=0
b2ccachinglevel_3=0
b2ccachinglevel_4=0
b2ccachinglevel_5=0
b2ccatalogcategorywomenlevel1id=100
b2ccheckout_cgi_path_info=http://littleburgundy.icongostaging.com/eng/checkout/redirect.cfm
b2ccolor_1_noimage=noImg_1.jpg
b2ccustomerservicesectiondirectory=customerService
b2cemailtemplatepath=D:\websites\aldoshoes_trunk\aldoshoes\\frontEndComponents\specificComponents\b2c\emailTemplates
b2cemptytemplatesection_cgi_path_info=/eng/emptyTemplateSection/redirect.cfm
b2cgeneral_cgi_path_info=http://littleburgundy.icongostaging.com/eng/storeSection/redirect.cfm
b2cgiftcardprocessor_cardcode_ca=357
b2cgiftcardprocessor_cardcode_us=358
b2cgiftcardprocessor_clientid=0
b2cgiftcardprocessor_languageid=0
b2cgiftcardprocessor_operatorid=AldoWeb1
b2cgiftcardprocessor_password=ABBA
b2cgiftcardprocessor_serviceid=0
b2cgiftcardprocessor_terminalid1=14190
b2cgiftcardprocessor_terminalid2=14191
b2cgiftcardprocessor_username=AldoWeb1
b2cgiftcardprocessor_wsdl=https://webservices.certification.ernex.com
b2cgst_taxnumber=141088666
b2cimagepath_flag=/_static/webupload/723
b2citem_1_noimage=/image
b2citem_2_noimage=noImg_2.jpg
b2citem_3_noimage=noImg_3.jpg
b2clanguageid=eng
b2cmoduleincludepathroot=/aldoshoes/frontEndComponents/specificComponents/b2c
b2cmoduleinitincludepath=/aldoshoes/frontEndComponents/specificComponents/b2c/init
b2cmoduleinituserauthenticationincludepath=/aldoshoes/frontEndComponents/specificComponents/b2c/init/userAuthentication
b2cmodulepath=/frontEndComponents/specificComponents/b2c
b2corder=Struct (5)
b2corderstatus_back_ordered=7
b2corderstatus_cancelled=5
b2corderstatus_on_hold=11
b2corderstatus_on_hold_in_store=15
b2corderstatus_open=1
b2corderstatus_open_in_store=12
b2corderstatus_rejected_cs=10
b2corderstatus_rejected_fraud=9
b2corderstatus_shipped=4
b2corderstatus_shipped_in_store=14
b2corderstatus_submitted=2
b2corderstatus_submitted_in_store=13
b2cphysicalimagepath_flag=_static\webUpload\723
b2cpresentationmoduleincludepath=/aldoshoes/frontEndComponents/specificComponents/b2c/applicationLayer
b2cpresentationpresentationincludepath=/aldoshoes/frontEndComponents/specificComponents/b2c/presentationLayer
b2cpst_taxnumber=1003661977
b2crmastatus_completed=4
b2cservletpath=/frontEndComponents/specificComponents/b2c/servlet
b2cshoppingcart_cgi_path_info=/eng/shoppingCart/redirect.cfm
b2cstoreid=36
b2cvirtualimagepath_categorytitles=/static/webUpload/categoryTitles
b2cvirtualimagepath_color=/static/webUpload/720
b2cvirtualimagepath_flag=/static/webUpload/723
b2cvirtualimagepath_item=/static/webUpload/730
b2cvirtualimagepath_itemcolor=/static/webUpload/731
b2cxmlpath=D:\websites\aldoshoes_trunk\aldoshoes\\frontEndComponents\specificComponents\b2c\xml
badhitcountceiling=3
badhittimelag=10
bannerspath=/static/webUpload/33
baseimagesphysicalpath=D:\websites\aldoshoes_trunk\aldoshoes\\_static\images\www
basepath=
basestaticphysicalpath=D:\websites\aldoshoes_trunk\aldoshoes\\_static
basewwwphysicalpath=D:\websites\aldoshoes_trunk\aldoshoes\
cachedebuginfo=Array (8)
cachedirectory=D:\ProjectsCache\aldoshoes
cachedxmldocsstruct=StructNew()
cacheserverdata=Struct (3)
callpopularind=129,133,329,333,629,633
canaddgiftcardtoshoppingbag=True
castorehomepage=store.cfm?CKEY=CA
castoreid=36
catalogimagespath=e:\websites\aldoshoes\_static\webupload
ckey_cookiename=aldo_Cookieckey
colornoimage=/_static/webupload/720
componentspath=/frontEndComponents/genericComponents
componentspathinc=/aldoshoes/frontEndComponents/genericComponents
contactcmblock=aboutUs/contact.cfm
contentpath=/frontEndComponents/specificComponents
contentpathinc=/aldoshoes/frontEndComponents/specificComponents
contextsinitpath=/frontEndComponents/authentication/contextsInit
contextsinitpathinc=/aldoshoes/frontEndComponents/authentication/contextsInit
cookie_expiration_date=05/28/2012
cookiename=aldo_Cookie
coremetriccount=99
csspath=/css
dsn=aldoshoes
ebaydsn=icongoEbay
encryptionkey=pPgcrpfjOOY=
engdefaultextranetnewscategory=1
extranet_staging_datasource=extranetStaging
footwearlist=126,127,128,130,131,132,144,161,207,1791126,1127,1128,1130,1131,1132,1144,11611126,1127,1128,1130,1131,1132,1144,11613126,3127,3128,3130,3131,3132,3144,31615126,5127,5128,5130,5131,5132,5144,5161
fredefaultextranetnewscategory=1
frontendcomponentspath=/frontEndComponents
frontendcomponentspathinc=/aldoshoes/frontEndComponents
frontendcomponentsphysicalpath=D:\websites\aldoshoes_trunk\aldoshoes\/frontEndComponents
functions=Struct (183)
genfuncobj=Struct (130)
groupid=6
hackersafe=Struct (50)
hasflashdetectionmessage=<div class="noFlashMessage">You are seeing this message because your browser does not have a Flash player or your version of Flash is outdated.<BR><BR><a href=http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash target=_new>Click here</a> to download the latest Flash player from Macromedia's site.</div>
icongoadminphysicalpath=e:\websites\aldoshoes
icongodsn=icongoDev
imagespath=/_static/images/www
imgpath=
includepath=/aldoshoes
infoemail=test@icongo.com
initgeneric=
instoreobj=Struct (43)
istransactional=True
itemcatobj=Struct (10)
itemcolornoimage=/_static/webupload/731
itemsearchfunctions=Struct (7)
jslibrairiespath=/frontEndComponents/jsLibrairies
jslibrairiespathinc=/aldoshoes/frontEndComponents/jsLibrairies
language_cookiename=aldo_CookielanguageID
lastvisit_cookiename=aldo_CookieLASTVISIT
localbasephysicalpath=c:\projects\aldo_redesignDEV
locationsobj=Struct (10)
logged_in_cookiename=aldo_CookieloggedIn
mailserver=mail.icongomaildev.com
mainpage=CountrySelection.cfm
master=master
masterdsn=commonDB
memcached=Struct (9)
memcacheddebuginfo=[[2012-05-21 00:25:07] Application.cfm: looking for session, [2012-05-21 00:25:07] Creating key: 6DA435A8-19B9-FA37-C009AA739BC768BF6DA435B7-19B9-F, [2012-05-21 00:25:07] Cache API Version:  on Thu Apr 02 08:43:00 EDT 2009
Build platform:  java 1.5.0_16 from Apple Inc. on Mac OS X version 10.5.6
Tree version:  2.3.1, [2012-05-21 00:25:07] Cache Server Version: {/209.202.132.61:11234={1.4.2}}, [2012-05-21 00:25:07] Getting session from current node: Node01, [2012-05-21 00:25:07] -------------------------------------, [2012-05-21 00:25:08] OnRequestEnd.cfm: saving session, [2012-05-21 00:25:08] Saving session to cache server]
memcachedkey=6DA435A8-19B9-FA37-C009AA739BC768BF6DA435B7-19B9-F
memcachedlist=209.202.132.61:11234,209.202.132.61:11234
monerispaymentgateway_apitoken=hurgle
monerispaymentgateway_password=abc1234
monerispaymentgateway_storeid=moneris
monerispaymentgateway_url=https://esqa.moneris.com/gateway2/servlet/MpgRequest
monerispaymentgateway_username=demouser
newsimagepath=/_static/webUpload/news
newsletterobj=Struct (4)
noimage=/_static/webupload/730
nonauthenticatedimagespath=/_static/images/www/nonAuthenticated
numofdisplayresults=10
path_info=/store.cfm
paypal_buttonsource=iCongo_Channel_EC_CA
paypal_certpassword=icongopaypal
paypal_certpath=D:/websites/iCongoFramework/com/paypal/paypal_cert.p12
paypal_password=2WYA395K7UNFRXVA
paypal_paypalurl=https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=
paypal_proxyname=
paypal_proxyport=
paypal_serverurl=https://api.sandbox.paypal.com/nvp
paypal_signature=AFcWxV21C7fd0v3bYYYRCpSSRl31A-3P5oquBMVNd9kZxx57JtOYtkob 
paypal_usecertificate=Y
paypal_useproxy=false
paypal_username=azamud_1223994562_biz_api1.icongo.com
paypal_version=51
portcullis=Struct (25)
presentationlayercheckouttemplate=checkout
prodbasephysicalpath=d:\websites\aldoshoes
rootimagespath=/_static/images
sharedimagespath=/_static/images/www/Shared
shipmentstatus_ups_accesslicensenumber=ABDC14FEA0BC9AA4
shipmentstatus_ups_password=42001366
shipmentstatus_ups_url=https://www.ups.com/ups.app/xml/Track
shipmentstatus_ups_userid=THEALDOGROUPQC
sitefolder=aldoshoes
sitename=Aldo
siteurl=http://littleburgundy.icongostaging.com
siteurl_ssl=https://aldo.icongostaging.com
siteurllocale=http://littleburgundy.icongostaging.com/eng
staticpath=/_static
staticpathinc=/aldoshoes/_static
store=Struct (354)
store_cookiename=aldo_CookiestoreID
str_flagskey=CA
surveydsn=aldosurvey
ukey_cookiename=aldo_Cookieukey
usecache=true
usecachewhitespace=true
wwwpath=
wwwpathinc=/aldoshoes
xmlpath=D:\websites\aldoshoes_trunk\aldoshoes\/frontEndComponents\xml
youthaidsweb=www.youthaids-aldo.org

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
actuallang=eng
b2corder=Struct (5)
cacheserverinfo=Struct (3)
currencyid=
languageid=eng
loggedind=N
remote_addr=38.107.179.217
sessionid=5230ec96b1efaa59d8d57b4d7f127b2a3414
storeid=36
uattest=false
ukey=106381133
urltoken=CFID=1212672&CFTOKEN=6e7be7de8bf6297b-6DA435D7-19B9-FA37-C0F794E69E640390&jsessionid=5230ec96b1efaa59d8d57b4d7f127b2a3414
useremail=
userfirstname=
userlastname=
xmlenvironment=DEV

URL Parameters:
CKEY=ca
HOMEPAGE=Y
LANDINGPAGE=
LANG=eng