Other Internet Technologies

One of my fields is an auto-enter calcultion (simply autom. copy text from a just entered field). Creating a new record auto-enter works well in FP7, but creating a new record in IWP and having entered text in the source field, the value never appears in the auto-enter field. The FM7 help file indicates "For information about auto-entered data and FileMaker Pro web publishing, see the online manual, FileMaker Instant Web Publishing Guide". However, I can't find anything in there on this subject, nor can I in the IWP Techbriefs. So I wonder wether it is normal that the auto-enter calculation does not work in IWP, and where in the Guide it is indicated ? Or is th…

Hi, I am using FM Pro 7 on windows. I have created a Conditional Value List, it is working fine. But when i published my database through IWP it is not working as like before. I have two drop down list Country and regions. Whenver i choose a country in the first drop down list the second "region" drop down list is not automatically populating. But i have to submit the selection of the first drop down item(country) then only the second drop down is populating. please help me.

It is great that FileMaker fixed the 5 record limit and I appreciate that they were listing to their users. I now have a layout that I would like to restrict the number of records displayed. These records have thumbnails and 25 records takes the browser too long to display. Is there a way of constraining the found set to 10 records and than have buttons to back and forward 10 records at a time. If so, how would I do it. As always thanks in advance - Sam

Hallo there, I have the following problem: I created a database and want to publish it using IWP. This runs fine, until I open the database in the main frame of a static HTML page. The database open OK, but scripts don't work. When i click a button which starts a script, IE6.0 tells me 'ERROR on Page'. When i open the database in a new IE-window everything runs fine. Does anyone have a clue ?? Erik

I recently was keeping track of all my passwords with IIS, and was using something called IIS Gate to stop people from going into folders in my web drive that they shouldn't be into. The problem with this was, while i'm pretty decent with HTML/PHP and what not, I couldn't make a page that redirected based on the user that logged in, and really, I didn't want to have to redirect in the first place. So, using filemaker 7 and Lasso 7, I found a way to have a table that contains. "Username", "Password", and "URL". So that when a user inputs the correct Username and Password, it directs them to the URL. So when they put in an incorrect UN or PW, there is no matching…

Hi fellow FM experts - I need your help - I have an instant web publishing solution that needs to be able to create a URL to a specific file. A previous post over the last few months gave details on linking to a specific layout in a IWP database (see below) http://<webaddress.com>/fmi/iwp/cgi?-db=<DATABASE>&-lay=2&-gotolayout= This is great - but I need to get to a specific record in the database. Given that you can achieve the above using cgi, it must be possible to put in a recid as well - but I can't work out a way of doing it. Does anyone have any ideas on how to achieve this? OR where I can search for a solution. Regards N…

I have a Project Management solution that has one engineer assigned to each project. The engineer's name is the Account Name, and is also stored in a text field in the Projects table. Could there be a way to set up a relationship to display only records that have the current user Account Name in the engineer name field? A global calculation field seems to always get the account name that starts the application, not current user logged on. Any insight will be greatly appreciated!

IWP is completely ignoring my tab order. I have cleared the tabs and rewritten them, then quit and restarted both FM and Safari. It does it on Safari, IE, and foxfire. Any suggestions?

I have a web form that asks for a login and password on a CDML find page. I want it to REQUIRE both the login and password, but currently it allows one or the other. Here is my code: You will be asked to re-enter your Login and Password for security: Login: <INPUT TYPE="hidden" NAME="-op" VALUE="=="> <INPUT NAME="IDWebLogin" TYPE=text id="IDWebLogin" VALUE="" SIZE=14 MAXLENGTH=255> Password: <INPUT TYPE="hidden" NAME="-op" VALUE="=="> <INPUT NAME="IDWebPassword" TYPE=password id="IDWebPassword" VALUE="" SIZE=11 MAXLENGTH=255> <input type="hidden" name="-find"> <INPUT NAME="-find" TYPE="submit" id…

I'm using mac os x panther, fm unlimited 6 and fm server. We are using fm for an ecommerce solution and for security we do not want all our databases to appear on the instant publishing home page. We have seen some documentation that says that this can be done by simply ending the database name with an underscore.. eg: database_.fp5 Sadly, this simple solution does not seem to work... our "databases_.fp5" are still visible on the homepage. Can anyone tell me an easy way to keep selected databases OFF our web publishing home page so that we are not offering up our customer information for anyone who cares to look at it? Is it really as simple as using some s…

My users need to log in to a database with a username and password automatically when they first hit the index page. At the moment the page is set up with a meta refresh that goes to the following - <meta http-equiv="refresh" content="1;URL=http://test:[email protected]:443/FMPro?-db=Mams.fp5&-token.9=0&-token.7=0&-format=media-library/loggingin.html&-FindAll"> i.e. <meta http-equiv="refresh" content="1;URL=http://[uSERNAME]:[PASSWORD]@[sERVER IP AND PORT]/FMPro?-db=[DATABASE]&-token.9=0&-token.7=0&-format=[FORMAT FILE]&-FindAll"> This works really well on a Mac from explorer, safari, firefox etc. It used to work on…

