Other Internet Technologies

Using CDML, I want to display a particular heading if the CurrentFoundCount and the CurrentRecordCount are the same. When I type [color:green][fmp-CurrentFoundCount] I get 29 (which is correct). When I type [color:green][fmp-CurrentRecordCount] I get 29 (which is also correct). When I type [color:green][FMP-if: CurrentRecordCount .eq. CurrentFoundCount]CFC equal to CRC[/FMP-IF] nothing happens. If I change the .eq. to .neq. then it appears...though it shouldn't. Does anyone have an idea why it is doing this? I don't have a problem with any of my other CDML on the page.

I noticed that PHP beta is out now - but I was wondering if the instant web publishing is going to start to be killed off in Server 9 Advanced. As far as I am concerned the web element is becoming more and more important and so this should definitely be something they invest their time in. I don't really want to get involved in php and have to first design the database it self and then design the php that would run off this on the web - mainly the whole idea of effectively Server 9 Advanced turning in to almost MySql GUI free is rather upsetting. Does anyone know if PHP is filemaker focus or whether the IWP is still got a good strong lifeline? Second point…

Because the built in field validation causes a problem with FM Server Advanced (the error 13 problem that has been discussed here in this forum), I've had to turn off unique field validation for a field that really needs to be unique. Does anyone have a good script for validating a field as unique in IWP? Thanks!

Hi Guys, Ive got a very small database I am trying to develop in IWP. As its IWP and SendMail doesn't work in the web, I am utilising the Open URL command. The output I am trying to do is create illustrated below. I can do this using the Email1 button (Send Mail). Email2 is the button I've created uses Open URL and everytime I've tried in a web browser its not fomratting the text like I would like, no matter what type of carriage returns I put at the end. I am working on a Windows XP machine using FMPA8 and so far testing in Outlook Express. If anyone is interested in looking at my simplified datfile, the un and pw are both "test" in IWP. *** THe outpu…

I need to divide the number of contacts into three categories; zero, one and more than one then display all records under the correct category. NOT published to the Web, this is easy to do wtih a subsummary sorted by contact count. HOWEVER, because you cannot enter Preview mode on the Web (via IWP)you can't see the subsummary counts. . Is there a normal solution for this or even a work-around??? . [color:green]T H A N K S !

