Pesinos

I have just set up a new Filemaker Web Server system Filemaker server is running on one machine with all of the databases This is a secured server. Filemaker Unlimited and Web Companion are running on another machine. The databases are remotely opened using Unlimited and the web pages are placed in the Unlimited Web folder. Now the problem: When you try to access the databases through the web ie. https://webaddress/foldername/FMPro?-db=databasename.fp5&-lay=layoutname&-format=file.htm&-view I get an error message that says format file not found. I can run it locally and it works fine but on the web server it fails. I have read other posts and cannot seem to find a sollution. It is now getting urgent that it work. It is time sensative information. Sherry

Here is my problem: I have two databases. DB1 has a field with a calculation that creates available dates. DB2 has a field with a valuelist created from the related field in DB1. DB2 is served to the web using CDML. Every field works except the related value list nothing appears on the web site. This happens to be the most crucial part of the database. I cannot have a static valuelist because the dates change and can only appear if they are available. Everything works fine in the data files but not on the web where it needs to work. Any ideas would be greatly appreciated. Sherry

I have two related databases that allow for items to be checked in and out. One database holds the item inventory and the other is a user list. As items are checked out they are added to the users list of current items out and theusers name is added to the item inventory. They work great but when an item is Checked In it is deleted from the users account. I would like to create a history file that would list all of the items that the user has ever taken out. I cannot seem to do this without the information disappearing when items are checked in. I have tried various relationships and editing the script to set a field in a different database to a value when the item is checked out. I am not sure if I should be using a lookup. I have a portal to keep the history but that is as far as I can make it work. Any suggestions?

I have two databases that are related to each other by an ID number. One is a list of videos and the other is a checkout database. Everything works fine for checking videos in and out. My next task however is to create a history of the videos checked out by faculty. Currently when a video is check back in, the title is removed from the list of videos that the faculty have out. I have tried using the Lookup option which I thought would work but it also removes from the list any videos that have been returned. My ultimate goal is to have a list of all videos that any particular faculty has taken out and possibly a list of how frequently a video is used. Thanks Sherry

I currently use Claris Homepage to create the CDML needed for hosting our databases on the web. I know that this is no longer supported and although everything is working well and the sollution is not difficult to use, I am looking for a replacement. I am not sure if Lasso is that replacement. I would like to know how difficult it is to use Lasso to generate the CDML that Claris does. If so, which of Lasso's many products is the right sollution. I am looking for ease of use. We will potentially be having novice FM users creating database that are web enabled. Thanks Sherry

Thank you!! It worked. I had set up a "no password" access to the DB but I did not assign it to a group. I love this program but boy is it picky!! Thank you again! I am so glad that this forum is here!!! : ) Sherry A very happy camper!

Good suggestion! I will check it out and let you know.

I have tried all of the suggestions. I even recreated the pages using Claris HomePage. I still get a new record with NO data. I am getting desparate. It has to be up and running by Friday. Do you have any other suggestions? It seems to be receiving the record and not posting any data. I have made the "space" errors in the past and usually received an error message. This time I do not get an error message just no data.

Thank you for the suggestion. I tried it and it did not change the outcome. Still no data in the record although it is adding a new record. I created the page with Claris HomePage. Do you think that I should recreate the page? Sherry

