ReturnStruct

public struct function getCompanyDetails(required string cc){

var cd = queryExecute("Select mfgCode,name,nameAlt,street,address2,city,state,county,postalCode,
country,phone,phoneTollFree,fax,url,corpEmail,manufacturer,distributor,calibrates_test_eq,specialist,
reconditioner,last_verified,servicer,exporter,importer,leases
	From mfgDetails_tbl	
	Where mfgCode = :ccp",{
		ccp={value="#cc#", cfsqltype="CF_SQL_VARCHAR", maxlength=6}
		}
		);
	
	objCompany = structNew();
	objCompany.cc = cd.mfgCode ;
	objCompany.name = cd.name ;
	objCompany.name_alt = cd.nameAlt ;
	objCompany.street = cd.street;
	objCompany.address_alt = cd.address2 ;
	objCompany.city = cd.city ;
	objCompany.state = cd.state ;
	objCompany.county = cd.county ;
	objCompany.postalCode= cd.postalCode;
	objCompany.country = cd.country ;
	objCompany.phone = cd.phone ;
	objCompany.tollfree = cd.phoneTollFree ;
	objCompany.fax = cd.fax ;
	objCompany.url = cd.url ;
	objCompany.email = cd.corpEmail ;
	objCompany.isMfg = cd.manufacturer ;
	objCompany.isDist = cd.distributor;
	objCompany.isImp = cd.importer ;
	objCompany.isExp = cd.exporter ;
	objCompany.isSrv = cd.servicer ;
	objCompany.isRecon = cd.reconditioner ;
	objCompany.isSpec = cd.specialist ;
	objCompany.isLease = cd.leases ;
	objCompany.isCal = cd.calibrates_test_eq ;
	
	return objCompany;
	
}