Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Multiple databases accessed through one web-site?

Featured Replies

Hello again!

I'm having problems with links inside a generic intranet-site that I have published on our LAN. Here's what I'm trying to achieve:-

- Users start in a main index page, with ~10 database links.

- Each database link takes them to the same web folder: "http://database_server/generic_dbase/FMPro?-db=DatabaseX.FP3&-lay=Main&-format=search_results.htm&-max=10&-findall" - in each link, "DatabaseX" will be the name of that individual database.

- User clicks on a link, and the page "search_results.htm" is opened, listing the entire contents of the selected database (as intended).

- At the top of the page are links to SEARCH the database for specific records - and herein lies my problem...

The link which the SEARCH button links to is always a fixed URL, therefore regardless of which database has been opened, the search page will always open up the search for the same database (ie the one specified in the link), for example:-

"Database 2" opened

Search results lists all records in "Database 2"

User clicks SEARCH button.

Search page opens for "Database 1"

"Database 3" opened

Search results lists all records in "Database 3"

User clicks SEARCH button.

Search page opens for "Database 1"

..and so on.

I'm not using IWP, so how do I make the "-db=" part of a link dynamic (so that it will always specify the current database rather than the same, fixed database)?

Cheers,

Dan

Can you use a "token" to hold the name of the selected database ?

  • Author

I don't know, can I? Can you tell me how I can do this?

Sorry, I'm no expert on FMP/CDML as you can probably tell smile.gif)

"- User clicks on a link, and the page "search_results.htm" is opened, listing the entire contents of the selected database"

Have you considered using this result directly, i.e., each item listed is used as your link (instead of the "Search" at the top of the page? Thus Database2 might have an anchor attached to it which provides your clickable link to db2

(I'm leaving off the opening a href and the ending anchor tag is incomplete so the code will show)

=fmpro?-db=database2.fp5&-lay=main&-format=db2findall.htm&-findall">Database2</

Also, if you do not have the cdml reference database, you would be well advised to download it from FMI.

From CDML reference:

*******************************************

What it does

[FMP-CurrentDatabase] is replaced with the name of the database being processed.

Syntax

[FMP-CurrentDatabase: Encoding ]

Parameter(s)

First parameter (optional)??? Encoding. Use one of the following reserved words:

Raw - Don't perform any encoding

URL - Perform URL encoding

HTML - (default) Perform HTML encoding

Syntax example(s)

Returns the name of the current database, using an HTML file

You are viewing the [FMP-CurrentDatabase: HTML] database.

<!-- After processing it could look like:

You are viewing the Contact.fp5 database.

-->

See also

-DB

*******************************************

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.