Other Internet Technologies

I have been running a web site with FMP5 with Web Companion as the web server for some time now. I am not using Instant Web Publishing but am instead writing CDML into regular HTML pages and this has working fine up until now. We recently purchased FMP5 Unlimited which comes with Web Server Connector with the intention of moving all of the pages to IIS located on one machine with the FM DBs located on a separate NT box. I have successfully installed the Web Server Connector on the IIS machine and have set the databases to be served from the FMP machine using the admin page. The problem comes when I try to use any pages that have CDML in them. The page displays proper…

I have tried every piece of advice I have gotten, but I still can't get my script to work on a browser. I've tried the -script tag, I've tried the a href link. Nothing will make it work! It works in the database, I checked, I uploaded the HomePage site and it doesn't work. What's happening? If you can help, e-mail me at [email protected] and I'll send you the code I have. I can't figure out why it won't work. Thanks for any help and patience. Smoothdra

The problem I've got is in using Value Lists in <Select... statements. They work perfectly if I have the actual Value List defined in Filemaker as "Use values from field -- All Values". But if I try to setup a list using "Only Related Values" -- it will not work -- always comes up blank. I've verified that my relation is working properly, and have even setup a script that executes to "double check" Set Field on the field that relates it to the other database. Even after creating a record and executing a -view statement to send it to another format file -- the lists still won't show! Any suggestions? Thanks!!

I'm using Filemaker pro 5 unlimited. Whenever I try to use CDML <a href="FMPro?-db=databasename&-format=filename.htm&.........> to access a page, I will hit runtime error. The error message is 'Attempt to load 'Access URL: http:// ........' failed. No object data. Anybody knows what's the cause of this error? Urgent.

Can someone help me figure out why this form doesn't work? I keep getting the error page.. <form action="FMPro" method="POST"> <input type="hidden" name="-DB" value="test.fm"> <input type="hidden" name="-Lay" value="info"> <input type="hidden" name="-Format" value="test.html"> <input type="hidden" name="-Error" value="error.html"> [FMP-RECORD] <input type="hidden" name="-RecID" value="[FMP-CurrentRecID]"> <input type="checkbox" name="Account" value="Y"> [FMP-FIELD: first] [FMP-FIELD: last]<br> [/FMP-RECORD] <input type="submit" value="Submit" name="-Edit"> </form> And also, when I check the…

Any help would be really appreciated. I am trying to setup a form with FileMaker fields that will email a response to the site visitor. I am using the standard CDML tags for the mail components. I seem to be having a problem with the mail server address. The mail server is located at "mail.host.org". In all the FileMaker documentation I've seen, the mail server is referenced with "smtp.yourhost.com". Does anyone know if "smtp" is required in the server reference, or if there is another way to reference the server, like using the actual IP address? Thanks..... Pat

I am running into a problem where all files which have referring pages that have -new commands will also create new records when the reload button is clicked on the broswer. For instance, if the customer purchases something, they click the purchase button and it will create a new invoice and take them to an invoice screen. While viewing the invoice, if they hit the reload button, it will create a new invoice for them with the same item(s) on it. This is happening wherever the referring page has a new record command. Is there any way to tell the broswer that if the last action was a reload, to not create a new record?

I used a CDML tag to activate the FMPro script in my database. The number that the script generates isn't being displayed in the field on the New Record page in my browser. I know the script is working because the number shows up in the database and on the Search Results page in my browser. However, when I activate the script I would like to see the number when it is created. Any suggetions as to what I'm doing wrong, or ideas as to how to get the number to display? Here's the code I have: <INPUT TYPE=text NAME="Tape Number" VALUE="" SIZE=30> <INPUT TYPE="hidden" NAME="-db" VALUE="The Tracker"> <INPUT TYPE="hidden" NAM…

well, here i am again in the CDML forum trying to get some answers. You guys have helped pretty good so far, so i'm going to stick antother question to you. Is there anyway to edit multiple records with one edit button. i've got a site in which after a series of records has reached a certain status, they need to be edited. Each series is related by a common field value and all the changes are the exact same for each record. For example: 3 records with fields Name, Email, Company, Status. with different values in the fields Name and Email, and the same value in the fields Company and Status. After search to find exact matches of Company and Status, Edit fields fo…

