Other Internet Technologies

Hi everybody, I have a weird thing that happens when I use my WinXp Home laptop to (try to) access my IWP home page: the dialog box asking for my user name and password rapidly flashes in succession 3 times, then I'm taken back to the IWP Home Page. This doesn't happen when I try it with a Mac running OSX or a PC running either Win98 or Win2k (I'm not even clear if it's only my laptop that has this problem or if it's a general thing wit XP - if anyone wants to try and log in, you can point to http://www.logisoft.no-ip.com:581/ ). I didn't install Service Pack 2, the WinXP firewall is deactivated (I have a hardware firewall) and it doesn't work if I point th…

Hi, Karen! I actually haven't really used IWP except to help folks with their questions but we should be able to get you going. I'll post your Q for you in the Instant Web Publishing forum, too... Now, a lot depends on your network configuration, e.g. if you have a router, what kind of IP address you have, etc. The ideal is to have a "static" IP address that does not change so anyone on the internet can always find your server. If you have a "dynamic" IP address, like most home networks, the IP will keep changing so it's hard to keep track of it. If you have a router that takes your "main" IP address and re-distributes internal IP addresses like 192.168.x.x, th…

I have a fm server 5.5 running under Unix, I share a couple of files using Web Companion on a PC, 1 files work fine but the other 2 don't appear in the web page. All the files are setup in the same fashion. Please Help !

I am writing my own PHP library that interfaces to FM7 via ODBC. If anyone is interested in this let me know. I hope to make this eventually publically avaiable. Right now I am interested in folks working together to make it better. Thanks DB Admin

Hi Could someone please tell me where I can get the latest version of the 'CDML Reference' database from? thanks!

Hey, I want a web page where users can edit existing records. I want some fields to have a drop-down list using values from a FileMaker value list as the options. I've got this much working fine. Also, if the record to be edited has a value for a particular field, I can get the option list to default to that value. For example: echo "<select name='userTitle'>"; foreach ($userInfoValueList['valueLists']['Titles'] as $key=> $titleValue){ if ($titleValue == $userTitle){ echo "<option selected value='"; }else{ echo "<option value='"; } echo $titleValue; echo "'>"; echo $titleValue; echo "</option>"; } …

I just caught a funny little glitch after an hour of pulling my hair out. In my FM7 database I have a relationship with a global on the left and a number on the right. The global is always 1 and the number is either 0 or 1. Since globals can't be indexed the relationship appears as broken on the TOG, but as we all know, this doesn't matter for glabals -- they can be used as the LHS of a relationship and it still works. Except that it doesn't work as far as FX is concerned. I have a portal based on this relationship. Looks fine on my FM layout, but FX always returns an empty result for this field in my browser window, as if there were no related records. …

I am using portals to display 10 records at a time in the web browser. Is there a way to have a button on the layout that will show the next 10 records in the portal (and previous 10 records)? thanks in advance

I am planning to buy Server 7 Advanced but before I do so I tested my database using the client's built-in web publishing. I assume that both make use of the same or similar engine and that they will both make the same mistakes. So here I go: If I use the client to format text in a text field (let's say, make it red) and then activate the same text field in the web browser (by clicking into it), the text changes to black, but upon exiting from the record and returning to it, I noticed that the formatting remained intact. If, however, I add a character to the end of the existing red text, the formatting for the entire text box gets lost. I assume that this has to do wi…

What I most like about FM is it's ease of use. I used to be able to create demos of projects using FM 4 and Claris Home Page in days and watch developers recreate them in what they than termed robust products like Silverstream in months. I never understood why it was so complex to connect to the high end databases. My fear with using Flash as a GUI is that I will have to learn and suffer the pain of those developers. Just how difficult is it to connect Flash to the FM files? I have FM 7 developer on OSX 10.3 Server. I also have Dreamweaver Studio 2004. My initial take is that I have a long learning curve to produce a working interactive site.

Dear Folks, I'd like to publish an FM7 file to the web using FMS7A and FX.php v3.0. I'm serving from Windows 2003 running IIS 6.0 and PHP 5.0.2. Following the FX.php in 8 Hours tutorial from FMWebSchool.com, I've set up FMS7A and the web publishing console. I can see the database is available and awaiting publication via IWP and XML. I've confirmed connectivity via IWP. I'm running into several problems with FX.php. Here is the code: <html> <head> <?php // Initialize Vars include_once("FX/FX.php"); include_once("FX/server_data.php"); include_once("FX/FMErrors.php"); // create instance per tutorial $instanceName = new FX…

Hi there, I've put my database onto the web using IWP. The problem is that when i skip each record there is a bit of a pause while some of the elements load. I haven't got any big pictures just a few small jpegs for presentation purposes. When i go back to a record this problem disappears (i presume becasue the images are cached) - the wired thing about this is some of the elements that take time to load are not images i've inserted but buttons. What is going on here? Cheers

I have a cdml page where users can enter a search term, which searches a fm5 database. I need to record the search term in a second database. How do I do it? I'm stumped. In Lasso it's a piece of cake, but cdml doesn't allow inlines... /dan