I have clients that sign in to view their past orders and place new orders. What is the best way to pass their id number to a new record layout? Right now I have a script that copies the id from the list (clients home page) layout and the paste the id into the New Record layout. This does not seem to be the most elegant way. I thought Set Field might be better, but I don't really get the concept. Any suggestions would be appreciated - Sam

Anybody know if/when FireFox will be a supported browser in IWP? Works fine with CWP, but not IWP (neither does Camino). We are being 'forced' to use Firefox next year for our student information system (Infinite Campus). Since this is the more important of the databases, Campus requirements win (Campus is NOT compatible with Safari, even Safari 2.0 and OS X 10.4).

Does anyone know how to execute a find or sumbit command with the enter key rather than having the user mouse over to a button in IWP? Thanks

What does this error mean? I can't for the life of me figure out what I've done wrong! I'm reusing code from othere databases so I thought maybe I got some stuck in there from the old DB but I can't find anything. Help!

Hi All - I have an odd browser-dependent problem which I hope you can help with. I have a simple database which I'm publishing using IWP. All clients are on Internet Explorer 6, SP2. For SOME clients, Internet Explorer loads the initial "list view" screen incorrectly - the status area is missing (and there's no arrow on the thick grey bar to allow them to open it). Futher, all the in-header or on body buttons don't work - a 'page error' message sometimes is displayed briefly, then the initial layout screen reappears. I DO have a default 'show status area' line in my default on-open script. The weird part is that other clients don't have this problem - everythin…

Can someone provide code for IWP Next/ Back buttons. Thanks!

Greetings All! I, like alot of people, was dropped into using FileMaker as our main Problem Tracking and Asset Data base. What happens is a user can "Report A Problem" on our Intranet and have it email me and it also logs the problem into our problems data base. The issue I have is that the mail function that I am using does not constantly email me. Once in a blue moon I will get an email. We are using a script called FX.php that calls on a mail function to do the emailing. Is there a more streamlined way of doing this? :confused:

