Other Internet Technologies

Hi Guys I jut posted this query elsewhere but then realised that this Lasso and CDML forum is probably the right place for my query (so apologies to those reading it again)... I've published a database on a website using Lasso and on a 'custom seach page' I have a checkbox field with about 20 different value list options but am having huge problems changing the search from an 'AND' search to an 'OR' search. If for example my value list ranges from A through M, I want the user to be able to search for records containing *any* of A, F or K not necessarily all of them. All I can seem to do is when selecting value list options A, F and K it will only retur…

Hi! Has anybody thought of making a FileMaker highlighting class in php? Regexp

Hi! I have a problem with FX.php and I couldn't solve it yet. ... $conn->AddDBParam ('C

I have a just quick question. Is there a easy way to get the last record id entered. I know the way to go it in mysql but not with filemaker and FX.php. any help appreciated

I have a made a FileMaker Pro 6 database web accessible via PHP using the FX.php class. I also created a password allowing only browse records priviliges for the FX class. FX passes this password to the database as expected; however, I also have container fields with images that I want to be displayed as follows: <img src="http://$serverIP:591/FMPro?-db=database.fp5&-RecID=1&ContainerField=&-img"> At this point an authentication dialog box pops up requesting the same password to be entered by the user. How can I pass the password to Filemaker and prevent the authentication dialog box from popping up?

Is it possible for Mac's running system 9.2 to access FileMaker 7 using instant web publishing? The documentation indicates it will be accessible from Windows 98 and above and Mac system 10.2 and 10.3 using Internet Explorer.

as far as i noe, the send email script is not web compatible. Is there anyway to work this out other than the open url method? The email must be dispatch automatically without the user's system opening the email application.

Hi, I'm trying to implement a CDML query that returns the newest record that contains an image. I can't for the life of me figure out a way to skip newer records that don't contain an image and return the first one that does. (Explanation: The database provides news articles for our website, some of which contain images. I'm trying to build thumbnail links into the home page to provide shortcuts to the latest articles/content, maximum of 4. Obviously I want to avoid records that don't give me an image to use as a thumbnail.) Any ideas? Cheers, Kevin Futter

Hi all, this is my first post to this forum. I'm a beginnger in using Filemaker with FX.php. The problem that I'm having is that I have a auto increment field [like a index] but when I try to enter information from a form on the web I get this error. XML error: mismatched tag at line 120 I do not know how to take care the increment stuff. Here is my code: $myQuery->AddDBParam('ID','1'); //is this necessary? $myQuery->AddDBParam('Name',$first_last_name); $myQuery->AddDBParam('Phone Number',$phone); $myQuery->AddDBParam('Email',$email); $myQuery->AddDBParam('Date Requested',$date_requested); $myQuery->FMNe…

I have a simple form which queries a database with thousands of records. The form takes twenty inputs, too much for using GET (the URL is about 500 characters long). POST works great. I want to show 50 records at a time and jump from group to group. The search part works fine. I use the 'Link Next' and 'Link Previous' commands on the search results page. When I click them, I get zero records. How do I get the page to remember the found set but advance the $skip setting when POST is used? (It worked great with GET before the URL got too long.) I have explored every resource I can find, but aside from Chris Hansen's FXExamples.php (which is not a for…

Hello all. I'm sort of new, so if I've done anything wrong, feel free to correct me. My problem is as follows: I have 2 databases that are related, Employees and Accounts. They are related by a field called Supervisor, so that each supervisor can type in his/her password and bring up all of his/her employees. The supervisor can also pull up all of his/her related accounts. Now I've created an 'account' value list in the Employees database as follows -It's defined with "use values from a field" -Only related values: "relationship_name" Therefore in the it pulls all the 'account numbers' from the accounts database and puts them in a nice value list for the S…

Is it possible to only IWP one database? I can turn on IWP in the preferences which makes them all display, but ideally I would like only one particular one to be available. Basically can I IWP on a "per database" basis? Any help greatly appreciated

hi, im buidling a new website for a client and he wants a .js menu (popup thingie) on his pages. Ive fixed that part sofar, it loads two external .js scripts. Weird thing is if I open the page in a browser the menu will work, if the page is generated bij filemaker it wont. Looking at the source i can tell the path to the files is correct. I don't know if this is a javascript error (seems not since it is loading when opened directly) or something that FM does. Anyone?? TIA JP ps. should i use the fmp-include tag to load this or can i use the normal method?

Hi. I have setup a database for our business where all our staff access it over the web. Most of the stuff works fine, however whenever you enter find mode and try to do a search in the Contact Details section I get a message "Javascript - Bad Request - The server could not process your request due to a missing command: "". However, if I try to do a find on the address it works perfectly. Any suggestions??

I saw a few posts on this subject but couldn't find a resolution. Does anyone know the source of this generic message, "Filemaker can not share files over the web because Instant Web Publishing could not be started" ? I've tried starting with/without OSX's personal webserver. I've turned off/on FMP7->Sharing->Filmaker Network. I actually got IWP to start once, then I started getting this message.