FX.php version 3.0 is now available at: http://www.fmwebschool.com/fxphp2.htm August 2004 (version 3.0) Below are the changes: * Added support for FileMaker 7 Server Advanced -- new features, updated error messages, etc. (Thanks to those who helped with testing: Dan Weiss, Jason H. Awbrey; Steve Lane; Yousaf Shah; Alex Klepov; Dan Stein; James Hea; John May; and Imadiff's team -- Philippe Laury, Jean-Philippe Palha, St

Iam a beginner in FM. I have couple of problems working on it and would be glad if any of the 2 gets fixed. 1) Iam using FM7 pro to create a database whose records are imported from a MYSQL database server. I want to publish this form i created using FM7(to import the records) on the web and allow the user to import the records from the web. I know the curent version of FM7 does not support this feature on the web so any suggestion as to how this could be implemented differently. I definitely want to make this online so any suitable suggestions are greatly appreciated. 2) If in the worst scenario iam not able to import records directly from the web will i…

FileMaker has made a giant leap forward with the release of FileMaker 7 in regards to Instant Web Publishing. We can now create layouts in the database designed for publishing on the web. No longer is it necessary to create separate web pages for publishing to the web. We can create the layout, test on the web and make layout adjustments in FileMaker depending on how the the browser renders the layout. So what's the Mistake? FileMaker has made two programing limitations that force me and others to have to publish our databases using Custom Web Publishing: 1) There is no way to customize the opening page when a client accesses the web database. We are stuck with the …

I'm quite new to web publishing of FM databases, so please excuse me if my question is obvious or doesn't make sense. Will FM7 be supported by an upcoming new release of Lasso? Thanks. Paolo.

Hi Does anyone know if you can suppress the URL detail in the browser address bar? E.g., instead of the browser displaying this as the result of clicking a link; http://192.168.1.3:591/buttons/FMPro?-DB...r.htm&-Edit You get this: http://192.168.1.3:591/buttons/FMPro I don't want to user frames to achieve this either - any suggestions appreciated!!

Hi All - Haven't visitied for a long time. I am trying to use a global field in an FMP-if statement and can't get it to work. What's up with that? If there is some reason that this can't be done, do you have other suggestions for how to work around? I am collecting screening data for research. At the und of my survey I have a thank you page that I use to invite certain people for follow-up studies, based on their scores. I can do that fine. In addition, I want to be able to turn that invitation text on or off depending on whether the follow-up study is active. So i've made a global field to set the study as active or inactive. TIA

I have been playing with the CDML to LDML (Lasso) conversion utility. It did not seem to recognize [includeField:fieldname]. Does anyone know what the equivalent for this CDML would be in Lasso? Basically my CDML uses [includeField:fieldname] to look at a specific field contents in FM. The field contains a calculation that changes from time to time. The contents of the field contains a name such as "thispage.html." Then [includeField:fieldname] is basically replaced with the contents of "thispage.html." LR

OK this is an addition to my last post..the problem I am seeing is that I dont have an "Edit Record" button anywhere. Any reason why its not there..is there something I am doing wrong?

hi all, i'm wondering if this is a bug in FMP7. i have only been having this problem in the last week or so. when i add new fields to a layout, i find they cannot be entered in find mode via IWP. they can be entered in browse mode in IWP however. the same fields can also sometimes be accessed on a different layout in find mode in IWP. it's not to do with object layering, because it does the same thing when there is no other object present. has anyone else had this problem?

I cant seem to be able to make any changes on any of the fields. I dont have restrictions whatsoever. I tried in both Form view and Table view and no dice on either one. Any suggestions?

I would like to restrict the access to a layout of a database I published on the internet to certain people only I tried to make this layout available to a certain group only using the Access Privileges but when I publish the database everyone can see it (I have associated a "Go To Layout" instruction to a button to access it). Is there a way to do it ?

I am very familiar with FileMaker, but new to Lasso and web publishing. Can anyone recommend a good book or other reference for those of us starting out on web publishing? Thanks.

Step 1 - login as root, change directory (do not forget to use "" for directory names with blanks!!) /Library/FileMaker Server 7/Web Publishing/publishing-engine/wpc/FM Web Publishing.app/Contents/Resources/iwpres/deu root# ls fmerrs.js help.html httperrs.js images nojserr.html strings.js strings.txt Step 2 - check file and permissions of strings.js /Library/FileMaker Server 7/Web Publishing/publishing-engine/wpc/FM Web Publishing.app/Contents/Resources/iwpres/deu root# ls -l total 264 -r--r--r-- 1 fmweb fmsadmin 2594 13 Aug 10:27 fmerrs.js -r--r--r-- 1 fmweb fmsadmin 109832 13 Aug 10:27 help.html -r--r-…

IPW shuts down after editing three records in form view. Upon choosing to edit a fourth record an error notice appears telling you the data base has shut down and is not available. In FM everything looks normal and works fine. In order to get IWP back up I need to restart the program and it will then go thru the same cycle again.