I've set up an online database using FMP 5 and CDML. It works just dandy with Microsoft Internet Explorer, but I've run into a problem with Netscape Navigator (tested with verison 4.7). When I try to submit a new record using Netscape, I get the following JavaScript Application error message: File Access Restriction: You do not have access privileges to perform the action: new Weird things are: 1. It works fine with MS IE. 2. If I use Netscape and the Instant Web Portal, I *am* permitted to enter a new record. So, seemingly I *do* have access privileges. The HTML/CDML code I'm using for the SUBMIT button is: INPUT TYPE=submit NAME="-New" VALUE="Add Data" A…

On my new record page I wanted to run a script to generate a number. I inserted the code to run the script, but since the whole page is a form, every time I click 'submit' the script is run. I need the script to be independent of the new record action, because I don't need a new number for every new record. Is there a way to create a new record without running the script? Thanks.

I putting together a creative request form on our intranet. I have the request and decided to break it into 3 html pages, contact info, request info, and shipping. Because only 1/4 of the people need to fill out shipping I would like to make it an option after filling out the request info. For example, on the request page I would like to have a button that says "complete request" and a link that says "click here if you have shipping." They could fill out the shipping and hit a submit button and go back to the request page. No matter what I've tried I can't get everything to work. When I test the setup I can successfully create a new request and add info with the contact …

Am I nuts? I have been trying to do the following using Home Page and have been running into an appearent bug. 1. Create a table 2. Insert a simple IF 3. Insert a table inside that IF statement 4. Go into HTML view 5. Go back into Normal view The entire original table has turned into one big CDML block tag. The only way to get it back into a usable WYSIWYG block is to go into HTML view and remove the table that's inside of the IF statement. Anyone else seen this bug? Anyone know how to defeat this bug? Thanks for the info/confirmation.

Perhaps this is not the appropriate place to ask this quetion, but has anyone experience with Javascript in combination with FMP/CDML? Is it possible to store Javascript code in a FMP database and have it published using CDML and interpreted/executed at the same time? I tried som using Web Companion wut it doesn't seem to work.

two things concerning the CDML mail tags. First off, it never works. Our SMTP host is not local, could this be the problem? I can set up a local host, but i'd rather not, but if this probably the problem then i'll do it. I've done it various ways that i got straight off help articles and the such so it should work. Second thing, when i was running my tests to see if i could get it to work, it all of a sudden starts crahsing my FM. It didn't do this until today, and i've worked on it before with out these problems. That's obviously bad, but on the bright side, maybe that means something is actually happening now! Thanks! The Boy With All The Problems, Jeremy

Like many others, I've been using Instant web publishing and have found that scripts don't run unless they are "Go To Layout". So now I want to do custom web publishing, but can't find any documentation on it other than "Go buy FMPro Developer" My question is: Where can I find out how to do Custom web publishing? All I want to do is run a script when I submit something, how hard is that?!?!

I am publishing a simple input only database on an intranet. I am using the connection assistant with Claris home page to generate my pages. How do I make a field a required field? I don't really need to validate the type of information but just that something was entered.

I have 2 databases 1 for contacts and another for phone numbers of each contact, they are related by a "contactid" field, and displayed in one of the layouts in a portal. How do i let users enter information to the phone numbers database from a web page using CDML in the same way they enter the information in the contacts layout including the contactid so that the relationship can be established. any ideas...please help!!!

I am using Lasso and FilemakerPro to serve questionnaires to research study participants. I want to make sure that no items get missed. Is there a way to make selection of one in a set of radio buttons or something within a set of check boxes required? Or am I out of luck? Mary Ellen

Hi, I've been trying to display FMP repeating fields using Lasso in Dreamweaver but I can only get it to show the fields horizontally. How do I get the fields to display vertically? Please email response to [email protected]. Thanks!

I'm having trouble figuring out how to configure password access to my FM Web pages. What I want to do is have NO password for users who are just browsing the records and a master password for administrators who are modifying/deleting records. I've found that I can set a BLANK password to give Web users browsing access. When I do that I can't figure out how to pass the administrator's password to the FM Web server so I can delete/modify/etc. Is there a way around this? Thanks! --Jeremy

