I need help with a rule that support provided me.
I'm trying to get the zipcode from one database to look to an external
database and get the city name. I created the 2 rules suggested but I get
a blank response, and no errors...
Can someone help???
\
OnJobStart Rule:
Dir = new ExternalDataFileEx("\\Storage\storage\Aaron Storage\G\Gilmore
Avenue Car Wash\74507 Christmas in July 08\zipnov99.csv", "\t");
Text rule:
var y = Field("Zip"); //get the field value from the primary db
var x = Dir.FindRecord("ZIP_CODE", y); //searches the external database
//with that header and pulls out the record number when the value matches
var Value_1 = Dir.GetFieldValue(x, "PONAME"); //uses that record
//number to pull out the corresponding value for whichever field you need.
//Duplicate this for however many field you need.
return Value_1 ;
Thanks
Aaron Nissalke
Supreme Graphics
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
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
--