We are currently using v6 of FM to host web pages. We need to start doing some delivery in foreign languages. For this our best solution is going to be FM7 with its Unicode support. I have a question about my transition over to V7. I am concerned about 100 or so existing CDML pages that will have to be switched over. Thes pages rely HEAVILY upon very specific web page layout and design. For example: 1. Tables. Certain cells are encased in [FMP-If] statements to indicate whether or not the cell contents get displayed. The table and cells are all set to specific widths and heights. 2. Use of text boxes encased in [FMP-If] statements. Text boxes are again place in …

I understand a standard URL using CDML: h**p://xxx.xxx.xxx/FMPro?-db=files.fp5&-Lay=main&-format=redirectactive.html &-Error=inactive.html&-RecID=32846&Login=donut&-find I am trying to learn the use of LDML? Here is what I think I understand for formatting a LDML url: h**p://xxx.xxxx.xxx/web/default.lasso?-Database=Respondents&-Table=Web&-Response=results.lasso& -ResponseAnyError=error.lasso&-KeyValue=34873&-Show Is that even close to being correct? It seems to be working, I think it is something about my -Response page. I think that maybe I don't quite get the differences in LDML from CDML. My -Response …

Hi Attached is an example login that I would like to make work with FM 7. Any direction would be appreciated. Cheers

Hi there, now i have develop a small system that allow me to print some picture. I just insert the picture into layout and different picture in different layout. All my picture is in A4 size and once i want to print, i just link to the layout and print. It work fine for me in FMP. Now i enable the IWP so that i can use it on browser(IE), but i found that the printing size is far more smaller than actual A4 size. I have link it to the same layout and same picture, but the output is totally different. How can i solve this printing issue? Regards, Henry

I have been toying with FMP6 CDML converter from Lasso since Lasso people claim that Lasso 7.1.1 is compatible with FMP7 Server Advanced. So far, I have had enormous trouble fetching data from the databases unless I use [iNLINE] [iNLINE] statements. Lasso documents that they are deprecating non-inline statements but are still compatible with CDML converted to LDML code. Sounds nice, but when I select 'Classic Lasso' Support in the Lasso Admin Setup, I get an Internal Server Error from MAC OSX/Apache 1.2. Lasso tech support is attentive even with this eval version I have, but they do not answer my questions as I would expect. Maybe it has something to do with email vs…

Can someone please point me in the right direction? Using Lasso I want to build a login system for a website (basically just a searchable database rather than a shopping cart). I want to make it so there is a login form from a web page (rather than the pop-up login in FileMaker) that takes you through to the main part of the website. Can someone please suggest the best structure for this - I'm guessing that in Lasso you set an admin password and then a guest password and then use cookies or something to control access to the website but this doesn't seem very secure to me. I've always relied on the WebSecurity database in FileMaker for access but am going to use Las…

Anyone on the forums have any online URL's showing examples of how they are sharing up data to the web from FM using Lasso instead of FM's built in custom web publishing? Would just be curious to see how successful it is in practice. LR

7.0v3 updates instant web publishing to work with Mozilla based browsers. I tested it with Netscape, Mozilla and Firefox on Mac and Windows. Does anyone with server advanced know if they've updated that as well? I'm planning to use Server Advanced to increase capacity for IWP, but with many people in the department using Linux etc., I want to make sure they'll be able to access my data without having to put in extra effort to create custom pages for everything.

When a user submits a form I'd like to capture their IP address. I'm using: $webEvent=new FX($FMAddress, $FMPort); $webEvent -> setDBUserPass('User' , $FMPassword); $webEvent -> setDBData('CabiNet.fp7' , 'WebEvents'); $webEvent -> AddDBParam('UserEmail' , $userEmail); $webEvent -> AddDBParam('IP', getHostByName($REMOTE_ADDR)); $webEvent -> AddDBParam('EventDescription', 'Password sent to user'); $webEvent_OK = $webEvent -> FMNew(); I thought the php command getHostByName($REMOTE_ADDR) would do the trick, but this keeps giving me the IP of the machine that is serving the database. Any ideas? Thanks, Dan

[Ann] FileMaker 7 IWP and Server Advanced Book "Special Offer" IWP is extremely powerful, but yet still a little quirky. Now more than ever you need a way to establish a web presence quickly and easily. I have seen on numerous newsgroups literally hundreds of questions about work arounds with IWP. The problem is, there is no one single reference that has all of this information. That is, until now! FMWebschool has completely re-written "FileMaker 7 Web Publishing" as a resource for immediate answers. I have listed below the chapters and page numbers so you can see exactly what is covered in this book. The FAQ section will be a continually updated section of t…

Ok, I have a question for you guys. Recently I started learning fx.php with the intent to use this to connect our FM databases to a web pages without the limitations of IWP. Everything I am finding is telling me to turn on Web Companion, but I cannot find this for Filemaker Pro 7 or for Filemaker Server 7 advanced. Can someone point me in the right direction as to what I need to do to get my php scripts working and communicating with my DB. Thanks in advance.

