Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

repeating portal question for CDML (difficult one!)


This topic is 8333 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have one database file (indiv_master.fp5) that is related to three other

database files (indiv_2002.fp5, indiv_2001.fp5, indiv_2000.fp5), with

relationships based on the same key for all four databases - and each

relationship is named the same as the three database files without the .fp5

(example - indiv_2002)....

I want to display info from each database right after each other. I need to

be able to do a "loop" where the only thing that changes in the CDML is the

year - as the formatting is long and tough to repeat four times - especially

when trying to develop and edit the CDML for the page.

So - I want to do something like this - but in CDML (or JavaScript):

(the following is written in pseudo-Perl format)

For $variable in (2000, 2001, 2002)

{

[FMP-portal:indiv_$variable]

[FMP-field: indiv_$variable::contri_name]<br>

[FMP-field: indiv_$variable::contri_address]<br>

[FMP-field: indiv_$variable::contri_city]<br>

[/FMP-portal]

}

Each database contains the exact same field names. I can't combine all of

the records into one database and use a different solution, as each database

contains 500,000-1.5 million rows - and putting them into one database

exceeds the 2 gig limit. I need to do this "loop"...

Any ideas?

Thanks,

Tony

--

Tony Darnell <[email protected]>

This topic is 8333 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.