I am using a WEB form with an FMP 4.0 database. It is a survey with certain values defined as "required values." My problem is that I want to be able to customize the error message to give the missing field names in RED, or something comparable, if the person does not fil out all the required values. Is there a way to do this? It is very difficult for users to figure out what is missing if I leave the default page... Thanks! -dana ------------------ Dana L. Hernandez danabase technologies http://www.danabase.net

Greetings Can someone look at http://24.29.137.85/bnlv/ I need to limit the number of reservations per show and have the FORM kick back a message sold out... I believe it's an FPM if statement however I dont know the wording IE: Seat limit is 150... so if someone books a show that is over the limit I want a page or message to pop up Any suggestions

I just published a database on the Internet. I have a script attached to a button. When published the button no longer acts like a button and the script doesn't run at all. What happened? What do I do to fix it? Thanks for you help

Please help! I need to publish a database across my company's network and it includes a script that generates a very critical serial number. I've learned after the fact (of course) that, according to the FMP5 manual, you can only run the script step "go to layout." Is there any possible way to get around this limitation? I'm new to Filemaker, but I have to get this issue resolved as quickly as possible. Thanks in advance for any help you can give.

Greetings Can someone look at http://24.29.137.85/bnlv/ I need to limit the number of reservations per show and have the FORM kick back a message sold out... I believe it's an FPM if statement however I dont know the wording IE: Seat limit is 150... so if someone books a show that is over the limit I want a page or message to pop up Any suggestions

This might seem like an obvious thing but I can't figure it out - I'm using a frame to navigate between various databases. When I click to do a search on a specific database, I want the results to appear in the other frame window. I'm using a FMPro Form (multiple ones) to set up the main frame. When I click the link now, it basically opens up a new Netscape window and all the data displayed. What I'd like is for this to appear in the target window. Any ideas? Thanks

Hi all, Was wondering if there was a way to have multiple databases linked to a common Web page. What we have is a set of 5 instrument scheduling databases (instrument -> day -> hours) and what I'd like to have is one "view-only" form that shows the user what machines are available and when.. (i.e. on Tues, here's the schedule for instrument 1 - 5). But I'd like to do this without having the user navigate through a pile of different pages.... Thanks

I have a file that gathers customer information. I have it set up to require fields and give error messages when the fields are not filled in. This works great when the user is entering information for the first time (using the -new command) but it does not pick up the error when editing the record (using the -edit command). For instance, if they are required to enter a user name, when they create an account the first time and they leave out the user name the program will tell them so and will not continue. However, later in the program, if they edit their user information and decide to delete their user name and click continue, it will act as though everything is fin…

The CDML look like this: [FMP-Cookie: Cookiename=Field: currentrecid, expires=43200]. But everytime I try to set it it is emty, but if i just put in a number (123456) [FMP-Cookie: Cookiename=123456, expires=43200] then it works. But i need to use a variable like the currentrecid, recid or currenttoken. Do some of you have any clue where to get more info on setting Cookies than the CDML Reference.fp5

I'm using some databases on the web that require different levels of access for the site visitor. I am using Instant Web Publishing, and when connecting to the databases on-line for management, a few of them do not require a username and password because of the web site permissions. Does anyone know if there is a way to force Filemaker to ask for a username and password for database administration, without requiring "Custom Web Publishing?" Thanks for any help. Pat

i wish i could figure out this Claris Home Page (CDML) stuff as easily as i did filemaker. But, hey, it's not my fault the program is very un-user friendly, even if the tags are supposed to be easy to understand. Actually i was just wondering how in the world to make a field required. We all know it can be done, besides on the -error pages, there is always a place for "required info missing." I looked in the help contents and index, but there was nothing there (didn't suprise me). I'm not overly impressed with CDML and Home Page, but it's all i have right now. Dreamweaver Developer's on its way though, and it's supposedly compatible with FM. Let's hope it's put…

