Element ph32 is undefined in a CFML structure referenced as part of an expression.
	    

			SELECT 	pathCss,group_id,group_name
			FROM   	b2c_groups
			WHERE 	url like '%lordandtaylor.icongodev.com|%'
	 

			SELECT store_id,url,ckey
			FROM   b2c_stores
			WHERE store_id !=0
			AND group_id =1 

     			SELECT 	DISTINCT
     					level1ID
     			,		level2ID
     			,		level3ID
     			,         level4ID
     			,		engLevel1 as level1Desc
     			,		engLevel2 as level2Desc
     			,		engLevel3 as level3Desc
     			,		engLevel4 as level4Desc
     			,		level1ID_sequence as level1Sec
     			,		level2ID_sequence as level2Sec
     			,		level3ID_sequence as level3Sec
     			,		level3ID_sequence as level4Sec
     			,		level3_pop as pop
     			FROM 	search_b2c_store_item_categories WITH(NOLOCK)
     			WHERE	store_id = ? 

			SELECT 	 newsletter_category_id
			FROM   	newsletter_categories
			WHERE 	group_id =1
			AND     language_id = 'eng'
			and		active_ind = 'Y'
	 

			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
			(	''
			,	26
			,	''
			, 	'38.107.191.87'
			, 	'lordandtaylor.icongodev.com'
			,	'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
			, 	''
			,	'5311211--CFID=120120&CFTOKEN=1b2bd76d58db410-26019916-CE72-553A-E3363C8F18F37215&jsessionid=a830da822755e45a8e001e796e255e606f23'
			,	'eng'
			,	''
			,	''
			,	''
			,	''
			,	''
			,	''
			,	''
			,	''
			,	GETDATE()
			,	GETDATE()
			,	GETDATE()
			,	0
			,	'Y'
			,	'Y'
			)

			SELECT @@IDENTITY AS 'Identity'
		

	select	first_name
	,	last_name
	,	email_1
	from	b2c_users
	where	ukey = ? 

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

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

				   select b2c_store_accounts.member_company_id
				   from b2c_store_accounts, b2c_users
				   where b2c_store_accounts.store_id=26
				   and b2c_users.store_id=26
				   and b2c_store_accounts.member_company_id=b2c_users.member_company_id
				   and b2c_store_accounts.approved_ind ='Y'
				   and b2c_users.ukey=14501151 

		select order_id
		from b2c_orders
		where ukey = 14501151
		and order_status_id = 1
	

			SELECT 	ckey
			FROM   	b2c_stores
			WHERE 	store_id = '26'
		

		SELECT country_id
		FROM ip_countries
		WHERE 644595543 BETWEEN start_number_ip AND end_number_ip
	

				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
				
				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 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 from application.banners.qry where 'lordandtaylor' = 'lordandtaylor' and banner_placeholder_id in (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,25,27,32,52,53,54,55,56,57,58,59) and language_id = 'eng' and active_ind = 'Y' and member_company_id = 100000 and store_id in (0,26) 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 *
			FROM ebay_stores
			WHERE ebay_store_id = ?
			AND active_ind = 'Y'
		