Hi Has anyone experienced anything like this? I'm running FM Advanced Server 8.0v3 on Mac OS X 10.4.6 2GHz G5 1.5GB RAM. It's serving an intranet using Apache on the same machine. Runs fine for days on end then suddenly the Web publishing engine freezes - can't logon via web - and I can't get things moving again unless I restart the machine. FileMaker Clients can still connect OK. Apache can be stopped and restarted. So I tried to stop FileMaker Web Publishing using SystemStarter in terminal and get an error involving eof in wpc_ctl in StartupItems. (I'll write it down properly next time it happens). Any suggestions much appreciated.

How do I change to top bar on IWP from Filemaker Instant Web Publishing to customize the title line. There is nothing in the Title line on the HTML home page or auth page. Where do I go to customize the title. Thanks, JVH

Hi there, I now have a working search form and search results page. What I need to do now is make the Course Code and Presenter Names in each row of the search results table into clickable links which activate an action that searches a database for information on the selected course or presenter and displays it in a new HTML page. Is this difficult to code? Cheers, Steven

I'm inside the iwp_auth.html file and I have managed to change everything except the font and color of the javascript text string on that page that is picked up from the strings.js file. I have little knowledge of java scripts. Is it possible to change the font and color? Thanks!

I am not able to enter data in the portal as batch and send the same File attached please help

I have built a web page that shows all of our current members when opened in a browser. However they are in one long list and I want the data to display in 3 columns across the page. Is there a way to make an HTML table display a single column of data in several format columns. Eg data results: 1 2 3 4 5 6 7 8 9 displayed as 1 4 7 2 5 8 3 6 9 Failing that I can build separate tables to display different chunks of the search data. How do I do this in PHP? Cheers, Steven

Ladies and Gentlemen, I have a working solution in FM 5.5 that we have used over our intranet for 3 years now at our school. At this point I need to move it to the web and have been working with IWP. I am hosting the files on a test server. The problem: I have a simple layout with a textbox. When I click on it the script goes to a new layout for a find. Here is the script: Go to Layout ["new_find"(print)] Enter Find Mode [Pause] Perform Find[] Sort Records [Restore; No dialog] Go to Record/Request/Page [First] Go to Layout ["ling_tabs" (print)] Enter Browse Mode [] This works fine in FM 8 but from the server with IWP the text box is not even an a…

Beware filtered portals in IWP. I have a portal which filters on a global Name field. Since the screen won't update automatically in IWP, you use it by typing a name in the global field, then clicking an "Update" button which does a Refresh step. The portal then has "click me" buttons, which jump to a particular portal row's record in Form view. Works great, except...for this: If the user types new text in the filter field, and does NOT click the Update button, and then clicks on one of the portal rows, you end up going to the wrong record! The reason is obvious once you think about it -- FileMaker re-evaluates the portal based on the new filter field valu…

I have added a browser-triggered script to our home page that displays current news (thanks Garry) but want to add a second portal that displays upcoming courses on the same page. Do I add the PHP code for this under the first script before the HTML starts or do I interlace the code of the two scripts and just have them referring to the separate portal tables? And if the second script goers under the first do I need to start with <? include_once('FX/FX.php'); include_once('FX/server_data.php'); in both cases? Cheers, Steven

I'm using a layout in IWP that consists largely of a portal with many buttons. However, the buttons do not work at all. I've checked the scripts for IWP compatibility, but this is not the issue. The buttons are text fields, not standard buttons. Is there a problem with buttons in portals like this in IWP?

Has anybody out there picked up the login user name from the network? Right now I am trialing an IWP form in version 6. I'd like to send users a confirmation email when their record gets safely received by FMP. I am wondering if it is possible to pick up the username of the user in IWP, from the network. I could ask them for their email address, but that could cause administration tasks if they make a mistake. Its not the most efficient since their username serves as the root for their email addresse. Can I achieve this using CWP? Is there a better answer in FM8? Thanks and all the best, Richard

hi Is there a way to add data into a portal (in iwp )without clicking "submit" after every line is entered any kind of help would apreciated sherif

hi, I'm using PHP FX to interface with Filemaker and i am having a problem in the way fx.php urlencodes DB paramenters before passing it to the Filemaker server.. This is my php script <?php include_once('../fx/fx.php'); include_once('../db_config.php'); [email protected]; $cand=new FX($dbHost,$port,$dbType,$conType); $cand->setDBPassword($dbPass,$dbUser); $cand->setDBData($dbName,'webdev_Candidate'); $cand->AddDBParam('email',$email,'eq'); $cand_data=$cand->FMFind(); $count= $cand_data['foundCount']; unset($cand); echo $count; ?> I checked the url that is being called and its as fo…

OK, I have done some research on using FMP and PHP and FX – but I still have some questions that I cannot find the answers to. I’ll set up what I understand and what my questions are, and I completely appreciate any assistance that anyone can give (to either correcting anything that I misunderstood, or answering a questions). So, what I am going to use this for is a website for a company that does conferences and training courses. We want people to be able to search for courses by city, date, or subject matter. To do this, we are going to need a webpage that gets the info from FMP. Here are things that I do understand: the db has to be loaded on a server t…

Hi there, I want a PHP script to be triggered when someone opens our home page. The script will find the latest news and upcoming courses which will be displayed in portals on the home page. Can anypone give me any pointers on how to do this? Cheers, Steven

I have a calendar solution I am working on. I decided to play with IWP, which is new for me. Each DAY is a portal row that contains a couple graphic container fields. These fields show you active days for the month and the current day. I have inserted JPG images of the colors I need displayed in the container fields. All is perfect if I am running in FM, but when I open the layout in IWP, everything shows except what is in the container fields. Is there something I need to do to display the contents of a container field in IWP. An additional note: I did notice that these images show fine, if the container field is shown directly on the layout (bypassing the portal…

I use FX.php, FM7, FMS7A, PHP 5.1.2 running on IIS. How can I use PHP to extract a found count for unique values from single column? Here is a mythical record set. larry, banana johnny, apple sally, banana bobby, pear billy, mango I'd like to find the number of unique fruits (4). One option is to order the record set and then run looping logic to disregard duplicates. This seems inefficient. How might I accomplish this using FX.php? Any ideas on using arrays / associative arrays? Thank you, Shannon

Hi, I have Filemaker Server Advanced 8 on OS X 10.4, and I am trying to run the v3 updater (v4 does the same). It keeps telling me that the Filemaker web service is still running, and that I need to kill it to install the update. However, stopping it in the terminal, and then all other Filemaker services in the Activity Monitor, does nothing to get rid of this error message. So 1. Is there a fix? and 2. What can cause this? Is the message right, or will I get this for any error? If someone had accidentally run a regular FM 8.0 server updater over this Advanced Server installation, and not the proper Advanced updater, would that cr…

Course_Code: <? echo $show found courseData['Course_Code'][0]; ?> Course_Name: <? echo $show found courseData['Course_Name'][0]; ?> Course_Length_Days: <? echo $show found courseData['Course_Length_Days'][0]; ?> All_Course_Dates: <? echo $show found courseData['All_Course_Dates'][0]; ?> Starting_Time: <? echo $show found courseData['Starting_Time'][0]; ?> Finishing_Time: <? echo $show found courseData['Finishing_Time'][0]; ?> Venue_Name: <? echo $show found courseData['Venue_Name'][0]; ?> All_Presenters: <? echo $show found courseData['All_Presenters'][0]; ?> Course_Description: <? echo $show found courseD…

Help desperately needed! Trying to get something online by friday and I'm stuck / confused. I want to have a single table that is accessible via IWP to both guests and registered users. In general, this is easy -- just set up the [Guest] account and another account with the fmiwp Privilege. The problem though, is that when both Guest and non-guest accounts have IWP access, it causes Guests to get the IWP login screen. In my case, we absolutely need a single form that can be customer branded -- the generic login screen (which requires a person to click the "Guest" checkbox) is not acceptable. Has anyone found a reliable, straightforward wa…

I am building my first IWP solution. testing with a local IP address. a simple scripted button to commit a record does nothing. Leaves user with no change to the edit record state and does not add the new record to the database. What am I missing? Also, what needs to be done for a reset button?

I have bought the fm server advanced, I want to put my database on the web. I do not own my server I purchase it from a provider ieasy website. What are the steps to publish on the web. I know how to do basic html and I am a novice on publishing fm on the web. Do I need to have my own server tied to the web or can I do it another way? thank in advance Randy

Does CDML have difficulty displaying fields that have periods in the field name? I am pretty sure that is what is causing the problem I am having, but before I go through and rename all my fields I want to make sure that there might not be another factor that I am not seeing.

I have a FM7 layout that has demographic data from one table (contacts) First_Name Last_Name It has address and phone info from two other tables (contact and address) in this layout. These are both 1-many relations based on a contact_id. I can display all data and update data from the contact table. I cannot update data from the dependent tables. Using print_r() the layout data looks like [First_Name] => Array ( [0] => Rich ) [Last_Name] => Array ( [0] => Gregory ) [uIP_Contact_Address::Address_Type] => Array ( [0] => Local Address …

Is it possible to perform a search on multiple field with just one field in my cdml search page?

Hello In my www-published database, I use some portals which needs scrollbars. I only need y-scrollers but gets both y and x-scrollers. The fields inside the portal is ofc smaller than the portal itself. Check out the image below. Do you have any ideas of how i can remove the x-scroller? Thanks in advance, Ezi

Is there a way to have someone log into a windows 2000 hosted website, capture the username and password via php, and then dynamically redirect the user to a page based on the username and password entered

I can't seem to get IPW working. Although MY IP address does not change, in the router I do not have an IP address in the Static IP field. Is this my problem?

I have a survey database and 10 persons are working in the field to collect data. they enter the data every evening into the database through IWP. I want to 1) monitor the each user and get their data seperatly. Can anyone suggest function/script? 2) is it possible to limit a user viewing the data entered by him only? any kind of help would be appreciated

Find A Course course_name starting_date venue presenters stream type_of_search: Find All Find Any Find

I can access my published database on our newtork, but not from outside it. We have a Dlink router and I have set port 591 redirection to the IP address of our Mac. We have made an entry in the Mac firewall but I cannot access the database using: http://'my iP address here'/fmi/iwp/res/iwp_home.html Any ideas?

I am building a timesheet/timeclock database for employees to access via IWP (served from FMSA). I want that when the employee logs in they will only have access to their timesheet records. I can get who is logged in via get(accountname), but how can I use this information to display the users' records? So far I have an employee table and a timesheet table, linked via an employeeID field. I posted this to another forum but I think it was the wrong place (and/or wrongly though out question)

Hello, I have a layout used for the web where I have created a radio button set, in which I've placed blank carriage returns in the value list so that I have two or three lines between each radio selection. When looking at the layout from FMP8, it honors those carriage returns. When published, the webpage does not honor the carriage returns and so there is no extra spacing. Does anyone have any idea how to remedy this? Thanks for your help! Tom

I have a portal set to display 6 rows, formatted with a vertical scroll bar. This portal displays fine in IWP, provided that the portal contains 6 or less line items. However, if there are actually 7 or more such items then the portal display goes crazy in IWP. Has anyone else seen this, and if so, is there a work around?

Hi there, I have built a search form which allows browsers to search for courses using any of the following fields: Course Name Starting Date Presenter Venue Stream I know that PHP searches default to "AND" and only records containing all criteria will be found unless otherwise specified. I also know that you can add a line of code to change the search to an "OR" search as follows: $InstanceName->AddDBParam('-lop', 'or'); But what I want is for the browser (person) to be able to select AND or OR in a drop-down list in the online search form so that the PHP script processes the search request based on their choice. So I need some k…

Hi Guys, I have gone through the documentation to enable IWP and seem to have got this working through the local LAN no problem. However I want to be able to access this database from home, the problem is we're based in serviced offices and have a firewalled Corporate Network which I don't physically have access to (can't enable ports etc.) All I want to do is to share the database online, but the IWP host setup doesn't allow me to choose the IP address (URL) configuration, it simply picks my local IP address (which obviously cannot be accessed from outside). As I have no control over the Network with our office environment, can anyone advise me the best …

Has anyone been able to publish/view IWP pages on the IE that comes with Windows Mobile? If so, could you provide some insight into how this could be accomplished. I tried and all I get are blank screens. Thanks

Hello, I am wonder if you could help me. At the very moment I have a website with an mysql db. any user can so save their profiles in there. from time to time I visit the site and start a script which brings all data from the mysql database into my fm 6 db. the fm 6 db is shared with the web companion. it all works fine. but now the project should be moved to fm8 and I have not seen the possibility to share the db like under fm6. would someone know what and how I could handle it? how can I bring data laying in a mysql db into my filemaker 8 solution. thank you very much in advance

Using Filemaker 6 Unlimited Ok, I have some databases that I am sharing with Instant Web Publishing and the button in the portal that are designated as "Goto Related Record" are not working in this particular database. After running some tests on my local machine with a copy of the database I found that if I removed the underscore from the filenames of the databases the buttons would work. The reason it has the underscore is because the databases were created long ago when that was the to make the file hidden when sharing (back before I inherited the database). Now my has anyone else seen this behavior before? I am a little wary of renaming all the files, even th…

Hi Does anyone know how you get the status bar not to appear at all (not the Hide Status (Lock) you still get a thick grey bar down the left side). Is there also a way to get the Window title to appear (when the status bar is hidden) and to resize a window, according to the New Window data in Filemaker? Apart from these small interface objections, I think it's a dream to work with - as long as you remember to extend your text fields to allow IE to show them all!!

I have several users accessing an Filemaker DB via IWP. They need to run reports and send them by Microsoft Excel. I am trying to take the data from a report layout displaying in the IWP Browser and move it to Excel. I know you can save directly from Filemaker, but a $300 per seat license to do this is not cost effective. Does anyone know an easy way to move data from the IWP Browser into Excel without losing all the formatting? Attached is a screenshot example of the report I am trying to move to Excel. Thanks for any help/advise.

Hi Guys, At present I've created a couple of simple fx.php pages to add,delete search my database. Im quite impressed with the speed of FMP8 and FX.php. `im thinking about converting some of my reports to webbased/php reports. My question is, can I mimic some of the FileMaker reports in fx.php with trailing grand summaries, and sub summary sort fields etc? I'm guessing reporting is just going to be lists and cant be formatted like FMP reports? Cheers

Hi all, I haven't ever used FMPs web interface before, so forgive me if this is a ridiculously easy task that I'm asking help with. What I'd like to to do is set up a web questionnaire that our customers can access. Ideally, I would create a customer record in our office computer, then send them a web link to the questionnaire form for their record. I would only want them to be able to view and fill in their record, not view or change any other records, obviously. I assume that information then would be transmitted automatically to our computer's database. Is this possible? If so, would we need to leave our office computer on all the time with FMP ope…

I am using FM server 7 and server Advanced installed on the same OS X 10.4 machine and am having trouble assigning a DNS name to iwp engine. I have a Cobalt Raq4 acting as the DNS server and the OS X machine hosts the company website as well. the Raq4 doesn't allow me to specify a path, hence any "name" takes me to the company site rather than the iwp engine. any help would be greatly appreciated. Thanks...

Hello there. I am using Filemaker 6 Unlimited at the momment. How do I add a Close Window button in Instant Web Publishing? I have a registration form that has a sumbit button that when they click it, it submits and opens a window saying thank you. I want a button on that page that if they click it will close their browser window. Thanks.

I thought I read a solution to this problem before I had the problem, and now can't find it. It seems that IWP created value lists and checkbox values have an extra return at the end of the line. If I [color:blue]Substitute(some_multivalue_field;"¶";", ") I get an extra comma at the end if executed via IWP. What's the best solution, check for the dangling delimiter or check to see if you're on the web?

Hello hello, Hopefully this is a really simple answer, yet I can't figure it out for the life of me. I can publish my DB and all our computers on our little LAN can see it, however any computer outside cannot. Instead of the log-in screen, they get "cannot display page". I have all the IWP turned on, I'm using the url: http://192.168.1.101 any suggestions on why people outside can't get anything other than "cannot display page"? Thanks and I appreciate any help. -ryan

Is there a way to test an Instant Web Publishing database on a single computer. That is, can I point the browser on the host computer to the FileMaker application running on the same computer? It would be extremely handy for testing purposes. Thanks.

Hi, I am trying to find a way to have a "compare records" function in my listing.lasso page which would enable me to see (and compare) 2 different results in my display.lasso. The idea would be to have a checkbox next to every records in my listing.lasso page, checking that box for 2 records, and then a submit buttom which would result in a diplay.lasso page showing the 2 selected records side by side. I looked everywhere to find a way to do it but I could not find one single bit of information... Thank you for your input fab

I've been running FX-PHP with no problems then suddenly I started getting errors that start with... Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in c:program fileseasyphp1-8wwwFXFX.php on line 35 FX: ExecuteQuery XML error: no element found at line 2 Nothing seems to have changed other than my own code. The errors are often, but inconsistent. I may get them 8 out of 10 page views then not get them for 20 page views. Has anyone seen this?

Hi there, To the best of my knowledge.Preview Mode is not available in Instant Web Publishing. How do I get rid of blank space between portal rows when the portal is displayed as part of a web page? We want to display news items in the portal, some of which have more content than others but we want to get rid of the blank space that appears after the shorter news items. Is there a way to do this? Cheers, Steven

Hello, I am trying to find out how one would restrict the number of words returned e.g. I am trying to only have 20 words returned at a time in the Model Description field and after the 20 words have the word 'read more' that jumps to the next page? Sorry very new to Lasso Thank you very much in advanced,

If I make a Filemaker 8 or Mobile database, can it be made to work on the following handheld computer? Assume that I own the necessary hardware, software, and have the necessary configuration. NEC MobilePro 900c Operating System: Windows CE.NET 4.2 Database: SQL Server 2000 Windows CE Edition (SQL Server CE version 2.0) Please refer to these two addresses. Windows CE.NET 4.2: http://msdn.microsoft.com/embedded/prevver/ce.net/prodovwce.net/default.aspx SQL Server CE 2.0: http://msdn.microsoft.com/sql/2000/SQLCE/default.aspx

We recently launched a solution that incorporates a "Survey" module. This filemaker file contains two tables: questions and answers. Each has their own respective indexing and there is a relationship between Q & A based on Q's index. In the survey, there are 20 questions. Ergo, 20 answers to post to the database upon completion. Here is the dilema (and it's a good one): When posting the records we are using a simple While loop as such: while (x < 20) { // the posting routine goes here $post -> doQuery; $x++ } Now we have used both FM-and-PHP and FX.PHP and the results are identical.... The loop creates …

I've got a database that I've put up at an FMP hosting site. This database is accessed via IWP. There is one container field in each record in which a jpg image has been entered into the field, i.e. it is not entered as a referenced picture. When I view the database on the web, the picture looks fine. But when viewing the records in list view, the refresh of the screen is very slow. I've heard that adding the image as a reference would speed up the redraw of the screen, so I added the image to my "web" folder (where my login file, among others, resides) at my hosting site. Going into FileMaker, I then added the image (as a Picture, not File) as a reference Unfortuna…

Good afternoon, I am using lasso pro 8 / lasso studio 8 for the first time in order to publish our sensor technology database which was originally created in FMPro 6 but has been recently updated to FMPRo 8. I am able to create and perform simple search/display pages with lassostudio and dreamweaverMX04. However, I have pictures in my original FMPro8 database and I do not know how to enable them to be displayed in my result page as actual images (via a lasso snapshot). As an example, this is what I have instead of a picture, just that text in my result page: /fmi/xml/cnt/data.jpg?-db=TESTLASSO%20ACT_Database&-lay=Form%20View&-recid=248&-field=Image…

What is the PHP syntax for getting the image stored in a Filemaker container field to display as part of a web page? The image is stored as an image not as a reference to the image. Thanks. JJ

Is there a way to pass variable information to a script being called by either FX.PHP or FM-and-PHP? I assume since neither developer included the functionality that there is no way to "mod" either class to pass variables to scripts? Steve

Hello, I have a dbase that builds value lists from two other reference dbases. Everything works fine until I publish this dbase to the web. When performing a find in the browser (Safari), the value lists are blank except for a check mark. Other value lists that are entered into the dbase (custom values) show up though. I had it working properly at one time but now it doesn't work--even with FM8v3. Don't know why it doesn't work. Any ideas?

When trying to play a sound file contained in a folder located on the server, the sound plays, but it also opens an extra browser window in front of the FM content. My script currently has a Go to Field step, Set Field step with the IP address where the sound file is located, then the Open URL step, and finally a Close Window step. When I use the script locally, it works and the extra browser window goes away; but when I test it live over the network using IWP the extra window remains open. I either could use a script step to make this extra window go away automatically, or a different way to link my sound. Thanks.

Is not my intention to open a "flame" -) I just wanted to get some feedback from those who have experienced FX.php (it would be better if that person tried both the platforms) to build and develop an entire site. is FX a good choice? I mean.. I know PHP and I know it is a powerful language with a lot o possibilities but - as I'm thinking about it to solve a lot o problems we have - I was asking my self if it is a good idea to re-build a web site using a software which has not much support (ok.. there are some forums which support it.. as every open source project). Does anyone can tell me his /her experience? thank you!!! -)

Hello All, I'm new to FX.php and am working on a registration database system. What I'd like to do is to create a registration php page (which has been successfully created) and then show the serial number created in FileMaker back to php page. I've tried several methods that looked to solve this problem but no luck. I'm using FM7 Server Advanced under OS X Server & FX.php. I'm using FMView process to enter form data, then create the record with FMNew when submitted, and want to create another page showing back the serial number assigned in FileMaker back to the web, so the people who register can note their registration number which is the same as in F…

In many scenarios using FM / IWP, it's desirable to allow a person to create a new record, have the record validated, and either accept it into the system or show them errors and correct / resubmit, or cancel / delete. Once done, it's also important to block any further access (read or edit) to that record, for security purposes. There are several problems doing this under IWP: 1. Field validation is rather cumbersome. 2. You can't force someone to logout unless they click a button, and even then it's not 100%. 3. Sometimes, hitting "reload" from a browser will reload the record when it should no longer be visible. I have come up with some solutions …

I have a simple script to pull records to the clipboard that works in the data-base, but not in the Instant Web Publisher. Maybe the problem is in that the access to the users is read only, although the script runs with full access. Is there a work around for this? It seems like a simple problem, but has become frustrating. Here are the script steps: 1. Enter Browsemode[] 2. Set field[main:name] 3. Copy [select;main:name] Any help appreciated.

What is the easiest way to export a table from IWP? The Export script step is not web compatible. I need to send a tab-separated point file to Google Earth.

Guys, Im thinking of getting into the world of custom web publishing due to IWP's limitations (boy I've been dealing with loads of workarounds for months, and I think its time I looked at CWP). Ive been looking at FxForge to help me get started with PHP and FileMaker 8. With IWP you create scripts which are web compatible, and you can tie a button on a layout to execute this script. With CWP do I still have to create script in FileMaker with the "Indicate Web Compatiblility" switched on? Sorry for my ignorance, im trying to understand the concepts of CWP as much as possible before I dive in. Cheers

