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

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

Recommended Posts

  • Newbies
Posted

I am a newbie and am updating a web site that already successfully queries and displays data from Filemaker CDML. I am using FileMaker Pro 6 Unlimited.

I have an HTML page with a form to query a database and that works fine.

I want to add information from a different database to this same HTML page.

Must I turn the link to this page into href=FMPro?-db...

Or is it possible to query the database and display the one record on this page.

I was looking at [FMP-InlineAction] or FMPro CDML in the <head> tag as possible solutions, but I am unsure.

I need detailed answers for a newbie please smile.gif I have no documentation and am just going from info found on the Internet and what is already on the site.

THANKS for your help!

Karene

Posted

From CDML database. You DO have that db, don't you?

<!-- List the employees named Doe in the current database -->

[FMP-InlineAction: -db={CurrentDatabase}, -lay={CurrentLayout}, last name="doe", position="Software Engineer", -find] [FMP-Field: first name] [FMP-Field: last name] [/FMP-InlineAction]

  • Newbies
Posted

Like I said I am new to all this smile.gif

What is the CDML database?

So can I do something like

[FMP-InlineAction: -db=specials, -findany[/FMP-InlineAction]

and later on the page (or directly after)..

[FMP-FIELD:Mfg] [FMP-FIELD:price] yada yada yada... to display the random record from the specials database?

Thanks!

Karene

Posted

Hi newbie,

Search the CDML forum with the string CDML Reference database.

Search the Sample Files forum. There are several CDML demonstrations there. I do not recall if any of them use the InlineAction tags, but they do present examples of how many things work. They are FREE. Studying them is time well spent. Better than a book.

Read as many fresh "Internet" threads each day as you can. While they may not deal with any immediate problem you are experiencing, they are dealing with problems which you are likely to experience and so the time spent daily (20-30 mins. max if you just read). Also searching the "Internet" forums with key words is likely to find useful threads. Don't be shy to use the many resources offered here.

Good luck,

Posted

Hi, Karene! SEARCH > RESULTS > DETAIL

FMP web companion cannot show db info on a page load right off the bat. If I understand correctly, you have a SEARCH page of some kind and would like to show the RESULTS of a new different search on that same page.

SEARCH1 > SEARCH2 > RESULTS > DETAIL

Even an inline cannot work from the 1st page. It must go on a -format page from another query. Now, some folks cheat by using a META REFRESH intro page to prompt the db and then go to the main search page (or even itself?). That has always bugged me but I've learned to deal with it.

Now, using Lasso, JavaScript, and/or other tools, you may be able to accomplish the query-on-load you like, but not with CDML and out-of-the-box FMP web publishing, IMO.

Hope this helps!

--ST

This topic is 7781 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.