Application Variables:
advancedsurveyadmincustomtagdir=/websiteTags/admin/advanced_surveyV7/
advancedsurveyfrontendcustomtagdir=/websiteTags/frontEnd/advanced_surveyV7/
applicationname=lordandtaylor_www_parent
banners=Struct (5)
bannerspath=/_static/webUpload/33
basepath=
basephysicalpath=E:\websites\lordAndTaylor\
basephysicalpathinc=E:\websites\lordAndTaylor\
basewwwphysicalpath=E:\websites\lordAndTaylor\
cachedxmldocsstruct=Struct (0)
clusterlist=,127.0.0.1,66.46.83.203:8301
dbcolumncheck=Struct (2)
dummysurveycompanyid=999999
dummysurveycompanyroleid=N
dummysurveyuserroleid=99
ebay=Struct (22)
generic=Struct (115)
getallsstore=Query (1)
mycaptcha=Struct (15)
portcullis=Struct (22)
privatenetworkid=0
redirecturl=http://lordandtaylor.icongodev.com
refreshapp=false
search=Struct (7)
sitename=lordandtaylor
store26=Struct (388)
storeobj=Struct (1)
xmlparser=Struct (1)
xmlpath=E:\websites\lordAndTaylor\/frontEndComponents\specificComponents\b2c\xml\default

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=E:\websites\lordAndTaylor\lordAndTaylor\error404.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=lordandtaylor.icongodev.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/error404.cfm
PATH_TRANSLATED=E:\websites\lordAndTaylor\lordAndTaylor\error404.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.87
REMOTE_HOST=38.107.191.87
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/error404.cfm
SERVER_NAME=lordandtaylor.icongodev.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=120120
cftoken=1b2bd76d58db410-26019916-CE72-553A-E3363C8F18F37215
hitcount=1
lastvisit={ts '2010-07-30 20:58:13'}
timecreated={ts '2010-07-30 20:58:13'}
urltoken=CFID=120120&CFTOKEN=1b2bd76d58db410-26019916-CE72-553A-E3363C8F18F37215&jsessionid=a830da822755e45a8e001e796e255e606f23

Cookie Variables:
CFID=120120
CFTOKEN=1b2bd76d58db410-26019916-CE72-553A-E3363C8F18F37215
LORDANDTAYLOR_COOKIELANGUAGEID=eng
LORDANDTAYLOR_COOKIESTOREID=26
LORDANDTAYLOR_COOKIEUKEY=14501151

