Query without href or form

July 24, 200322 yr

Newbies

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 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

July 24, 200322 yr

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

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

July 24, 200322 yr

Author
Newbies

Like I said I am new to all this

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

July 24, 200322 yr

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,

July 25, 200322 yr

And... Everything must be withnin [inline] ... [/inline] tags.

July 28, 200322 yr

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