Other Internet Technologies

I've been through most of this forum. Looks like IWP doesn't like lookups. I have a caculation that combines a document tracking number and an illustration number to make a file name something like this: C154-001 C154-002 ... C155-001 C155-002 ... All the illustrations for a particular document start at 001. This relys on a lookup of the document number to find the last illustration. Everything works just fine in Filemaker. When I publish it to IWP, everything breaks down. Any help would be great. I'm using FileMaker 7.

I have a working fx.php/FileMaker 7 solutions which is connected and queries correctly. I have been able to edit a few fields in the database, but have been unable to edit a global field. Is there a way to edit a global field with FX.php? Thanks, Wesley

Let me start by saying I'm a novice with regard to IWP... Anyone have any ideas why FM crashes with "This application has generated errors" every time I try to activate IWP for a database? I have a large database that a client wants to install on several machines without spending $1500 on FM licenses, so I thought I would give IWP a look to see how much clean up I would have in my scripts. I fully expected to find a slew of incompatibilities, given that I haven't written a single script with web compatibility in mind. However, every time I try to turn web publishing on, FM crashes unceremoniously. The crash happens every time I click the ok button on the I…

Hey Guy, I am working on one project. one person is using filemaker pro. Now I have to convert his data from filemaker pro to postqresql using php. if some body have done or know how to please help me! thanks in advance... Bharat :>(

Hello Everyone !! Wish a very Happy and a prosperous New Year to all of you. I am new on this forum, but I am using Filemaker from last 4 years, I've an application which is currently running on FM 5.5 Unlimited with a CWP by using CDML, javascript and perl/PHP and I am trying to switch my application on FM 7 server advanced with CWP by using FX.PHP plug-in. Let me explain you the architecture of my new system, I am runnning two machines one for the FM 7 database and another one just for webserver stuff, it works pretty good becoz I just test some sample database with XML/XSLT publishing. I was trying to configure FX.php but I am having some configuration problems, I…

Hi, I'm running FM Developer 6 and I have a layout with 4 text fields and 158 container fields. When I view it over the web in Table View using IWP, the last 58 container fields are cut off. If I remove the 4 text fields, then I get about 6 more container fields. Is there an overall column or width limit to IWP? or is it an HTML limit? Also, are the widths of the fields adjustable when using IWP? thanks

When logging into a database using FMP7 client, username/password authentication works as expected. From a browser, the only access to a database is through the "guest" logon, which requires no password. Attempting to log on as "admin" or another identified user with password, FMP7 Advanced complains and disallows. Any suggestions?

Hi! I'm using IWP to run a relatively simple registration database on the web. Link to it is here (the database is live, but the opening page is still telling people to come back later to register) GEAR UP showcase registration Everything seems to be working well, and I wanted to open it up to the public next week, but I just got an email saying that a user was able to "see" another person's registration after hitting "Click Here to Register" (which usually produces a blank record and switches to the first layout) -- I couldn't figure out how this happened except maybe that the script "hiccuped" and skiped the "create new record" step. Has anyone heard o…

What I am trying to accomplish is to have the user be able to search through different file maker fields but chosing the field through a html form value list and then typing their search criteria, then click find for example If a user wishes to find items by company they would chose "company" from the pull down list, type in the company name and click the search button. Or If the same user wanted to find items by model number they would choose "model number" from the pull down list, type the model number and click the search button. The code below is the html equivalent of what I want. (sorta) The values in the value list (sku, compname, description, etc) are…

Hello, I have a simple subsummary report in my database and am having trouble displaying the subsummary data on a web page using CDML. My report consists of a subsummary part with two fields in it: 1) subject 2) subject count (a summary count of subject) In the FileMaker database I get a result like: Biology 5 History 10 Science 2 etc. I don't know how to replicate this on the web. I've tried sorting by subject and displaying the two fields within [FMP-Record] tags, but, of course, the subject field is repeated for every record in the found set and the subject count field gives only a count of all found records. I can't hard…

This new release fixes the "new record" duplication problem. You can download this new version at: http://www.fmwebschool.com/fxphp2.htm

Im setting up a DB and will be publishing it on-line. Im worried that the page doesnt resize itself and that may cause some users to not see info. Thanks in advance for any suggestions

Does anyone know if there is a php reference like the cdml reference that use to come with FileMaker. I would like to find equivalent actions such as Max, Sort Order, Scripts, ect. Thanks in advance

I'm trying to perform a search via a CDML web page on 2 fields of a database (field_1 and field_2) I want the search to require that both fields get entered exactly. The web security is set so that each needs to be an 'ExactSearch'. The HTML reads <P><INPUT TYPE="hidden" NAME="-op" VALUE=eq> <INPUT TYPE=text NAME=field_1 VALUE="" SIZE=30> <INPUT TYPE="hidden" NAME="-LOP" VALUE=AND> <INPUT TYPE=text NAME=field_2 VALUE="" SIZE=30> <INPUT TYPE="submit" NAME="-Find" VALUE="Search"></P> If I only limit field_1 to ExactSearch in the web security, I can type field_1 exactly and press Search and it…

