Custom Web Publishing

I have a database of publications on our web site (http://www.mrc-hnr.cam.ac.uk/). When a user performs a search, the criteria are returned together with subsequent links to show more detail of a particular record. It is at this point where the more detail (abstract) is requested that a unique "recid" appears to be assigned to individual records. The problem I have is that the data in this database are frequently updated. Initially our publications are in an EndNote file. I use PocketCites (http://www.woodenbrain.com/) to export from EndNote and then into the FileMaker database. Each time an update was required I created a new Filemaker database (based on an exis…

Hi all. I'm new in File Maker, i have a problem now in my new job, this guys work's with FILEMAKER, nice, but i need work with LINUX and Virtual Domain Name, my idea it's work with one filemaker and publish multiple database with VIRTUAL NAME. ex: xxx.myjob.com => 1111 and 2222 database yyy.myjob.com => 3333 and 4444 database It's posible do it with Filemaker 6 Pro?: Because now i have the problems with Virtual Name, sometimes i see one database in one virtual name and sometime in another, it's a problem or a bug with Filemaker Thank's to all.

I have a image database running on 5.5 server, and publishing via IWP using 5.5 Unlimited. I have just created an OPEN URL script that opens the full size image (with a reduced version also displayed in a container field as a reference only) The Open URL script opens the file using the path recorded in a field called URL. This functions totally successfully within FMP5.5, and appears to also work in IWP, but only when browsing all records. When browsing a found set of record within IWP running the OPEN URL script opens the image for the wrong item. For instance when browsing a set of 4 records, clicking on the OPEN URL script for the 4th record will open u…

I am just getting to look into publishing my database on the web, and I need to get one silly point straight. Is the only way to publish a database on the web by getting a company with Filemaker hosting available? To clarify, I guess there is not way to publish a Filemaker database without Filemaker working in the background? I know it is a silly question, but I have the website, I have the server space, and HOPED that it would be as easy as publishing the database that is on my computer. No such luck huh? Finally, if all that is true, and I must find ANOTHER company to publish my site, then does anyone know of a company in Canada (Toronto) who does this? …

Hello, I am trying to do dynamic list box. There is two field one is Grade level such as K1, K2, K3 and there is standards for Each Grade level such as Standard 1 for K1, Standard 2 for K1 .... On the website when user select one of the Grade level, other listbox should show only this grade level related standards. I am using FMP 5.5 Sever on MacOSX 10.3. Thank you Fethi

I'm creating DB with help of FMPro6... for now everything seems to be ok except one point: I publish DB on the web, so some people can edit it. For creating new record I'm using simple script like this: script NewRecord New Record/Request Set Field ("Date","Today") In FileMaker it works perfectly, but when I'm trying to do through the browser, in new created record no data is pasted at all . What can be the reason? Thank you!

With the just released version of FM Pro 7, is it possible to design a FM web accessible database that allows password permissioned visitors to access via a web browser a FM web DB hosted on a Mac with OS X 10.3 to add or download files into the FM web site database. Just one or maybe 2 people at a time. Possibly using the library document template I saw on the feature set for FM 7 Version: v5.x Platform: Mac OS X Panther

Hello all, I have developed a FM database product I would like to offer via browser. I envisage up to 50 databases, each individual database being individually accessed by up to 6 users. I I desperately need some guidance to get me looking in the right direction. Is the following outline correct: 1)All 50 databases running on machine 1 with FM Server. 2)Machine 2 running FM Unlimited. Are all the numerous scripts likely to work correctly? Could printing be directed to the appropriate client printer? Would the complex permissions be handled by Unlimited? Do I appear to be attempting something too complex for browser access? Thanks in advance…

I've been working on this little problem, and am beginning to think there's a better way to go about it, that maybe I need a fresh perspective. Hoping someone out there has some ideas. I have a DB full of events for our school. I'd like visitors to our site to be able to find all events for the next week, and all events for the next month (as well as other sorts of find requests, but I've got those working). I currently have fields with the event date (absolutedate) and today (currentdate), and a field (daysout) that calculates the difference between today and the event date (that yields negative numbers when the date has passed). And I have another field (datestatus…

I'm researching what would be my first web-published database and my first foray into FM 7, and I cannot find out if Filemaker's site is misleading or accurate when it states: "Web users see a familiar, intuitive FileMaker interface within their Windows or Mac OS X browser" Does this really mean that pages published via FM 7 Server Advanced cannot be used by OS 9 web browsers? It doesn't make sense that that would be the case, but I need to find out because most users at my company still use OS 9. Thanks! FileMaker Version: 7 Platform: Mac OS 9

I am currently running a version of Unlimited. It is serving up the files to my local network Filemaker users as well as to the internet. I am thinking of adding Server to the mix. I just want to make sure I understand how this would work: 1) I can use he Server version on my Xserve to serve up all the files to my local network users. 2) I use my Unlimited version on my eMac to open the files being served by the Server version, and then the Unlimited version on the eMac serves up the files to the internet. Is this how it would work? One question: I am running about 12 different FM files. Of course some of them are set to multi-user hidden. There is …