Does anyone know why my FMP7 IWP access.log file would be filled with stuff like this? ?

My IWP only works in my internal network. How do enable my computer so that my sales reps can access me from outside my internal network?

I have been experimenting with the sample files from Chapter 8 of the Bowers/Lane book, in particular the "Dog Walk" set. I am interesting in storing sessions in a database as the authors do there. All is well. However, there is a peculiar error message that appears when the session record is first created at login. It reads as follows... "Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42…

I have been using CDML -mailto -mailcc -mailformat etc.. to automatically send a work order request when it was added to a database. It worked fine until recently. I think the culprit is a new firewall that IT installed on the network, but I can't find any information about Filemaker, firewalls and the mailto function. Is there a port that needs activitated??? How can I tell. Thanks.

Hi gang, FM 7Pro with IWP (OSX). I have a form with a portal showing related records. The related records are from a self-joined table (Medications is the original table, Medications 3 is the self-joined table, PatientID=PatientID and Yes=Active are the match fields, this is to select only those entries from the Medications table that match the current patient and are active medications). The form works properly within Filemaker, but when accessed by a web browser, the portal does not display initially. If I click on the button which is programmed to add a new medication record, the portal displays and I see all of the previous active medications as well. Af…

I had a website running smoothly interfacing htm pages and FMK 6 databases using CDML I've upgraded to 7, and now I get a message that "The requested file was not found at this location. /FMPro", with a 404 error. I've checked that the htm file is in the web folder (and it is). I've checked that the database is open, with IWP enabled (and it is). I was reading in the manual for FMKR 7, and it says " The URL syntax for linking to a particular database is different than FileMaker Pro 6 and earlier, so you must update the link after converting the file". Those instructions don't really tell me what I'm supposed to do. The CDML coding has reference…

Hello, I have the following problem with showing the same style used in the FMP portal on my internet page. I use the next CDML code: [FMP-Portal: Prijzenlijst_sjsolutions] [FMP-field: prijzenlijst_sjsolutions::Productomschrijving, format] [/FMP-Portal] My portal show the right font and the right size, but when I make one line Bold in the portal, within Filemaker, it doesn't show on my internet page. HOW COME or better what to do? Greetings Jukkie

I have a basic form which makes a submission to a database. Works great. What I desire is to have an email submitted to a fixed address simultaneously upon submission of the form. I explored the demo/examples posted on various PHP sites and tried incorporating them into my form, without success. I then tried to just make a form whose sole purpose is to submit an email, and I could not make that work either. I am using the built-in Apache Server on OSX Jaguar. There was mention in one article of the need to adjust the httpd.config file. Actually the article was about the Windows .ini file. I searched httpd.config but could find none of the lines they me…

Hi everybody, I'm having a big problem in my work. I need to publish databeses using FX.php. I'm abble to connect the database, check data but I can't access to the linked fields of my database. I've checked that all tables where shared on the web with FM companion but when I try to access to a field linked using relatonship The field appear empty. Here is my code (based on the exemples of FX) $BushingQuery = new FX($serverIP, $webCompanionPort); $BushingQuery->SetDBData("Bushing request.fp5"); $arrayName = 'HTTP_' . $HTTP_SERVER_VARS["REQUEST_METHOD"] . '_VARS'; …

I have successfully used Instant Web Publishing to get a database on the web. What I need to happen is for users to be able to enter/update values in certain fields Depending On The Layout. Using a validation based on a calculated value, I got it to work OFFline. If the user enters something into a field on an incorrect layout, when they go to leave that record, a custom validation message appears telling them they can't change the value and they must revert to the previous value. When I try the same thing on the web, no error message appears, the current page looks like it is reloading and I cannot exit the file. When I try to exit the original fil…

this error pops-up when i turn on instant web publishing *FILEMAKER CANNOT SHARE OVER THE WEB BECAUSE INSTANT WEB PUBLISHING COULD NOT BE STARTED* im using fm7 pro what does this mean??? HELP ANYONE

Hello everybody, i have a question i have a cdml page that i want to use online but there' s one problem, i have a field that has a picture that changes for example when a product is ordert the customer can see where his product is in the company with a color(picture) can i show this field on my cdml page with the color in this field? how? (when i use [Fmp-field] i get to see a code (33448)..) and when there is another color does that change automaticly? how can i do this? i have tried an FMP-image tag i get this in my CDML file FMPro?-db=database.fp5&key=33448&-img i have a separate db with the pictures en from there it…

OK, I'm trying to return a value list from my database. But in my format file I'm trying to something involving an if statement. I have... [FMP-ValueList: press CLASSIFICATION, List=press CLASSIFICATION] at the start to loop through the value list items. And for each I'm trying to do this... [FMP-If: ValueListItem .cn. test] <a href="http://www.domain.com/foo.php?classification=test">[FMP-ValueListItem]</a> [FMP-Else] <a href="http://www.domain.com/foo.php?classification=normal">[FMP-ValueListItem]</a> [/FMP-If] [/FMP-ValueList] But it isn't working. I'm trying to say, if the current value list item contains the …