I am having a problem with the -Delete Tag. I have a shopping cart application that has a format called "view cart" which allows a user to view all items in their cart. Also, in this view, they can delete individual items. The problem is, when they click to delete one item, another item may be deleted instead. I think that the -delete tag is picking up the wrong CurrentRecordID tag but I am not sure if this is the case, nor do I know how to fix it. Also, is there a way to combine actions on a submit button? When the user clicks the delete button, I think I need to re-perform the find and refresh the browser to reflect the current items in the cart. Is there a way to…

When I put in this code in my format file: <select name="Equipment1" size="1"> [FMP-option: equipment]</select> After it is processed, all that is left is: <select name="Equipment1" size="1"> </select> What am I doing wrong? Thanks, Anita

I've set up a search on my page - when I click the actual button the request comes back properly, but if I hit the Enter key on the keyboard, I recieve the error message. Anyone experience or know of this problem? ------------------ Rich

Does anyone know how to perform an EXACT find on your database through the web? For example, if I have a "Locations" field with, for example text such as, San Diego in 3 records and San Diego-Clairmont in 4 records. When I do a search through the web on my "Locations" field for San Diego I only want those showing San Diego not the ones that include the word Clairmont. I have included the tag <name="-op" value=eq> but that doesn't give EXACT finds.

Hello does anybody know a tutorial or tips how to configure a filemaker database with lasso for dreamweaver?? Any idea where I can find a tutorial better written than the original??? Or any other idea how to make a good looking database on the web with filemaker? With web companion there are to many design limits! Please help! ------------------

Hello does anybody know a tutorial or tips how to configure a filemaker database with lasso for dreamweaver?? Any idea where I can find a tutorial better written than the original??? Or any other idea how to make a good looking database on the web with filemaker? With web companion there are to many design limits! Please help! ------------------

Hello does anybody know a tutorial or tips how to configure a filemaker database with lasso for dreamweaver?? Any idea where I can find a tutorial better written than the original??? Or any other idea how to make a good looking database on the web with filemaker? With web companion there are to many design limits! Please help! ------------------

I'm new here and i don't know much about CDML. So if anyone can tell me something about it. You can write to me at [email protected] thanks

I published my database online but there are tags (<> ) showing up in my fields, and one of my value lists is empty (its a hierarchical value list based on a relationsip). I would appreciate any advise, I'm new to HTML.

I'm not sure why whenever I submit a search page by hitting the return or enter keys on my keyboard it returns a search error. Whenever I hit the 'Submit Search' button at the bottom of the form by clicking with my mouse it works fine. Does anyone know how to fix this? Thanks, Cael.

HI all, I'm having a problem with a number format. I am using FM 4.0. The problem is, i need to have a thousand separator (comma) in the number field. No problem to format this field in layout mode. The problem is that when working in web intergation--when this field is uploaded--the comma is no longer there. I can't seem to figure out how to fix this. Can anyone help me? Thanking you in advance! Renee [email protected]

In the page I am designing, I made a single calculated field to show the detailed information in a record online. I thought it would be simpler doing this one field then having a dozen different fields getting published seperately. The web companion does not register the paragraph symbol into the html conversion though, so all the information runs together in a long line. I tried putting HTML tags in the calculation, but web companion changes it so it is displayed as text, instead of a part of the HTML. As far as I can tell, none of the external Web functions will do anything for this situation. Am I doomed to creating a dozen little fields? ------------------

I want to include a <textarea> tag in my format file to let my clients submit edits to a large body of text. But the textarea tag doesn't seem to work with CDML. I keep getting an ERR:102, which translates into "Make sure the field you want to modify is on the layout you're using." It is. Now the -Edit works just fine if I make my input type a standard "text" field. Has anyone else experienced a similar problem with using <textarea>, and is there a way around it? Here's how I've set up the table using the textarea tag with the CDML. Actually, here's a sample of the whole form: <form action="FMPro" method="post"> <input type="hidden" name="…

The page that I'm trying to get to work has changed its URL, to view the page, go to: http://hsfo.ucdavis.edu:591/orientation/registration.html Sorry for the confusion. Shawn [email protected]

quote: Originally posted by dmacpherson: I now understand how to host a FM file on a local Web server. How do have an ISP host a FM database? You need to find an ISP that is willing to host FMP databases. Many ISPs use Unix boxes only and will not be able to run FMP. You need an ISP which is running Macs and/or WinNT machines so that they can host your files. The other question would be if you actually need your ISP to host the databases? If you can do so already and you are not behinda firewall, you might just be able to handle the hosting yourself. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Senior Filemaker Developer http://www…