Hi, I have my databases hosted with FileMaker Server (not Advance) and was wondering if there is any way to open them with a web browser using IWP. Thanks in advance

When trying to convert my php which previously worked with FM6 (and an older copy of FX.php), I have been having real difficulties finding the source of a problem: When I attempt a simple query using FX, I get an error 502 back. When I try the query myself, directly requesting it from FMSA7, the 'errorcode' element is 0. This is the dump from the FX query response: Array ( [data] => Array ( ) [linkNext] => [linkPrevious] => [foundCount] => -1 [fields] => Array ( ) [url] => http://server/fmi/xml/FMPXMLRESULT.xml?-db=Flat+Codes&-lay=Web&-max=15&Proper…

After chagin one of the FM templates, if dfound that the tab sequence isn't the same on the web and the one that i have configured on FM. any ideas?? Thanks in advance...

Hi I've used the search but couldn't find a way to do this. I have a "company" database and "employees" database. Now I have a page that has all the company info I need and below this a portal where all the related employees are listed (from the related "employee" database). I would like to open a new page with the employee info if I click the employee portal row. I haven't found a way to do this (to open the related record). Could someone tell me how this is done? Thanks in advance !

I have a PHP program that authenticates users against an LDAP server. Once authenticated Id like to give the user a link or button to click. I dont want to just give them a IWP link because they could just use the link to login in the future, and that defeats the purpose of using the LDAP server. how can I tell Filemaker to only accept users coming from a certain server IP or URL?

I have a .gif on one of my pages. I want the width of the .gif to be determined by a FM field. Can I get something like this to work: <img src="images/bar.gif" alt="" height="9" width="[FMP-field: Research::Q%] /1.5" border="0"> The field Q% is a FM Field with a number in it. I want that number to be divided by 1.5 for the width of the .gif. I know I can use a different field in FM to do this as a calc, just wanted to know if it can be done using CDML. Larry

I'm hosting a few websites on a XServe with FM7SA & FX.PHP So far I'm placing all the images in a separate directory. In the FM database I'm placing the location of that image as a normal textfield. Everything works fine that way. There's only one problem: for each client I have to make a webpage to allow him to upload or change his pictures on his website. Some of these client have FM Pro7 on their computer. It would be much easier if they could simply copy these images in a container field, just like they do with their text-data. That way I could make a nice back-office solution in Filemaker to manage their website content. But then I have to be able to di…

I am trying to create a new record in a database with FMNew(), but it doesn't seem to be working. I know that the variables have the correct data in them, and the same code used for FMEdit() (plus the -recid parameter) works fine. I've copied the code below: <? include_once("../FX/FX.php"); include_once("server_data.php"); $firstname = $_REQUEST['FIRST_NAME']; $lastname = $_REQUEST['LAST_NAME']; $middleinitial = $_REQUEST['Middle_Initial']; $numids = $_REQUEST['ID_Number']; $birthday = $_REQUEST['Birthday']; $gender = $_REQUEST['Gender']; $…

Please help! If the answer to my query has been posted before please direct me! I am using FM 5.5. I want to instant web publish a database. I am on a network with a local IP address. My server is connected to a Netgear router/adsl modem. When i publish a database as per instructions I can view it wihtin the network but not from the web. What am I doing wrong?

Hello Everyone, This might sound really basic but I've been staring at the screen for too long now and need some help. I've got Server 7 Advanced all up and running ok and using sitemaker I've managed to produce a basic xslt site. What I now want to do is start talking to the database using LDML. Sound silly but do you need Lasso installed to be able to do this. And where do you place the html pages on the server that talk to the database? In Filemaker 6 it was in the"web" folder of the application. Where now, in 7? I am just having no joy in connecting to any of my published databases using ldml. Any help on how to go about this would be great thanks.

Recently got FM Server Advanced, and have had good results for the most part. I have a nagging error with one user, who is running Internet Explorer 5.2 for Mac (I prefer and preach Safari, but this user's OS won't run Safari 1.1 or 1.2, which FM 7 requires)... The user routinely copies text from our FM database and pastes into emails, Word docs, etc. as part of her daily duties. In switching/toggling between her browser that's running the IWP session and her e-mail app or MS Word, however, she inevitably gets an error message stating "Internet Explorer Script Alert / Bad Request / The server could not process your request because your session has timed out" (scr…

FMWebschool has uploaded a new version of FX.php In 8 Hours. This update corrects coding errors and includes more examples. http://www.fmwebschool.com/php8.htm If you have already purchased the book you can download the new book at: Windows http://www.fmwebschool.com/download/PHP8H.zip Mac http://www.fmwebschool.com/download/PHP8H.sit The passcode is the same. Enjoy

Two snippets of code below - 1st is to enter search criteria 2nd to process that search 1---------------- <html> <head> </head> <body> <br><form method='post' action='Details.php'> topic<input type='text' name='topic' value=''><br> <input type='submit' name='submit' value='Submit'> </form> </body> </html> 2--------------------------- <?php include_once('FX/FX.php'); include_once('FX/FMErrors.php'); include_once('FX/server_data.php'); $groupSize='50'; if($type=='next'){ $skipSize=$skipSize + $groupSize; } if($type=='prev'){…

This is an annoying problem I've never fixed: When searching, after entering their search criteria, if a visitor hits the enter key instead of clicking on the Find button it doesn't work but comes up with 'Page Cannot be Found' I seem to remember looking at this a while back and was advised then to add a piece of code which made hitting the enter key work but stopped clicking on the 'Find All' button (which I want to keep) from working. Is there a method of making the Enter key submit the request whilst still allowing a visior to click 'Find All' instead? or if not, is there a method of suppressing hitting Enter from submitting the request? F…

I've seen this question asked many times on sites, but none seem to give a definitive answer. I have a database of users, each user has 1 record page containing fields of personal information that relates to them, and them alone. Via a web page and CDML, I want a user to enter a Username and Password that retrieves only the record page that applies to that user, and if they want to edit this information they should also be able to do this as well via a web page. The solution I initially had was a basic CDML search containing 2 fields and this works to a point. However if you type '*' it then finds information for all Users. Is there a way I can submit …

Hello, I just purchased a copy of FileMaker Meetings 2.0 for FileMaker Pro 7. Much to my dismay, Meetings 2.0 is not compatible with IWP out of the box. You simply cannot publish the database to the web. I don't understand why not. I bought it for that reason. I called the FileMaker Tech support line and was told that the program can be customized, but they do not offer any tips or advice on how to do so. Has anyone out there customized one of FileMakers Applications to work with IWP? I understand that Tasks, Donations, and Recruiter also suffer the same no IWP problem. Has anyone customized one of these FMP apps to publish to the web? Any help w…

I have a client that publishes a database using FMP v.6 on the web. It is controlled by another database only by admin. While the client DB can be accessed through an HTML page easily, the other DB, let's call it DBADMIN relates to DBCLIENT. Without using links on the HTML pages used to access DBCLIENT, how would I directly access (address) DBADMIN on the internet? www.mydomain.com:FMP_port#/what else? Keep in mind that DBCLIENT and DBADMIN are both located in the same FMP/Web folder. I've been using IWP in FMP7 which uses an completely different addressing scheme.

When a field with an attached value list is entered from a browser, the values at the bottom of the list show up. The user must scroll up to get to most of the list. This is bad! In the FMP client, it works properly. The values in the list come from fields in the same table and are related by a self join, if that makes a difference. Help!

I want this IWP-solution (FileMaker 7) to be used in a frame. <html> <body> <frameset cols="125,*" border="1" framespacing="1"> <frame src="html.htm" name="left"> <frame src="http://10.0.0.151:80/fmi/iwp/cgi?-db=testiwp&-loadframes" name="main"> </frameset> </body> <html> It looks great. But none of the buttons of IWP work! Am I overlooking something or is it simply not possible to work with (= push buttons) IWP inside a frame?

i have a database published online using FM7 IWP. when i open the file on the web all the buttons and forms are working fine but iam not able to go back to previous page using the browser back button. when i click the back button nothing happens. does anyone have a solution to this??

Hello, I'm kind of new to Instant Web Publishing in FileMaker Pro 7. I have a layout with a button that calls a script that increments the value of a field (because I think this will be easier in context). This works fine in FP7 but when published on the web (with IWP of course) the result is weird. The "set field" script line actually changes the value but then the web page waits for the user to click the "submit" button in the status area (it enters "edit current record" mode). I would like for the value to change automatically. How can I fix this? Is "set field" the wrong script step? Is there a way to bypass the edit mode? Is there a way to refresh? …

How do I tell fx.php to close/end a session in FM7? I have an application that will get heavy use, they are very quick and simple lookups. Once the user gets the info they need on a specific PHP page, Id like to close/end the database session. I know how to end the session in PHP and FM 7 IWP (Exit Application Script Step) but not on CWP with PHP.

I know that Dynamic Value lists do not work using IWP, but is there any workarounds for this? Here's what we have: We are creating a quick online ordering type system for our customers. We would like to store all customers in one database. The system should have an internal ticketing system. To build this using just a filemaker interface is not a big undertaking. We have a table for customers, a table for items, and a table for orders. The main ordering screen would have a portal that lists the related items specific to the customer that is logged in. This is no problem. However, each item needs to have a pulldown with very specific quantities available per ea. item…

Hi For a website I'm working on I stumbled upon something that I can't get working... On a page you have to select a country (this is a fixed list in HTML), hit 'search' and get a result page. Thats working nicely, but what I can get to work properly is this; On the resultpage theres another popup containing the cities and towns of the country selected before, and the values are dynamic. It should use a field (in the same DB) named 'City' to create the list from. So in a way its building its own list on availability. Hope this makes sense to you, 'cause I cant get it to work somehow. I've tried a bunch of things, but all I seem to be able to generate is A) a c…

I need to make logical or search using FX.php.I tried the way written in the document.I tried by mentioning AddDBParam('-lop','or') before mentioning the other AddDBParams and after and in between also. But none is working.It is giving me following error:- Fatal error: Maximum execution time of 30 seconds exceeded in C:inetpubwwwrootFX7FX.php on line 563 Probably it si having some problem in reading file in while(!feof) loop. Bharati

Been playing with FMSA and serving up pages to the web with lasso using Unicode. I can put text in a FM field using unicode and have it show up on the web correctly. For example, enter japanese text in the field, view the record on the web, it stays as japanese. BUT I cant get web forms with text entered as unicode to work when submitted back to FMSA. For example, if the field on my form has been filled out using Japanese and submitted, when viewing the field contents in FMSA there is nothing but question marks and squares. I have made sure that my web pages are set to UTF-8 encoding, but still no go. Now if I copy the text out of the FM field and paste it into …

A number of individuals have asked about setting up PHP and Apache on their PC's. We have found that one of the quickest and easiest ways to do this is: http://www.easyphp.org The installer is in French, but is extremely easy to navigate. After installed their is a toggle to switch to English. easyphp enables you to install php, apache and mysql through one easy executable. In Kindness Stephen K Knight FXForge FXForge, FileMaker custom web publishing made easy

Hello, When showing data from related fields (e.g. showing test scores for a student, where a student's data is in one file, his/her test scores in a related file, as in "toGED::form"), do both files need to have web companion enabled, or is it sufficient that the parent file have it enabled? Thanks in advance, Ursula

Hi, I am new here, but am having some trouble so I thought maybe I'd ask for help. I have a database that I am sharing through IWP. I have a fields that returns a "1" or a "0" that is calculated based on whether other checkboxes in the record are checked or not. my calculation looks like this: If (VideoEncoded &#8800; "" and VideoMaster="Yes" ; 1 ; 0 ) Now in FM7, everything works fine. As I click my VideoEncoded and VideoMaster checkboxes, my calculated value changes from 1 to 0 and back. In IWP however, when I click on a checkbox, my value changes... but when I click "Submit" it changes back. Has anyone experienced this? …

Hi from a newcomer to this forum! I have a booking web page with several FMP fields with the possible choices from a list in FMP. The fields are presented as checkboxes. The user fills out the form, submits it and is referred back to the form which now presents the summarized costs due to the choices. The user now has the choice to edit the form and resubmit...and can repeat this until satisfied. My problem is this: How to make it possible to remove all values from a field on editing the formpage? If the user unchecks a checkbox this works as far as to the last value which is NOT removed from the FMP field and the reply form page still has the checkbox for that …

At the FM IWP Home Page when I click to access a shared file I get a pop-up error that reads UNKNOWN ERROR 802. In Firefox it indicates a JavaScript error if that helps. IE just gives UNKNOWN ERROR. A little history. I wasn't able to access my IWP Admin page because APPARENTLY you have to set the Identifier and Passcode equal to a username and password with admin access on the OS. I ALSO read that turning off (unchecking) something in IIS works. I did both, and was able to get the IWP running. I can now log in to the Pub Eng. Administrator, AND I was able to get to the FM file home page through my internet browser(s), BUT when I click on one of the files…

I have a IWP based Filemaker DB that I want to go directly to. Instead we get that FM web page with the blue stripe at the top. The user then has to click on my FM db. Is there anyway to URL straight to my File? i.e. http://www.mydomain.com/MyFileMakerDB.fp5 thanks.

Have enaabled IWP using server 7 advanced and have turned on SSL at the FM7 admin section.. We we log into fM thru IWP using IE6 and SSL is enabled should'nt it show in my browser location as https instead of http ? And should'nt there be a lock in the bottom right hand corner of our screen. I think I am missing something Thanks Stu

I have a custom website that uses a FP5 database (we'll call MAIN-DB ) and displays records from that database using CDML. It also displays a field called field1 from a related database (EXTERNAL-DB). For the purposes of this example, the relationship we'll called LINK) so I use [FMP-FIELD: LINK::field1] . This works fine, and the related text field is displayed on the web page. field1 happens to hold the name of a person and pic1 is a container field, holding a picture of that person in the same related database EXTERNAL-DB. How can I pull pic1 through to appear on my website via MAIN-DB, in the same way that field1 does ? I've tried [FMP-IMAGE: LINK::pi…

When I view my layouts in IWP, my radio buttons and checkboxes are so light-colored I can hardly see them. I can easily change the colors but the changes don't show up for IWP users, only for local or remote FM users. I could use popup menus but the radio buttons are really more convenient. I've tried both IE and Netscape browsers and the results are the same. Any ideas?

Is anyone out there using VisualFX who has figured out how to sort or AddDBParam? If so, would you share the details - TIA- -Kele

Hi I'm using FileMaker Unlimited 5 and am having trouble with a CDML If statement. I've been using CDML for almost a year now and have encountered something similar before. I think I was told it was a bug in the web companion but here goes... I have a CDML if statement on my format page which tests a value of a field. Here's what I've got... [FMP-Record] [FMP-If: Field: ODD|EVEN .eq. ODD] <tr align="left" valign="top" class="row1"> <td>[FMP-Field: ODD|EVEN]</td> </tr> [FMP-Else] <tr align="left" valign="top" class="row2"> <td>[FMP-Field: ODD|EVEN]</td> </tr> [/FMP-If] [/FMP-Reco…

Is it possible to store the selected value from a value list ? e.g. <select name="subj1"> <option value="">Select Subject</option> [FMP-ValueList: get_subject] <option value="==[FMP-valuelistitem]">[FMP-valuelistitem]</option> [/FMP-ValueList] </select> so that the value of "subj1" can be passed to 'subj2' in order to perform an 'or' search on subj1 & subj2. Thanks drewc

Hi Guys, I've been writing a solution in FM7 to publish to our LAN users over IWP. The new IWP is FANTASTIC and has saved me SO much time over writing all the HTML I had to in v6 and earlier, so 10/10 to FileMaker for it. Except when it comes to printing. Does anyone have any clues how to standardise the scaling and positioning of page items so that a form can be printed straight from the browser, on Macs and PCs, and ACTUALLY LOOK THE SAME ON EACH? At the moment, when I print a form from a PC it's about 70% the size it should be, and the same form on a Mac browser is about 40% the original size, but it looks perfect when I print it straight from fileM…

I want to limit the number of characters a user can enter into a text area on a form. before i put any scripts on my form when the user edits the fields and clicks update, everything works well and the db fields are updated. However once i put the javascript to limit the number of characters in my textarea and then submit the form i get an "unknown error number 102". I know filemaker says this error is about incorrect links or field names but not in this case. Below is the javascript that i have used: <head> <script language="javascript" type="text/javascript"> function limitText(limitField, limitCount, limitNum){ if (limitField.value.le…

I have a few records displayed (all on one page) and I am trying to set a cookie based on whatever record the user clicks on. But the cookie is always getting set to a value from the last record displayed, not the one they click on. The idea is the user clicks the link in a record and it then goes to a page to create a new record in another database, where MyField is pre-filled in. This bit works fine it's just the wrong value pre-filled. The key part of code in my format file is... [FMP-record] <P> Value of MyField:[FMP-field: MyField].<BR> <A HREF="FMPro?-db=MyDatabase&-lay=Detail%20Layout&-format=CreateEntry.html[FMP-SetCooki…

I have a form that involves several checkboxes. It is a menu items checklist that a student can order thier week's of lunches. Each day is a separate table but not in a Portal. These days have a checkbox for each item they want to order. Why is it that when the student logs into the form, the squares for the checbox are not there? I even tried a "setfield" to a hidden field thinking that the Record had to be created first but that didn't work. I check the pallete thinking that it is a display field, no luck. It works in the regular FM interface but doesn't work in IWP. Any thoughts? Thanks.

We have uploaded 2 new movies from FXForge. One of the most requested tools for the web is the ability to upload files and images to your server. Also, to enable individuals to upload files and images while browsing your website. FXForge can build the pages for you to do this in "Seconds" watch the movies at: http://www.fxforge.net/Movies.php Another often requested feature is the ability to email from the web. In this movie we build the FX.php page with FXForge http://www.fxforge.net/Movies.php We would like to welcome everyone to participate in our FXForum at: http://fxforge.net/phpBB2/ FXForge, It Just Works! In Kindness Stephen K. Knig…

We have a results page with several links, if a specific field is empty, we want one page returned...if the same specific field is filled, we want a different page returned...we are having trouble with the if/then statement coding - specifically as it pertains to returning the correct page...any ideas???

Hi everyone, This one is very very weird. I'm using FileMaker unlimited on one of the computers at our office to share out databases to the web. Then to protect the fact that we are using FileMaker as our database and the location of our web server I include all the filemaker data using PHP. A basic technique but I think it stops most people prying. So what I do in PHP is... <?php include("http://db.ourdomain.com:591/FMPro?-DB=OURDB&-Format=..proshow2004entrants.html etc"); ?> But I keep getting format file not found errors. I have the filemaker web folder shared out over our network so that a few of us who are developers c…

Hi Everyone, After a discussion on another section of this forum I decided to have a go at using php on a test webserver, but I'm not having much success. As far as I can tell php is installed and working properly, because I get a pretty page full of info when I execute a test.php file containing: <? phpinfo(); ?> I then downloaded FX and I now have the FX folder sitting under my www folder (this is an IIS5 server by the way). I configured server_data.php with my filemaker servers (fm5.5, not unlimited) IP address and port. On my filemaker machine I have opened the sample Book_List.fp5 provided with FX, and I've verified it is being served via IWP.…

I'm debating about upgrading from FM 6 to FM 7. I read somewhere that FM 6 only allowed a certain number of people to access the DB at one time or per 12 hours. Does FM 7 have any restrictions on web usage? I would really like to know if buying FM 7 is the right choice. The free download has the IWP disabled so I cant try it out. Thanks for all your help.

What is the situation with record-locking? With a reasonably large FMSA (more then 15 files) + FX.php solution in play - is record locking an issue? How is it handled? Anything to be aware of? Special coding required (in FM and/or PHP)? The situation I am thinking of may entail 10+ users hammering the same files/record set. Thank you for your assistance Wes

I am using PHP 4.3.9and running the following simple code:- <?php if( !isset($_SERVER['PATH_TRANSLATED']) ) { if(isset($_SERVER['SCRIPT_FILENAME'])) $_SERVER['PATH_TRANSLATED'] =$_SERVER['SCRIPT_FILENAME']; else $_SERVER['PATH_TRANSLATED'] =realpath('install.php'); } if (! isset($_SERVER['DOCUMENT_ROOT'])) { global $DOCUMENT_ROOT; global $HTTP_SERVER_VARS; $_SERVER['DOCUMENT_ROOT'] = str_replace(str_replace('', '/', $_SERVER['PHP_SELF']), '', str_replace('', '/', $_SERVER['PATH_TRANSLATED'])) . '/'; $DOCUMENT_ROOT = $_SERVER['DOCUMENT_ROOT']; } include_once("/inetpub/wwwroot/FX7/FX.php"); includ…

I have a problem using a different account for my cwp(other than admin account). at the moment i can use fx php using either of the below step to choose the account. Code: $result->SetDBPassword('bandwagon','admin'); $result->SetDBUserPass('admin','bandwagon'); i now create a new account for my filemaker database, called 'web', which uses the same privilege set as the 'admin' account. this time when i try to use 'web' account with: Code: $titles->SetDBPassword('','web'); i get Errorcode- 100:File is missing error in the browser. does anyone know where i am getting it wrong. why is it saying file …

I am using FMP 7 on the Mac and I am looking for a toturial or a guide for pubishing databases on the web. I can't seem to find instructions. Is there additonal software needed? Thank you Robert

FMP6. Lasso 6. Mac 10.3. After creating unique 6 digit random numbers (no leading 0's) I am using Encrypt_MD5 in Lasso to loop through the records and record the encrypted version., which then gets put in the file the people log on to, the file with both versions is not web activated. The lasso loop gets a number, encrypts it, then passes it back to the encryption field. But FMP crashes, always unpredicatable. I have tried slowing lasso down with an extra loop, I've checked and re-checked everything, but go for 100 at a time and FMP always crashes. Can FileMaker take this kind of activity I am wondering?

I am working on a project I know how to do previous and next with FX.php but now I need to be able to add numbers like (1-2-3-4) so I can jump from page to page. Just like when the search results of a found set are shown, I need to figure out a way for those numbers to show up as well!! Please let me know if you know how to do this! Regards, Wes

I'm trying to make my FM Pro 6 DBs available over the web using IWP. I have two DBs, one called "Main" and one called "Jobs." When I navigate to the host machine through IE 6.0 I see the IWP home page with links to both of my DBs. The "Main" DB works just fine, but when I try to open the "Jobs" DB over the web I get a "Layout Not Found - Unable to process your request because the layout "28" could not be accessed" error. I have tried this with the "Jobs" DB open on the host machine, and with it closed on the host machine, and still, no luck. I have no idea what "layout 28" is...certainly not anything I've ever named one of my layouts. Anyone know how to access this DB usi…

I have been playing around with Developer 7 and IWP....obviously annoyed with the 5 record limit on lists....will server advanced allow MORE records to be shown when using IWP? There are many simple projects I would love to use IWP but this limitation would force me into more elaborate schemes. I have tried using a portal which displays many records..however..when signed on via the GUEST acct I am unable to trigger the portal to display various related records...even when using the set field script step with "run with full access privileges" option. Any info would be greatly appreciated!

Hi all, THE PROBLEM I am publishing two databases with Server 7 Advanced. One is the "FMServer_Sample_Config.fp7" database that comes with FMP and the other is a simple database that I created. Both of these databases are being served up by FMP 7 Server and can be accessed using remote copies of FMP 7. However, neither database is accessible via the Web using FMP 7 Server Advanced. Both databases can be published via Instant Web Publishing (individually) by using FMP 7, but not by using FMP 7 Server Advanced. WHAT I'VE TRIED I've tried turning on Network Sharing and Web Sharing for the individual database files and that doesn't seem t…

Hi everyone!!! Would like to know if we can disable these 2 buttons. There causing my scripts, in some cases, to execute more then once. Example: If I already have a button on the layout with a script attached to-it, if I press this button it will execute my code, but then the 'submit' and 'cancel' button show up. If I want them to disappear, I will press submit. Now when I do that in some instances, it re-executes the previous script that was activated. Any clues on how to fix this, if I cant disable the 'submit' and 'cancel' buttons. Thank you in advance for any help you can provide me with... Pat.

Okay I made a FM 6 solution with a custom login file and a data file. Nothing fancy. But I've locked the status bar and forced users to use my buttons for all functions. Most of the ideas and techniques came from this forum. Then I used the web companion to publish on web site. Now only some scripts/buttons work and my custom login doesn't work at all. Need suggestion of where to go now. I want my DB to work the same on the web as it does on my desktop. Is there an easy fix or plug in or do I start from scratch. Also is there any good books/websites that take desktop dbs to the web. Thanks

Around my place of work (and where my database is going to be accessed) we're all Mozilla Firefox fans. Unfortunately it seems the only browser that features/functions are working well is IE (for XP and OSX)... eg. buttons don't work in firefox Am I spanking a dead horse here? Should I just break the news and tell everyone we have to go back to using microsoft?

Hi I'm having a problem with an inline (this is the first time I've used them). I have the following link; FMPro?-db=databasename.fp5&-format=formatfile.htm&-lay=layoutname&-error=errorpage.htm&-view The inline on the result page is: [FMP-InlineAction: -db=databasename.fp5, -lay=layoutname, -max=10, -format=formatfile.htm, rep_notify="{ClientUserName}",searchstatus="Yes", -find] It displays the first 10 results ok but when I click on [FMP-linknext] button it doesn't display the next 10 records. Can someone please tell me what I'm doing wrong? ta

I have an application hosted on FM7 Server Advance, and use IWP for my clients to access it. I use the standard IWP homepage, which lists my application on it, and opens up an authentication window when the user tries to log in. Instead of the standard IWP homepage, I would like to create my own HTML page with a form, which would handle the authentication. Is is possible to have an HTML form handle the authentication, and link to my IWP application? I've seen mention of modifying the IWP resource file, but can't seem to find a post or article that describes how to do it.

hi there !! I have a problem with AddDBParam('-lop_end','or'). Can anybody give me some piece of code. I'm doing that in this way: //version 1 for($i=0; $i<count($field_value); $i++){ $this->query->AddDBParam('-lop','or'); $this->query->AddDBParam($filed_name[$i],$field_value[$i]); } $data = $this->query->FMFind(); //version 2 $this->query->AddDBParam('-lop','or'); for($i=0; $i<count($field_value); $i++){ $this->query->AddDBParam($filed_name[$i],$field_value[$i]); } $data = $this->query->FMFind(); but it's doesn't work : thanx for any help !!

Hello, I'm using FileMaker 6 (not the Unlimited Version) and I would like to know if it is realistic to use that product with FX.php to make a website that will be browsed by many users (for example, 20 users at the same time, or 50 users at the same time). What do you think about ?

Hi: I am having a problem with Lasso 6 retrieving html-encoded information from FileMaker Pro 6. The lasso code in the html format file looks like this: <P>[portal: 'AP2004CS'][field: 'AP2004CS::ct_html_HeadsPlusBody', -EncodeRaw][/portal]</P> A sample entry from the field 'ct_html_HeadsPlusBody' is as follows: <a href="http://handbook.school.edu.au/cgi-bin/univi.acgi?goto=HIS238" target="_blank">HIS238</a> Aboriginal History -- 4 pts<P> What is then displayed by Lasso as a result is: <P>HIS238HIS238 Aboriginal History -- 4 pts<P></P> How can I get the <a href...> c…

I have a simple layout (MembershipMasterFind) that presents the user with a Last Name field as well as a few control buttons. The script below works perfectly to "get" the member's last name and then present a new layout (MembershipMasterAddress) to allow editing. When working locally, you can enter the last name, either press Enter or click my "Find Member" button. However, trying to duplicate this through IWP fails. If I press Enter, the prior text is pushed up and I am on "line 2" of the last name field. If I instead click the "Find Member" button, I get to the 2nd layout with blank fields. To make it work correctly through IWP I have to enter the last name a…

I have a FMP-LinkRecID but wat to execute the script when the link is clicked. <input name="[FMP-LinkRecID:format=orientation.htm,layout=web]" type="button" onClick="MM_goToURL('parent','[FMP-LinkRecID:format=orientation.htm,layout=web]');return document.MM_returnValue" value="Orientation"> Can I add the script or the script.presort on the link. Thank you

After a day of debugging I've found my problem. But it shouldn't be a problem, and I'm wondering if others are facing the same issue. I have a layout/table for Jobs (called WebOneJobOK). Each job has and Architect, stored as a number. The Architect number is used to relate to a table called Architect, which has the related info for the architect -- name, phone, etc. This is really straightforward relational DB theory, and works fine within FileMaker. The problem comes when I access this data via FX.php. Suppose the layout has 3 fields: JobNumber, Architect, and Architect::Name. I perform a find based on the job number $userOneJob = new FX($FMAddress,…

I have a value list with some values much longer than others. I am presenting the value list using checkboxes. In FMP7, the checkboxes are lined up to the left. In IWP the checkboxes are "text wrapped", so most of the boxes are not lined up on the left. Any suggestions as to how to get the checkboxes to line up properly in my browser (IE 5)? Thanks Paul

When I try to turn on IWP using FileMaker Pro:Sharing:Instant Web Publishing, there is a long delay followed by the informative message "Filemaker cannot share files over the Web because Instant Web Publishing could not be started." In Preferences:Plugins, web.fmplugin does not show up. The plugin file is located in FileMaker Pro 7/Extensions/web.fmplugin along with autoupdate.fmplugin which does show up in Preferences:Plugins. Can anyone point me in the right direction? Thank you!

Hi, I am just curious to know if there is any way to show preview on webpage using FM Pro. Basically what I need is to Pivot (or group) the data so that it looks tabular but I am not being able to show like that. Let me explain what I mean say I have three columns as country state count USA CA 1 USA TA 2 USA AB 1 Singapore SN 1 Singapore SN 2 What I want is instead of showing like above group like USA CA 1 TA 2 AB 1 Singapore SN 3 Would appreciate any help. Thanks, Aditya

In my experimentation with IWP in FM7 I have found that, when you first open the file from the IWP Home Page, the Open script in the database runs. The problem that the open script is designed for the FileMaker Pro users that open the database, not the IWP users and thus goes to a different layout than I want the IWP folks to go to. Is there a way to tell that a guest is opening the database from IWP so that I can put that condition into the open script? I am open to other suggestions as well.

I a little stuck on this one. Instant Web Publishing FileMaker 7. Here is the scenario: I have over 300 clients that have records in the database. I would like to have just the records for the client that signs in with "User Id" and "Password" to show. How would I set up a script for this to happen? Thanks in advance for your help.

I am new to working in FM7 server with FX.PHP. I am used to Lasso so everything seems different. I am really having a hard time understanding and getting any code to work that would send an email out from a record in a database, with information from the database record embedded in the email. I am currently editing a record, then bringing the edited record up for display. Once it is brought up for display I want the choice to send the person from that record an email with there edited information. I am having no problem passing the field information through variables, it is getting them from there into a sent email message that is not working for me. If any on…

Instant Web Publishing on Server 7 Adavanced doesn't seem to process tab stops. Is this true, and is there any way around this? This seems to be a badly missing feature. Thanks, Enzo

Is there any work-around for the error code you get when you force a user to change their password on next login? Thanks.

I have put images into a container and they are distored and pixelated. The container is then linked to another page where the images show up but are pixelated? I have also tried putting them not in a container and that shows up pixelated as well. any help here on instant web publishing and images would be great. have tried pngs, gifs, jpegs at 300 resolution. Trying to make it work for both mac and pcs and printable. help!

Hi All. I'm quite new to lasso and I have a problem getting images from a filemaker database to a webpage. I use lasso studio for dreamweaver and have no problems getting the other fields from my database. But I have tried to get an image from a container field but no luck. I have a search page that works, a resultpage that works and displays all the found records. But I just can't get the image from the container field for each record displayed. Anyone know the tag/code to do it?? Any help would be great. Thanks The Dog

Using FM7SA and FX.php. When I create a new record or edit data using FX.php, the data is written to FileMaker twice. For example, when I create a record for John Doe, FileMaker records each field as a multi-line text field: First = John John Last = Doe Doe I'm sure the data is being passed to the php page properly. So why is it going to FileMaker twice? Has anyone else had this problem? What is the solution? Thanks, Dan

Hi, As written here http://www.fmforums.com/threads/showflat.php?Cat=0&Number=127207&an=0&page=0#127207 I'm looking for a way of building a complex application. I wrote already most of the business logic in PHP5 but now we need to port this PHP/MySQL to FM7. I know that with FX.php you can access the data of FM. But I would like to process some data and send the result back to FM, do you know if that is possible ? Otherwise, I could have to write a C++ plugin but I have no idea how that works? Where can I find the API doc?

I have a database that has WC turned on. I want to determine what the exact URL is to a given record in the DB so when I email the URL to an end-uder, they can click on it and be sent directly to the record.

Hi I have the same question. i have two files say, Interface and Data File. One contains all the tables (Data File)and the other has all the layouts,scripts and relationships (Interface). Thus on the web , i host only one of them (the one having all the layouts : Interface). The issues that I have in this arrangement are in the scripts. The Go to Related Record script step (in Interface File), shows a Unknown Layout to be selected.....even though there is a layout mentioned. This issue cud be b'coz the file in which the script is made has no table of its own. Though the script performs its function.The problem lies in the display, in Scriptmaker...it shows an unkn…

After making a search through a Lasso 6 page I notice that FileMaker remains in Find mode if anything except a non-specific find is executed. I think it's causing crashes. Any ideas?

OK, guys. I could really use some experienced input regarding IWP on Server Advanced. Some of the higher-ups at the college I work at have determined that making everyone use Filemaker by way of IWP would be a good way for the school to save money. I am highly skeptical (you don't think that nick is for nothing, do you?) that this will be effective for my department, which encompasses Maintenance and Security. I already have researched problems regarding script steps, and know that the lack of import and print steps will be a problem for some of our people if they were required to use IWP. Will it work on a computer where the people are doing frequent data ent…

I want to do some basic finds on records. I have a button that puts the layout in find mode, then I enter some information in any field and hit enter on my keyboard - it just clears the text I just entered...it works in filemaker but not online (with IE or firefox)...what do I need to do? Appreciate the help!

OK, I am in the process of converting my CDML over to Lasso. I have most of it working, but I am having a HORRIBLE time getting images contained in FM fields to show. In particular, it is the related fields that are just not working. It was simple in CDML: [FMP-Image:Research::Logo] Here is what I have tried in LDML: [image_URL:

I'm trying to maintain tokens across seperate web pages. It works fine until the page tries to access a differant database. At this point the tokens seem to lose their values.