I have a database set up to receive form information. The pages are written making use of PHP and Chris Hansen's FX. Works great. I just noticed, however, that the symbols ' and " appear as ' and ". The backslashes get put into the database field. It happens on text fields and textareas. Can anyone give me a push here? Thanks in advance for the help. O_W

I'm trying to convert an FM6 layout using IWP. Everything seems to work fine except the portals I have on the layout. They won't allow new rows??? It seems to only recognize entry into the first row??? How do I get the portal to work properly using IWP in FM6??? Eventually we'll convert our entire environment over to 7 and the layout seems to work fine using FM7 but for now I need to try and get the portals to work in FM6. I'd rather not invest the effort into learning CDML since it's going away with 7 if I can avoid it. I just need to get this one layout working properly on the web so any help is appreciated.

I'm doing a FM6 php interface. On windows server 2003 and XP, it works beautifully. On the mac, I am getting this error: "XML error: not well-formed (invalid token) at line 2" What's the difference? If I run phpinfo, on Mac I have 4.3.0; the xslt engine is sablotron 0.96. On Windows I have php 4.3.3; this version does not say anything about the xslt engine. Does anyone think this is the right track to solve this? I really think the code is OK. Why would this be happening? TIA Jim McNeely New Century Data [email protected] http://www.newcenturydata.com (940)383-2772

OK here's an annoying problem for me to get through. I've been using PHP with filemaker for a few months now - basically just including data via a URL. include("http://.../FMPro?-DB=TEST..."); But I've come across a problem. I'm trying to do a search, to only return a subset of the records of the database. Using the above method works fine when I'm doing a -FindAll but as soon as I use -Find it seems to break down. When I view the source of the resulting page, nothing is returned. No javascript errors generated by the Web Companion No PHP errors All other PHP code on that page, both before and after that include() statement works fine. …

I'm totally delighted with the ease of use on IWP. However, there is one last thing that would make it perfect: The layout my boss likes to search in has a group of 6 fields that I added to a pre-packaged layout (shh! keep the secret of how easy this new version is, willya?). Naturally these six fields are the ones everyone at this site needs to search in. so it's a big problem when someone accesses via IWP and... those fields aren't visible in Find mode! Any thoughts?

I've searched the forum and there has been a lot of discussion around it but couldnt find the answer. It's about the list limitation of 5 records (list) and 20 records (table) which you can see when accessing via IWP. How can I resolve this item? Regards, Mark Appel

Hi, I haven't been able to find an answer to this (excuse me if it is obvious or redundant) anywhere. I am running FileMaker Pro 7 and FileMaker Application Tasks 2.0. I am trying to run Tasks via IWP and it is not working. I can see the DB from a browser, login, however it hangs with the browser displaying FileMaker Applications: Tasks and a nice graphic (URL string: /fmi/iwp/cgi?-db=FileMaker%20Tasks&-loadframes). The application log has plently of errors like: [15/Jul/2004:19:20:01 -0700] FM Web Publishing: Web Scripting Error: 100, File: "FileMaker Tasks", Script: "Session Globals Init", Script Step: "Set Field" [15/Jul/2004:19:20:01 -0700] FM Web…

I can't seem to change the column width (as it appears on the web) very much for my Table View layout. Is that just the way it is with IWP? Thanks for your help.

Hi, SO I have been banging my head up against a wall with this problem. I am doing a basic update of a filemaker database using the FX.php class. I can edit all of the ORIGINAL records up to the 127th with no problems. However after the 127th it can no longer update the database. I just get error 101 which means it can not find the record. I did some investigating and have discovered the query that FX.php makes into filemaker is this: http://192.168.100.169:80/FMPro?-db=test.fp5&-format=-fmp_xml&name=name2&-recid=127&-edit So I play with the different record ids and I have the same problem. It seems to me that this is not a FX.php problem, b…

Greetings, I am working on a database in which I am trying to use one table to provide a selection list for ease of data entry into another. The main table is a field work tracking system for a utility and the secondary table is a list of a few thousand streets that are in the service area. I have set up a relationship based on the first letter and have the match field in the primary table set up with a value list consisting of the alphabet so that when a user picks a letter, the portal below displays all the streets starting with that name. I then put a button on the portal row that executes a script to move the street name to the list of street names affected by…

Is there a way when submitting a -edit form to have a new record created when going to the subsequent -format page? In otherwords, right now when I am looking at a particular record through the web, I can make changes to that record, hit submit and -edit takes place. I am then sent to a -format page. I want the -format page to actually be a new record that gets created using some data from the -edit page. Right now I have accomplished this by making my -format page use a redirect script. So I hit submit -edit, goes to a -format page which looks at field from my -edit page, the field contains the url info needed to redirect to a new record. Just wanted to know i…

My databse has a container field that displays a TIFF image. This field works fine when i'm editing the database directly but the images don't appear at all when i use IWP. The images are stored directly in the DB and not by a reference. I suspect I need to use JPGs to see these images in a web browser. Does anyone know of a reasonably inexpensive plug in that will convert the TIFFs to JPG/JPEG for viewing on the web? Any advice would be great thanks, Colleen