hi there! i'm customizing the clienttracker template for use in our company and am trying to find out how/whether it is possible to send mails directly out of the fmp database using fmp iwp (with no fmp-software installed on my pc). hans

Before I dig too deep into this I thought I'd see if anyone else has experienced the same problem. Whenever I try to start IWP on FM8 (Mac) the coloured wheel spins for a while then an error comes up saying IWP could not be started (no error codes or other information). I can start IWP in FM7 and FM6 so I assume the problem is not with my computer (OSX 10.4.6). Any ideas? Thanks in advance.

Is FileMaker adecuate to publish on the web a music library for sale, listen and download?

I have not used filemaker in a while but now run against some new things and wonder if they are now available .. Custom Html designed page that has call tags to pull up the databases// Also ajax would be nice to know how it handels it all.. I saw the posts here of sites but no kinda new users guide ..

I'm retrofitting an old FMP4 web-plugin DB to reflect some style changes in the HTML while I build an IWP solution in Pro 8. The Keyword (Find by searching all fields) function is working, but the dropdown menus are not populating or even recognizing their correct fields in the DB. They worked before, but do not even work now with the unmodified HTML and CDML and Original DB. Anybody ever run into something like this?

Has anyone figured out how to get IWP to show BOTH columns in a two-column value list? I am using FM7v3 and find it extremely frustrating that IWP doesn't show the second field in the value list. That's always the field that means something to the user, since the first column invariably is the ID number. When I look at the html, the second values aren't even in there! The only thing I can think of is to create a set of calc fields that concatenate the fields together--say "ID ~ VALUE", and a post-process that pulls out the ID field after the fact (using GetAsNumber won't work because the other data fields often have numbers in them). But that entails large amounts of…

