jayman Posted March 29, 2001 Posted March 29, 2001 Hi all, I have a site that accesses a filemaker 5 database - 1 layout 'tasks'. I have an edit page with the following code <FORM ACTION="FMPro" METHOD="POST"> <input type="hidden" name="-recid" value="[FMP-currentrecid]"> <input type="hidden" name="-db" value="tasks_01.fp5"> <input type="hidden" name="-lay" value="tasks"> <input type="hidden" name="-format" value="../html/editresp.html"> <input type="hidden" name="-error" value="error.html"> This page includes all the FMP fields and code, and a 'submit' button at the base. When checking in the browser, a message appears that it can't find the html page (.../html/editresp.html) - the pathname is correct and all the html pages reside within the /html dir of the site. Is it filemaker or a simple targeting issue?? Please help!null
Philip Sommers Posted March 29, 2001 Posted March 29, 2001 Hi, Jayman: Try putting your web page files (editresp.html and error.html) in the Filemaker Pro "Web" folder of the computer you are hosting the file on. [ March 28, 2001: Message edited by: Philip Sommers ]
jayman Posted March 29, 2001 Author Posted March 29, 2001 Hi Philip, the site is set within a multiple nested frameset and is dependent upon a 'neatly' organised dir structure (index.html in the root dir within the 'Web' folder and sub dirs of /html, /assets, /css, /notes and /flash)
Vaughan Posted April 2, 2001 Posted April 2, 2001 If the files are in the Web folder, then make sure the path in the specified URL is correct.
jayman Posted April 3, 2001 Author Posted April 3, 2001 thanks for the reponse Vaughan... still confused as to why the simple '-format' tag is not working on this page. I have moved all html to a flat directory structure (root in the 'web' folder, and yet on 'submit' [see the following page] action, filemaker doesn't find the page 'editresp.html' (this is just a simple .html page - no CDMLor any other code functions - just a response page) - what's even more confusing is that on some 'getURL' functions I'm using on other pages, the coded link looks like this.... <a href="http://192.168.25.80/FMRes/FMPro?-DB=tasks_01.fp5&-Lay=tasks&-Format=../browse.html&-Error=ZErr.htm&-SortField=LastName&-SortOrder=Ascend&-Max=10&-Findall"></a> ...and it finds the page?!? work that out. Obviously, the root dir is targeted by '../' but where is there any documentation on this for serving web pages??? Sorry for the code listed beneath, but it seems that for anyone else to understand, the bigger picture is required. Thanks in advance. <html> <head> <title>untitled</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="css/fieldtext" type="text/css"> </head> <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="assets/body_panel.gif"> <FORM ACTION="html/FMPro" METHOD="POST"> <input type="hidden" name="-recid" value="[FMP-currentrecid]"> <input type="hidden" name="-db" value="tasks_01.fp5"> <input type="hidden" name="-lay" value="tasks"> <input type="hidden" name="-format" value="editresp.html"> <input type="hidden" name="-error" value="error.html"> <table width="85%" border="0" cellspacing="3" cellpadding="3" align="center"> <tr> <td colspan="2"><font face="Arial, Helvetica, sans-serif" size="-1"><b>Alter the following fields to update the database...</b></font> </td> </tr> <tr> <td width="60" bgcolor="#FFFFFF"> <div align="left"><font face="Arial, Helvetica, sans-serif" size="-2" color="#000000">Task Number:</font></div> </td> <td bgcolor="#999999"> <input type="text" name="date out" value="[FMP-Field:task no.]" size=20> </td> </tr> <tr> <td width="60" bgcolor="#FFFFFF"> <div align="left"><font face="Arial, Helvetica, sans-serif" size="-2" color="#000000">Description:</font></div> </td> <td bgcolor="#999999"> <textarea name="description" cols="40" rows="4">[FMP-Field:description]</textarea> </td> </tr> <tr> <td width="60" bgcolor="#FFFFFF"> <div align="left"><font face="Arial, Helvetica, sans-serif" size="-2" color="#000000">Date Started:</font></div> </td> <td bgcolor="#999999"> <input type="text" name="date started" value="[FMP-Field:date started]" size=20> </td> </tr> <tr> <td width="60" bgcolor="#FFFFFF"> <div align="left"><font face="Arial, Helvetica, sans-serif" size="-2" color="#000000">Date Out:</font> </div> </td> <td bgcolor="#999999"> <input type="text" name="date out" value="[FMP-Field:date out]" size=20> </td> </tr> <tr> <td width="60" bgcolor="#FFFFFF"> <div align="left"><font face="Arial, Helvetica, sans-serif" size="-2" color="#000000">Time Taken:</font></div> </td> <td bgcolor="#999999"> <select name ="time taken"> [FMP-ValueList: time taken , ] <option> [FMP-ValueListItem] [/FMP-ValueList] </select> </td> </tr> <tr> <td width="60" bgcolor="#FFFFFF"> <div align="left"><font face="Arial, Helvetica, sans-serif" size="-2" color="#000000">Status:</font></div> </td> <td bgcolor="#999999"> <select name ="status"> [FMP-ValueList: status , ] <option> [FMP-ValueListItem] [/FMP-ValueList] </select> </td> </tr> <tr> <td width="50"> <div align="right"> <input type="submit" name="-edit" value="submit"> </div> </td> <td> <input type="reset" value="clear form" name="reset"> </td> </tr> </table> </form> </body> </html>
Keith M. Davie Posted April 3, 2001 Posted April 3, 2001 Often it is something as simple as having put in an extra period "home..htm" or inadvertently putting in a space "home .htm" on the format file itself or in the code. I know as I've done this on more than one occasion. Hope it is this simple. Peace Keith
jayman Posted April 4, 2001 Author Posted April 4, 2001 Thanks Keith.... No, it's not that simple - I wish it were!
Vaughan Posted April 4, 2001 Posted April 4, 2001 If on a mac, check the actual name of the file. There may be spaces or some other non-visible character in there somewhere. Select the whole name and re-type what it should be. Then check all the references to the file in the urls -- check if the url is /something/FMPro?-db= because that'll throw it off. Check the source code for the pages, check the link URLS on the browsed page... it's gotta be there somewhere, because it aint a FMP bug.
Newbies kennyvick Posted July 24, 2001 Newbies Posted July 24, 2001 hey jayman ... did you ever get a fix for this problem??? i'm having the exact same problem. HELP!!!!
Garry Claridge Posted July 25, 2001 Posted July 25, 2001 My guess is that the .. is not needed in front of the format path. It should be: <input type="hidden" name="-format" value="/html/editresp.html"> not <input type="hidden" name="-format" value="../html/editresp.html"> Hope this is it. Garry
ivyorg Posted August 22, 2001 Posted August 22, 2001 Hey. I just came from installing the web/database solution at a school, and while I was there modifying the search page, all of a sudden I started out of the blue getting the format file error. And believe me, it was not because of a typo or an extra space. I had 5 different search fields, first and last name and one value list menu for each of three seasons for the person to select a sport. When you searched by sport, no problem. Then, search by name and boom. You'd get the error. I had this happen to me 2 other times. The only solution was to copy all HTML and paste into new web page. This time that didn't work. Then, it wasn't recognizing the search results page for any of my three different search pages. Finally, it just "started working" again. Don't ask me. All I did was keep re-entering my search fields, but it was like something out of the twilight zone. And it had NOTHING to do with the -format tag. Any guesses? Bevin
jayman Posted August 22, 2001 Author Posted August 22, 2001 Hi ivyorg... I have a feeling that because filemaker pro is developed via the Macintosh operating system (originally) - the way it handles directory structure and targeting info is a little screwy for PC op systems? - the original problem i had (see the beginning of this thread) still has not been solved on my current network - so i have left it to simmer while i develop in PHP for the time being. best of luck.
Vaughan Posted August 23, 2001 Posted August 23, 2001 Naaah, we're talking internet/web stuff here, and that's been UNIX for over 30 years. The problem is probably the URL of the original querie. Look at the path in the url of the browser: is it something like... http://www.com/folder/FMPro?-db= If it is, then the format files referred to in the form MUST be in the "folder" directory, because that's the default path that the browser will be assuming. If it still doesn't work then check the target path on the URLs for the html format pages, the default frames etc. There is something wrong, and it's something basic. It might be in more than one place, too.
ivyorg Posted August 23, 2001 Posted August 23, 2001 Vaughn, I'm the first to admit when I make a sloppy error, but in this case, that's not happening. Obviously the -format tag was correct, because when you'd search on a couple of fields, it would display the correct search results page. Only when searching on a couple of the other fields would the mistake occur. Since all the search fields are reading the same -format tag (they're all in the same form), it has to be something else. Bevin
Vaughan Posted August 24, 2001 Posted August 24, 2001 Who's question am I answering here, Jayman or Ivyorg? Ivyorg if you've got a question, post it separately. I was answering Jayman's question here not yours. There are over 10 posts in this thread and I am not going to waste my time trying to work out what your problem is when it's mixed up in Jayman's posts.
ivyorg Posted August 27, 2001 Posted August 27, 2001 Hold your fire, Vaughan! I think you're totally out of line, esp. as some one who is respected in these forums, to be flaming me like this. Jayman's post had been down for a month, and when I wrote my version of the same problem in the same thread (which people always do) jayman began responding to me. Therefore, it's completely reasonable to think that your post had to do with that comment as well. If you have a problem with me, don't be so passive aggressive. I've been in these forums a year now and nobody has treated me this rudely. I think, by the way, I figured out why FMP is giving a false error message, but you've made this forum a freaking miserable place to be with your attitude. Thanks buddy.
Garry Claridge Posted August 27, 2001 Posted August 27, 2001 Sometimes using the Mac 'Backspace' etc can leave odd control characters. This can explain some X-file type problems. All the best. Garry
Vaughan Posted August 28, 2001 Posted August 28, 2001 Ivyorg, the fact still remains that I was originally answering Jayman's question -- two earlier responses of mine plus several from other people were directed to him. I thought I phrased my request for you to post your question separately rather politely -- assertively, but politely. Sheesh, I didn't even say I wasn't going to answer your question, just that I wouldn't when it was mixed up with Jayman's posts. That's not too much to ask. Of the 1000+ posts I've made to the forum in the last 12 months, this is the first that's runied somebody's day. Maybe I'm not trying hard enough.
WadeRoberts Posted October 2, 2001 Posted October 2, 2001 At the risk of setting somebody off , I've had the same problem (The search was successful, but the format file can't be found). The only workaround I've found is to make a new format file, sometimes several times as mentioned earlier. Basically, a file that used to work doesn't. Somehow something gets corrupted, but beats me as to what it is.
sfsmith Posted January 28, 2002 Posted January 28, 2002 I've been experiencing this same error and here is what I discovered... I got the "format file not found" error as long as I did not include an -Error page as part of my data submission. When I added this tag to my form submisssion, <input type=hidden name="-Error" value="/newop/search_error.html">, I no longer got the "format file not found" error. Instead, my error page was returned to me where I had inserted the [fmp:statuscurrenterror] code and the error code that was displayed was Err: 102. A quick search of the FMP TIL for Err: 102 revealed this little nugget of information: RESOLUTION Check that all fields that you are attempting to add to the database exist on the layout specified in the HTML document. Voila! Two hours of troubleshooting fixed! You may all have different kinds of errors, but try adding an error trapping page to your submissions to see if what's really going on is a database error. Good Luck!
Recommended Posts
This topic is 8404 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now