Jump to content
Sign in to follow this  
jgreenlee

Viewing the Last Record

Recommended Posts

Hi, I have recently converted our databases over to IWP using FMPro 6. In one of the primary DB's there is one particular record that displays fine in FM but produces an IE error (see attached) when I try to access that particular record from a browser. I can navigate to any of the other records just fine. It's just this one record! I get the same error when I try to Search or Sort. As an expiriment I tried setting up Web Companion so it would sort the records before it reaches the Browser... I got all the records but once again, when I navigated to that one record.. Ouch!

Unsorted, this "bad" record is the last one, so I'm wondering if there is some sort of indexing problem or something that Web Companion can't handle when it generates the HTML??? Again it produces no problem whatsoever in FM. I keep looking at the DB in Table view and I can't detect any sort of Key violation or thing like that. Anyone have any ideas what might be hapening here?

Once again I will attempt to post an image of the error. You may notice the token in the URL that refers to the number of the record. when I play with it, it appears to by one less the the actual record number. (I assume that's because Javascript, or what ever its using is 0 based.)

Jeff

FM_IE error.jpg

Share this post


Link to post
Share on other sites

First let me say that I have never used IWP. I have, however, read as many of the threads on IWP as I could. That in mind ...

"I assume that's because Javascript, or what ever its using is 0 based."

Never assume. Research. Of course, asking questions is a form of research.

IWP does use some JavaScript. But it also uses CDML tags. a token could be used by either.

You have no idea which it is (not that I do) and you have a problem. Basically the problem with IWP is that FM generates the HTML/CDML. It does so based on your design abilities combined with an understanding of how FM generates the HTML/CDML. Not that you can control the code directly, but you must be able to design your solution to work with this self-generating code over which you have no direct control.

I am a solutions designer of CWP. As with IWP, there is a learning curve with CWP. I recommend going the latter route. I've told you as much as I can about IWP, except, I don't believe there are any explanations (.pdf's, etc.) of how to control your db design to take full advantage of IWP. If there were such a reference, I'm sure someone will refer you to it. But don't hold your breath waiting for that to occur.

Share this post


Link to post
Share on other sites

Hey, thanks for your response. when you say, "As with IWP, there is a learning curve with CWP..." I must comment that I think the whole bleedin' idea of IWP is that there is NO learning curve.. thats its problem. What you see is apparently what you get. No frills, Do not pass GO... Garbage in, Garbage out sort of thing... (sigh!)

So I guess really the only solution is to go to CWP... which I'm going to do.. but boy its not easy finding documentation on it! I tried using the CDML module that FileMaker provides.. but the examples won't work with 6.0 .. only 5.5 for some reason... How did you go about finding docs for the "learning curve"?

I have a fair amount of Cold Fusion experience.. I can't imagine CDML would be a whole lot different would it?

Jeff

Share this post


Link to post
Share on other sites

In the Sample Files forum are several examples of web enabled databases which use CWP. Help yourself to any or all of them.

I have not converted any files to 6.0, but if there are any language differences (I think .fp5 is the accepted suffix with 5, 5.5 and 6) you can always make a change in the format files. But basically all of these examples should work for you. They will show you some of the ways in which CDML tags are embedded in HTML. They have useful ideas and information.

A daily reading of the Internet forums to see what problems are being experienced and what problems have been solved and how is also very useful.

"What you see is apparently what you get. No frills, Do not pass GO... Garbage in, Garbage out sort of thing... (sigh!)"

But that's what WYSIWYG is all about - it ain't the Hokey Pokey. laugh.gif

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By AlesD
      Hi I can not fiddle out how to make it work. I have tried several browsers with same result. We are using FM 12 server. I tried this file paths
      file:///C:/file.jpg
      C:/file.jpg
      file://localhost/C:/file.jpg
      and few others
       
      I'm using this code in the Web Viewer which is working fine in FM client but not in browser
      "data:text/html, <html> <head> <style type=text/css> " & table::style & " </style> </head> <body> <div class='thumb'> <span class='helper'></span><img class='thumb' src='" & table::ThumbnailPath & "'> </div> </body> </html>"  
      If it's caused by fact image is not present in web site folder as stated in document then my question is if it possible use unc network path in filename like file://///other_than_fmserver/networkpath/file.jpg. I wasn't successful either. 
      Any help appreciated
       
      Thank you
    • By KevinArevalo
      Good morning! I need some help getting something working.
       
      We have a company website, and we are trying to create a instant web publishing portal for our customers to login and view their open invoices. Pretty simple. We have all of our information on a FileMaker solution that is hosted with FileMaker Server 12. The problem is we can't get it to work the way we want it to. 
       
      This is our idea and how we kind of want it to work. We want the have our customers create their accounts/passwords on our actual website. We will store their account information on our web server. We will authenticate their login on our web server. Then, after they log into our website, we want to take their username, bypass the filemaker instant web publishing login page, and then set their username (which they used to log into our website, not filemaker) to a global variable or a field or something, we just need it in filemaker so we can do searches on it. We have the instant web publishing layouts built and we can get all that part working fine, we have the login authentication working on our site, that part is fine. It's just bridging the two together. 
      We are using WordPress to build the website, and our site is hosted on GoDaddy. Our problem is that we can't find a way to auto-login and bypass the login web publishing page. We currently have one account called "WebLogin" which we have been trying to use as a general login (since the actual customer login is authenticated on our website, not FileMaker) but we can't seem to bypass the page. I found this page through google searching: http://lnx.acidsoft.net/problemsolved/bypass-filemaker-iwp-login-via-url.html
      and tried to do it the way that he describes, but it is not working. It gives me an error saying:
      Bad Request
      The server could not process your request due to a missing command: ""
       
      And I get another dialog box that says: 
      Bad Request
      The server could not process your request because your session has timed out, been closed, or communication with the server has been lost.
      Please reselect the database to begin a new session. If you cannot open the database, please contact your database administrator.
       
      That is one of the problems, how can I resolve this?
       
      My other problems is we are trying to pass through the username that the customer uses to login to our website as a variable in filemaker or even set it to a field. I am not sure how to do this. Is this even possible?
      Thank you so much!
    • By djlane
      I have an application that was using IWP under FM Server 12, to allow my friends and friends of friends to upload their golf scores, and my system would calculate their USGA handicaps.
       
      After upgrading to FM Server 13, IWP not longer exists, and WebDirect does not support mobile devices.
       
      So, I set up an alternative server using FM12.
       
      A lot of guys that I don't have contact details for, used that IWP based system to upload golf scores. So I don't have a way to tell them all the new URL.
       
      Using the old IWP URL, you are presented with a screen that says "The requested page is not found. Check the URL you are using to access FileMaker WebDirect."
       
      I want to edit that page to add some additional information telling them the new URL etc. But I can't find any document with that content in any FM Server folder or sub folder. 
       
      Anyone know where I can find it ?
       
      thanks
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance!
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.