Hi folks, Am trying out an eval copy of FM 7, as I need to publish a large database of photographs to the web. Everything is working as planned except that all the photographs are squeezed into the same sized box, and lose their original proportions. This makes them look awful and is totally impractical. I have searched in vain inside FM for settings but find none to change this behavior. Any help would be most appreciated! Lurch FileMaker Version: 7 Platform: Mac OS X Panther

My Instant Web Publishing user manual states that it is possible to create a script step that hides and locks the status area. I tried the "Show/Hide Status area" script step but this doesn't seem to do anything on the web page. The manual also states, " If you lock the status area... you must create buttons so users can create new records, enter edit mode to modify data, delete records, change layouts, and so on." Is there a script step to "enter edit mode"?

Before anyone starts I know there are 99 ways to find out the real URL. But in simple terms why give someone that doesn't know that the extra input. How can you access a web based FM 7 database and not show all the extra ?-db= etc etc at the end of the URL. Any suggestions? It interesting to note that once its there you can move all over the place in IWP and it doesn't change. I would like to hide the real URL and simple show our website name in the URL.

I apologize for my previous post subject heading. I simply need to know where the access log file is stored on the Mac using Native FM7. Thank you

I've developed a page using CDML to enable a person to add a record to a database through the web. Is there a way that an image can be loaded through a web browser and added to the database (ie. a company logo?). Thanks

I am trying to find out where the web access log files are kept for Native FileMaker 7. I have the path for FMAS7A. But I would like the correct path for Mac OS X 10.3 system Thanks Joe

I know filemaker can not run a spell check in a web browser, but is there a way round this??? Thanks, Kieron

I'm working through converting our CDML pages to PHP, and with CDML I am using the 'Break' encoding for properly displaying text field content that may contain paragraphs (eg. [FM-Field: myField, Break]). This allows for paragraphs in a FM text field to at least look like paragraphs on a web page, even if semantically they're not. However, using PHP all I get is one large block of text, irrespective of how it was formatted in FileMaker. Now, I realise that this is normal behaviour, but how do I go about replicating the CDML Break encoding functionality with PHP? I thought about searching for hard returns and replacing them with a <p> tag, but can't seem to figu…

After attending FileMakers DevCon in Phoenix, I was inspired (as many where) as I watched Cris Ippolite demo in the opening session. I have been developing in flash for three years and in FileMaker for seven. This is a great mix of a very user friendly, flexible tool (Macromedia Flash MX 2004) to develop a user friendly, interactive rich UI (user interface). Over the Web or as a standalone app the delivery is the same. If you coupled this with the new power of FileMaker 7 Server Advance or FileMaker 6 Unlimited, you end up with the ability to deliver a very powerful Interactive system to exchange data. I would like to use this Forum to promote Flash as a new UI tool, to …

Hi, I'm very new to FX and even PHP itself, so I'm struggling a little bit with it, but am making some headway. Anyway, I can't seem to figure out how to make linkPrevious and linkNext work. If I do this: $ReturnedData['linkNext'] as part of a link, it just reloads the page with the same (original) dataset, with 'skip=50&' appended to the URL. I've examined the FXExample file, but most of it just bewilders me. Can anyone give me some (gentle) advice? Cheers, Kevin Futter

I'm using FX.php and I'm trying to perform a find by an e-mail address submitted on a form. But it isn't working. For example: <?php $validate = new FX($FMAddress, $FMPort); $validate -> setDBUserPass('User' , $FMPassword); $validate -> setDBData('CabiNet.fp7' , 'WebLogin'); $validate -> AddDBParam('UserEmail' , $userEmail); $validate -> AddDBParam('Password' , $password); $validateResult = $validate -> FMFind(); echo "<pre>nn"; print_r ($validateResult); echo "</pre>nn"; ?> This fails to find any matches. There seems to be a problem with the @ sign. If I change my email to danatmydo…

Somewhere I found this function External ("Web-ClientIP";0) and it is suppose to get the IP address of the Client User on the web. Get(CurrentIPaddress) or whatever the name of it is only gets the WEB SERVER ip address and not the client. Any suggestions where one may find a command like the OLD version one above to get to work on Version 7 using the IWP web publishing???