More of a PHP question maybe but... I think this might be down to what I set the cookie path and domain as but... We host some databases on the web and the domain is dealer-world.com We have our main webspace with our host, but also some PHP enabled webspace on a different server at dealerworld.plus.com I have a couple of cookies set using the FMP-SetCookie CDML command, but I don't use the path or domain options for the cookie. Is it possible for me to access those cookies from my PHP website, even though the domain is different? I want to have as few pages running from filemaker as possible, to reduce loads and keep only the actual CDML format pa…

Hope someone out there can help me with this problem. I know how to script a tag to perform a specific search on a FM Db I'm serving on the web, but don't know if it's possible to embed that script in a page that exists on a separate server, and, if possible, how to do it. My working tag looks something like: <A HREF="FMPro?-DB=sample.fp3&-Format=search.htm&day=15&-Max=10&-Find"> and I'm thinking that, if it's possible, I need to add the IP address of the server running the DB somewhere in there, but don't know how. Also, you'll notice the file has a .fp3 ending because I'm still running 4.0, but have a copy of 6.0 to upgrade…

I want to do a search using address bar CDML syntax to try and get a list of records in a database that *aren't* duplicates. I've been trying to find a way to accomplish what I want by creating a value list and having the values based on the field, as in the value list the items only appear once. But it means I cannot then sort the records by reverse date. Basically I'm working on a FileMaker news posting solution and want to display an archive listed in the format 'month name - year number' I've created the 'month name - year number' field but obviously if there are 70 posts in a month, I don't want it to show... April 2004 April 2004 April 2004 April…

Wading in deeper, as the saying goes........ any help will be appreciated! I have checked all the documentation I have + the filemaker Techinfo database and came up dry. I am doing a (-find) action from a form in a web page and want only an exact matche. Is there an additional parameter I can use to accomplish this? Is there a good reference manual I can buy to assist me in the future. Many thanks, Ray Version: v6.x Platform: Mac OS X Jaguar

Hello, I cannot figure out how to compose a particular FM query in a URL. Suppose I have a database of names and addresses. I want to find all the "Smith's" that live in NY or NJ, but not any other states. A SQL-esque query might look like this: SELCT * FROM mydatabase WHERE lastname=smith AND (state=ny OR state=nj) The FM query I am trying to use looks like this: http://myserver.com/fmpro? [snipped...] &name=smith&state=NY&state=NJ&-find If I insert "-lop=and" anywhere in the query, I get NO records found because there are no records that have both NJ and NY as the state. If I include "-lop=or," I get nearly all the records that …

I have a DB set up and working online, and I can search for records using multiple criteria, and it returns the data to a table format. Now I want to be able to re-sort the 'found' records. When I try to add a simple re-submit it gives me the entire database not the found records. is there some tag or variable I'm missing to get it to do this? Basically I'd like to be able to sort the table by clicking on the column header (a field name of course) without going back and defining the search criteria. Thanks, Ed FileMaker Version: 6 Platform: Mac OS X Panther

I am trying to display two valuelists in a webpage. My first valuelist shows up perfectly, but my second valuelist shows the first valuelist twice. I am using the code provided in the FX.php documentation for displaying valuelist from FileMaker6. I guess I am missing a step though. I am using the same exact code for my first valuelist for the second value list. The name of my first valuelist is called 'Disease.' The name of my second valuelist should be 'Diagnosis' -where can I change this??? $DiagnosisName = new FX('127.0.0.1'); $DiagnosisName->SetDBData('<same as in first valuelist>', 'same as in first valuelist'); // password line purp…

I have created rather long and extensive forms and I'm serving them using FMP 6 Unlimited. I want to be able to break the forms up over multiple pages so that the scroll bar is used minimally. There has to be an easy way to do this. Any ideas? Basically, it comes down to whether I have Javascript store the values and insert them into hidden fields on the following forms, or find some way for FMP to create a record, then allow the following forms to modify that existing record. Any help would be greatly appreciated. Thanks! -- Chevell FileMaker Version: 6 Platform: Windows 2000

Hello, I would like to publish a database over the web. The problem is that I have relationships in the database. The question is do relationships beetween databases work when using it on the web.

This may sound like a stupid question, but I need some expertise to explain it to me...I have been using Filemaker 6 to build some databases and I also created some CDML pages to share information out on the web. Fortunately, or not so fortunately, we have been exceeding the user limit A LOT lately. We have the databases and web pages sitting in the web folder, on a PC running XP Professional. I have been tossing around the idea of getting Unlimited to take care of the user limit issue. I know that Unlimited is being discontinued soon, but it will be a much cheaper solution than going for the Filemaker 7.0 advanced server. The main purpose of these databases is so th…

If I am hosting files through FM Server, is there some way to also access via internet explorer? FileMaker Version: Server 5 Platform: Windows 2000

Hi, I'm serving a FM form and the sidebar displays on the web page is there anyway to just have the database itself available to users. The database is a questionnaire and I've worked out how to do drop down lists and check boxes but this has me stumped. Thanks in advance for your help. Chris FileMaker Version: 7 Platform: Mac OS X Panther

