Does any one have html code file I could use for FMP5

kulmansam · January 6, 2002

Now that I got the Instant Web Publishing solved, I am ready to take the next step... how in the world do I make html codes that connect to FMP database.. does any one have a working file (sample) that I could analyse and then try my own stuff??

I am familiar with HTML and also I have FrontPage2000

Garry Claridge · January 6, 2002

Firstly you need to query the database. This can be done in one of two ways:

URL: http://nnn.nnn.nnn.nnn:nnn/FMPro?-db=dbname.fp5&-lay=weblay&-format=page1.html&lastname=smith&-find

or

HTML:

Enter Name:<input type="text" name="lastname" value="">

You will need to have a Layout(myweblay) in your database which displays the fields you intend to use. The query then calls a format file (page1.html), which may look like this:

<body>

[FMP-Record]

[FMP-Field: firstname] [FMP-Field: lastname] [FMP-Field: address]<br>

[/FMP-Record]

</body>

The format file will loop through, and display, any found records. Hope this helps to get you started.

Garry

kulmansam · January 6, 2002

Thanks,

I appreciate your help... I will go and try that and come back with a question if I have one (LOL.. IF?? .. let's say.. when I have one)

BTW... the nnn.nnn.nnn, does it refer to the path in web address?? like if I had a test site in geocities.. would it mean www.geocities.com/testsite??

or does it refer to the ip numbers?

Thanks smile.gif" border="0

kulmansam · January 6, 2002

Thanks once again Garry.

After a few trials and avariations, I am able to querry the database smile.gif" border="0

I guess I can attempt other things now smile.gif" border="0

I like what you just showed me, coz it means I can actually have the database there and people could querry it smile.gif" border="0 and get results that they can print or view, which is all I want to do for now. I do not want to give them access to modifying, or edditing any records

That answers my own questions about what the nnn.nnn.nnn.nnnn meant smile.gif" border="0

now I know

Thank you very much

Tokyo-B · January 6, 2002

Are you asking about CDML and how to use it to link FMP in to your own custom webpages?

Cheers,

Vaughan · January 6, 2002

Get a copy of the CDML reference -- from the FileMaker web site, under downloads. Then get a copy of Home Page 3. It's NLA but the trial version can stiull be found if you look hard enough around the web.

Use HP3's FileMaker Connection Assistant to build a basic set of custom format files. Look at them, see how they work, then change them to suit.

kulmansam · January 6, 2002

Tokyo-B,

Yes thats exactly what I want to do.

I have been able to querry records (based on suggestions given here yesterday), but only about 25 results show in each page,

I would like to know now.. how to get single page results for each record and to navigate between the found set of records

or at least to be able to show either all the found records or give option to the searcher to go to the next page that has more results (the thing is I do not know if there is a next page generated or not)

Vaughan B,

Thanks, I will surely go and do a little search smile.gif" border="0 Thanks

I have already downloaded the CDML tool, but it left me with more questions than answers. So I will go and look at the ohter things you mentioned, thanks.

Anatoli · January 7, 2002

CDML reference is a must. The 25 is default number of records returned.

From CDML database:

code:

What it does

Specifies the maximum number of records that should be returned per page.

Value is

A number from 1 thru 2147483647, or the word "All". The default value is 25.

Syntax example(s)

Specify the maximum number of records using a link

<a href="FMPro?-DB=Contacts&-Format=format.html&-Max=10&-FindAll">First 10 Records</a>

Specify the maximum number of records using a form action

</form>

Other tags that are required

-DB, -Format, -Find or -FindAll

See also

-Skip

kulmansam · January 7, 2002

Thank you very much Anatoli,

Honestly I was gonna personaly send a question to you earlier. I noticed you were around every where giving answers and I could not afford not having your valuable input to my questions. But you got here finally.

Thanks.. code copied to text file which I will work with an an hours time.

smile.gif" border="0

kulmansam · January 7, 2002

Anatoli! !!!

Perfecto... it worked great smile.gif" border="0

Now I will try and look up the omit option because there are so many records that should not show up since they are not needed.

Just to enlighten you, I have a database for our cemetery where I live. The database is in FMP and I want it available to any one interested to be able to see who is buried there. However, the database has records of the cemetery in total, every single grave and grave plot is counted. Some of them are not occupied or even reserved. I do not want these to show up.

Some plots are reserved (people are still living), I do not want these to show up either.

In other words I want only the records that have 'deathdate' to show up when some one searches a section of the cemetery or the whole cemetery.

At this point all I am interested in doing is making the data available to the visitors, they should not be able to edit any information.

Anatoli::: Thanks for the code again smile.gif" border="0

BTW: I'mjust doing this as a charity act. And when I say our cemetery, I do not mean that we own it, but rather it is the cemetery in the town that I live in.

Anatoli · January 7, 2002

First -- get the CDML database.

Second -- you'll not omit; you must do the opposite -- find.

That will omit the records that you'll not need. Again from CDML reference:

code:

-Find

What it does

Submits a search request using defined criteria. A format file is used to display the records found.

A Web user must have Browse permission in order to execute this action. You can improve the perceived performance of your Web database by using the -Max tag to limit the number of records returned.

Syntax example(s)

Find a record using a link

<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&country=USA&-Max=1&-Find">Find first USA record</a>

Find some records using a form action

</form>

Other tags that are required

-DB, -Format, field name

See also

-Max, -Skip

kulmansam · January 7, 2002

Thanks once again Anatoli smile.gif" border="0

Hmmm.. that's rather interesting way of doing things!

Anyway, code copied to text file,

will work with it within an hour.

Will post tomorrow about results smile.gif" border="0 )