How bad an idea is it to enable websharing on the Web Security Database to allow users to add themselves to the database (with all privileges etc submitted as part of a form so they can't change it from what I want them to have), also, it'd be restricted so that they can only add a user, not view user lists, edit or delete users etc Is this a really bad idea or would it be OK if it were tied down tightly enough?

I have two calculated fields defined in my FM database: - cn_current_found_ct = Status(CurrentFoundCount) - cn_current_rec = Status(CurrentRecordNumber) When I display these fields in a CDML web page, I get incorrect results: - cn_current_found_ct: evaluated after find and sort (e.g., in relation to found set) - cn_current_rec: evaluated before find and sort (e.g., in relation to entire DB, not found set) I found one or two threads regarding this incomprehensible behavior, but they all date back to previous versions of FileMaker (2-3+ years old posts). It makes no sense that one calculation would be pre-find/sort and one one post-find/sort, but…

Hi - I've got a reporting system with a "filter" at the top of the page, to narrow the search results (via inline action). The question I have is: once the results are displayed, if more exist than will fit on one page, the [FMP-linkprevious] and [FMP-linknext] don't behave properly. I'm wondering about the placement of these 'previous/next' links within the InlineAction tag pair. Interestingly the 'rangestart' and 'rangeend' and 'rangesize' seem to show correct numbers. Here's a code snippet: Thanks in advance. <P>[FMP-linkFirst]First[/FMP-LinkFirst] [FMP-LinkLast]Last[/FMP-LinkLast] [FMP-InlineAction: -db=coursesByUser.fp5, -lay=Search, …

My startup script includes the following step: Show/Hide Status Area ]Lock; Hide] It works fine for Windows users. The View > Status Area menu option is disabled. On the other hand, Instant Web Publishing users can still toggle the Status Area on and off. How can I prevent that?

I know IWP isn't terrible secure to begin with, but I want to at least try to lock my solution down as much as possible. The database is powering a signup/registration page (why they couldn't find someone to make something with PHP or similar is beyond me... ) so the users need much more access than the usual setup. As it stands now, a script locks the user to one restricted layout and locks out the menu items on load and creates a new record. Users have to be able to create, modify and delete records, however, becase the only way I could make an "unsubscribe" function compatible with IWP was to set info from the "new" record to a global field, delete the record, an…

I have a layout with a portal that I'm trying to publish with IWP for Entry Only. When I view it on the web, I can only add data to one row of the portal. That one row works great and publishes the data to the right database. I just can't get it to give me another row. Am I just doing something wrong or is it not possible to enter data into multiple rows of a portal with IWP? Thanks, Amy

Hope I am posting this in the right forum. We have a database solution which has been converted to version 7 form version 6 and now being hosted under fm7 server advanced running IWP . . It comprises of about 20 files. Using the new security feature we had to create a small database which will create and manage all the passwords and users across all the files. We have done this successfully. If I login under "user x" password "xxx" this will open all the other databases under "user x" and password "xxx" From the main file after logging in we have a re-login script attached to a button which will relogin us in with a different user and password and a new privel…

I've converted our database from 6 to 7. I'm trying to do a IWP and the script command Open File is not compatible. Is there a way around this to where I can view the necessary files when the a button is pressed and online?

I am making a system using CDML for booking places on events. I have a page at http://216.168.37.92/peterb/eventbooker/client_search.htm which allows the visitor to enter their booking reference and password to view the status of their booking but there are two problems with it: 1. The search needs to only return the record if the visitor enters the booking reference AND the password correctly. I've put <INPUT TYPE="hidden" NAME="-lop" VALUE=AND> in the file but if they leave the password field blank (or the reference!) How can I force this behavior?? I've tried a couple of scripts to combine the two fields into one and then search with that with…

Hello, can anyone help me? If there a way with an inlineaction to send mass email? I can only send one with -mailto, one with -mailcc and one with -mailbcc. But I search a way to send 100 emails or more with the -mailbcc instruction. It is for a newsletter. Dragon

Another problem with the events booking system: I created two fields, 'password' and 'passwordconfirm' I set both fields to require a value and I set the validation of 'passwordconfirm' in FileMaker with a calculation: passwordconfirm = password but that doesn't seem to work, the system allows different passwords to be entered - do I need to select 'Validate only if field has been modified' in the calculation if FileMaker or have a validation calculation on both fields??? Thanks

I am having problems with the nav links at the bottom of my results page. The search works as it should and returns the valid number of results, however, when you select the next group link at the bottom it goes to the next group of records but also changes my search results. It does the equivalent of a find all. Any help would be greatly appreciated. here is a link to the search page. http://208.137.136.132/events/events-search.lasso

Hi Everyone! I'm doing some conversions for a client and I'm trying to find date conflicts in scheduling. Now, I've successfully broke down the day's and times to UNIX time. SETUP: 1) I gather the requestors information $startDate and $endDate. 2) I gather the information from the database for that user. PROBLEM: I'm having trouble trying to get a handle to conflicts in date and start times. Logically I would step through each record and say: "if the requested start date is BEFORE the database END DATE but NOT AFTER the database START DATE, then all is well..." else return an error. I think I'm headed in the right directio…

As many of you already know, there is no built-in way for FileMaker to alternate table row colours via CDML. I recently needed to do this, so I thought I'd offer my simple-but-easy solution as thanks for the help I've received from these forums. I hope it helps someone else. In the document head: <script language="javascript" type="text/javascript> function alternateRowColors(RecNum) { if ((RecNum % 2) > 0) { document.getElementById(RecNum).style.backgroundColor = '#FFFFFF'; } else { document.getElementById(RecNum).style.backgroundColor = '#CCCCCC'; } } </script> Then, in the HTML code for your table: <table> [FMP…