Request Parameters:
addtourl=&var=d&ckey=US
admingenericcomponentspathpath=/admin/content/genericComponents
adminpath=/admin
adminurl=http://lordandtaylor.icongodev.com
advancedsurveyadmincustomtagdir=/websiteTags/admin/advanced_survey/
advancedsurveyfrontendcustomtagdir=/websiteTags/frontEnd/advanced_survey/
ajaxpath=/icongoFrameWork//cfajax/core/
appname=lordandtaylor
authenticatedimagespath=/_static/images/www/Authenticated
authenticationpath=/frontEndComponents/authentication
authenticationpathinc=/lordAndTaylor/frontEndComponents/authentication
b2c_ups_package_type=
b2c_ups_terms_of_sale=
b2ccachinglevel_1=0
b2ccachinglevel_2=0
b2ccachinglevel_3=0
b2ccachinglevel_4=0
b2ccachinglevel_5=0
b2ccheckout_cgi_path_info=http://lordandtaylor.icongodev.com/eng/checkout/redirect.cfm
b2ccolor_1_noimage=noImg_1.jpg
b2ccustomerservicesectiondirectory=customerService
b2cemailtemplatepath=E:\websites\lordAndTaylor\\frontEndComponents\specificComponents\b2c\emailTemplates
b2cemptytemplatesection_cgi_path_info=/eng/emptyTemplateSection/redirect.cfm
b2cgeneral_cgi_path_info=http://lordandtaylor.icongodev.com/eng/storeSection/redirect.cfm
b2cgiftcardprocessor_cardcode_ca=357
b2cgiftcardprocessor_cardcode_us=358
b2cgiftcardprocessor_clientid=0
b2cgiftcardprocessor_languageid=0
b2cgiftcardprocessor_operatorid=
b2cgiftcardprocessor_password=
b2cgiftcardprocessor_serviceid=0
b2cgiftcardprocessor_terminalid1=14190
b2cgiftcardprocessor_terminalid2=14191
b2cgiftcardprocessor_username=
b2cgiftcardprocessor_wsdl=http://webserviceuct.lordandtaylor.us
b2cgst_taxnumber=141088666
b2cimagepath_flag=/_static/webupload/723
b2citem_1_noimage=noImg_1.jpg
b2citem_2_noimage=noImg_2.jpg
b2citem_3_noimage=noImg_3.jpg
b2clanguageid=eng
b2cmoduleincludepathroot=/lordAndTaylor/frontEndComponents/specificComponents/b2c
b2cmoduleinitincludepath=/lordAndTaylor/frontEndComponents/specificComponents/b2c/init
b2cmoduleinituserauthenticationincludepath=/lordAndTaylor/frontEndComponents/specificComponents/b2c/init/userAuthentication
b2cmodulepath=/frontEndComponents/specificComponents/b2c
b2corder=Struct (5)
b2corderstatus_back_ordered=7
b2corderstatus_cancelled=5
b2corderstatus_on_hold=11
b2corderstatus_open=1
b2corderstatus_rejected_cs=10
b2corderstatus_rejected_fraud=9
b2corderstatus_shipped=4
b2corderstatus_submitted=2
b2cphysicalimagepath_flag=_static\webUpload\723
b2cpresentationmoduleincludepath=/lordAndTaylor/frontEndComponents/specificComponents/b2c/applicationLayer
b2cpresentationpresentationincludepath=/lordAndTaylor/presentationLayer
b2cpst_taxnumber=1003661977
b2crmastatus_completed=4
b2cservletpath=/frontEndComponents/specificComponents/b2c/servlet
b2cshoppingcart_cgi_path_info=/eng/shoppingCart/redirect.cfm
b2cstoreid=26
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=E:\websites\lordAndTaylor\\frontEndComponents\specificComponents\b2c\xml
badhitcountceiling=3
badhittimelag=10
bannerspath=/_static/webUpload/33
baseimagesphysicalpath=baseStaticPhysicalPath\images\www
basepath=
basephisicalpath=E:\websites\lordAndTaylor
basestaticphysicalpath=E:\websites\lordAndTaylor\\_static
basewwwphysicalpath=E:\websites\lordAndTaylor\
buyerloginpage=memberIndexB.cfm
bypassexpandpathfornetworkdrives=false
cachedirectory=C:\ProjectsCache\lordAndTaylor
cachedxmldocsstruct=StructNew()
callpopularind=129,133,329,333,629,633
catalogimagespath=d:\websites\icongo_dev\_static\webupload
categoryobj=Struct (8)
cferrorbrowserskiplist=ScanAlert,ia_archiver,Googlebot
cferroremail=schan@icongo.com, rvergara@icongo.com
colornoimage=/_static/webupload/720
componentspath=/frontEndComponents/genericComponents
componentspathinc=/lordAndTaylor/frontEndComponents/genericComponents
contactcmblock=aboutUs/contact.cfm
contentpath=/frontEndComponents/specificComponents
contentpathinc=/lordAndTaylor/frontEndComponents/specificComponents
contextsinitpath=/frontEndComponents/authentication/contextsInit
contextsinitpathinc=/lordAndTaylor/frontEndComponents/authentication/contextsInit
cookie_expiration_date=never
cookiename=lordandtaylor_Cookie
csspath=/css
currentcategorytree=Query (476)
cybersourcedisableavsscoring=true
cybersourcemerchantid=lordandtaylor
cybersourceorgid=1snn5n9w
cybersourcepassword=Shiva123
cybersourcereportqueryurl=https://ebctest.cybersource.com/ebctest/ConversionDetailReportRequest.do
cybersourceusername=lordandtaylor
dsn=lordandtaylor
ebaydsn=icongoEbay
encryptionkey=B0nZV7pSZFg=
engdefaultextranetnewscategory=1
extranetbuyergeneralscript=/nonAuthSection/progRedirect.cfm
extranetgeneralscript=/nonAuthSection/redirect.cfm
extranetgeneralscriptnomenus=/nonAuthSection/redirect.cfm
extranetsalesrepgeneralscript=/nonAuthSection/progRedirect.cfm
extranetvendorgeneralscript=/nonAuthSection/redirect.cfm
footwearlist=
fredefaultextranetnewscategory=1
frontendcomponentspath=/frontEndComponents
frontendcomponentspathinc=/lordAndTaylor/frontEndComponents
frontendcomponentsphysicalpath=E:\websites\lordAndTaylor\/frontEndComponents
functions=Struct (149)
genfuncobj=Struct (137)
giftcardobj=Struct (64)
groupid=1
hackersafe=Struct (48)
http_host=lordandtaylor.icongodev.com
icongoadminphysicalpath=d:\websites\icongo_dev
icongoframeworkversion=V7
imagespath=/_static/images/www
imgpath=
includepath=/lordAndTaylor
infoemail=info@lordandtaylor.icongodev.com
initgeneric=
instoreobj=Struct (43)
ispda=NO
istransactional=TRUE
itemcatobj=Struct (12)
itemcolornoimage=/_static/webupload/731
itemsearchfunctions=Struct (12)
jslibrairiespath=/frontEndComponents/jsLibrairies
jslibrairiespathinc=/lordAndTaylor/frontEndComponents/jsLibrairies
language_cookiename=lordandtaylor_CookielanguageID
localbasephysicalpath=c:\projects\lordandtaylor
locationsobj=Struct (2)
logged_in_cookiename=lordandtaylor_CookieloggedIn
mailserver=mail.icongomaildev.com
mainpage=aldoCountrySelection.cfm
master=commondb
masterdsn=commonDB
monerispaymentgateway_apitoken=yesguy
monerispaymentgateway_password=password
monerispaymentgateway_storeid=store5
monerispaymentgateway_url=https://esqa.moneris.com:43924/gateway2/servlet/MpgRequest
monerispaymentgateway_username=DemoUser
newsimagepath=/_static/webUpload/news
newsletterobj=Struct (8)
noimage=/_static/webupload/730
nonauthenticatedimagespath=/_static/images/www/nonAuthenticated
numofdisplayresults=10
paymentsobj=Struct (69)
paypal_buttonsource=iCongo_Channel_EC_CA
paypal_password=YGWV9PEKX9SWNH3V
paypal_paypalurl=https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=
paypal_proxyname=
paypal_proxyport=
paypal_serverurl=https://api-3t.sandbox.paypal.com/nvp
paypal_signature=A0vGGXyW0R9lG3TfHoAuTe6FCaW-ABj1rc4EMZrGlLiJ5Y-vmAnn1jzU
paypal_useproxy=false
paypal_username=xlu_1209734439_biz_api1.icongo.com
paypal_version=51.0
portcullis=Struct (22)
privatenetworkid=1234680381
prodbasephysicalpath=d:\websites\lordandtaylor
remote_addr=38.107.191.87
rootimagespath=/_static/images
server_name=lordandtaylor.icongodev.com
sharedimagespath=/_static/images/www/Shared
sharedpages=/sharedPages
sharedpages1=/sharedPages/
shipmentstatus_ups_accesslicensenumber=BC0E7C80D9934B54
shipmentstatus_ups_password=
shipmentstatus_ups_url=https://www.ups.com/ups.app/xml/Track
shipmentstatus_ups_userid=
sitefolder=lordandtaylor
sitename=lordandtaylor
siteurl=http://lordandtaylor.icongodev.com
siteurl_ssl=https://lordandtaylor.icongodev.com
siteurllocale=http://lordandtaylor.icongodev.com/eng
siteurlnossl=http://lordandtaylor.icongodev.com
staticpath=/_static
staticpathinc=/lordAndTaylor/_static
store=Struct (388)
store_cookiename=lordandtaylor_CookiestoreID
str_flagskey=US
ukey_cookiename=lordandtaylor_Cookieukey
usecache=true
usecachewhitespace=true
usstorehomepage=store.cfm?CKEY=US
usstoreid=26
vendorloginpage=memberIndexV.cfm
wwwpath= 
wwwpathinc=/lordAndTaylor
xmlpath=E:\websites\lordAndTaylor\/frontEndComponents\specificComponents\b2c\xml\default
youthaidsweb=youthaids.icongostaging.com

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

Session Variables:
actuallang=eng
b2corder=Struct (5)
currencyid=USD
ipcountry=
loggedind=N
sessionid=a830da822755e45a8e001e796e255e606f23
storeid=26
ukey=14501151
urltoken=CFID=120120&CFTOKEN=1b2bd76d58db410-26019916-CE72-553A-E3363C8F18F37215&jsessionid=a830da822755e45a8e001e796e255e606f23
useremail=
userfirstname=
userlastname=

URL Parameters:
CKEY=US