I am publishing a recently converted fm7 file using IWP and one of the layouts is a list view. When I see it in the browser, only 5 records appear at a time, leaving a big blank space at the bottom. Is this a built in restriction or is there something about my layout that limits the number of records that can be seen in the browser? Thanks in advance! Tom K

Has anyone figured out how to send a user to a custom homepage when she logs out of the Web interface? You can begin at a custom page, and place a link there to your database, but when a user logs out, she always is taken to the unimaginative FM default homepage. A button/script with any order of Exit Application and Go to URL does not work.

I've been having some weird behavior with filemaker running a database and publishing it through IWP. At least I thought it was wierd behavior because sometimes a field marked with "global" storage would hold different values depending on which client (IWP or Filemaker Network) was being used to access the database. If I understand global storage fields correctly, if one client updates the global field, all other clients should see that updated value. In other words, global fields aren't just temporary storage fields local only to the client, although they are often used that way. Is this understanding correct?

Ok this is my problem I have a database with a portal for topics in which a actual schools class will cover. So lets say the main database is "descriptionOfClass" and the database in which the portal comes from is "topics" (there are only 8 at most topics in this portal) I want the person to be able to create a new class which means they will have to add topics to the "topics" database(the portal) as well as add the information to the "descriptionOfClass" database hopefully on the same page and form. Also when they go to edit this information i want the topics to indiviually or in one box be able to be outputed in a text box, many text boxes, or whatever it will be abl…

Is there a way for a script to detect if the client is running through IWP verses Filemaker network?

I was just wondering if there was anyway I can get around the required password/username popup that comes up w/ IWP on 7. I know that you can just press enter to use the guest account, but I was wondering if there was ANY way you can just go right to the database w/out even that. Is there some sort of workaround, maybe in the url that you use, by passing the password or username? Thanks.

To do a FMEdit() on a record I need the RecordID, I have tried the following script for this, but no luck so far. -------------------- $ProductQuery = new FX( $serverIP, $serverPort); $ProductQuery->SetDBData("personligweb.fp5", "www_publish"); $ProductQuery->AddDBParam('personal::brukernavn',$brukernavn,'eq'); $ReturnedData = $ProductQuery->FMFind(); foreach ($ReturnedData["data"] as $row) { $recordPointers = explode('.',$row); $currentRecord = $recordPointers[0]; $currentModified = $recordPointers[1]; } ---------------- I only get these error meassages: Unkown error type: [8] Array to string conversion Unkown error t…

I am new to this whole FX.php stuff. I have successfully connected to my filemaker server, the problem I am having now is that when I display the fields from filemaker using PHP it is not recognizing the carriage returns that were entered via the Filemaker interface. Any suggestions???

Does it work if you have something like... [FMP-If: FindValueItem .eq. something] Or... [FMP-If: FindFieldItem .eq. something] As there are some CDML replacement tags that are [FMP-FindValueItem] and [FMP-FindValueItem] Basically I'm trying do an if on the results page of the search, to detect what fields people searched on by seeing if they contained a value. Do I need to use the intratag replacement syntax for this? So it looks something like... [FMP-ElseIf: {FMP-FindFieldItem} .eq.] ?? What I've got so far is... [FMP-CurrentFind] [FMP-If: {FMP-FindFieldItem} .eq. XHTML] <!-- DO NOTHING FOR THE XHTML FIND REQUES…

Hi All, I have a FMP7 database that works pretty well via IWP, except for one lousy field. No matter what I do, I cannot make this field active in order to enter text. Other fields on the same page work OK. I can duplicate one of the OK fields in Layout mode, and the duplicate works, but when I reassign that field element (in Layout mode) to the field I need it to be, I can no longer enter text in the field. It's just dead. Otherwise, the fields are identical except for their names ("Initials" works; "Comments" doesn't.) Has anyone else experienced a field that just won't open for editing in the browser? I get the same results with Explorer as I do with Safari. …

I have a database file containing a few fairly high resolution images. I want to display these on the web using CDML. Is there a way I can resize these images automatically before they're sent to the browser? I could resize them once they're on the page by specifying the width and height attributes in the img HTML tag, but this still means a 1MB jpeg is downloaded by the client. Has anyone found a solution to this problem? Thanks

OK, I have a database and it's shared using the web companion and it works fine. It is a list of e-mail newsletters, about 10 in total. I've been making a website archive of these and on the front page of the archive is a list of the months that the bulletins have been sent - a user then clicks the month link which does a search, to return a list of the bulletins sent in that month. On that front archive page there is a search box also, which works fine when searching for something that is present in the database but I get a 'could not find format file' error if the search criteria does not return any records. The format files i'm using for this task are …

This is just a quick one... When I do a CDML If statement, I like to do HTML style comments so when I view the source, I can track the route the web companion took through the CDML code. Unfortunately the HTML style comments don't show up... [FMP-If: FOO .eq. TEST] <!-- FOO = TEST --> rest of CDML/html code in here... [/FMP-If] Anyone know why? Anyone know how to rememdy this? Using FileMaker Unlimited 5. Thanks in advance.