There is a layout name and all of the fields are in the layout. Here is the HTML: <HTML> <HEAD> <TITLE>MM ClassroomGrant - New Record</TITLE> </HEAD> <BODY BGCOLOR="#FFFFFF" LINK="#003300" ALINK="#CC6699" VLINK="#33CC33"> <P><FORM ACTION="FMPro" METHOD="post"> <P><INPUT TYPE="hidden" NAME="-DB" VALUE="MMClassroomGrant"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="Application"> <INPUT TYPE="hidden" NAME="-format" VALUE="new_reply.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="new_error.htm"></P> <CENTER><TABLE BORDER=0> <TR> <TD ALIGN=center WIDTH=65> <P ALIGN=left><IMG SRC="images/mclogo.gif" WIDTH=87 HEIGHT=76 X-CLARIS-USEIMAGEWIDTH X-CLARIS-USEIMAGEHEIGHT ALIGN=bottom></P> </TD> <TD ALIGN=center WIDTH=492 BGCOLOR="#000000"> <H1><FONT COLOR="#FFFFFF">One-on-One Instructional Technology Development:</FONT></H1> <H2><FONT COLOR="#FFFFFF">Create practical uses for the Multimedia Teaching Stations</FONT></H2> </TD> </B></FONT></TR> </TABLE> <P><TABLE BORDER=0 WIDTH="97%" HEIGHT=228> <TR> <TD COLSPAN=2> <H3><CENTER>Please complete the application below and select the submit button. Deadline for submission is December 21st. We will notify all successful candidates by January 11th.</CENTER></H3> </TD> </TR> <TR> <TD> <H4>Name:</H4> <P><INPUT TYPE=text NAME=Name VALUE="" SIZE=55></P> </TD> <TD> <H4>Department:</H4> <P><INPUT TYPE=text NAME=Dept VALUE="" SIZE=55></P> </TD> </TR> <TR> <TD> <H4>Phone:</H4> <P><INPUT TYPE=text NAME=Phone VALUE="" SIZE=55></P> </TD> <TD> <H4>Email:</H4> <P><INPUT TYPE=text NAME=email VALUE="" SIZE=55></P> </TD> </TR> </TABLE> </P></CENTER> <P><TABLE BORDER=0> <TR> <TD WIDTH=230> <H4>Are you a full or part-time faculty member?</H4> </TD> <TD> <P>[FMP-VALUELIST: Fullpart, LIST=full/part] <INPUT TYPE=radio NAME="Full or Part time" VALUE="[FMP-ValueListItem]">[FMP-VALUELISTITEM: Always, HTML] [/FMP-VALUELIST]</P> </TD> </TR> </TABLE> </P> <CENTER><TABLE BORDER=0 WIDTH="100%"> <TR> <TD> <P></P> </TD> </TR> <TR> <TD HEIGHT=47> <H4>What are your learning goals for enhancing your use of the multi-media classroom and/or web based instruciton?</H4> <P><INPUT TYPE=text NAME=Question1 VALUE="" SIZE=116></P> </TD> </TR> <TR> <TD HEIGHT=50> <H4>How would you use one-on-one training provided by the Media Center?</H4> <P><INPUT TYPE=text NAME=Question2 VALUE="" SIZE=116></P> </TD> </TR> <TR> <TD HEIGHT=52> <H4>What specific products and outcomes will result from the training you receive?</H4> <P><INPUT TYPE=text NAME=Question3 VALUE="" SIZE=116></P> </TD> </TR> <TR> <TD HEIGHT=52> <H4>With whom would you work as a mentor, and what are your mentee's learning needs?</H4> <P><INPUT TYPE=text NAME=Question4 VALUE="" SIZE=116></P> </TD> </TR> </TABLE> <P> <HR> <BR> <INPUT TYPE="submit" NAME="-New" VALUE="Submit"> <SPACER TYPE=horizontal SIZE=15> <INPUT TYPE=reset VALUE="Reset this form"></P></CENTER> <P><A HREF="http://www.ccsu.edu/media">Return to Home Page</A> </FORM></P> </BODY> </HTML>

I have created about 5 different FMPro databases using web companion. They all work very well and when I submit a record it is recorded. Now for the problem. The last online registration database that I created looks fine and tells me that a new record has been added and IN FACT a new record is added to the database. Unfortunately there in NO data in the record. Nothing appears at all. Any suggestions?

Thank you all. I have taken out the IP address but the next question is this... The IP address shows up as part of the web site. How can I prevent that? AND Do any of you have a suggestion for protecting the database? My databases are search only and entry only. I do not want every user to have a password. I do not know who the users may be if they are registering for a workshop. My two options seem to be: FileMaker Pro Access Privileges or Web Security Database Is one better than the other? Any other suggestions???

Thanks for the warning but a more effective approach would be to explain how to protect the database instead of proving that you are in fact one of those HACKERS. Point taken!!!!

Thank you to all of you for your help. I was finally able to make it work. It turned out to be spaces left after a field name. What a mess. Thank goodness that this forum is available. Sherry

I went back and renamed everything and verified all of the spelling. I am still getting the # 102 error. If you have any other suggests I am all ears. We are getting down to the wire in terms of time. Could it have something to do with the submit button?: ...Sherry [This message has been edited by Pesinos (edited March 07, 2001).]