<% Set tdatacustomer = (CreateDictionary()) setArrElement tdatacustomer,".NumberOfChars",80 setArrElement tdatacustomer,".ShortName","customer" setArrElement tdatacustomer,".OwnerID","" setArrElement tdatacustomer,".OriginalTable","customer" Set fieldLabelscustomer = (CreateDictionary()) if IsEqual(mlang_getcurrentlang(),"English") then setArrElement fieldLabelscustomer,"English",CreateDictionary() setArrElement fieldToolTipscustomer,"English",CreateDictionary() setArrElementN fieldLabelscustomer,CreateArray2("English","FirstName"),"First Name" setArrElementN fieldToolTipscustomer,CreateArray2("English","FirstName"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","LastName"),"Last Name" setArrElementN fieldToolTipscustomer,CreateArray2("English","LastName"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","Salutation"),"Salutation" setArrElementN fieldToolTipscustomer,CreateArray2("English","Salutation"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","Position"),"Position" setArrElementN fieldToolTipscustomer,CreateArray2("English","Position"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","Organization"),"Organization" setArrElementN fieldToolTipscustomer,CreateArray2("English","Organization"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","Adress1"),"Adress1" setArrElementN fieldToolTipscustomer,CreateArray2("English","Adress1"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","Adress2"),"Adress2" setArrElementN fieldToolTipscustomer,CreateArray2("English","Adress2"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","City"),"City" setArrElementN fieldToolTipscustomer,CreateArray2("English","City"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","State"),"State" setArrElementN fieldToolTipscustomer,CreateArray2("English","State"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","Country"),"Country" setArrElementN fieldToolTipscustomer,CreateArray2("English","Country"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","PostalCode"),"Postal Code" setArrElementN fieldToolTipscustomer,CreateArray2("English","PostalCode"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","WorkPhone"),"Work Phone" setArrElementN fieldToolTipscustomer,CreateArray2("English","WorkPhone"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","CellPhone"),"Cell Phone" setArrElementN fieldToolTipscustomer,CreateArray2("English","CellPhone"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","FaxNumber"),"Fax Number" setArrElementN fieldToolTipscustomer,CreateArray2("English","FaxNumber"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","Email"),"Email" setArrElementN fieldToolTipscustomer,CreateArray2("English","Email"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","DateOfBirth"),"Date Of Birth" setArrElementN fieldToolTipscustomer,CreateArray2("English","DateOfBirth"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","ID"),"ID" setArrElementN fieldToolTipscustomer,CreateArray2("English","ID"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","PassportNo"),"Passport No" setArrElementN fieldToolTipscustomer,CreateArray2("English","PassportNo"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","VisaNo"),"Visa No" setArrElementN fieldToolTipscustomer,CreateArray2("English","VisaNo"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","VisaStatus"),"Visa Status" setArrElementN fieldToolTipscustomer,CreateArray2("English","VisaStatus"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","FinancialSponsor"),"Financial Sponsor" setArrElementN fieldToolTipscustomer,CreateArray2("English","FinancialSponsor"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","PaymentChoice"),"Payment Choice" setArrElementN fieldToolTipscustomer,CreateArray2("English","PaymentChoice"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","TravelDate"),"Travel Date" setArrElementN fieldToolTipscustomer,CreateArray2("English","TravelDate"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","AirlineOrFlight"),"Airline Or Flight" setArrElementN fieldToolTipscustomer,CreateArray2("English","AirlineOrFlight"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","HowReferred"),"How Referred" setArrElementN fieldToolTipscustomer,CreateArray2("English","HowReferred"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","RegisterCID"),"Register CID" setArrElementN fieldToolTipscustomer,CreateArray2("English","RegisterCID"),"" setArrElementN fieldLabelscustomer,CreateArray2("English","EssayOrCV"),"Essay Or CV" setArrElementN fieldToolTipscustomer,CreateArray2("English","EssayOrCV"),"" if bValue(asp_count(ArrayElement(fieldToolTipscustomer,"English"))) then setArrElement tdatacustomer,".isUseToolTips",true end if end if setArrElement tdatacustomer,".NCSearch",true setArrElement tdatacustomer,".shortTableName","customer" setArrElement tdatacustomer,".nSecOptions",0 setArrElement tdatacustomer,".recsPerRowList",1 setArrElement tdatacustomer,".tableGroupBy","0" setArrElement tdatacustomer,".mainTableOwnerID","" setArrElement tdatacustomer,".moveNext",1 setArrElement tdatacustomer,".showAddInPopup",false setArrElement tdatacustomer,".showEditInPopup",false setArrElement tdatacustomer,".showViewInPopup",false setArrElement tdatacustomer,".fieldsForRegister",CreateDictionary() setArrElement tdatacustomer,".listAjax",false setArrElement tdatacustomer,".audit",false setArrElement tdatacustomer,".locking",false setArrElement tdatacustomer,".listIcons",true setArrElement tdatacustomer,".edit",true setArrElement tdatacustomer,".inlineEdit",true setArrElement tdatacustomer,".view",true setArrElement tdatacustomer,".exportTo",true setArrElement tdatacustomer,".printFriendly",true setArrElement tdatacustomer,".delete",true setArrElement tdatacustomer,".showSimpleSearchOptions",false setArrElement tdatacustomer,".showSearchPanel",true setArrElement tdatacustomer,".isUseAjaxSuggest",true setArrElement tdatacustomer,".rowHighlite",true setArrElement tdatacustomer,".addPageEvents",false setArrElementN tdatacustomer,CreateArray2(".arrKeyFields",empty),"ID" setArrElement tdatacustomer,".isUseCalendarForSearch",true setArrElement tdatacustomer,".isUseTimeForSearch",false setArrElement tdatacustomer,".isUseiBox",false setArrElement tdatacustomer,".isUseInlineAdd",true setArrElement tdatacustomer,".isUseInlineEdit",true setArrElement tdatacustomer,".isUseInlineJs",bValue(ArrayElement(tdatacustomer,".isUseInlineAdd")) or bValue(ArrayElement(tdatacustomer,".isUseInlineEdit")) setArrElement tdatacustomer,".allSearchFields",CreateDictionary() setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"FirstName" if not bValue(asp_in_array("FirstName",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"FirstName" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"LastName" if not bValue(asp_in_array("LastName",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"LastName" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"Salutation" if not bValue(asp_in_array("Salutation",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Salutation" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"Position" if not bValue(asp_in_array("Position",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Position" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"Organization" if not bValue(asp_in_array("Organization",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Organization" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"Adress1" if not bValue(asp_in_array("Adress1",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Adress1" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"Adress2" if not bValue(asp_in_array("Adress2",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Adress2" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"City" if not bValue(asp_in_array("City",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"City" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"State" if not bValue(asp_in_array("State",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"State" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"Country" if not bValue(asp_in_array("Country",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Country" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"PostalCode" if not bValue(asp_in_array("PostalCode",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"PostalCode" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"WorkPhone" if not bValue(asp_in_array("WorkPhone",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"WorkPhone" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"CellPhone" if not bValue(asp_in_array("CellPhone",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"CellPhone" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"FaxNumber" if not bValue(asp_in_array("FaxNumber",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"FaxNumber" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"Email" if not bValue(asp_in_array("Email",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Email" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"DateOfBirth" if not bValue(asp_in_array("DateOfBirth",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"DateOfBirth" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"ID" if not bValue(asp_in_array("ID",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"ID" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"PassportNo" if not bValue(asp_in_array("PassportNo",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"PassportNo" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"VisaNo" if not bValue(asp_in_array("VisaNo",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"VisaNo" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"VisaStatus" if not bValue(asp_in_array("VisaStatus",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"VisaStatus" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"FinancialSponsor" if not bValue(asp_in_array("FinancialSponsor",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"FinancialSponsor" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"PaymentChoice" if not bValue(asp_in_array("PaymentChoice",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"PaymentChoice" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"TravelDate" if not bValue(asp_in_array("TravelDate",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"TravelDate" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"AirlineOrFlight" if not bValue(asp_in_array("AirlineOrFlight",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"AirlineOrFlight" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"HowReferred" if not bValue(asp_in_array("HowReferred",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"HowReferred" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"RegisterCID" if not bValue(asp_in_array("RegisterCID",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"RegisterCID" end if setArrElementN tdatacustomer,CreateArray2(".globSearchFields",empty),"EssayOrCV" if not bValue(asp_in_array("EssayOrCV",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"EssayOrCV" end if setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"FirstName" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"LastName" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"Salutation" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"Position" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"Organization" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"Adress1" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"Adress2" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"City" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"State" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"Country" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"PostalCode" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"WorkPhone" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"CellPhone" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"FaxNumber" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"Email" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"DateOfBirth" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"ID" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"PassportNo" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"VisaNo" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"VisaStatus" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"FinancialSponsor" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"PaymentChoice" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"TravelDate" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"AirlineOrFlight" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"HowReferred" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"RegisterCID" setArrElementN tdatacustomer,CreateArray2(".googleLikeFields",empty),"EssayOrCV" setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"FirstName" if not bValue(asp_in_array("FirstName",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"FirstName" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"LastName" if not bValue(asp_in_array("LastName",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"LastName" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"Salutation" if not bValue(asp_in_array("Salutation",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Salutation" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"Position" if not bValue(asp_in_array("Position",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Position" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"Organization" if not bValue(asp_in_array("Organization",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Organization" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"Adress1" if not bValue(asp_in_array("Adress1",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Adress1" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"Adress2" if not bValue(asp_in_array("Adress2",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Adress2" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"City" if not bValue(asp_in_array("City",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"City" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"State" if not bValue(asp_in_array("State",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"State" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"Country" if not bValue(asp_in_array("Country",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Country" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"PostalCode" if not bValue(asp_in_array("PostalCode",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"PostalCode" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"WorkPhone" if not bValue(asp_in_array("WorkPhone",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"WorkPhone" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"CellPhone" if not bValue(asp_in_array("CellPhone",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"CellPhone" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"FaxNumber" if not bValue(asp_in_array("FaxNumber",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"FaxNumber" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"Email" if not bValue(asp_in_array("Email",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"Email" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"DateOfBirth" if not bValue(asp_in_array("DateOfBirth",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"DateOfBirth" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"ID" if not bValue(asp_in_array("ID",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"ID" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"PassportNo" if not bValue(asp_in_array("PassportNo",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"PassportNo" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"VisaNo" if not bValue(asp_in_array("VisaNo",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"VisaNo" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"VisaStatus" if not bValue(asp_in_array("VisaStatus",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"VisaStatus" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"FinancialSponsor" if not bValue(asp_in_array("FinancialSponsor",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"FinancialSponsor" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"PaymentChoice" if not bValue(asp_in_array("PaymentChoice",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"PaymentChoice" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"TravelDate" if not bValue(asp_in_array("TravelDate",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"TravelDate" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"AirlineOrFlight" if not bValue(asp_in_array("AirlineOrFlight",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"AirlineOrFlight" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"HowReferred" if not bValue(asp_in_array("HowReferred",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"HowReferred" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"RegisterCID" if not bValue(asp_in_array("RegisterCID",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"RegisterCID" end if setArrElementN tdatacustomer,CreateArray2(".advSearchFields",empty),"EssayOrCV" if not bValue(asp_in_array("EssayOrCV",ArrayElement(tdatacustomer,".allSearchFields"),false)) then setArrElementN tdatacustomer,CreateArray2(".allSearchFields",empty),"EssayOrCV" end if setArrElement tdatacustomer,".isTableType","list" setArrElement tdatacustomer,".isDisplayLoading",true setArrElement tdatacustomer,".isResizeColumns",false setArrElement tdatacustomer,".subQueriesSupAccess",true setArrElement tdatacustomer,".pageSize",20 gstrOrderBy = "" if bValue(asp_strlen(gstrOrderBy)) and not IsEqual(asp_strtolower(asp_substr(gstrOrderBy,0,8)),"order by") then gstrOrderBy = "order by " & CSmartStr(gstrOrderBy) end if setArrElement tdatacustomer,".strOrderBy",gstrOrderBy setArrElement tdatacustomer,".orderindexes",CreateDictionary() setArrElement tdatacustomer,".sqlHead","SELECT FirstName, LastName, Salutation, `Position`, `Organization`, Adress1, Adress2, City, `State`, Country, PostalCode, WorkPhone, CellPhone, FaxNumber, Email, DateOfBirth, ID, PassportNo, VisaNo, VisaStatus, FinancialSponsor, PaymentChoice, TravelDate, AirlineOrFlight, HowReferred, RegisterCID, EssayOrCV" setArrElement tdatacustomer,".sqlFrom","FROM customer" setArrElement tdatacustomer,".sqlWhereExpr","" setArrElement tdatacustomer,".sqlTail","" Set arrRPP = (CreateDictionary()) setArrElement arrRPP,asp_count(arrRPP),10 setArrElement arrRPP,asp_count(arrRPP),20 setArrElement arrRPP,asp_count(arrRPP),30 setArrElement arrRPP,asp_count(arrRPP),50 setArrElement arrRPP,asp_count(arrRPP),100 setArrElement arrRPP,asp_count(arrRPP),500 setArrElement arrRPP,asp_count(arrRPP),-1 setArrElement tdatacustomer,".arrRecsPerPage",arrRPP Set arrGPP = (CreateDictionary()) setArrElement arrGPP,asp_count(arrGPP),1 setArrElement arrGPP,asp_count(arrGPP),3 setArrElement arrGPP,asp_count(arrGPP),5 setArrElement arrGPP,asp_count(arrGPP),10 setArrElement arrGPP,asp_count(arrGPP),50 setArrElement arrGPP,asp_count(arrGPP),100 setArrElement arrGPP,asp_count(arrGPP),-1 setArrElement tdatacustomer,".arrGroupsPerPage",arrGPP Set tableKeys = (CreateDictionary()) setArrElement tableKeys,asp_count(tableKeys),"ID" setArrElement tdatacustomer,".Keys",tableKeys Set fdata = (CreateDictionary()) setArrElement fdata,"strName","FirstName" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","First Name" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","FirstName" setArrElement fdata,"FullName","FirstName" setArrElement fdata,"Index",1 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=20" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"FirstName",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","LastName" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Last Name" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","LastName" setArrElement fdata,"FullName","LastName" setArrElement fdata,"Index",2 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=20" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"LastName",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","Salutation" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","Salutation" setArrElement fdata,"FullName","Salutation" setArrElement fdata,"Index",3 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=10" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"Salutation",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","Position" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","Position" setArrElement fdata,"FullName","`Position`" setArrElement fdata,"Index",4 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=30" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"Position",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","Organization" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","Organization" setArrElement fdata,"FullName","`Organization`" setArrElement fdata,"Index",5 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=50" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"Organization",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","Adress1" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","Adress1" setArrElement fdata,"FullName","Adress1" setArrElement fdata,"Index",6 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=50" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"Adress1",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","Adress2" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","Adress2" setArrElement fdata,"FullName","Adress2" setArrElement fdata,"Index",7 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=50" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"Adress2",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","City" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","City" setArrElement fdata,"FullName","City" setArrElement fdata,"Index",8 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=20" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"City",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","State" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","State" setArrElement fdata,"FullName","`State`" setArrElement fdata,"Index",9 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=20" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"State",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","Country" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","Country" setArrElement fdata,"FullName","Country" setArrElement fdata,"Index",10 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=30" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"Country",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","PostalCode" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Postal Code" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","PostalCode" setArrElement fdata,"FullName","PostalCode" setArrElement fdata,"Index",11 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=20" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"PostalCode",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","WorkPhone" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Work Phone" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","WorkPhone" setArrElement fdata,"FullName","WorkPhone" setArrElement fdata,"Index",12 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=15" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"WorkPhone",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","CellPhone" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Cell Phone" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","CellPhone" setArrElement fdata,"FullName","CellPhone" setArrElement fdata,"Index",13 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=15" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"CellPhone",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","FaxNumber" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Fax Number" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","FaxNumber" setArrElement fdata,"FullName","FaxNumber" setArrElement fdata,"Index",14 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=15" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"FaxNumber",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","Email" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","Email" setArrElement fdata,"FullName","Email" setArrElement fdata,"Index",15 setArrElement fdata,"EditParams","" setArrElement fdata,"EditParams",CSmartStr(ArrayElement(fdata,"EditParams")) & " maxlength=30" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"Email",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","DateOfBirth" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Date Of Birth" setArrElement fdata,"FieldType",7 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Date" setArrElement fdata,"ViewFormat","Short Date" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","DateOfBirth" setArrElement fdata,"FullName","DateOfBirth" setArrElement fdata,"Index",16 setArrElement fdata,"DateEditType",13 setArrElement fdata,"InitialYearFactor",100 setArrElement fdata,"LastYearFactor",10 setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"DateOfBirth",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","ID" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"FieldType",3 setArrElement fdata,"AutoInc",true setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","ID" setArrElement fdata,"FullName","ID" setArrElement fdata,"IsRequired",true setArrElement fdata,"Index",17 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElementN fdata,CreateArray3("validateAs","basicValidate",empty),getJsValidatorName("Number") setArrElementN fdata,CreateArray3("validateAs","basicValidate",empty),"IsRequired" setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"ID",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","PassportNo" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Passport No" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","PassportNo" setArrElement fdata,"FullName","PassportNo" setArrElement fdata,"Index",18 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"PassportNo",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","VisaNo" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Visa No" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","VisaNo" setArrElement fdata,"FullName","VisaNo" setArrElement fdata,"Index",19 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"VisaNo",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","VisaStatus" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Visa Status" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","VisaStatus" setArrElement fdata,"FullName","VisaStatus" setArrElement fdata,"Index",20 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"VisaStatus",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","FinancialSponsor" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Financial Sponsor" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","FinancialSponsor" setArrElement fdata,"FullName","FinancialSponsor" setArrElement fdata,"Index",21 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"FinancialSponsor",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","PaymentChoice" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Payment Choice" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","PaymentChoice" setArrElement fdata,"FullName","PaymentChoice" setArrElement fdata,"Index",22 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"PaymentChoice",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","TravelDate" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Travel Date" setArrElement fdata,"FieldType",7 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Date" setArrElement fdata,"ViewFormat","Short Date" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","TravelDate" setArrElement fdata,"FullName","TravelDate" setArrElement fdata,"Index",23 setArrElement fdata,"DateEditType",13 setArrElement fdata,"InitialYearFactor",100 setArrElement fdata,"LastYearFactor",10 setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"TravelDate",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","AirlineOrFlight" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Airline Or Flight" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","AirlineOrFlight" setArrElement fdata,"FullName","AirlineOrFlight" setArrElement fdata,"Index",24 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"AirlineOrFlight",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","HowReferred" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","How Referred" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","HowReferred" setArrElement fdata,"FullName","HowReferred" setArrElement fdata,"Index",25 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"HowReferred",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","RegisterCID" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Register CID" setArrElement fdata,"FieldType",3 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","RegisterCID" setArrElement fdata,"FullName","RegisterCID" setArrElement fdata,"Index",26 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElementN fdata,CreateArray3("validateAs","basicValidate",empty),getJsValidatorName("Number") setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"RegisterCID",fdata Set fdata = (CreateDictionary()) setArrElement fdata,"strName","EssayOrCV" setArrElement fdata,"ownerTable","customer" setArrElement fdata,"Label","Essay Or CV" setArrElement fdata,"FieldType",200 setArrElement fdata,"UseiBox",false setArrElement fdata,"EditFormat","Text field" setArrElement fdata,"ViewFormat","" setArrElement fdata,"NeedEncode",true setArrElement fdata,"GoodName","EssayOrCV" setArrElement fdata,"FullName","EssayOrCV" setArrElement fdata,"Index",27 setArrElement fdata,"EditParams","" setArrElement fdata,"bListPage",true setArrElement fdata,"bAddPage",true setArrElement fdata,"bInlineAdd",true setArrElement fdata,"bEditPage",true setArrElement fdata,"bInlineEdit",true setArrElement fdata,"bViewPage",true setArrElement fdata,"bAdvancedSearch",true setArrElement fdata,"bPrinterPage",true setArrElement fdata,"bExportPage",true setArrElement fdata,"validateAs",CreateDictionary() setArrElement fdata,"FieldPermissions",true setArrElement tdatacustomer,"EssayOrCV",fdata setArrElementByRef tables_data,"customer",tdatacustomer setArrElementByRef field_labels,"customer",fieldLabelscustomer setArrElementByRef fieldToolTips,"customer",fieldToolTipscustomer setArrElement detailsTablesData,"customer",CreateDictionary() dIndex = CSmartDbl(1)-1 strOriginalDetailsTable = "courses" setArrElementN detailsTablesData,CreateArray2("customer",dIndex),CreateDictionary16("dDataSourceTable","courses","dOriginalTable",strOriginalDetailsTable,"dShortTable","courses","masterKeys",CreateDictionary(),"detailKeys",CreateDictionary(),"dispChildCount","1","hideChild","0","sqlHead","SELECT CourseID, CourseTitle, CEUCredit, Location, CourseDates, DurationInDays, Tuitionfees","sqlFrom","FROM courses","sqlWhere","","sqlTail","","groupBy","0","previewOnList",0,"previewOnAdd",0,"previewOnEdit",0,"previewOnView",0) setArrElementN detailsTablesData,CreateArray4("customer",dIndex,"masterKeys",empty),"RegisterCID" setArrElementN detailsTablesData,CreateArray4("customer",dIndex,"detailKeys",empty),"CourseID" setArrElement masterTablesData,"customer",CreateDictionary() asp_include getabspath("classes/sql.asp"),true Set proto40 = (CreateDictionary()) setArrElement proto40,"m_strHead","SELECT" setArrElement proto40,"m_strFieldList","FirstName, LastName, Salutation, `Position`, `Organization`, Adress1, Adress2, City, `State`, Country, PostalCode, WorkPhone, CellPhone, FaxNumber, Email, DateOfBirth, ID, PassportNo, VisaNo, VisaStatus, FinancialSponsor, PaymentChoice, TravelDate, AirlineOrFlight, HowReferred, RegisterCID, EssayOrCV" setArrElement proto40,"m_strFrom","FROM customer" setArrElement proto40,"m_strWhere","" setArrElement proto40,"m_strOrderBy","" setArrElement proto40,"m_strTail","" Set proto41 = (CreateDictionary()) setArrElement proto41,"m_sql","" setArrElement proto41,"m_uniontype","SQLL_UNKNOWN" Set obj = (CreateClass("SQLNonParsed",1,CreateDictionary1("m_sql",""),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto41,"m_column",obj setArrElement proto41,"m_contained",CreateDictionary() setArrElement proto41,"m_strCase","" setArrElement proto41,"m_havingmode","0" setArrElement proto41,"m_inBrackets","0" setArrElement proto41,"m_useAlias","0" Set obj = (CreateClass("SQLLogicalExpr",1,proto41,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto40,"m_where",obj Set proto43 = (CreateDictionary()) setArrElement proto43,"m_sql","" setArrElement proto43,"m_uniontype","SQLL_UNKNOWN" Set obj = (CreateClass("SQLNonParsed",1,CreateDictionary1("m_sql",""),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto43,"m_column",obj setArrElement proto43,"m_contained",CreateDictionary() setArrElement proto43,"m_strCase","" setArrElement proto43,"m_havingmode","0" setArrElement proto43,"m_inBrackets","0" setArrElement proto43,"m_useAlias","0" Set obj = (CreateClass("SQLLogicalExpr",1,proto43,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto40,"m_having",obj setArrElement proto40,"m_fieldlist",CreateDictionary() Set proto45 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","FirstName","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto45,"m_expr",obj setArrElement proto45,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto45,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto47 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","LastName","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto47,"m_expr",obj setArrElement proto47,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto47,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto49 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","Salutation","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto49,"m_expr",obj setArrElement proto49,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto49,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto51 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","Position","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto51,"m_expr",obj setArrElement proto51,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto51,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto53 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","Organization","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto53,"m_expr",obj setArrElement proto53,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto53,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto55 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","Adress1","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto55,"m_expr",obj setArrElement proto55,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto55,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto57 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","Adress2","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto57,"m_expr",obj setArrElement proto57,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto57,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto59 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","City","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto59,"m_expr",obj setArrElement proto59,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto59,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto61 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","State","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto61,"m_expr",obj setArrElement proto61,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto61,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto63 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","Country","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto63,"m_expr",obj setArrElement proto63,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto63,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto65 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","PostalCode","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto65,"m_expr",obj setArrElement proto65,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto65,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto67 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","WorkPhone","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto67,"m_expr",obj setArrElement proto67,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto67,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto69 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","CellPhone","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto69,"m_expr",obj setArrElement proto69,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto69,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto71 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","FaxNumber","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto71,"m_expr",obj setArrElement proto71,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto71,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto73 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","Email","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto73,"m_expr",obj setArrElement proto73,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto73,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto75 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","DateOfBirth","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto75,"m_expr",obj setArrElement proto75,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto75,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto77 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","ID","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto77,"m_expr",obj setArrElement proto77,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto77,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto79 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","PassportNo","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto79,"m_expr",obj setArrElement proto79,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto79,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto81 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","VisaNo","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto81,"m_expr",obj setArrElement proto81,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto81,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto83 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","VisaStatus","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto83,"m_expr",obj setArrElement proto83,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto83,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto85 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","FinancialSponsor","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto85,"m_expr",obj setArrElement proto85,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto85,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto87 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","PaymentChoice","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto87,"m_expr",obj setArrElement proto87,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto87,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto89 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","TravelDate","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto89,"m_expr",obj setArrElement proto89,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto89,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto91 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","AirlineOrFlight","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto91,"m_expr",obj setArrElement proto91,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto91,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto93 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","HowReferred","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto93,"m_expr",obj setArrElement proto93,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto93,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto95 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","RegisterCID","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto95,"m_expr",obj setArrElement proto95,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto95,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj Set proto97 = (CreateDictionary()) Set obj = (CreateClass("SQLField",1,CreateDictionary2("m_strName","EssayOrCV","m_strTable","customer"),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto97,"m_expr",obj setArrElement proto97,"m_alias","" Set obj = (CreateClass("SQLFieldListItem",1,proto97,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fieldlist",empty),obj setArrElement proto40,"m_fromlist",CreateDictionary() Set proto99 = (CreateDictionary()) setArrElement proto99,"m_link","SQLL_MAIN" Set proto100 = (CreateDictionary()) setArrElement proto100,"m_strName","customer" setArrElement proto100,"m_columns",CreateDictionary() setArrElementN proto100,CreateArray2("m_columns",empty),"FirstName" setArrElementN proto100,CreateArray2("m_columns",empty),"LastName" setArrElementN proto100,CreateArray2("m_columns",empty),"Salutation" setArrElementN proto100,CreateArray2("m_columns",empty),"Position" setArrElementN proto100,CreateArray2("m_columns",empty),"Organization" setArrElementN proto100,CreateArray2("m_columns",empty),"Adress1" setArrElementN proto100,CreateArray2("m_columns",empty),"Adress2" setArrElementN proto100,CreateArray2("m_columns",empty),"City" setArrElementN proto100,CreateArray2("m_columns",empty),"State" setArrElementN proto100,CreateArray2("m_columns",empty),"Country" setArrElementN proto100,CreateArray2("m_columns",empty),"PostalCode" setArrElementN proto100,CreateArray2("m_columns",empty),"WorkPhone" setArrElementN proto100,CreateArray2("m_columns",empty),"CellPhone" setArrElementN proto100,CreateArray2("m_columns",empty),"FaxNumber" setArrElementN proto100,CreateArray2("m_columns",empty),"Email" setArrElementN proto100,CreateArray2("m_columns",empty),"DateOfBirth" setArrElementN proto100,CreateArray2("m_columns",empty),"ID" setArrElementN proto100,CreateArray2("m_columns",empty),"PassportNo" setArrElementN proto100,CreateArray2("m_columns",empty),"VisaNo" setArrElementN proto100,CreateArray2("m_columns",empty),"VisaStatus" setArrElementN proto100,CreateArray2("m_columns",empty),"FinancialSponsor" setArrElementN proto100,CreateArray2("m_columns",empty),"PaymentChoice" setArrElementN proto100,CreateArray2("m_columns",empty),"TravelDate" setArrElementN proto100,CreateArray2("m_columns",empty),"AirlineOrFlight" setArrElementN proto100,CreateArray2("m_columns",empty),"HowReferred" setArrElementN proto100,CreateArray2("m_columns",empty),"RegisterCID" setArrElementN proto100,CreateArray2("m_columns",empty),"EssayOrCV" Set obj = (CreateClass("SQLTable",1,proto100,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto99,"m_table",obj setArrElement proto99,"m_alias","" Set proto101 = (CreateDictionary()) setArrElement proto101,"m_sql","" setArrElement proto101,"m_uniontype","SQLL_UNKNOWN" Set obj = (CreateClass("SQLNonParsed",1,CreateDictionary1("m_sql",""),Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto101,"m_column",obj setArrElement proto101,"m_contained",CreateDictionary() setArrElement proto101,"m_strCase","" setArrElement proto101,"m_havingmode","0" setArrElement proto101,"m_inBrackets","0" setArrElement proto101,"m_useAlias","0" Set obj = (CreateClass("SQLLogicalExpr",1,proto101,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElement proto99,"m_joinon",obj Set obj = (CreateClass("SQLFromListItem",1,proto99,Empty,Empty,Empty,Empty,Empty,Empty)) setArrElementN proto40,CreateArray2("m_fromlist",empty),obj setArrElement proto40,"m_groupby",CreateDictionary() setArrElement proto40,"m_orderby",CreateDictionary() Set obj = (CreateClass("SQLQuery",1,proto40,Empty,Empty,Empty,Empty,Empty,Empty)) doAssignment queryData_customer,obj setArrElement tdatacustomer,".sqlquery",queryData_customer setArrElement tableEvents,"customer",CreateClass("eventsBase",0,Empty,Empty,Empty,Empty,Empty,Empty,Empty) %>