Just beginning

[scarletjake89]

I am new to FM and am trying a few things to see how it works. I set up a site inside the web folder. I placed a database in the web folder as well. I want to link to the database from a html page inside the web folder. i want the database to launch in my browser, IE. I followed the instructions and have set up my computer to be a localhost, using web companion. When I tried to link to my database, I get a dialog box that states that the file cannot be located on the server. What is the code I need to place in the html to launch the database? Any help would be much appreciated.

[Christian Coppe]

Before to go further, be aware that you have to use CDML, and not HTML, to dialog with an FMP database. Try to find "CDML Tools" on the web (I don't remember where). Also check if your file is shared with the web companion.

Good luck!

Christian

[Garry Claridge]

The database file should not be in the "Web" folder; this is for security reasons.

Check the "port" number in the WebCompanion Control Panel. If it is anything other than 80, the URL, to use in your browser, would look like this:

http://localhost:nnn

The "nnn" being replaced by the port number.

To use your own html pages you will need to learn cdml as well. (This is as Christian has pointed-out.)

Good Luck.

Garry

[scarletjake89]

I have the cdml tool now. I'll check it out and give it a try.

As far as the port number, it is set to 80.

And Garry, thanks for the database location advice.

[scarletjake89]

OK,I have inserted the DbOpen script onto my htm page and I created an htm page to view the db once the db is launched. What happens is that the view db page opens and is blank. I have tried a number of things with no result. I am not sure if I need additional cdml. I have created search and editing pages that work, but I have to manually go into FMpro and launch the db first. My goal is to click on a button on the htm page to launch the db and then perform the searching and editing.

This is what I get in the address once the Open db button is clicked on:

http://localhost/FMPro?-Db=demo.fp5&-format=//localhost/01_proc_pad/format_file.htm-input%20type=

Hopefully this might provide some clues.

[Unable]

Hey buckeye,

Why put an open script into your htm page? When serving your db files should be open.

If you have named your first page either default.htm or index.htm, you can use

http://localhost/default.htm/ or http://localhost/index.htm/

in your url to access the db and format files.

For a simple demo, use the FMP-If, FMP-Else with operator .or. from the Sample Files forum. Plenty of other examples there as well.

Bon chance,

[scarletjake89]

Thanks Unable,

I am trying to figure out a few things. The way I have a site right now on my computer is as follows:

I have a web site consisting of htm files in the web folder. I use a database that contains different functions. I also have other databases that the site may use but not always. So I want the user to be able to open and close the different dbs as needed.

I will check out the samples you have posted. Thanks.

[Unable]

re: So I want the user to be able to open and close the different dbs as needed.

Why? If the files are open they are available. If there are two clients, and one decides to close a db file, what are the effects on the other user? On several users?

Is this a closed site with only one or two users? Will you need Unlimited because of the number of users? Yes, there is no doubt a lot for you to determine.

[scarletjake89]

This is a site on a company's intranet. They do not want some of the databases open unless they are opened by the user and they want them to close the database when they are finished using it. I know I have tried to explain, but that is what they want.

[Unable]

At some point you may need to sing them Mick Jagger's line, "You can't always get what you want. But if you try, sometimes you get what you need." And what they will need is a web solution which works in spite of their preconceived ideas.

[scarletjake89]

My feelings exactly. Now, I have made a few examples with the db open. I'll see what they think.