I had originally posted this in the online forum, but just realized it should be here... It seems that if I do a -find on my form using a text box, and if the -find does not match any records, instead of the -error page loading, FM Unlimited just unexpectedly quits. If I do a -find and it does match a record, not a problem, it continues on to the -format page. This one has me confused. I have tried hosting the files a various machines, and the problem exists on all of them. It seems to not be consistent though. It crashes about 80% of the time. <FORM ACTION="FMPro" METHOD="post" name="Find"> <INPUT TYPE="hidden" NAME="-db" VALUE="Researc…

Is it possible to generate the IWP pages then just change the generated code slighty to customise the solution or if you require customised pages do you have to write them from scratch yourself? Any advice here would be great, Thanks

I have created a perfectly working image library database(each record has an image file in a container field and some other text fields). I am trying to make this available on the web using instant web publishing to create the pages. I have a button in my database that allows users to download the image to their own computers. This button is scripted using the export field contents function supplied. This function is not web compatible so the button is disabled when i make the web pages. This function is essential to the system I am creating, can anyone suggest another way of scripting it?

Hi everyone, I ended up having a database job assigned to me at the last minute. Someone else had already built the database (in FMPro 6), relying on repeating fields. I am using Lasso to pull the information out of FMPro fields, and I'm having a lot of problems with the repeating fields. For example, there can be a maximum of 20 records per repeating field. I want Lasso to only list the fields that actually have something IN it, instead it's currently listing fields that have something in it AND fields that don't have anything in it. So, I get something like this: UNIT COST: $3,480.00 $35.00 $8,400.00 $900.00 $900.00 $900.00 $900.00 $2,10…

Hi...I've created a simple database and used Claris Homepage to generate the Web interface to the db. One field is used to collect the names of the users. In some of the pages of the Web interface, that info appears as a checklist in the db (so that people can click and unclick their names). In other pages, however, I want to display that same list of people as a list that's either separated with line breaks or with commas. How can I do this? Here's the code that I'm working with: [FMP-field:Editor Designer Name] With this format, all of the names are separated only by spaces. I'd like a break or a comma. I've tried adding <br> after the closing ], bu…

I am trying to put small MPegs on my database and it works in FMP, but I can't see them in IWP... why?

Hello all, I am new to FMP7 and looking forward to utilize the power of this application. I am having an issue with the IWP over WiFi however and hope to get some ideas on how to do this. First, I am strictly running WiFi and do not have ethernet connections. When I go to enable IWP on a test database I created, it allows me to enable it however the URL is incorrectly mapped to my local ether net port of http://192.168.2.1:8080/. I need this to map to my WiFi port on http://192.168.0.2:8080/ which will allow my WiFi users to access. IWP does not let you specify which interface to use. I did enable Filemaker Network Sharing as well and I noticed it showed both Ethernet…

Using the OS X FM 7demo, all attempts to activate Instant Web Publishing give an error message "Instant Web Publishing Could Not Be Started." Preferences/Plugins also does not show the Webfm.plugin, though this is in the Extensions file. Any ideas how to get this working? Version: v7.x Platform: Mac OS X Panther

Hi all! I'm a neophyte Lasso user and I could really use some help on this one. I'm working for a small company whose e-commerce platform is built in Lasso/MySql with a Filemaker offsite database. The current server they are using is a Mac XServe. This server is currently going kaput. I've been looking into new servers, we need to purchase two so we have a backup. The new Mac XServes run around $4500. A good Linux box from the same company who is doing the hosting is only around $1500. I've been told it should be easy to revert over to the Linux server. I've also been told though that the Lasso browser-based admin tool doesn't work with Red Hat. I've a…

I am very confused with IWP and FMP 7 in a sense that I was told 7 is attempting to make IWP almost a mirror of the FileMaker database and that 70 or so scripts work with it. Why is it then that I cannot use a script that changes layouts on the web with IWP? This is just a basic function. Although the script step is web-compatible and that it does perform the step in FileMaker database, it does not do it online. Also, I tried to maybe have a script step that opens a URL that has a -lay as the parameter, but there is not such parameter with IWP? How am I supposed to use FileMaker 7 and IWP to web-publish even the simpliest of datbase solutions if I can't use such a si…

I have a DB that is published to the web using IWP. Usually when clicking in a field on the web page, IWP will recognize that the user is trying to input data and automatically enter the "edit record" mode. However, this "automatic edit record" function does not work if the field is formatted as a drop-down. So, my question is, is there a script or something that can be put on the web page (as a button or something) to allow the user to enter the edit record mode? Oh, I have locked the status area to keep users from searching and browsing through records. This DB is an "add records" only DB. Thanks!!

I AM IN DESPERATE NEED OF SOME PRINTER-FRIENDLY INSTRUCTIONS FOR MAKING MY DATA BASE ACC [color:"red"] [color:"red"] ESSIBLE FROM THE WEB!!! PLEASE HELP!!!