I have a database layout with some unstored calculated fields that are referencing data from another file with some calculations applied to that data. When I call these fields from PHP (for a record that I know has this data when looking at the layout), they have no value in them. Is this because they are unstored, or because they are based on a related file? The problem is that it is not just a simple go get the value from the related field, it has some logic applied to it, otherwise I would either pull another record set using the key field between those tables or stick the related fields on the layout in FileMaker and pull them that way. Any help would …

Has anyone used a bar code scanner to input data to a database over IWP? I assume it will work ok, as a scanner is just another input device, but wanted to check to see if anyone has done this and experienced any problems. Thanks in advance.

I have a stack of plans etc that are linked to my database. What is the best way of delivering these? Have tried containers but they error out on open (save as and then open works fine) and are a general pain in the butt for management of data. I would prefer that I use the old send event and open the file from a concatenation of an id field in the database and a path, but am unsure if this is a good way to go. Infact generally am unsure of where to put them to access them. The database will be used both internally (via filemaker) and externally (via web) Thanks in advance.

Hi, Closing down the db. I have used the link so that my users go direct to the one database I want them to see (using the http://xxxxx/fmi/iwp/cgi?-db=yyyyy&-startsession address). However, when closing the database down (e.g exit application), it defaults back to the list of all the databases. How can I get it to go to a different webpage (e.g my company's home page) or close the window. I have tried Open URL but it opens it in another window leaving the current session. I have also tried some HTML code to no avail. Thanks in advance.

I've added a demo application to the fmDotNet website (www.fmdotnet.org). The ZIP files include: - the application - the full source code (in either VB.NET or C#, you choose) - a PDF printout of the source code in case you don't have Visual Studio 2005. In that case you can just open the .vb or .cs files with Notepad or Word to view the code. The PDF has color-coded code so it's easier to look at :P

I have not done any FMP7/8 IWP sites to date, but I am contemplating replacing an existing CDML site with an IWP site. However, there is one functionality that needs to be retained, but which I do not know if it is possible to do with IWP. Unfortunately, it is not a situation where I can just whip up a test file and try it out, hence my coming to the IWP experts here. The current CDML site registers people for classes, and then, as a final step, pulls the sales data from the database and posts it to VeriSign, via a simple web form, to complete the payment process. Is it possible to mimic such behavior using IWP? It seems it should be possible, to create a clickabl…

I made a solution in Filemaker 6 Unlimited with Apache and FX.php. The datefield in the database was yyyy-mm-dd and was published in that way on the website. Now I have upgraded the database to Filemaker 8 and are using FMSA 8 with IIS and FX.php and the date is still yyyy-mm-dd in the database but are published on the website as mm/dd/yyyy. I thought first the problem was that the server that I tested the upgraded solution had an english OS but when I tested it on a machine with swedish OS, the problem was still there. made a query to the database with the datefield (format yyyy-mm-dd) and with 1 matching record just to see what it would return. $query_…

Dear Group, I note that IWP's "windowtitle" object does not properly show my customized FM window title when the status area is hidden. Instead, the browser window title reads "Filemaker Instant Web Publishing." When I show the status area, however, it correctly displays the window title I have set in FM. When I close the status area again--poof--it's gone. Any idea where this setting is hiding and how I can change it? Thanks in advance.

I originally posted this question in the thread about wanting to get rid of cookies in FM7 IWP, but I didn't want it to get overlooked so I am adding it here too. I have found that the new method of logging in and out (forms-based authentication) using IWP and FM8 doesn't work as good for the folks I have using my system. Is there a way to script or modify my database so that when someone logs in via IWP on 8 that the system remember who they are even after a "logout" (until browser restart) in the same way that 7 does? Essentially, I would love to have IWP logouts in 8 function just like they did in IWP 7 so that after a user logs out from the database they don…

How do I let the cookies be deleted or expired after I logout from IWP? Seems like I need to quit the browser completely, otherwise the cookies remain. Any script to end the session completely?

This is a new form so, except for testing data, there are no records. I am using FM 8 Advanced and Instant Web Publishing on Windows XP. The form is rather lengthy with some calculations. There are no headers or footers. I have a date field that will allow the user to input data but once it is submitted the data disappears - the field is blank The date field has been deleted and recreated (not copied) to no avail. It has been formatted in various date formats - still disappears. Privileges allow the all the user to modify and view. Even under Admin privileges the field remains blank after submittal. Any suggestions?

I have a layout that has several fields in it. All of them are simple editable fields. If I create a new record, I can tab from field to field and fill them all in; however, if I'm viewing an existing record I can only click in ONE of the fields to edit it -- I cannot click into the others! I'm just beginning to experiment with IWP. Is this sort of glitch common? If so, is there anything I can do about it? Thanks.

I have an FMP file with a field with a checkbox attached and data entered (i.e. Interests). Using FX, I can take the querried results, explode it, and have multiple checkboxes appear checked on an edit Form. However, I cannot resubmit the results to the FMP file, even if I don't change the data. I am able to implode it prior to sending it back, creating a single-line string (i.e. hiking, math, swimming), but then the checkboxes don't work on that end. Does anyone know the code I would need to reorganize the data prior to using FMEdit() to submit the results to the file? Thanks, as always. DSW

Remove Session limits in IWP-Filemaker Inc. has developed one of the most promising capabilities for deploying FM solutions to the web, namely IWP. By allowing Filemaker developers to design all of our UI, scripts, logic and content within Filemaker for subsequent web deployment (or Filemaker deployment or a mixed use deployment) as opposed to partially deployed in Filemaker and partially within a middleware such as Lasso or PHP is a phenominal capability that seems to be missing in virtually every other application! Inhibiting this capability by limiting sessions is a disservice to Filemaker developers as well as Filemaker itself in the long-term. The future of database/…

I have been able to customize the IWP_home.html file and place it into the folder Web Publishing/IWP/ on a XServe running Mac OS X. However, I am unable to get the server to point to a customized version of IWP_auth.html (which is in the same folder as the IWP_home.html file). Instead, the default version is used. Hence, I was wondering if there is any means of getting the IWP server to use the customized version of IWP_auth instead of the default version.

When you add some text to some fields and it should be added to the db, what would be the usual scriptstep to a button if you hide the toolbar to the left and want a custom submit button instead?

Hi Can someone please help with this. What I want to do is get a value returned to CDML format page (in this case a file name), I then need to get the value into a PHP page that is running in the Apache root (OSX) to create a blind link to the file to download it (I'm assuming there is no way to run the PHP scripts out of the Web Companion Folder). I'm guessing that the best way to do this is with Javascript but I don't know anything about it. Any suggestions greatly appreciated!!

So far totally unsuccessful connecting to files via IWP. the files which are hosted on our server (using standard FM) have been listed them for IWP. I type the address fmp7://IPnumber/file+name.pf7 and it either opens up filemaker or i get a message saying that MacosX doesnt recognise that file format I (in safari). On a PC I get error messages too. - cant connect to server i am wondering if I have a firewall issue. If this sounds likely what would a good port number be to use.

I am running FM7SA, PHP 5.1.2, Win 2003 and FX.php v4.2 I am using FX.php to search a layout that has fields from multiple related tables. $Search = new FX($serverIP,$webCompanionPort); $Search->SetDBData('FMFile.fp7','LayoutTableA'); $Search->SetDBPassword($webPW,$webUN); $Search->AddDBParam('Field1','$post-value1'); $Search->AddDBParam('Field2',$post-value2); $Search->AddDBParam('TableB::Field9',$post-value3); $SearchResult=$Search->FMFind(); $FoundCount = $SearchResult['foundCount']; foreach($SearchResult['data'] as $SearchKey=>$SearchRecord) { ... } When it Works I can perform the query directly in the F…

Environment: FM8SA and Filemaker 8 Advanced. I have a text field that will be used to enter the text of a letter to parents of a student. The field is formatted with full-justification and first-line indent. The field looks and works as expected when viewed trough the FileMaker client program. The paragraph formatting is not shown when the layout is accessed through IWP. When I type text into the field, the indentation does not occur (although the full-justification does appear). I am also not able to type a tab character into the field. This occurs when IWP is accessed from FM8SA or from the FMP8A Is this the expected behavior? Does anyon…

Hi All, I am working on a online proposal form, I am wonder if it is possible for me to have the number of row from the portal displayed at the webpage so people can enter/edit their information all at once instead click add several times. Any help will be appreciated. Thank You, PHP2005