During development of my FMP5 db to be published on the web (using CDML) I checked the selection to log all access to the db. 2 questions: 1) What does the last two numbers (200 2568) in the example below refer to? xxx.xx.xxx.xx - [29/Mar/2004:14:18:40 -4114] "GET /pix/logo.gif HTTP/1.1" 200 2568 2) The db is open to external access - but passwordprotected until the solution is deployed. No one but me knows where to find the entry-point. When I read the access log I can recognize the ip's I've used to test the solution, but sometimes I see an entry like this: xxx.xx.x.xx - - [27/Mar/2004:18:25:37 +0100] "GET / HTTP/1.1" 302 0 - from ip's I'v…

I'm just starting with Filemaker 7 IWP. I want to run a startup script which checks whether the user is coming from the web or the network and go to a specific layout. I thought there would be a Get field which would determine this, but i have been unable to figure it out. Thought? FileMaker Version: 7 Platform: Mac OS X Panther

This was posted originally in PHP but this section seems to get more traffic. So here goes... I am trying to add a php query to filemaker as a section on my training page. The database contains a list of movie urls and titles. I have successfully generated the list by modifiying the index.php that is included with the FX installation. My problem is that when trying to make the Title into a clickable Link I am getting the following parse error. Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /Library/WebServer/Documents/FX/index1.php on line 86 here is line 86 code echo "<a href=" . urlencode($valu…

Thanks for stopping to read this. I

Hi all, My 1st post, here's hoping someone out there can help. I still use Claris HomePage to do my CDML coding (remember HomePage Mac users?) because I'm not all that good at CDML/HTML. I have a solution which uses a text field to store website addresses (ie: www.apple.com). There's a piece of CDML coding which then makes this a clickable link on my webpage, the CDML looks like this: <A HREF="http://[FMP-Field: Website, url]">[FMP-FIELD: Website]</A> This works great for "generic" websites, ie: www.apple.com - the problem is when I try to use a more direct/detailed link, ie: www.apple.com/itunes.html. The CDML above likes to add a backslas…

Hi, Can anyone direct me to a tutorial for setting up a TCP/IP intranet for Macs? We are a home office with a G5 running OSX and an iMac running OS9. We are set up for file sharing using AppleTalk over Ethernet, but each computer connects to the internet (one at a time) over a phone line because we moved to the absolute middle of nowhere where there is no DSL or cable service. I enabled web sharing on a FM 6 database so I can view it through a browser window and it works great. This is all on the G5. Now I want the iMac to be able to see the database so that while the user is doing research online, he can search our internal database as well. I'm tripp…

It appears that each IWP web client has their own globals. I think this is a great advance and I imagine this will impact custom web developers. It certainly makes it much easier to make web enabling single user interfaces that tend to be heavily dependant on global variables.

I am experiencing a problem where I am not able to create a new record in the database via the web. The error message I get is: "Access Restriction: You do not have access to perform the action: new" The database is for work requests that our users can enter via a form on our corporate intranet. The form's action contains the username and password for an entry in the Web Security database, along with the hostname (i.e. <form action="username:[email protected]/FMPro">). This username and password combination is only allowed to: Create, Edit and run Scripts. The corresponding database password for this user has permissions set to the following (File &…

I have a solution that uses pulldown lists to select an item. The list are set up like this: Database 1 - Basicly a table. Contains info for pulldowns Database 2 - The entry screen I use 2 fields for the pulldown field 1 shows the item number and discription (both comming from to fields in database 1). Field 2 is a lookup from field 1. When I click in field 1 I only see the item number and not the item. (I don't see the also display values from this field step) Thanks in advance Version: v6.x Platform: Windows XP

Hi, I am a new user with Filemaker. I have been asked to upgrade a Filemaker 5 database to the new Filemaker 7. They use the Filemaker database with web publishing to allow users to complete a survey which gets entered directly into the database. The survey is access via the web as html. On the first page, it redirects to the actual survey after the introduction: url= FMPro?-db=ballot_.fp7&-lay=Survey&-format=survey.htm&-view The second Page which is the actual Survey has this code: <FORM ACTION="FMPro" METHOD="POST"> <INPUT TYPE="hidden" NAME="-Token" VALUE="StartUp"> <INPUT TYPE="hidden" NAME="-DB" VALUE="ballot_…

Hello, At this moment I publish FM databases at my own computer. What I want is to upload my databases to my Internet Service Provider, but of course there is no Filemaker running. Is there a way to publish FM database like ASP databases? Greetings Jukkie Version: v6.x Platform: Windows XP

If you have your FMPro database on the same machine as your PHP, give this PHP file a try. This single file shows how to incorporate CDML into PHP code directly. No more parsing FX.php arrays! Just write native CDML. Too good to be true? Try it out and you'll be a convert. You have to enter your own variables and change some of the PHP settings: $db $pass Also some of the CDML has to be customized to your setup: For example... [FMP-InlineAction: -db=dbnamehere.fp5, -lay=layoutnamehere, fieldnamehere={$_GET['x']}, -find] Note: this InlineAction shows how to incorporate PHP variables into your InlineAction find request. <?php …

What a major Bummer of an announcement. Unless someone can clear this up - I have personally spent thousands upon thousands of hours crafting CMDL/HTML files to access a major database system I have developed. And taught other new programmers the skill. NOW THAT IS ALL GONE, DOWN THE DRAIN! I HAVE TO USE XLS TO DELIVER MY SOLUTION?: CMDL IS DEAD? THERE IS NO MAJIC CONVERSION TOOL??? WHY DO I DO THIS STUFF??? Version: v6.x Platform: Windows XP

I need a little help with the rest of this asp page using Mariano Peterson's ASP with FileMaker class. I have most of it translated but any extra help would be greatly appreciated. Thanks. Justin Grewe

I made a dhtml page with claris homepage 3 in order to display data from fmp5.5 on 2000server in a web browser. Works great in MSIE, netscape, mozilla, and firefox, but if I attempt to load a page hosted by fmp5.5 into opera web browser : the page doesn't load, and the servers cpu cycles go to 100% and stay there until fmp is unloaded. Does anyone know anything more about how to fix this or prevent opera from loading the page? Version: v5.x Platform: Windows 2000

Every once in a while I will get the error pop up "cannot locate filename.fp" from filemaker. .fp5 missing the 5, but if I click through that, it still seems to locate the file just fine. Has anyone experience this or know what it is? Version: v5.x Platform: Windows 2000

I am a complete novice when it comes to this program. I'm considering purchasing it based on a favorable review given it by Cnet.com. The review lauds it's ease of use for novice and experienced alike. My question is this: Can I use Filemaker Pro 7.0 to build a website integrated photo/profile database similar to those found on "web personals" sites (Match.com; Oneandonly.com; etc.)? It would have to be password accessible by members for editing of their personal information. It would have to automatically format a members photo/profile for display on the website with thumbnail pics upon their completed registration. It would, of course, have to be search…

Hello! I'm new, and I have a specific problem. I work for an association. We are wanting to add a Members only section to our website. Ideally, the usernames and passwords will be kept in our FMv4.0 DB (I'm planning on using a certain field to correspond w/ their username and their Phone # field as their password), but I know very little about scripting, and I haven't seen any examples using FM. I'm not extremely concerned with security, and there'll probably just be a couple of protected pages. I just need a script that will log in hundreds of members and keep them logged in until they logout. I would appreciate any help anyone could offer! (I don't need any fancy…

i've published an iwp database and the returned results are displayed in "table view", which i can change to form view by clicking on the link, however when i choose table view to return to the table it seems to revert to some other design. how can i control the table view given to me by my search? ultimately i would like to customise the table view with the categories similar to the client - is this possible?? Version: v6.x Platform: Windows 2000

The FM manual states that one can control the tab order on a web form (from Instant Web Publishing). It talks about using stacking (move to back, move forward, etc). With IE 5.2 on Jaguar, I can't seem to get any control of the tab order. At one point the tab key actually jumps up the the URL entry field in IE. Any suggestions? Thanks Version: v6.x Platform: Mac OS X Jaguar

I am creating a database and i was wondering if there is a way to add a website link, that can be clicked on in the databease, and bring the user to the selected website.

I have a question for the Filemaker whizzes out there. Just so you all know up front I have been working with FM for 3 years on a basic to intermediate level in our business, developing as I go. I posted this in another thread and received only one answer. I am hoping that by posting it here, in a more topic specific area, I will get a bit more feedback. Thanks for taking the time to read this long post. I am truly perplexed. ___ I am the owner of a graphic design firm who has recently taken on doing contract work for a local marketing company. We currently use a filemaker database to track all of our clients. I would like devise a simple solution for …

I have set up a simple DB and I'm trying to get it online. I've done this before and have not run into this problem before. The relative references within the files keep getting messed up. I can go through the page and all is fine (the Js & CSS files all connect) then after I edit a file, and try to come back to a "browse" page there's an extra folder added to the paths so the format file still loads, but none of the Js or CSS work! Any ideas on what's going on? All the files (DB, html, css, js) are in the Web folder of FMPro, and it connects to the web just fine - then it falls apart. The DB is at mullindesigns.com:591/mason/ Thanks for any suggestions.…

I just published an IWP database to serve as an adjunct area of my main html website. It has limited navigation, simple activities - but buttons do not work to submit or navigate in Internet Explorer, however they work perfectly in Safari. Has anyone seen this? I had same poor performance in FM 5/6 IWP 'solutions' - however, those versions are no where near as advanced as 7's. Not sure if I'm nuts, or this is a verifiable issue with IE. I'm runninig OS X Panther with FM 7... Thank you in advance for any info. G. Version: v7.x Platform: Mac OS X Panther

Hi there, now i have create a custom web publishing system for user to create quotation on the net. I have created two type of printing format that allow support Laser/Inkjet and Dot Matrix printer. Because i must use Draft 10/12cpi font type to print on Dot Matrix printer for faster printing. I always do this on FM and it work perfect. But after i come to web, even i have set the font type to Draft 10/12cpi but it still print the graphic mode font like Arial. After that i try to create a testing file with 2 type of font setting, and use IWP to host it. But when i use web browser to open and print it, it still come out the graphic mode result. Just want to know …

In relation to my previous post, I have discovered that so far Safari 1.2 has failed to hook up to and crashed every filemaker 5.5 file I have tried to log onto, either from my own machine of from another. Safari 1.0 works fine as does every other web browser I have tried. Does anyone else have any information related to this issue? --Kenoli

I have gone through the routine to publish Filemaker on the web with mixed results. Some people get on some don't. On one friend's computer, I am able to log onto the file on the his local computer using either http://LAN-IP:port or http://WAN-IP:port. On mine, this doesn't work. It says it can't find the server, though it finds the server fine when I use port 80. (I am using port 8081 for Filemaker). One friend is able to log onto my published Filemaker and also onto his locally published filemaker, while when I try to log onto his Filemaker remotely, his Filemaker goes into spinning disk mode and he has to force quit the software. This latter seems to mean that I…

How do you configure databases such that they when opened by FMU 6, they are automatically shared via web companion? We have a few databases used on the web, and the 2 that were written by our former webmaster always open with web sharing enabled, while none of our new files do. Thanks in advance for any help. Version: v6.x Platform: Mac OS X Panther

I have an Open URL(field value) script step that works fine on OS X and Windows 98. But on a client's WinNT machine, the URL always truncates at 254 characters. (Yes, it's that long -- often 1000 characters or more -- it's sending CDML commands and data to a web-hosted FileMaker database.) I can copy the URL from the field and paste it into IE. This works fine. But FileMaker can't seem to send the complete URL to IE on its own. Has anyone encountered this problem? Additional info: this client has various security layers in place that I don't know enough about to explain. Could this be the problem? If so, what should I look for? I know we all want to…

Hi, I am taking my first steps towards learning fx.php to connect to my databases. I can do the simple stuff like show a list of records and move from a list to a details page for a record. Now I am trying to put together an edit form with dropdownlists and radiobuttons. I am stuck here. This is what I tried: Drop down: <? $TypeList = '<select name="Type">'; foreach ($ReturnedData['data'] as $key => $value){ $TypeList .= '<option selected>'.$value['Type'][0].'</option>'; } $TypeList .= '<option>&lt;----------------------------&gt;</option>'; foreach ($ReturnedValues['valueLists']['Ty…

Hi Is it possible to make a login and password form on a webpage so the user can use these to login to a web database instead of using the standard popup window? thanks

Okey, here's my situation. I have almost gotten all of my coding done in the FX.php class for my project for the college. Now the network team says that they can not install php on their server. I have tried to tell them that they could but they refuse. So now my only option was ASP again. But as I began looking at it, it says that the FMConnector, currently the only available option of connecting FileMaker with ASP, is not compatible with Windows 2003(My college is running server 2003). Why is it able to run on 2000, xp but not 2003? Is there a way to get around this? Also, any advice would be appreciated. Thanks, Justin Grewe

I'm have a bit of trouble making checkboxes send back what has been checked to the FMP db. In FMP, I've set up one Field (FIELDNAME) as 'checkboxes' with a 6 item Value List (myValueList). I can read/display the correct items from the db, but I'm not sure how to get it back into the db once changes have been made. // i explode $formInfo['FIELDNAME'][0] because FX sees the contents of // that field as: items checked with a newline inbetween each item $checkboxParts = explode("n", $formInfo['FIELDNAME'][0]); // $formInfo is [data] array from FX $cbList = $allLists['myValueList']; // $allLists is [valueLists] array from FX foreach ($cbList as $cbChoic…

We are planning out what we can do in the future for our database. We have been using filemaker and would like to register car vin numbers for an auto auction via the internet. Is this possible now. Is it something to easily do if we give all our constituancy runtimes to send stuff to the internet. Any feedback about doing such a thing would help me ask better questions. I would really appreciate any answers you might have. Thanks Stan

Here's one for ya"! Could I use FM to update common "feilds" on my website? Here's the idea: Build a layout consisting of the variable feilds I frequently update. Design a script to generate an updated HTML file & then upload to my site. The question: Would it be possible to write a "copy/paste-trick" that could write a new HTML by copying the basic framework I've written for my site, while bouncing in & out of the "new-info" layout-feilds, picking up & placing them in the new HTML? -hope that makes sense to someone out there,... thanks in advance! my new website

I've noticed something with webhosting and performing a script. If I can describe accurately; I webshare db1, and then when I open nonshared db2 it runs a script that takes a minute. During which time, If someone queries my db from the internet..the script stops dead in it's tracks. I have set allow user abort off in all scripts. I've tried a few things, but no luck fixing this. Access to the database is CDML and read only. Anyone?

Hello, I am about ready to move away from Instant Web Publishing, which I have found to be an instructive exercise but one with no results. Having almost completed a self-taught course in HTML I am ready to figure out what would be the best programming language to use to enable FileMaker for the web. There are a lot of choices and I

Hi there, i just want to ask how can i create a multiple(And/Or) find request by using PHP FX. For example the find request , A and B or C. It is very easy to do it in Filemaker, but in PHP with using FX, i only can perform one type, either all "And" or all "Or", eg. A and B and C / A or B or C Hope someone can help me. Thanks for helping. Regards, Henry

I am trying to use the FMNew Fuction to create a new record but am encountering problems. Just as Mariano said, the examples that come with the FX.php package are old and outdated so maybe that is why the fuction list is out of date as well. I am having trouble with the $InstanceName and the $Query. What's the diffrence? Mariano uses the $Query in his samples. Also when I use the AddDBPParam('FirstName',$firstName) it responds with an error stating that I have used an invalid function. What am I to put in the 'FirstName' spont as well as the $firstName? Is the first just the field name or either what you want the new record to have in that field? For the second is…

So, I've got my PHP file upload script working great (finally). Now I just need to get the images displayed. Because images are being added constantly, I have the cdml code written as such: <img src="[FMP-Field: Fieldname, url]"> The "Fieldname" field contains the full url path to image (it's a calculation field). In the browser source code, I see a bunch of additional garbage being thrown into the url-- lots of &'s, etc. Has anyone else experienced this? What am I doing wrong? Thanks for any responses. Eveke

Hi Could someone tell me if this is possible - I have a global field (aelist) in my database with several user names, what I want to do is check the current username against a name in 'aelist' to see if there is a match. The code I though it would be is (doesn't seem to work) - thanks. Also, why can't I post any text after the code below in this forum? [FMP-if:aelist.cn.{currentusername}]Hit[FMP-Else]Miss[/FMP-if]

I've got a problem with all records appearing blank over the web in Instant Web Publishing, unless all privileges are turned on in Access Privileges. If I turn just one privilege off, such as Delete, all records are shown but have empty fields throughout. (Using FM 6 Unlimited on Windows 2000 Server). Expect I am doing something stupid - tell me what it is, please.

On one of my web pages that is served by FM, I have a CDML tag that points to a field in my database record. This field has a address to a image located on a ftp server, something like http://63.226.110.xxx/images/myimage.jpg. When anyone clicks on the above link the image from the ftp server displays in the browser. Can I instead use a path to a image located on a remote volume. In other words, I have a volume mounted on the desktop of my OSX machine, the same machine hosting my FM pages. Is there a way to type the path in my FM field (something like user/desktop/harddrive1/images/myimage.jpg) and have it work so that when someone clicks the link from the hosted web…

I've been faithfully trying to sort this out on my own, but maybe this is the question i need to ask, instead of programming tidbits...so here it is: I've made a database that holds graphics and text. It took a while to make, but I'm quite happy with the results. Now I want to take it to the web, I thought, in a dynamic fasion. So I tried instant web publishing. MSIE was great, but other browser just choked on it. Then I read the folks at FM got the same result, and don't care to support netscape. I figure that forcing my audience into MSIE isn't an option so I tried a little script in XML. Same result. Now I'm digging into this php business, hoping for the a…

Hello to everyone, i'd like to know what is the best security methot to: 1.protect dbs over web 2. manage password to let the web audience edit,clear,create records My purpose is then to assembly the best method and publish here for future visitors bacause all the forums are full of security issues and notices and i really don't understand what is the best method. Could everyone partecipate with me to this goal?

Anyone knows what script must we use to replace the "submit" button when we "hide and lock" status area with web companion??Thanx!!

Can anyone tell me where I cann find the procedure to upload a FmP

Having a frustrating time, wondering if anyone has encountered this: very simple database, a user is adding a portal row, one field has popup menu of dates (from today back 20 days). Obviously the other existing portal rows are in editing mode - and if the existing dates in the othe other rows are older than the popup menu dates, the data is erased when submitted (the new row is obviously fine, as they can only choose from the popup menu of dates). Any ideas/workarounds?

Hi, I'm building a page with conditional value lists loaded into Javascript arrays and I'm stuck!! on the page below I've loaded some of the arrays and this was going OK until I've reached the second level. In my example, if you choose "The Grocer" and then choose " the grocer display" it works OK, but not if you choose "the grocer recruitment". If I comment out the "If" statement for "the grocer display", the "recruitment" choice starts working. Apologies for getting rather OT here, but can someone point me to the errors in my JavaScript please?? http://www.william-reed.net/adsizes8.htm thanks, jeff

Does anyone know if if is possible to stop people concurrently logging into the same database via the web security using the same login/password as another concurrent user? It doesn't have to be anything too sophisticated - I just want to force each user to use a separate login

... currently I am observing 2 "failure" types when using FM Unlimited (FMU) Some files simply "forget" to be shared via Web after a complete restart of FM Unlimited - I have to activate the Web sharing manually... Second ly- even more astonishing for this never happened before: After a proper login the first layout (Table view) is working but activating the Form View and/or the Search Layout I get an error message (unable to open...) But these views are activated after I am "viewing" them directly in FMU... Any ideas?

Hello, long time no see. I used to post often, long time ago. I don't use Filemaker online, just as an interface to help me publish things online. It's something like this, I've got on a site a list of teachers. When people apply for the list, they use a form. This form generates with javascript the complete html code of all the infomation they fill in, I get the html-code via a field in the form. There's even a preview function so they can see how their application will look like on the web. Recently I use Filemaker to organize those chunks of html, to compose once a month the complete html-file. My problem is the representation of non-ascii html signs, normally…

Hello, I've spent the last 8 months learning Filemaker, and building a very powerful database for my company to use for internal use. Now, we have decided that we want to communicate with our customers using a web page. First, my security concerns: The type of data that our database contains is EXTREMELY sensitive to our clients. Protected at all costs. Clients will only have access to data specific to themselves. Second, what we are doing. Currently, I have 500 clients, and 4 employees. Keeping up with their changing data is becoming a full time position. e.g., updating address, email addresses, phone numbers, credit card numbers, ect. Phone calli…

I am not sure if other users have done this, but there are times that I want to direct users to a specific DB record using a redirect script in my web pages. I use a redirect script or inline action. This then includes all the information such as -db, -format, -find and etc. The user then goes to the page containing this redirect, the script then redirects them to what I want them to see. Easier than me trying to provide them with a long URL. Cleaner than having to put a link on the page and make them click. Anyway, you can forget about doing this anymore. Microsoft just released a update Feb. 10th that makes changes to explorer on the PC. Anyone that applies this up…

Hi, A possible client is currently using FileMaker for is business and on his website. He wants to update his website in PHP and still use FM. I never used FM, i've used MS Access, MS Sql, Oracle, MySql, but FM is unknown to me, which is always cool to learn something new My question is, how different/easy is it to communicate to a FileMaker database with PHP ? Any help would be appreciated and pointers to tutorials or what not

I've been working on an online relational set of dbs using password fields to control who can edit records, and am having a devil of a time figuring out why it's not working. Here's a description of what I've done; maybe I'm approaching it all wrong, but in my mind and experience with FMP it seems like it SHOULD work. But this is my first attempt to use passwords in online forms and it doesn't seem to want to cooperate. Here's the story. I have a small database for students which contains passwords they've entered, and another database for them to enter online journal writings. I have a relation set up between the two so that when a student creates a new journal rec…

In the past few years I have made a fair number of solutions for the schools that I work in. Many of them are now wanting to put their stuff on the web... but I don't know how to do that. A colleague of mine talks about PHP and MySQL .... can I convert my solutions to that or do I have to start all over once I learn that? Or is there a better solution? Any suggestions or advice on books, sites, programs, whatever to help me go to the next level would be great. thanks. Susan

Hello I'm trying to web publish a specific layout of a database served in our office via FMPServer 5.5. In order to do this I have created a separate database (with just the fields I want published) called webpublish.fp5 which is served vis FMPServer. I also have a copy of FileMaker on our web server which opens the file webpublish.fp5 remotely and (in theory) serves it for the web via web companion. However, when I go the relevant browser address, the database is listed but when I try to open it (by clicking on the link in the Instant Web Publishing page) it returns the following error: "Javascript: Database not open .. unable to process your r…

I would have 2 questions please: Is there a way to prevent non printing objects to print using instant web publishing? The second ,is how to take off the header/page nbr and footer when we print from the web.... At the top we've got the page number and the file name and th URL at the bottom, is this to do with fFMpro print setup or explorer? Thanx for your help

Hello, I finally wrote a decent database for indexing a weekly newspaper. I want to thank everyone who gave me various hints on how to solve a number of problems. I learned a lot. However, there is one big problem that I can

hi there, now i want to try to host my db on the web. I create a simple db and set it web companion enable with IWP. I hosted in my pc and use other LAN pc to open it using ip address, it can work. But after that i try to access using other pc outsite the network, by internet, it can't work. I try out the ip address provide by isp and also the ip insite the pc. Both ip can run on intranet but when come to internet, it cannot run. Just hope somebody can let me know how to host the db to web Regards, Henry

I need a solution, workaround, anything to get this to work. I need to add mutliple records to a database based on the amount of records in another database. Then I need to edit those records. I have looked into everything there is. Php I thought would work but it says in the FX.php class that you can have only one query string on a page so that would eliminate that. I have tried portals and the .0 without success. Is there any way of doing this? Justin Grewe

I must have something confused. I have a small survey, and have assigned a single generic password for the department to use, just to keep outsiders from submitting data. The problem is that the password window only appears AFTER the submit button is clicked. How can I tell it to ask for the password FIRST, then only after the correct one is entered, can one access the survey? I am using FMP6 on Windows 2000, and CWP. I have set up the password in the WebSecurity db. That's the extent of my knowledge. Do I need a CDML or HTML code to make this work properly? Thanks in advance.

i have a simple portal in a document which fm can use to create a document in a related database. this doesn't seem to work using the IWP - is there a workaround?:?

Hello. I am trying to switch from CDML to PHP. It's going SLOOOOOW! Using this link: server ip/bookmarks/bookmarks.php?Category=Teacher+Resources I get 81 links in my database. That's what is supposed to happen. But I do not want all 81 showing at the same time, so I am limiting the number that are displayed. I can't get the equivalent of [FMP-LinkNext] to work. I copied the code from the FX documentation and adapted it to my database: if (strlen($BookmarksData['linkNext']) < 1) { echo "<span class="medgraytext">Next</span>n"; } else { echo '<a href="'.$BookmarksData['linkNext']."" class="bbody">Next<…

just to confirm: if i use instant web publishing, there's no way i can add html in "pass-through" mode ie i can put some html or javascript onto a layout and have that served to the browser? if i want to do that i have to start from scratch, and use the CDML tags in html files and build everything from new?? theres no way to supplement what's allready produced by the instant web publisher thingy?

I don't know if the following is possible, or, if possible, it would be easier to use a canned service to provide what I want. It seems simple to me, but.... I would like to create a threaded discussion list online using FMP 6. I already have a guestbook up and running, and it seems to me that creating a discussion list (where visitors can read a post, add their comments, and have those comments "attached" to the original) would require setting up some sort of field/script determining whether a new record (entered online) was an original topic, or a reply to an existing one. I'm thinking of something like auto-enter a record number for an original, and if it's a repl…

Can anyone tell me what the CDML Tool is and where to find it or how to use it....Thanx!!

Okay, I've had a first class education in the last month in moving into FMP and the web. Sometimes I feel like I've bitten off more than I can chew, but always manage to work my way out of the corner (with many, many thanks to my FMFORUM friends). Now here's the point that I haven't been able to clarify yet. Just when do I know it is time to use CDML rather than HTML, and when do I know I am supposed to use JavaScript instead of the other two? It seems there are some things covered by all three. How does a novice know how to choose correctly?

Hi there, now i need to find out a web hosting services that able to host php with Filemaker database. Any recommendation? Regards, Henry

Hi, Can filemaker pro/unlimited be configured to host PHP files via web companion or do I have to run a seperate web server (apache/IIS) to be able to host PHP? Or am I way off and there's a much simpler way to integrate a couple PHP pages into my CDML solution? Thanks!

i'm afraid i find the filemaker pro and developer manuals heavy on the obvious and light on the useful, so maybe someone can clarify the architecturesteps needed to publish a custom web site to the browser... i have a fairly simple database (about 40-50 fields). it currently has a simple layout with a couple of navigation scripts and a couple of calcuation and validation scripts. the instant web publisher version of the database is pretty but breaks a lot of items (ability to add to lists for instance, and the back-and-forth to the server validation is sooo '90's....) i want to use javascript to make the UI more helpful, and i'm happy to use htmljavascriptcss et…

Hello, I am in need of suggestions for DB Hosting. I would like web connector and fast database serving from this host. Who do you guys currently use? Any information would be greatly appreciated. Currently I have a dedicated server that serves out httpd, smtpd, pop3, and a few other services. Performence on this dedicated server has been extremely slow which is no good at all for us. We need FAST filemaker hosting with the web connector ability. Thanks.

My problem is simple. I have a web published database which includes 4 databases. It is a college end-of-year class evaluation system. The user logs into the student database, chooses their course from a course database, then takes the evaluation in a evaluation database which includes questions from a question database. My problem is this script. I have been able to find xsl and xml solutions to get around my other filemaker scripts that I have used but not this one. I am using a global field for portals to pass on information to the evaluation database and globals do not work with multiple users on at the same time. So here is the script: 1) Set Registratio…

Okay, I've been lurking for a while now, and none of the subjects seem to answer my most basic question. I've been using FileMaker for about 10-12 years, but only recently began struggling with the Web capabilities of it. I am familiar with, but by no means an expert in, HTML. I am becoming familiar with JavaScript. I design survey questionnaires for faculty members. I have one that is so long, it exceeds the length I am allowed in a single layout. I have split it into several layouts, which created the problem of getting the program to jump from one page to the next and submitting all the data at the end of the entry process. With that failing, I was told I would ne…

I've got a database, Db1 , shared by the w.c. ,and a layout with some 10 fields. Db1 is related to another database, Db2, not shared via the w.c. Db1 displays data from Db2 on its layout + a couple of fields from a third database, Db3. In the Db2, I use a couple of calculation fields to get the data (from db3) on the layout of the web database. Thus: web database .......................................... 1) some fields from db2: relToDB2::fieldA relToDB2::fieldB etc. 2) fields from db3, via calc field: relToDB2::calc_FieldC db2 .......................................... fieldA fieldB calc_fieldC …

Just wondered whether anyone has had any experience of how Google indexes Filemaker websites - or not, as the case seems to be!!! It has come to light, after running several Filemaker driven websites that Google isn't able to follow Filemaker generated links to pages. Static pages are indexed just fine, but for some reason Google can not follow dynamic pages. Does anyone know why or how? If you go a search for 'known' text on one of your sites in Google, does it show in Google's search results? Any help would be appreciated since I'll be looking to run these sites from another database solution otherwise :-(