We're running our production databases on one machine using FM Server 5 and we use automatic backup to back up those files each night. Using Visual Basic, we copy the backup files to our web server (separate machine) and want to open them in FM Pro Unlimited 5 to allow access to more than 10 web users. In order to do this we would have to close the day old files on the web server, then copy the new backup files and open those in the Unlimited application. Does anybody know of an easy way to do this or know of something that has already been created? Thanks!

II am developing a website that requires the user to enter a name and a password stored on a filemaker database... The Html file, currently submits a find to the filameker db and checks for the correct user and password. However, if you enter the user name with no password, still finds the right record and returns a successful request html file. I tried java scripting, but I was not able to make the script work on verifying that the password field was not empty... Anyone know of a different way of implementing a login method that is secure? ( or more secure anyway) Rick [email protected]

I've got a situation in a results page where I need to say, "If THIS *or* THAT, then do THE OTHER." I tried putting a Boolean operator into the FMP-IF statement, but it didn't work. Specifically: [FMP-If:FMP-Field: PHONE.cn.NOT or LISTDATA.cn.N] Hmmm . . . maybe it should be: [FMP-If:FMP-Field: PHONE.cn.NOT or FMP-Field: LISTDATA.cn.N] ?? Or maybe I could NEST the IF statements? Thanks. --Jeremy

Hi I am currently creating a website for an antique store. They have all thier stock on a FMP4.1 database and im looking for a viable and efficent way of creating a HTML page off a template for each record/peice of stock for upload. I have lookd into custom web publishing but it seems that you can only create a template that loads the record info dynamically when a record is accsessed. Any help would be very much appreciated Thanks in advance Thomas Manning

Hi there I have got a problem with my database on the web. Ive got a field that has contains track titles. The complete list shows up in filemaker but on the web the field is cut short. I'm using filemaker4.1 and lasso 3.5 Do you know how to solve this problem. thanks all. nikolai

Can someone tell me is it possible and how to move teh FM files from teh web companion system to another web server system. Let me explain - currently I have seven files accessible via the web using FM's built in web companion. What I want to do is utilise another more featured web server software - so I can use cgi, php etc and still have the FM files active Am I making sense? Please help Greg

Hi, I am trying to perform a complex web search query on an FM db, by using the logical operators and and or. Basically I want to display an or'ed search on one field along with anded searches on other fields, and get the result in xml. Anyone have any idea how to do this?

Is there any way to customize the layout of the form view of databases that are published through instant web publishing? Thanks!

I've been having trouble linking TO a search page I created with CDML on a FMP 5 Web server. When I create a link to the search page in an HTML document that is not in the FMP Web folder, the link fails with a #4 error. But when I enter the search page's URL directly into the browser, it works fine. Any thought as to what's up? The URL for the search page is: http://www.tcf.ua.edu:8080/ATA/FMPro?-db=ata&-lay=Layout%20%231&-format=search.htm&-view (I'm using 8080 as my FMP port, but I plan to change it to 591.) And example of a failed link is on the following page: http://www.tcf.ua.edu/ata/#Archives Try the "searchable archives" link to see what…

Has anyone figured out a way to get numeric formatting with CDML. For example, a numeric field for currency in FileMaker is formatted to display as "$1,234.50". CDML displays it as "1234.5". I know I can simply put the "$" in HTML, but I haven't found a simple way to get the two decimal places to display correctly. [This message has been edited by REdSta (edited May 30, 2000).]

I have a 2 relational databases. "Problems", and "Problem Revisions". They have a one to many relationship based on problem number. From the "Problem Revisions" database I wish to search for all problem revisions where the status of the problem is open and the revision of the problem has my name on it. The web companion only allows searching on fields in one file. Is there a way I can make it search over two. IE: "Status" in "Problems" and "Person" in "Problem Revisions". Thanks