Hi All, I have to create a survey pageA where I have 22 questions and in each question I have 3 radio (Don

My question has to do with foundCount and related fields. I know that if I want to say: "The total number of records that match this search is XXXX" foundCount will provide me with the number XXXX. However, I can't figure out how to get fx.php to return the number of records displayed on a certain page along with foundCount. For example, I want to say: Shown below are records number 1 through 20 of 236 records. (236 being my fictional foundCount number) and successive pages like this ... Shown below are records number 21 through 40 of 236 records. How do I do this? I can show you the code from my pages if that will help. Everything el…

I have searched through the threads for displaying value lists from FMP databases, and I cannot find my specific problem/solution. I have a database into which a Value List for each person is built, using entry into a field. Then I want the user to login, and be able to retrieve their custom values in a pop-up. I was using an inline action, but the value list is based on related field values from a second database. Here is what I am using, and I only get an empty pop-up: <select name="CourseMath"> [FMP-InlineAction: -db=CSTReg.fp5, -lay=Web, -view] [FMP-Valuelist: CourseMath, list=MathEligibleYr] <option value="[FMP-Value…

Can anyone help a poor frustrated boy out of a corner? I need to save a preview of a Report as a static web page that other people in the office can book mark and view without going to filemaker. Is there a way to write a script that can update this static page? Eg copy the report and either paste it into, say a web document made in word. Or or overwrite a jpeg or other image file that is referenced in a static web page? Sure there must be a simple answer to this one. (LOL)

I am publishing a database using fm server advanced, and accessing it via the web. I find a great discrepancy between fonts using filemaker and fonts via the web. In order to have the web fonts a reasonable size (they are much too big) I have to set my iexplore text view to smallest and the font size on labels and fields must be set to 9 point arial. Is there anyway to adjust this correspondence via style sheets that get used by the web publishing engine? thanks, darren

Most sites that have tutorials on getting filemaker pro on the web with PHP start with being sure the web companion is checked in the plugins section of the application preferences. Unfortunately, there is no web companion option in the plugins. I am very new to FileMaker, is this an outdated method (as I can only find references to web companion in relation to versions 4 and 5)? How do I make it so FX.php can access my filemaker pro 7 database? I am trying to learn to see if a potential client can use filemaker for their web application.

I'm trying to limit search results to only those whos dates are today or in the future. I created a flag field named current with a value of 1 to indicate those records which meet this criteria. I am doing a "google" style search where I pass the users search term into multiple fields, which works nicely, except for the AND and OR logic mix. Here's a sample of the PHP - <?php $search=new FX ($serverIP,$webCompanionPort); $search->SetDBData('wkspweb.fp5','web'); $search->AddDBParam('current','1'); $search->AddDBParam('-lop','and'); $search->AddDBParam('description',$search_term); $search->AddDBParam('-lop','or'…

I have a problem with very slow access to web pages on File Maker server 7 Advanced. The problem is definitely not caused by the proxy or by network problems. I have set up two machines running on one 100M switch. One is running FileMaker sever 7 advanced on Windows 2003 server. The other is running File Maker 7 Developer on Windows XP. There is no proxy or firewalls turned on. I have setup the same set of files on both machines. The server is sharing the files using File Maker server advanced web publishing. The XP machine is sharing the files using Instant web publishing. When I use a third machine to connect to these machines the files shared off the XP …

I have a few problems with my PHP Code. First and most important, I'm having issues with the link next and link previous links. If all records are shown the next and previous buttons work fine. If I do a search for certain criteria (example: manufacturer's name), then click the next link it returns no results (the url isn't correct) If I do a search and then sort (using some links in the table headers), then click the next link all is good. (the url is good) My second issue deals with the text that says which records are being shown (showing 8-14 of 20 records) The skip value doesn't seem to be functioning properly. Any help would be greatly appreciated. Rheal …

I am having trouble finding if a container field is empty or not. In English: If containerfield is not empty - get the image and display it. Here is what I have (and does not work) in PHP if($findData['Coverimage'][0] != '') { get the image } -The field cover image is a container field. -I can get the image without the if statement, however not all records have images.

Does anyone have an example of login into filemaker Server advanced 7 with a php session or cookie that records the username and password typed into a form and so that it passes to each pages. using fx.php

I have a database that has two related databases (such as vendor address information). I have set up a button on the primary database to bring me to the related database (with IWP). This opens a new window in Internet Explorer and perfectly to the new database. PROBLEM IS I can't see to get back to the original database cleanly. I can have my "Return" button go back to the originals URL, but that opens yet another window. Do this a few times and I'll have a dozen windows for the same database. Any technique for closing a window as one opens another for the related database?

Hello, I was amazed to see that you can now render a complete FM Layout onto the web without having to use Custom Web. But have a couple of probs with it! Does anyone know how to get a FM Layout to access an external URL that is a button on the FM layout and rendered on the IWP generated web page? My button works fine in FM but when I use the web button it just seems to refresh the page! Also, how about embedding some HTML into the layout that could for instance specify a img src tag and place a calculated result as the src. I tried containers but they remove image proportions. Any help would be appreciated. Thanks, David.

Hope someone can help! I started using Filemaker 7 a couple of days ago and tampered with the Purchase Order template. I added 5 fields to the template and the work great on FM7. When publishing with IWP, the fields appear on the form but when I click to edit them, they disappear! The ones that came with the template remain and can edit, but all the new ones are gone when I click them! I have rechecked the field properties, compared with the ones on the template, etc... all are the same! Could some one help me out! Thanks...

Greetings Experts I am using FMserver 7 and IWP I have a table that I am trying to display related graphics in using IWP. The primary table has "Tech Request" records in it and I would like to show a Logo for each building that the request is from. So I set up another table called "graphics" then made records that contain a container field for the graphic and a text field that contains the building name. I used the building name to relate the graphic table to the Tech Request table. In FM Developer 7 i am able to see the graphics in my tech request layout. but when i log in via IWP (admin acct) i only see a small blue box with a white "?" question mark in i…

Back with yet another question In configuring Server Advanced, I notice it is possible to raise the limit for the number of IWP users above 100. Does this setting work, or will I still hit a ceiling at 100? Cheers...Sean!

Hi, I am new at php. I am creating a survey with 150 question, but using several php pages instead 1. My problem is to make the information of each page go to the same record instead create a new record. How do I keep adding information to the same record if I have several php pages. The code that I have unitil now are: =======index.php====== <form action="evaluation.php"> <table width="150" border="0" align="center"> <tr> <td width="22"><input name="have_program" type="radio" value="Don't know"></td> <td width="118">Don't know </td> </tr> <tr> <td>&l…

Hi everyone, I've recently upgraded my system to version 7, running on server advanced patched to 7.0v3 and IIS6.0. Everything is running on the one box. I had read that IWP cannot work with external authentication, but apparently it can, because authentication seems to work fine. I have set up a local group on the server itself with domain accounts of certain people who are allowed write access. All users in the company are in the the Domain Users group, which I have have set to give read access. When I was playing around setting all this up, I could swear that if I was already logged onto the domain, Internet Explorer would go straight into the IWP page for …

There are different user with different rights defined in Filemaker 7v3. By not all user J get after logon in Safari the error. I don't know whats wrong. Can J get information about the JavaScript error?

Does anyone know of a php calendar that will work with Filemaker 6? I need to put a calendar on the web that will pull information from dates to display on the web calendar. Thanks [email protected]

Why do my value lists that are comprised of two fields in the same table (ID and Name- sorted by the first) only show the first value in IWP? They work in Pro. When I change the sort to the second, things get weird. The first field is the unique key- the name may be used more than once. My users need to see the names to choose. I'm using Server Adv. on Windows 2000. Thanks!

I've recently migrated a large student records system from FM3 to FM7. However, the budgetary powers-that-be, upon reading FM's marketing spiel about FM Server 7 Advanced's web publishing features, only budged for a handful of copies of the client. Thus, I need to get a lot of stuff web-enabled. The trouble I'm running in to is that FM doesn't seem to be able to display any info from more than one file. I can display info from other tables in the file, but that helps me not, as our converted files have only one table each. Is FM really not capable of displaying the contents of related fields from other files in online layouts? Does this not defeat the entire…

I am new at PHP, I am wonder if someone can help me. I have a problem with a web survey I am doing. The survey has 4 pages. But for some reason when I try to click continue each time, it is entering as a new information to a database. I guess I am doing the RecId incorrect. Here is the code Index.php <body> <form method="post" action="page1.php"> <input type="radio" name="have_program" value="Don't Know" > Don't Know </td> <input type="radio" name="have_program" value="Yes">Yes</td> <td width="10"><input type="radio" name="have_program" value="No" > No </td> </form> </body> ------ …

Hi gang, My app uses PHP as middleware and FM7 for the backend. My data model uses key field IDs to define relationships between tables. Here's an example of records across two tables, Names & Phones: NameID 1 John Smith :: PhoneID 1, 555.1212 NameID 1 John Smith :: PhoneID 2, 555.3434 NameID 2 Jane Doe :: PhoneID 3, 555.5656 NameID 3 Bob Jones :: PhoneID 4, 555.7878 NameID 4 Bob Jones :: PhoneID 5, 555.9090 For web publication, it is not necessary to define this relationship in FM7. I simply have a primary key, Names:NameID and a corresponding Phones:NameID. Then, using PHP, I can simply grab the NameID in one FX instance from the Names table a…

hi and thanks for all your help in the past! i perform several inline actions that will not work when i reference my current database, yet when i make an identical copy of the database, name it something else, reference it, it all works fine. this leads me to believe it's not a database, but a cdml problem. here is a code snippet: [FMP-InlineAction: -db=mydatabase.fp5, -lay=master, clientnumber={fmp-field:clientnumber}, type={fmp-field:type}, birthdayempty=0, -sortfield=birthcountdown, -sortorder=ascending, -max=3, -find] again, that coding works fine referencing an exact copy, differently named. im stuck, any advice is most appreciated!

Hi fellow FileMaker web gurus! FMWebschool has re-written their popular book "FX.php In 8 Hours" specifically for FileMaker 7. http://www.fmwebschool.com/php8.htm Now when you purchase this new updated version, you receive separate books for FileMaker 5/6 and FileMaker 7. What is FX.php? FX.php is one of the quickest, easiest ways to bring FileMaker to the web. FX.php is a free, open-source way of putting FileMaker data on the Web using the XML output by FileMaker's web companion. What do I get with FX.php In 8 Hours? ** "FX.php In 8 Hours" for FileMaker 5-6 (Book available for instant electronic download) ** "FX.php In 8 Hours" for FileMaker 7 …

Hi everyone, I have a layout which show a list view of records, one line per record. At the end of each line I have two buttons. One is just a button, the other is a field. Both buttons should do the same thing, run a script which changes to a form view layout of that record. The proper button works perfectly, but the field button changes layout without changing to the relevant record - it always displays the first record on the page (not the first in the found set). Anyone else come across this, and found a work around? It's driving me nuts! Edit: Something I forgot to mention - the buttons are in a portal designed to hide the button if it isn't relevant.…

Im creating a new entry using FMNew() and I have a ID# that is generated for every new entry (in my FM DB) but I can't seem to be extract the info. <?php include_once('FX/FX.php'); include_once('FX/server_data.php'); include_once('FX/FMErrors.php'); $user=$_POST ["user"]; $newrecord=new FX($serverIP,$webCompanionPort); $newrecord->SetDBData("demandereparation.fp5","Web"); $newrecord->AddDBParam("user",$user); $newResult=$newrecord->FMNew(); ?> I try to extract the FM variable ID but I always get an error. I tried adding this to my code to get it to show. foreach($newResult["data"] as $key=>$newData) {} echo $newData…

I have a survey published online to track our customers satisfaction wiht our product and service. I would like to be be able to capture the survey takers IP address. Is this possible?

Database goes "offline" and is not available via the Web, but the database is "open" on the host machine is accessible via FileMaker clients over TCP/IP. The FileMaker Pro error.log shows the following message "HTTP session disconnected." and "Badly formated url" Does anyone know what would cause this error?

I've set up IWP so that others can read our database over our LAN, but I've encountered two bugs (?) and I need workarounds/fixes/explanations. ~ When viewing a list, only five records appear in the browser window, even though there's room for at least twice that many. (the rest of the vertical space is empty, white. ~ The toolbar does appear in the client's web browser, on the left-hand side, but clicking on the "sort" button triggers a popup window which disappears in a flash. Now, I know that IWP is optimized for MS Internet Explorer (IE) 6. But I've kinda disabled it on all of our PC's because I've gotten sick of fighting popups and malware. (I've got a…

Greetings Windows 2000 server FM 5.5 Unlimited I have read this thread and I wonder if anyone ever found a solution to the problem. I have found out that you don't need more than one form field, and it's sufficient with one field in the FM db, to generate the error. If the amount of characters in the one form field exceeds aprox. 3000, Web companion sends this error message: 'Unexpected Error An unexpected error occurred: Couldn't find database name in POST arguments. Click the Back button on your browser to return to the previous page' You can have 1000 form fields on a single page, as long as the total amount of characters sent to WC don't…

Finally FileMaker Custom Web Publishing Made Easy November 15, 2004 DAYTONA BEACH, FL- November 15, 2004- FMWebschool announces the release of FXForge V1.01 a powerful automated custom web page builder for use with FileMaker 5-7. http://www.fxforge.net FXForge puts the power of web publishing back where it belongs. Yes, within FileMaker Pro. FXForge works from within FileMaker making use of FileMaker

I'm having some problems starting IWP. I can turn on the TCP/IP in the Filemaker network settings, but then when I try to turn on Instant Web Publishing it gives me the error "Filemaker cannot share files over the web because Instant Web Publishing could not be started"...i've read a few of the posts regarding this issue but nothing seems to be applicable...ideas??

I am building a fairly simple product DB that I will need to publish on the web using Instant Web Publishing and Server Advanced. Anyway, I am attempting to test (off-line and from my hard drive) the search function from IE, but I get and error as soon as I click on one of the search fields that indicate

I am seeking any information on persons that have upgraded from FM 5 to FM 7 that have online databases being run by Lasso coding. Did this coding convert easily? Did the coding have to be all rewritten? THanks Bif

Everytime I launch the FMD7, the message "FM cannot sahre files over the web because IWP cannot start. I go to Edit/Sbaring/IWP and set it to ON, the same message appear. Any ony can help me on this. How to start IWP ? It was running fine earlier. Thanks for the hlelp.

Hello PHP Ninjas, I have a multipart form that needs to post to multiple FM7 tables via FX.php. Is it possible to force the POST method in PHP across all the pages? Here's the dealio: Step 1: foo.php - Form action goes to foo-add.php Step 2: foo-add.php - retrieves data via POST, submits to foo table in FM7, then redirects to bar.php?foo=123 via an html meta tag. Step 3: bar.php - retrieves foo via GET, builds new form where foo is a hidden field. Form action goes to bar-add.php. Step 4: bar-add.php - retrieves data via POST, submits to bar table in FM7, then redirects to success page. For the sake of security, cleaner error trapping and stro…

Hello, I have the following form in a HTML / CDML web page: <form action="FMPro" method="post" name="search"> <input type="hidden" name="-db" value="nomenclature.fp5"> <input type="hidden" name="-lay" value="mod

I've got a huge problem. I have FM Adv Server 7. As you may know, it comes in 2 CD's (one is for serv7 and one is for the advanced features). Well, I installed Server 7 on my Windows fileserver, but never got around to adding the Adv server features - since I planned to use them when I was ready to integrate my FM DB with my web site. I finally got around to planning the connection of my web site to my FM DB. After much posting on this forum, many people suggested going with Lasso. I bought and installed Lasso v.8 on my Red Hat Enterprise Linux 9 web server, and was about to install the adv 7 package - but found out there is absolutely no way to install FM v.7 o…

Hi All, I've just converted our 80 file FM 6 system to a nice 11 file FM 7 system. The only think holding me back in deploying the system is the few websites we had connected to FM for a few of our customers to log in an make a reservation or lookup properties they have in stock. This was done with some CDML - and worked fine for us for a number of years. My initial plan was to get these up with IWP and then learn how to use the new xml/xslt system with Advanced to make the equivalent of our CDML system. I have found that for the simple things we need to do, IWP will be fine. However, one - what I thought would be simple - thing is now holdin…

We just upgraded our FM server advanced to v.3. Our agents who access us over the web would click a button which would open a url using the open url script step open url (https://doctoopen.pdf) which worked fine in server advanced 7.v.1 Now that we have upgraded to server 7.v.3 the open url script opens as http://https://doctoopen.pdf which fails to work. We called filemaker and they have acknowledged that this is a bug in the latest release (which amazes me that they would release this with this bug.) To us this is a major security breach and they suggested I downgrade to 7.v.1 Can anyone think of a workaround? Any help would be appreciated.. …

This may be an id10t error but why are my hosted db files, IWP enabled, limited to 3 concurrent web users? I have Server Adv.,of course- I thought the limit was 100 users for IWP. In the Server admin tool, I am told that my limit of WPE connections is 3- I cannot set it higher. What's up? I have read everything I can get my hands on and see no mention of licensing for IWP clients. Any thoughts? (Hopefully I overlooked something stupidly simple...)

I have a Lasso8/Filemaker6 install that contains a PDF link using: [variable: 'file' = (string_concatenate: ('/volumes/pdfs/'), (field: 'Job Number'), '.pdf')]. I have all my PDFs in a read only server directory - the name of each PDF matches the record name in the database and makes a nice hot-link on a web page. I have a thumbnail for each PDF that uses a container in a separate FileMaker database that uses some older Lasso code and some Java script:<a href="action.lasso?-Image&-Database=picturesx1&-KeyValue=[field:'pictures::recid']&Picture=jpeg" target="_blank" onMouseOver="javascript:window.status='Click here to view this image in a new window';…

I want to hide the status area and display a table on IWP, but the user has no way to go to another layout without navigation button. I tried creating a global container with a button in it, but it didn't work. Is there any clever way to include navigation options in a table layout in IWP?

FMP 7 with IWP Loading the database in a framed page leaves it un-useable. Buttons don't work and can't enter fields. Loading it in a new browser window and everything works fine. Link for a framed page: www.mlsmax.com select buyers and email new listings Link for new window: http://sage.forest.net/fmi/iwp/cgi?-db=eEstate.fp7&-startsession FMP7 Mac OSX 10.3.8 Help!!

on my layout I have a portal to input up to 10 records, which works perfectly on my local machine. When it is over IWP however, the portal only allows me to input 1 record at a time. If I hit the submit button and then go back and edit it again I can put in one more. Is there any way to be able to type in all 10 records without submitting them one by one?

Hi FMForums, I have created my database so that records from one table are linked to records in another based on a unique id number: a basic "many-to-one" relationship. I want to make it so that when a user gets to associate their new record with a record from the other table, they can choose from a pop-up menu of all the possible items from the other table. This is easy in the FM App: Just make a value list that displays both the ID and name field from that other table. However, the second value (the name field) doesn't show up in that list when its published on the web! What technique do most people do to overcome this limitation? This seems like it must be a …

Hi, I'm new to the forums, and relatively new to File Maker Pro. I made a couple of databases and didn't have problems hosting it on one computer, but now I have moved to another Mac (running on OS X) and the databases were giving me an "unknown error of 802" in IE when I tried to access them. I tried working in Netscape and it was fine, but since FM doesn't really "support" Netscape, I downloaded Safari and when I tried going back to FM, the files were saying that IWP could not start, and sometimes saying that the computer was already hosting the file. Even when I close everything up and restart, it's giving me the same problem. What's going on? Thanks for any advic…

Hi, I am new in PHP. I am wonder if has anybody out there who can help me with some code? I have a form with 3 radio buttom and what I am trying to do is to have an if statement if in case the radio "Yes" is checked will take it to the page 1 If radio "No " is checked will take to page 2 If radio "other is checked will take to page 3 thank you, msei

I have a client that I have built a custom web publishing shopping solution for using CDML. They are also using IWP for some things that they are doing periodically. I read in the documentation that you can hide files from the default home page by changing their names to end in an underscore, which I did try but it did not work. Does anyone know of a way of doing this in FMU 6.0? I know it is very easy in 7.0.

I may be missing something small here but anyway : I am trying to use a "ghost" file which only contains my layouts and scripts for IWP purposes. This file is stored on its own server and is linked to our main FM7 server. In FM Pro this file works perfectly however when i go to our website there is no data in my records. This is my first try at online DB design in this way so i am a little lost. As always any and all help is appreciated

FMWebschool has uploaded a free, fully functioning FX.php driven website powered by a FileMaker 7 database for you to enjoy. If you are interested in custom web publishing, and want to see it in action here is your chance. If you have FileMaker 5-6 you can be up and running in 10 minutes. If you have FileMaker Server 7 Advanced with either Apache or IIS installed, you can be running with FX.php in 10 minutes. What you get: http://www.fmwebschool.com/fxsamples.php -A free website. (Add your own images, change it around, make it your own) -The FileMaker database the website uses (Vertigo.fp7) -FX.php Folder set up and ready to go (Add this to your Apache…

I've searched the forum and can't find an answer to my question. So hopefully someone out there can shed some light... In my photo archives database (published via IWP), I want my clients to be able to search their photos, but I don't ever want them to see other clients' photos. The "Home" layout is always viewed in Browse mode. The only visable field on it is a global field that is set to "" every time someone goes home. The idea is that the user enters the search term in this field, then clicks the Search button. This button is scripted to copy the contents of my global search field, enter find mode, paste into a Keyword Concatenate field (which is on the lay…

Hi, I'm a bit of a newbie to web publishing, and I'm interested to see if I can get one particular output from a company database saved as a web page that both our mac and windows users can easily reference. It's basically a flat plan layout for a magazine, so it's quite graphic. I want people to be able to see the current plan for any particular issue. The trouble is, the layout that will be used to depict it will change with the issue size. If they access it through filemaker, they will automatically be taken to the layout with the right number of pages on it. But for most people filemaker isn't very convenient to load up, and a web page would be much better. …

Hi, I've made a simple form to input some text. I post this text using POST. The text is received by the second page, like it should. Then I save this in a new FM7 record. No problem. Only problem is that when somebody uses characters like "

Hi, a while back I was having a problem with the format of an email.txt file that would be the body of an automatic email that would be sent out using the inline script: [inline: email.host='smtp.bu-london.co.uk', email.to=(Field:'stpermemail'), email.subject='BU London - Update Confirmation', email.format='email.txt', email.from='[email protected]', Nothing] [/inline]

Im trying to create a simple login page. I need for both user and password fields to match to validate the user, but if only user or password is filled the user with still have access. Took some code from Advanced filemaker pro 6 Web Development book but still doesnt work. Here's my code for my result page. <?php include_once('FX/FX.php'); include_once('FX/server_data.php'); include_once('FX/FMErrors.php'); $search=new FX($serverIP,$webCompanionPort); $search->SetDBData ("db.fp5","main"); $search->SetDBPassword ("123"); $search->AddDBParam('user',$_POST['user'], 'eq'); $search->AddDBParam('pass',$_POST['pass'], 'eq'); $searchResult…

I think I posted this in the wrong forim, so please do not consider this a double post. To make my fmi/iwp my home directory, what is the corresponding directory on my hard drive??

As a FM newbie I got some general IWP questions (and of course I browsed through the postings first...). I'm redeveloping an existing database for my office to launch FM7 soon. The plan is to run the office-intranet on FM7 server (which is already in a box on my desk...still not opened) but as far as I got this, IWP needs FM7 server advanced (if ran from a server) that costs a little more... So, if your boss asks you, is it worth to upgrade to the advanced version and use IWP, what would you anser???

A friend of mine has his sales information in FM 5.5. I created a forecasting model with PHP/MySQL, exporting and importing data via CSV files. The model is working great and we'd like to put things in daily operation. We're not sure what to do: re-programming the model in FM, or linking up FM/PHP. What's your take based on your experience? Does FX.php work on FM 5.5?

In trying to test my IWP solution for various client log ins I have run into the problem of the Get(AccountName) getting my name instead of the client's name I have signed in with in User Id and Password fields. How do I fix this problem? I want to just show the client's records on their log in, but can not right now. I am running FM Server 7 Advanced on Mac OS 10.3.8. Thanks in advance - Sam

Hi and thank you in advance for any help you can provide this humble newbie. Short story: When hosting a file on FileMaker Server 7 Advanced, enabled for IWP, I can't log into any account except Guest using an Internet Explorer browser. The same file open on FileMaker Developer WILL allow login to other accounts. Long Story: I've been using FM Developer 7 for a few months and I have been doing well except for Instant Web Publishing. I will need to serve a database to 50 clients using Internet Explorer on an intranet, thus the need for IWP. Here's what I'm using: FileMaker Server 7 Advanced on a Windows Server 2003 Standard Edition, with IIS version 6. The …

Hello, I am posting a list of active and inactive members. I would like to sort first by last name and then by their active status. The result would be: Jane Doe, Active Bob Jones, Active Bill Adams, Inactive How do I configure multiple sort parameters in FX.PHP? Here is my code: // Connect to DB $ShowAll = new FX($serverIP,$webCompanionPort); $ShowAll->SetDBData('TheDatabase.fp7','TheLayout'); $ShowAll->SetDBPassword('xxxx','xxxx'); $ShowAll->AddSortParam('LastName','ascend'); $ShowAll->AddSortParam('ActiveFlag','descend'); // Search Parameters $ShowAllResult=$ShowAll->FMFindAll(); So far, I can only sort by l…

Recently I switched from FMP 5 umlimted/cdml to apache/lasso/FM 6 to serve my web site. Site is being served on an Xserve running OSX Server 10.3. Everything seems to be working fine, except when it comes to displaying images. When displaying search results that include an image, my results page frequently "misses" images (displays the little ? in a box), and even worse, seems to be bringing filemaker to a halt ("filemaker not responding") every day or so. Some stats: The database that holds the images contains only 650 records or so, and the images are in a container field and are small, small jpegs (>15k). I'm using the older [img: 'picture'] tag in the res…

I've constructed a site using IWP in which the status bar is hidden and locked. I've added a "logout" button for the users with the "Exit Application" step attached. Unfortunately, it's not working. It appears to log them out and sends them back to the home page. However, when clicking the link to re-enter the application, it logs them in automatically. I'm guessing this has to do with the browsers caching the username/password. It's not really practical to get the users to flush their cache each time (or even close their web browser). Is there some other way around this? Note that I get the same results with both IE and Netscape.

First, thanks to all who responded to my previous post about pulling data from other files in IWP. In the end, I had to import the data I needed into another table in my IWP'd file. I will probably roll all my tables into one file at the end of the academic year. Now, on to the new challenge: IWP is SO SLOW! FM Server Advanced is running under OS X 10.3 Server on a PM G4/733 w/ 512MB RAM. Pages take up to 30 seconds to render, finds take up to a minute or more to complete, and submitting data gets progressively slower (one teacher claims a 16-minute wait to submit her grades...) Is anybody else experiencing such performance issues? I don't think my h/w…

Ok, so I need to get FMS7A IWP to trigger some type of notification when a new record is entered. I saw that WebTrigger is not FMS7A IWP compatible? I need to either launch a script so I can make a dialog happen for desktop users or send email, etc... Also, we are in a budget crisis, so can't spend much money Thanks!

When I put the file up on IWP with a script that goes to the next data entry field, IWP places the entry field in the upper left of screen, putting the header and other important information "off screen." The webuser has to scroll down and scroll to the left to see the page the way I intend it to be viewed. I tried putting an invisible field on the upper left of the screen and telling the opening script to go there, which works, but seems kind of silly because I really want the user to be directed to the next data entry field which can be in the middle or even in the lower right of the layout. Is there any solution for this that works on IWP on Safari 1.2.4?

Hi everyone, I am a illiterate computer user in an unfortunate predicatment. I need to create an online database for 500 user to search for research resources (mice) that are available at the insitute. There are two users, internal and external. Okay, I have designed a database that works in browse mode, links work and data can be inputed by the secretaries in each lab. That was the easy part. However, when I went in to web testing, all the merged fields disappeared. (First problem) How do I prevent this from happening? What have I done wrong. (Second Problem) How do I test the different access priviledges? I have no idea if they are set up properly for t…

I have a web application that currently accesses a filemaker 6 database from unlimited on a mac os x machine using fx.php. We are trying to upgrade to filemaker server 7 advanced and have run into some issues pulling the data from the databases. I have upgraded my fx.php to the latest version so it will work with filemaker 7. The problem I'm having is that when I do a FMFind() or even a FMFindAll() my foundCount is always zero. For example, I am trying to query a login database for my username and password for the web application. The record exists so it should be returned however it's not. Here is what returns when I do a FMFindAll() array(9) { ["data"]=>…

Hello, I am trying to use CDML to display only the found records that are less than a date using the following code: [FMP-IF: FIELD: ExpireDate .lte. 6/30/2005 ] The problem is that this is only pulling up records referring to the month and day (not the year). So it will pull up dates like 1/9/2008 but not 9/13/2005. I can't figure out how to make it refer to the year as well... Any ideas? I've tried many different date formats in my FMP-IF statement without success. J

I'm in the process of trying to convert Mason Miller's shopping cart for lasso 3.5/3.6 to lasso 7. I'm allmost there, but I'm having trouble getting the sessionid generated by the lasso page to work. I can add items to the database but they do not get any entry into the sessionid field.. And this is needed to use the data later. Would like any help... I'm going to make the files and databases public if I can get them to work.... At the start of the shoppingcart page is this code (I have changed the value of the variable SessionID from a random number to a fixed value - trying to minimize possible errors)..... [if: (Cookie:'SessionID')=''] …

Is there a way to capture a url? I would like to have a catch all for "name.domain.com", get filemaker to catch the url and and go to the appropriate record based on the first part of the url.

Hi all, Today I decided to download the free trial copy of Lasso just to fool around with and learn. Our company does not really use Web based solutions, so I have had no real need to use it in conjunction with FM. So, following the instructions of OmniPilot, I installed the Jave runtime, ImageMagick, and Lasso. After putting the 'LassoSettingsMigrator' folder into the public web directory on my local machine, when I try to Open Server Administration, it just hangs. I can not even close the browser window. The vlose button becaomes unclickable. Since I am new to Lasso, any help would be appreciated. XP Professional. Lasso 8 Trial. Thanks.

Premise: I am using FileMaker Pro 7 to create, manage, and publish a database of records that are ultimately intended for a website being hosted (purchased service) under FileMaker Server 7 Advanced. This website is ought to provide a secure user login, after which each user is supposed to view his/her records only. Problem: Since I am creating this database on FileMaker Pro 7, I have to intend it so far for Instant Web Publishing, which will be unnecessary, once it is hosted under FileMaker Server 7 Advanced. This means that I cannot yet alter any browser appearance (e.g.browser tags) other than through FileMaker's own layouts. This also means, that to test my D…

How can I pass both the UserId and Password to the FM database in IWP? When my client logs in I would like the UserId & Password to be passed to the database so a search can be made on just that client's records and only that client's records will display. I can not just use the UserId ( Get(AccountName) ) because I have a few clients with the same last name and there is no Get(Password) function. Can the Password field be retrieved by another function? Thanks in advance - Sam

I have all my pages in the web folder. and when I run the search page, it says database is not open, but I have it open? here is my html code: <form method="post" action="FMPro"> <input type="hidden" name="-db" value="portal.fp5"> <input type="hidden" name="-lay" value="Layout #1"> <input type="hidden" name="-format" value="edit.html"> <input type="hidden" name="-recid" value="[FMP-currentrecid]"> [FMP-Portal: relationship] <tr> <td>[FMP-Field: Title]</td> <td>[FMP-Field: Author]</td> <td>[FMP-Field: Genre]</td> <td><a href="[FMP-l…

I have a question about doing a search on a related field. The field in publication.fp5 has a related field N_Catalog::Note that refers to a Note page in Note.fp5 So in doing a single search $search=new FX($serverIP,$webCompanionPort); $search->SetDBData('Pub_Publication_.fp5','ForWeb'); $search->AddDBParam('Title',$Title); $search->AddDBParam('N_Catalog::Note',$note); $searchResult=$search->FMFind(); Unfortunately, this doesn't seem to work. Any one have an idea, or is it not possible to do?

Hi, I am new at PHP, I am having a problem to bring the error message to my page if in case no record were found during the search, but for some reason the message is not showing up at the page. Does anyone have any idea what is missing at the code? here are the code I am having at the page: index.php --------- <form action="summer_result.php" method="post" > <input name="title" type="text" size="24" border="0"> <input name="author" type="text" size="24" border="0"> <input type="text" name="school" size="24" border="0"> <input name="submit" type="submit" value="SEARCH" border="0"> </form> -----…

Hello All, Newbie here, I want to use my database over the web with status hidden but can not seem to add a ubmit button when I enter a new record. I have created a "new record" button that runs a script - goto layout "data entry" then New Record/Request. That works fine, but how do I tell it to submit? I'm using Devloper 6 for Mac Thanks Slimz

Hi Everyone, I have a client that is the author of a regional media guide. He has a database in Filemaker with all the content for the book. He wants a CDROM to accompany the book. At its most simple, users must be able to search for media contacts from an interface on the CDROM. I'm not familiar with Filemaker so I