I am having an issue modifying a repeatng field using FX, how would I set up the AddDBParam calls, do I 1.) send 1 AddDBParam with field name and an array 2.) multiple AddDBParam with same field name and a single value for each repition 3.) multiple AddDBParam with field name+[1...n] and a single value for each repition not sure if this is clear, but hopefully someone knows what I need... TIA

Hi, I'm a complete newbie on FM. (Experience in SQL Server, Delphi, PHP, etc..) I'm trying to find out, how can I change the default look&feel of the homepage ? thx

I've been doing a lot of testing with IWP ver 7 and from time to time for whatever reason and maybe its the user. IE gets closed and when the user goes back into the app they find there on a screen (they may have already been on)and locked and can't get off or to a previous screen. Anytime someone gets kicked out or exits the browser, I would like the session to be released and when they attempt to go back in to the app a start script. If they close the browser and go back in. Same thing. We need the ability to KILL an active session or something so when a users gets stuck and exits there browser we can reforce a start script. At the very least a UR…

Hi, I'm interested in showing the currently logged in user (account name) when connecting to a FMPro 7 db published via IWP on a particular layout. Here's what I've tried to do: - defined a field CurrentUser as a Container - defined a script Login with a line "Set Field [db::CurrentUser; Get (AccountName)]" - set File Options to run the script Login when opening the file I've tried putting the script on a button and executing it that way. Doesn't seem to work when connecting to the server IWP via a web browser. Everything, of course, works fine when connecting directly to the database locally--I haven't tried connecting over a network. (Not th…

Is it possible to make an IF-tag to check if the CurrentRecordNumber matches a series of numbers, say 1 or 5 or 9 or 13. Something like: [FMP-If: CurrentRecordNumber.eq.1 or 4 or 9 or 13]

Can anyone tell me why the IWP interface doesn't display a blank or new portal row at the bottom of a portal when the existing portal rows match or exceed the number of display rows? Meaning, if I have 6 rows of related data and my portal in IWP is set to only show only 5, when I go into Edit mode, I will not have a blank portal row to add a new portal record. If I crank up the display rows to exceed the existing data rows, presto, a blank row appears at the bottom during edit mode. Grrrrrr........

HI, ALL. i have a picture database and i set it up to share as iwp locally. from my host file , i have a table with pictures which i imported from hard drive from host machine. now i opened this files from guest machine and it opened the file. but it doesn't show none of pictures. should i place this pictures into guest machine as well ? thanks, kyle

I have added data validation to one of my fields. It is validated by a calculation and I have added a custom error message. Everything works as expected for Windows users but when an IWP user enters a value that would cause the validation to fail, no error message appears. Now it seems that FileMaker won't let the IWP user commit the record if this field's validation fails but the user has no clue about the reason why. How can I overcome this problem?

A FileMaker 6.0 database is running on a workstation with IWP turned on. The database is located on a NT server and being hosted on the FMServer 5. I am experiencing on a weekly basis that the database crashes. I am seeing two errors in the error.log. They are 401 and 100. I am seeing when the error occurs that the database is being connected to by the web/ip address and then they receive an error indicates "Filename could not be found and is required to complete this operation". If you go to the server the file has closed and needs to be reopened. The permissions for the user accessing the database is set to allow a constant connection and the permissions allow th…

Hi Can someone please tell me if it's possible to pass the result of the [FMP-Link] tag as a token; eg., <a href="FMPro?-db=database.fp5&-layout=layout&-format=formatfile.htm&-token=[FMP-Link]&JobsRecID=[FMP-Field:JobsRecID]&watchedby=[FMP-clientusername]&jobnumber=[FMP-field:combinedjobnumber]&-new"> If this is possible can someone please advise me on the correct format/syntax? Ta!!

Hi again, I'd like to know if it's possible to open a fp5 file through PHP. I'm using FX.php to get data from Filemaker, but all files must be open or else it won't work. I checked FX.php files and there's a function called FMDBOpen, but I can't put it working. Thanks in advance :

hello am newbie at FM. trying to make an integrated search page, with a search from a value list and the results on one page (so the format file is the same as the searchpage). The site is in a frameset that is hosted on one server, the page with the value list&search is on a different server and gets loaded into the frame'main by an url(http://mydomain.com/directory/FMPro?-db=database.fp5&-format=searchconcerts.htm&-lay=invoer&-view" target="main )When I click the submit button on the searchpage to perform the search I get a error message saying that the format file is not found??? have a look here to see what I mean, on the menu click "concerts": …

I have a maddening problem with a simple CDML web application that displays images out of FileMaker. The nutshell is, it works fine when the server is running on a Mac with FileMaker Developer 6, but the images are not served when the application is moved to Windows Server 2003 running FileMaker Unlimited 6. The basic architecture of the system is, the FM databases are hosted on a FileMaker Server system (Windows), clients connect to the FM Server to use the FileMaker-based application. A FileMaker Unlimited machine *also* connects to the same FM Server, and provides service for the web side of the application. The web app is pretty simple: a search form, search…

We are a small school district who has assessment databases in FileMaker 6.0. and using FileMaker Server 5.5. We are interested in converting them to online databases for the staff to enter information via the web. What is the best way to do that and where do I get more information about converting - what do we need and will the databases (they are pretty simple databases now) convert easily. I'm just beginning with this. Would it be better to upgrade to 7.0 - can anyone help or recommend training

Using IWP I am unable to access my database with an Admin account set to Full Access Privileges. On the home page I click on my database, logon as Admin, and a white page (with no database) with a small bar on the left hand side appears. However, if I logon as a Guest I see my database but the dropdown to select the user only has "[Guest]" with no other data available. What the heck is going on?!

I have followed the instructions in the manual and provided here in other posts to the letter. What am I missing? I have 1) turned on the Web Companion plugin and configured it to use the default.htm page and port 591 (yes IWP is turned on); 2) set the file -> sharing to use Web Companion; 3) have ensured there's no wierd password problem (by removing the passwords - having full access w/o a paswd for the time being). I have the DB files in a local dir (not in "Web"). When I browse to localhost:591 or even my IP address:591 (which is not static but I looked it up), I only get the stock default page with the boring text about Web Companion. What am I missing?…

