I am currently referencing external data files and returning a record
based upon a value in
the data source which works perfectly for a single record.
What I would like to do is use it as a lookup table so that it
returns every record that contains that
value.
Orga Campus Name Program Name
81 Calgary Bachelor of Science in Business/Administration
81 Calgary Bachelor of Science in Business/Information
Systems
81 Calgary Bachelor of Science in Business/Management
81 Calgary Bachelor of Science in Business/Marketing
81 Calgary Master of Business Administration
81 Calgary Master of Business Administration/Technology
Management
Is there a way to loop through?
Here is the current rule (OnRecordStart)
if (FusionPro.inValidation)
Rule("OnRecordStart");
var RecNum = Courses_XDF.FindRecord("Orga", Left(Field
("CampusProgramListing"),2));
CourseListing = Courses_XDF.GetFieldValue(RecNum, "Program Name");
if (!Courses_XDF.valid){
return "!!!!!Missing file " + txtPath + "AllPrograms.txt";
}
else if (RecNum == -1){
Print("!!!!! Missing record for " + Field("CampusProgramListing") +
" in external data file "+ txtPath + "AllPrograms.txt");
return '<z newsize="10.0">' + "!!!!!Missing Record "+ Field
("CampusProgramListing") + " in External Data File "+ txtPath +
"AllPrograms.txt";
}
else if (LetterHeading == ""){
Print("!!!!! Missing heading text for record " +Field
("CampusProgramListing") + " in external data file "+ txtPath
+"AllPrograms.txt");
return '<z newsize="10.0">' + "!!!!!Missing heading text for record
"+ Field("CampusProgramListing") + " in External Data File "+ txtPath
+ "AllPrograms.txt";
}
else return CourseListing;
Larry Whiting
Rastar Digital Marketing
[EMAIL PROTECTED]
T801-990-6421
C801-558-5316
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