--------------this is my current code----------

<P> First Name: <INPUT TYPE=text NAME="First Name" VALUE="" SIZE=30></P>

<P> Second Name:<INPUT TYPE=text NAME="Middle Name" VALUE="" SIZE=30></P>

<P> Section: <INPUT TYPE=text NAME=Section VALUE="" SIZE=30></P>

</FORM>

-----------------------end of code-----------------

do you still think I need to use the code you just gave me? or do I need to use -skip at this time?

Thanks smile.gif" border="0

[ January 07, 2002: Message edited by: kulmansam ]

kulmansam · January 8, 2002

Right now, my results file displays all the found set of records (in this case max is set to 1000.

Is there a way that I could make the results file only display 1 record or only 5 records, then I can have a link or button to display the next found set? Next 1 record or next 5 matching records.

If that is possible then I can have something that looks like my database smile.gif" border="0 and functions more like my database, while in reality it only querries my database

Any suggestions?

Anatoli · January 8, 2002

You really need the CDML reference database. Search this forum for link to it or www.filemaker.com site.

kulmansam · January 8, 2002

Please ignore my question about navigation. The CDML tool from FMP site is quite useful. Now I can view any number of records at a time smile.gif" border="0

I have it set to 10 records, then navigation at the bottom of the page says (First Page, Previous Page OR Next Page, Last Page)

I still need to find out a way to skip (magic word), records. For example I do not want to show records that do not have death dates!

Any guidance appreciated smile.gif" border="0

Thanks.

kulmansam · January 8, 2002

Sorry Anatoli,

I had not seen your message because I did not refresh the page before my last post.

Thanks for your advice. The thing is I do have the CDML tool, but it did not make sense.

Thanks to the codes given by you and Garry in here, NOW I can understand and actually its working great smile.gif" border="0

Thanks a lot.

I will try to find out about skipping records I do not want before I go to sleep. shocked.gif" border="0

Vaughan · January 21, 2002

Anatoli's advice is good: don't omit records, FIND the records you want to view.

In your case I think you want records WITHOUT a death date. One way to do this is to create a calculation field in the database -- lets call it DDCheck. Make the calculation insert a "1" into the field if the death date is empty, otherwise leave the field blank. It coud be...

code:

If ( IsEmpty (DeathDate), 1, "")

Now you need to create a "canned" find for all the records with DDCheck=1. This could be:

http://www.site.com/path/FMPro?-db=database&-lay=web&-error=error.htm&-format=results.htm&DDCheck=1&-find

Use the CDML Reference database to look up the syntax for the -Find action.

Sign In

Does any one have html code file I could use for FMP5

Recommended Posts

kulmansam

Garry Claridge

kulmansam

kulmansam

Tokyo-B

Vaughan

kulmansam

Anatoli

kulmansam

kulmansam

Anatoli

kulmansam

kulmansam

Anatoli

kulmansam

kulmansam

Vaughan

Create an account or sign in to comment

Create an account

Sign in

Browse

Site Support

Forums

Blogs

Marketplace

Activity

Important Information