I'm updating fields in a database, sdoprej.fp5, and once the user has submitted their updates, I want to turn off (change it from 1 to 0) a field, "prime", in a second database, sdoconsent.fp5. So I set up nested inlineactions. The outermost inline finds the correct record using the "studentid" field which is passed to the inlineaction via -token.3. Then all I want to do is to set the field "prime" to 0. But this isn't working? Here is my current inline code: [FMP-InlineAction: -db=sdoconsent.fp5, studentid="{CurrentToken:3}", -find] [FMP-InlineAction: -db=sdoconsent.fp5, {field:prime=0}, -edit] [/FMP-InlineAction] [/FMP-InlineAction] Thanks for your he…

Hi I've managed to test a db using IWP using the 10.10.10.10 test IP... I tried ver 7 yesterday and it is stunning and seems to work really well - I've designated two different ports - 591 for v6 dbs and 592 for trialing new v7 dbs - we're on a LAN here and connected to our local ISP through ADSL - As far as I remember (from setting up my router) the IP addresses are assigned dynamically by 'xtra' (my ISP) here in NZ, and when i checked the router config. they were certainly changing over time - the thing is how can I give an IP address to my client so he can see the db over the web if I can't ever be sure of the IP address... further more if the mac…

Today I installed Windows XP Service Pack 2. On the first re-boot, it asked me if I wanted to allow FileMaker Pro 7 access to the Internet, and I responded "yes". But when I started FMP7 it took a longer than normal time to start, and informed me that it could not start the Instant Web Publisher - before FMP7 did, in fact, start - without, it turns out, IWP capability. I then tried to share a database that had previously been shared, and it would not let me, giving me a pop-up error message saying that I could not share on the Internet because Instant Web Publishing had not been installed. But when I checked the firewall section on XP's newly installed Securit…

I am using FM 7 and iwp. The problem I am having is that lookup fields are not populated as they normally do within Filemaker itself. The many fields (ie names and addresses) remain blank even after the submit button is used. Any help would be appreciated. Thank you.

Hey gang, I've taken the plunge and have taken FM to the web, or at least I'm making good progress in that direction. I'm using PHP 5 with FX.php on Windows XP with the IIS server. I'm Using FM6 Pro for testing and learning at the moment, but will switch to FM7 Advanced Server once it comes out... I'm working through chapter 8 of Bob Bowers and Steve Lane's book "Advanced FileMaker Pro 6 Web Development." Having really good success, but am stuck at p 292. I'm trying to use the FX.php FMEdit() to edit an existing record. I understand that this command works only on a single record at a time, based on the -recid. I can find a single record using FMFind(), re…

Is there any way to trigger SMTPit through IWP? I see that there are other ways using PHP or other more complicated programming methods, but for simpletons like me I was hoping that I could get IWP to send emails using SMTPit. If the script is running on the host machine, why does it make a difference if it is triggered by someone coming in through IWP? It seems that in FM7's version of IWP, scripts run much more effectively than they did in previous versions. Thanks in advance Tom

Hi, I am not sure if this is the right place to post this question but here goes. I use FMP extemsively an want to make databases available on the internet but I am not going to be running a server myself. I have an account with a web host and most of my clients are using the same host. I have MySQL working on my account and I have full functionality of PHP/MySQL form what I have tested and seen so far. Is there a way to take FMP databases and set up, export or format so the data can be accesses as a table using PHP/MySQL? I am a novice when it comes to MySQL, I have set up phpBB and have some working knowledge but not alot. Can someone give me some direction …