Hi...I posted this under the "Fields" topic, but someone suggested that this topic might be better. (They were right.) I am very new to Filemaker and Claris Home page, but so far so (reasonably) good. I do not have CDML experience, but I have been using HTML and HTML forms for years, so I can customize the output that Claris Homepage produces with its Filemaker Connection Assistant. I have a question about how checkboxes interact with the FM database. I'm using FM 6.0 and have used Claris Homepage to create the Web interface to the database. I'm then customizing the HTML pages. When I created the interface with Claris, I instructed the one field (Editor/Des…

Hi, I have a Filemaker Server 5.5 that is located on the local network. I open these databases from the computer on the local network which has DNS provided so that those databases could be accessed from the web. FM plugin is configured for port 5003. Everything is working fine. Now I am trying to use php (FX) to submit some data to FileMaker. User can browse database online via CDML - no problem. When the user modifies a record and submits, the action of the form is :"http://localhost/save_changes.php" file. It works fine on the local network. However when I am trying to submit changes from external network it says that "localhost/...." path is invalid. Does anyb…

Hi -- We have an ordering database in FM which is accessed via the web, using cgi scripts, javascript, and CDML. (FMPro 5, Mac OS9) The ordering from can accommodate up to 6 items, which are represented by repeating fields. When you enter the item name, the catalog number, vendor, and estimated price are looked up, and javascript submits the form and refreshes with the appropriate values. This all works beautifully in FMPro itself. Via the web interface, the vendor and catalog numbers update great, but the estimated price is stubbornly blank. Incidentally, the records that were already in the DB appear just fine, with the estimated price right where …

Is there any way to get rid of the opening screen that lists the databases and replace it with a simple web page without getting into server 7 advanced?

Hi, I need to pass tokens through a couple of pages via links. I start by assinging tokens using javscript .. URL = "&-token2=" + document.form1.date_installed_start.value; .. On the next page I see those tokens and I insert the following link: <A HREF="FMPro?-DB=example.fp5&-Format=record.htm&-Lay=web&-RecID=[FMP-CurrentRecID]&-token.1=[FMP-CurrentToken:1]&-token.2=[FMP-CurrentToken:2]&-token.3=[FMP-CurrentToken:3]&-token.4=[FMP-CurrentToken:4]&-max=1&-Edit">Edit Record</A> However, when I click that link - tokens are not passed. They are empty on the record.htm page. DOes anybody hav…

In Dreamweaver I'm creating a Jump-Menu that will take me to certain items in my database. For the Link I have the following: http://127.0.0.1:591/fmpro?-db=frames.fp5&-lay=parts&-format=parts.html&-max=368&-recID=127&-find There are 368 records in the database. The above command works. If I just replace -recID and -Find with -Findall it will show all 368 records. However if I change -recID=128 or go any higher, Filemaker returns a javascript warning that the file is not found. I can see records 1 through 127 fine, but then it seems to loose its way. Am I searching the wrong way? Thanks

Hello, I want to compare my edit (currentRecId) with the (CurrentRecID) value in the database. I want this because if the field subscription did not change it may go directly to reply.htm page. But if the field subscription is different then de database I want to get a email with the changes in it and after the e-mail it should go to reply.htm. Is this possible using CDML. I am thinking about using [FMP-if:] tags, but I still don't have the solution. Greetings Jukkie,

I am developing an IWP solution that hides the status bar at all times. The site is basically run by buttons. However, logging out is somewhat problematic. I have a fairly short timeout for each user, but closing the browser window apparently does not perform the same function as hitting the "logout" button in the status area. What does this button specifically do, and can it be simulated in some other way? (There is no "logout" script item, and there's probably a reason for this which is opaque to me.) Thanks for any ideas.

I have two fields, a dropdown with 1,2,3,4. The next field is a text field then a search button. What I want to do is if 1 is chosen search database 1 for the entered text, if 2 search database 2, etc. Any thoughts on how to capture the drop down then do the search depending on it's value? Thanks, Ricardo

Hi all, I've got two fields: text Field: 150mA, 750mA, 1A num Field: 150, 750, 1000 How do I populate my value list with values from the "text" field and sort with values from the "num" field? I'd like the following to happen: Web Select field: 150 (value) > 150mA (label) 1000 (value) > 1A (label) vs. 1A 150mA I need to do this because of sorting and logical operators on the numeric values. Thanks. -Jose

I've created a search page (for our publications database) which links to a stylesheet but when viewed in the browser it doesn't display correctly. When viewed in my html editor (Dreamweaver) all appears to be fine. The stylesheet is in the same directory as the search.html page. I also need to create the response.html and detail.html pages which need to use the stylesheet, but they obviously reside in the cdml_format_files folder of FileMaker Pro. All three html pages mentioned above use CDML to display the database info via the web, and this works fine. The stylesheet is needed so that the pages resemble the design of the newly designed web…

I was going to try phpmyfaq ( http://www.phpmyfaq.de/index.php for our website at school. My question is can filemaker do the same thing. I am ready to filemaker 7.0 if that will work. here is an example of a site using phpmyfaq http://www.sad60.k12.me.us/ Thanks for the help in advance

I am in need for some hints on how to upload an image from my lokal disk, to a container field in my database. Have tried something like this: --------------- <?php if(is_uploaded_file($_FILES['form_image']['tmp_name'])) { // file uploaded to server echo "file information is :-<br />"; print_r($_FILES); $imageInfo = getimagesize($_FILES['form_image']['tmp_name']); $width = $imageInfo[0]; $height = $imageInfo[1]; $image_type = $imageInfo[2]; print_r($imageInfo ); // move_uploaded_file($_FILES['form_image']['tmp_name'], "./test/".$_FILES['form_image']['name']); } else { echo "…

i have a script that changes a single value in a field after a find for a single record. that's what it's supposed to do. it doesn't change the value of the field when triggered on the web but it does work when doing it via the FMP interface. the relevant part of the URL i'm using: http://thesite.com:591/FMPro?-db=Staff.fp5&-lay=WebDay1&-format=viewday.html&-recid=103&-token.1=WebDay1&-token.2=103&-token.3=Time%20Que&-token.4=Day%201&-token.5=&-script=WebPrevDay&-find it's a next/prev day script that changes the date in a field so that it display a new portal. why won't it trigger? thanks for any insight!

1. can i edit any pages that created in web publishing mode, for example cam i add any graphical object with Frontpage in server to web pages? 2. can i insert output of web publishing in my own frames of any other web pages?

I have created two databases and a relationship between them called REVIEW. I also have a HTML doc set up to display some records from the Master file and then all of the related records from the related file. However, this is not working. I've tried stripping out all of the code to a bare minimum to see if I can even get it to work but when I look at the source of the "rendered" html doc, I see nothing. Here's my code below. Can you see anything wrong with it? InlineAction tag - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <script language="JavaScript"> // Obtain RECORD information and save into parallel arrays. // var …

I followed the example from FX folder, create a list.php, detail.php, and apply to my database. Everything works fine. I got stuck when I try to update a record. there is no error message, but the record cannot get updated. Here is my detail.php <?php require_once ("FX.php"); require_once("server_data.php"); $Query = new FX($serverIP, $webCompanionPort); $Query->SetDBData("MyDB.fp5", "Form view"); $currentRecord = $_GET['ID']; $Query->AddDBParam('-recid', $_GET['ID']); $result = $Query->FMFind(); $currentKey = key($result['data']); ?> …

Radio buttons in read only don't show state in IE on windows 2000 but look fine in Safari Mac OS Panther, however, occasionally you can see and active button. Is this a bug for read only? All other states work fine in IE. Any suggestions would be greatly appreciated

Hi! I'm building a solution for use with IWP, and I've noticed what I think is a bug. I was wondering if anyone has seen this and could provide any insight: I have three tables; A, B, and C. They are related in that order (From A to B, and B to C, in a continuous link: A-B-C) Table C contains a container field with graphics in it. A layout based on table A contains a portal to B, which contains a field linked to a graphic in C. The effect of this is that each row in the portal is a record from B, and also shows an image in C related to that row. This works properly in FM7, but when published to the web, the images are broken (404'd). If any…

Can anyone recommend a decent schema for the following, because I'm having a tough time of it. in FM7 (direct and via IWP), I would like to set up a log-in system that allows new users to establish a user account name. Once they have established this account, they can enter the rest of the solution/site and operate with user-level permissions. Splash screen shows button options for new user or existing user. If new, they enter an account name in a global field, hit the new user button, and the account is created. They would then be automatically relogged-in as that account. If they are an existing user, they hit a button and are prompted to enter an accoun…

Two email questions: First, as Send Mail is not an option for IWP in 7 (why? -- ok that will be 3 questions), is there any way around this that's cross-platform? Second, if I capture in fields the data that would have been sent via an email, is there any way to trigger the host to send an email to the web user? Basically, this has to do with lost log-in information. I want to automatically send the user his/her password if they've forgotten it. Thanks for any ideas.

How exactly would you implement this workaround? At the moment I have done it by creating a new empty table with a link field in it (set to 1) and a link field in the table I want the portal fields to come from - then set up a relationship between these link fields. Then the portal layout is created from the new table. Is this the right way to go about it?

hi all, please bear with me with the following questions, im not a database developer by trade, ive just picked things up along the way, so am quite ignorant about lots of things. my work has recently upgraded to FM7 with most users accessing the data via instant web publishing. this has a limit of 5 users that can access via the web at any given time. as we have more than 5 people who need to access the file, i have set the timeout period to only 10 minutes, so there is regular turnover and people dont have to wait too long to get on. but there are a couple of problems. 1. i cant work out how to stop users logging on more than once. so if they close the browser wit…

Has anyone else had a problem with calculations not working in the web mode? I have found this several times now. An example is a simple calculation that inserts the date when a particular field is modified... it works perfectly in FM, but via the web the calculation field just returns a '?'. Any help would be greatly appreciated as most users are accessing the database via the web, and a lot of these functions are really necessary. Thanks, J

I have a database that users use through there web browsers, the problem im having is when trying to add a new record it will only let me add data into certain ones. Any ideas? Thanks for any advide. Chris.

I have a website being hosted in one place and a link on one of my pages to another IP address which is running FileMaker Unlimited and serving the remainder of the pages which interact with the FMP database. The main website uses frames, with the web companion pages 'inside' one of the frames. (To see this, go to www.cpestore.com and click on the "Online Grading" link; then clicking on the "Grade It" button opens the default web companion page.) I use the following link to get to my default Web Companion page: http://216.168.63.37:591/cpestore/default.htm Here is the problem. Some of my users get a "Page Not Found" error when they click on the above li…

I want to try to publish a database for access on the web. Guidelines say I should create a dedicated file for the Web. I'm not sure how to set it up. Here's my scenario I have a Time Sheet database with daily record for each employee and a related Time Line Item file that has the records for each time increment and the client job number it is assigned to. If I create a Web database relating to the Time Sheet database, do I have to create all the same fields from both Time Sheet and Time Line Items in the Web database or do I just create portals to the information. I can't create the relationship without defining some field(s). Please help me see the logic…

Hi! I have a web page that allows user to find certain records and then edit them. After the record is edited I use PHP script to enter data into database and return user to the "browse" screen. The problem is that the user shouldn't see the records that have been modified today. When the user returns to "browse" screen, the set of the found records is still the same as it was in the original search. However, when the user clicks "next" link, the page refreshes. For example, if the user find 7 records it shows "Found:7, Showing: 1" in the first place. When the user modifies a record, returns to that screen, and clicks "next" it shows - Found:6, showing 2. So, it show…

I know this a come up a number of timesin the past but I can't quite get it to work. I have tried the code from a previous post (below) but all this achieves to create a new record with no image in the container. Would one not have to encode the image 2 say base64 they are to use a readfile into the database or are we infering by reference where the file is living in the /volume/data path?? Thanks <?php $file_name = $_FILES['myfile']['name']; move_uploaded_file($_FILES['myfile']['tmp_name'], "/Volumes/Data/" . $_FILES['myfile']['name']); readfile ("http://10.0.1.2:1154/FMPro?-db=combotest.fp5&-lay=web&-format=hworld.html&na…

Help. Related field as a dropdown list on web. I have a fm db with two fields color, code. This db is related to another 'all', by color. the all db has multiple records with many colors and each color contains several codes. On the original db I type a color and then the code by pull down list I want to see the desinagted code. It works on the client by relating the db using the values from field from related db. ex. red, 1, 4, 5 white 2, 5, 7 you select red, then values for red should be 1 4 5. if select white then values for white. I have multiple colors and multiple codes per color. Help needed to accomplish this on web.

Just installed Apache and Lasso 7 and converted all my (I am certain) flawless CDML, HTML pages (nearly 93 pages for one database segment) on a test machine accessing FMPro 6.0 Unlimited - on another machine. The converter plugin for GolIve really stinks. It has taken nearly 2 days to repair/fix bugs ON ONE PAGE!, in code that should have been converted - what they claim is simpe and nearly the same as LDML. Sure - a conversion occurs and reports no errors. But the pages all blow up or report really nice pages with cryptic errors that cover really strange errors. If CDML is so compatible - how come I get so many errors?:?

I would like results of search to display in a table format (with 3 records in a table row, then on to the next row). I'm not sure how to do that. I'm going for the 'catalogue" approach, where several records are displayed and a 'click' takes you to a 'details' page. Presently, the search results are listed in one column and its tedious to scroll through). Any advice?

OK, I'm having trouble with the mail CDMl tags. The problem is, it doesn't work - and I've got a hunch as to why. I run an exchange server on our company network, and I've heard before that the mail CDML tags don't work if your filemaker web server is on a network with an exchange server Is this true? Are there any other reasons? I've checked my code and it works when I use it running the web companion at home.

I have a pretty extensive CDML website running at the moment. But increasingly I'm learning PHP and have been converting many of the pages on my main website to php. In php, when you do an include of a php file, any PHP code in that file is parsed. With CDML, if you include a CMDL format file, the CDML isn't parsed. I was looking at using the FX.php solution and will shortly begin testing it. I'd like to know this... Say for example a have a menu file, written in PHP, with the menu items being records from a filemaker database. Say I use fx.PHP to do this. Can I include that menu file in my main site? So effectively I'm including a PHP menu file,…

Hi List!!! We have two different problems using Inline code: 1) First problem When we use this code (search and update): [inline: -Search, -Database='Contacts', -Table='People', -FMScript='DTcreate', -KeyField='recID', 'username'=(Field:'username')] [inline: -Update, -Database='Contacts', -Table='People', -KeyField='recID', -KeyValue=(field:'recID'), 'name'=(Var:'name'), 'email'=(Var:'email'), 'Address'=(Var:'Address'), 'ZipCode'=(Var:'ZipCode'), 'Phone'=(Var:'Phone'), 'City'=(Var:'City')] [/inline] [/inline] The errors generated by File Maker are ignored! In FM we are validating the phone number with t…