Hi, I have a results page which with a -max of 10. I would like to be able to link to "1-10","11-20",21-30","31-35" if the found count is 35 for example. The link next/previuos/first/last, are useful but my client wants to link in tens as this. Does anybody know of a way to achieve this, if so I would be most grateful. Antz....

Hello! I need your help! I'm using javascript on a page to change a jumpbox dynamically. This page also connects a FMP database and I'm having difficulties using [FMP-tags] within my javascript! It just won't work. Here are some details about my script. The script checks to see what selection the user makes on a "select-tag" (i mean <select> ) and then dynamically loads a second "select-tag" accordingly to his choice. I use writeln(...) to display the text and also the <script>...</script> does not produce all the html page but only a certain part, the part that needs to be dynamic. Since I'm using a script to load and modify the user's selection into…

When my users edit or add records through the web companion (ie, using their web browser), they need to include formatted text (eg, italics) in some fields. Does anyone know if and how this can be done?

Can someone please tell me how to execute a script from the internet? I am trying to publish a database on the internet but when a user clicks submit on a web browser, I need a script to run. Is there some sort of Java script that I need? I am "cgi stupid" and would be grateful for any help that I can get. Thanks!

Hi there I have got a problem with my database on the web. Ive got a field that has contains track titles. The complete list shows up in filemaker but on the web the field is cut short. I'm using filemaker4.1 and lasso 3.5 Do you know how to solve this problem. thanks all. nikolai

When I import .jpg files into a Filemaker container field the size of the images increases to about 13 times the actual size as it enters the database. I have my document preferences set to 'store compatible graphics'. And when I import, I make sure that 'store only a reference to the file' is unchecked. I am trying to publish a database of images as a gallery online. Each record contains 5 images (4 at 8k each and 1 at 16k to 18k = a total of 58k). When I import the images into FMP, the size of a single record in the DB is almost 800K and every record I add thereafter (containing the 5 images) adds another 730K to the total file size! There is very little overhead in th…

I have been using Filemaker for many years and am proficient in HTML. I want to combine my skills and host my company's online store inside FMP. What is the best way to learn CDML? There doesn't seem to be much info on it. Will I be able to figure it out or does it require higher knowledge of programming? Any help is appreciated. Thanks, Cael.

Greetings, (fmpro5U, webcompagnion v2, mac os 8.6, netscape 4.72) With a normal Browse html/cdml page we get an error message from the browser: "Unexpected error. Unable to process your request because the server encountered an unexpected condition. for more detail check error 4" Our browse page does not contain any fmp-if, it is in fact very similar to the browse.htm of "shopping cart" (web exemple in fmp4) but it does'nt work... Now if I dont specifiy a layout to use for that page... no javascript error ! But also no related fields... Dont know where to look anymore, any suggestion is greatly appreciated. Nic progi-media

Is it possible to upload images to a mac OSX server using FMPro? If so how? Thank you Antz.

I think I'm going crazy!!! As far as I can tell I have set up a page in Home Page properly so that I can edit a record in FMP 4.1 BUT!!! I have all the fields on the details page and the idea was to fill in the ones you want to change and click edit and it will update the record - leaving the blank fields untouched. Or at least that's how I thought it would work - of course what happened was that the fields left blank [unchanged] caused the record to get blank fields!! Do I add an if or something! help.... i can't edit fields!!! ------------------ _____________ Think Different, Think for yourself.

Dear CDML geniuses: I am a CDML programmer having some email woes... FileMaker CDML is woefully underdocumented, and, I think we all can agree My FileMaker email forms aren't working out in both of these situations. In the form, I've put in the hidden fields <INPUT TYPE="hidden" NAME="-mailto" VALUE="[FMP-field:Customers::Email]"> <INPUT TYPE="hidden" NAME="-mailCC" VALUE="[email protected]"> <INPUT TYPE="hidden" NAME="-mailBCC" VALUE="[email protected]"> When the user submits the shopping cart, the user, the company (filmwest), and myself, are all supposed to get a copy. In this setup, only the customer is receiving mail. When I have it setu…

I'm looking at integrating Lasso Studio 1.5 and Lasso Web Data Engine 3.6.5 with FileMaker 5 Unlimited/Server for our first attempt at web database publishing. Has anyone had any experience with these products? Any information would help. Thanks!