I've used the mailto- tag to email our office with the details of the booking each client makes, which works great but I want it to also send an email to the client themselves as well, using the email address they've just entered in a field. If possible the version of the email sent to the client needs to be different to the version we get - is it also possible to have two text files with the email content - or even html files with links??? I see that I can either use a metarefresh (tried this and didn't seem to work, it displays a conf of the details OK but doesn't send any mail) or an inline action... here is what I have written: [FMP-InlineAction: -db=eventb…

Hi all, am using windows NT with Filemaker 5.5. Unlimited. I set up my DB on and intranet site and all works great. using Instant web publishing. It is currently set up so that so that each user must enter a password and based on that pw have certain accessible rights. What I need to know is how to set it up so that when the user goes back to the homepage, they get the password request window again. Thanks for any help Carmen

hi Just read anumber of accounts on how to upload images to a folder linked to FM db. i think I could make it work using CDML but do not know how it would work in iwp. Would be interested in an applescript solution. I am running FM 7 on OSX Server. http://www.fmforums.com/threads/showflat.php?Cat=0&Number=114256&an=0&page=2#114256 Cheers Gary Weisbrodt

As a newcomer to (the soon to be defunct it seems) CDML these questions are probably obvious, but: 1. When using the format tag ( as in [FMP-Field: Adress, format] for example ), how do I set what that format is? It works fine in that the carriage returns the visitor enters appear when we view the record but the text seems to come out in differenct sizes with different pages/databases. 2. Could you point me towards any help with sending mail when a visitor creates a record, ideally to send them a confirmation with the details they entered and to send us a slightly different version with that information - I know it's just a CDML action but if there's a site or …

i have a contact logging system that i developed with online in mind. Everything is web compatible (unless i missed something). When going through the system within FM, everything works fine. i shared the system online, and i can't get it to let me enter anything into the fields at all! Even when i'm in "edit" mode it's just not letting me edit anything. I can't even click in the fields and the checkbox and radio buttons are greyed out. If someone has heard of this and has any ideas plese let me know. Or, even better, if you are fairly familiar with FM7 and IWP and can take a look at the file, drop me a line and i'll send it your way through email. An…

PRE- RELEASE "FX.php In 8 Hours" It's now possible to learn in days not weeks. http://www.fmwebschool.com Daytona Beach, Florida (Aug 23, 2004) -- FMWebschool is proud to announce "FX.php in 8 Hours". "We are extremely pleased with this book as it will allow individuals to create custom web sites for their customers using FileMaker 5-7." said Stephen Knight of FMWebschool. "PHP is the most widely used scripting language for the web. By learning FX.php you have opened the door to integrate thousands of PHP scripts and utilities with your FileMaker solution. PHP is a server side programming language and doesn't have the browser compatibility issues tha…

Is there another way to capture CDML Form content on a web page and send it via email other than CDML's -mailto -host et.:? I am collecting data in a form, but need it sent to a specific email address when it is submitted to the database. Thanks

For some reason if you just point a browser to my FM6 server it loads quickly. http://helpdesk.chesaningschools.net but if I point it to a CDML page it loads very slowly. http://helpdesk.chesaningschools.net/FMP...0View&-view What might I have wrong? The password to display the database is "support" Thanks, Brad

The iwp keeps shutting down. Is this happen to somebody? I browse the files as soon as I open FMP7 but within an hour I can't

Have been running FMPro 4.1 on the web and using CDML to search and display results. This has been running for four years with no problems on our own server running Mac OS 8.6. For various reasons have now changed to FMPro 5.5 using a third party server also running Mac OS 8.6. Using the same CDML based pages the database file cannot be accessed and an error message stating File Not Found with the subtext 'The file you have requested does not exist on the server' Despite checking all coding and the parameters for Web Companion etc cannot solve the problem. HAs anyone any ideas as to what may be the reason.

Anyone want to test my online scheduling system? The address is 128.101.105.13 You can use the test account name nilgun, with the password nilgun. This is obviously not a production system so you are encouraged to try to break it. There is a 5 concurrent session limit, so I'm expecting people to run into that error message. This will be helped when advanced server is released (and I scrape my pennies together) Any comments questions are welcome and appreciated. Dana PS, I should mention that I have it set up so each account can only be logged into once. The account will then be disabled until either the user clicks the logout button, or the…

Hoping someone can see what I can't here. I'm trying to use a value list to display radio buttons for a survey. No related files involved - it should be easy. But the value list isn't showing up online - just the code. Any ideas? Here's what I think are the relevant parts of my code. <form method="Get" action="FMPro"> <input type="hidden" name="-db" value="LEEDSurvey.fp5"> <input type="hidden" name="-lay" value="Main"> <input type="hidden" name="-format" value="leedty.html"> [many more lines here that actually work] <p> Please rate the projects with a letter grade of A to F.<p> <table width="100%"&gt…

i have a network that connects to the internet through my computer (2 NICs) using Microsoft Internet Connection Sharing. Before IWP is turned on and accessed on the client computer, they can all browse the internet. But as soon as IWP is turned on, and after they try to access the database, their internet connection is lost. not until i completely exit filemaker will they be able to access the internet again. this is rather an odd sympton. does anyone else run into a similar problem? now i have to use sygate network manager in order to use IWP and internet sharing at the same time... for some reason Microsoft's just doesn't work ... or is there any solution…