returnData = createObject("component","company"); returnData.ErrorCD = variables.ErrorCD; returnData.ErrorTXT = variables.ErrorTXT; returnData.sid = server.fse_identity; returnData.FRBrokerID = ""; returnData.BrokerName = ""; returnData.Address1 = ""; returnData.Address2 = ""; returnData.City = ""; returnData.State = ""; returnData.Zip = ""; returnData.FirstName = ""; returnData.LastName = ""; returnData.Email = ""; returnData.Phone = ""; ---> select zipcode from tbl_SSD_NoFedxZips where zipcode = select InternalSalesID as data from tbl_TER_Territories where ownerid = #application.OwnerID# and fsl_tablecode = 'MFR' and territoryid = select data from tbl_TER_FieldValues fv, tbl_TER_Fields f where fv.fieldid = f.fieldid and f.name = 'FundRaisingID' and fv.partnerid = and fv.partnertype = 'ter' ContactGroupID=4269 DocLibVersion="2.0" dsn="#application.dsn#" >