Other Internet Technologies

Hello Everyone, I want to create a bar code system, I use the web to query my database, I made my html files, I activate my web companion, I open my database, I copy my html file in my web folder in the folder web of the filemaker 6 folder... and it doesn't work... do you have a tip for me?? I am sure my html code is good...

I have these buttons setup to navigate through records. nothing fancy, not scripts.. built in things. When I use a simple text filed called "goto next", make it a button to do just that, it works fine in the browser. However, if I do the same thing to my graphic I made, the graphic appears in the browser, but it doesnt work as a button. I cant click on it at all. Any ideas why this might be so? thanks!

I have some portals on a CDML page, each one is on it's own form. After I fill the fields in and hit my "add line" button. The new line of info gets added to the file and I go to the -format page. On the format page, I have it automatically redirect me back to the main page with no delay, since I don't really need to see the "Record Edited" page... Once back on the main page, I have to hit refresh in order to get the new line be be displayed in the portal. I tried using javascript to refresh the page, but it goes to the top of the page when it refreshes, causing the user to lose their spot on the page. Is there a way to add the new line and make it vis…

Hi If my database is not open, I would like to 'capture' the error 'Database not open:' and redirect to an html page. Is this possible? Cheers Hal

Please! Can anyone help me to find "Claris Homepage 3.0 for Win" for download it?

I have read with interest the posts on this subject. I am just getting started with php too and have, I hope some simple questions. I have found a php upload solution through DMXzone.com called Pure PHPUpload (it also comes with a progress bar so the user can see the progress on their upload) and am trying to get it working with my cdml database. It works fine when I access it through Apache (file is called "upload.php"), but how do I get it to work through the Web folder in FileMaker. I have my default.html page in the Web folder where my clients sign in to their web database. The "upload.php" page will not work through the Web folder, but needs to be in the root fo…

Looking for an idiots guide to deleting portal records. Have managed to add & edit but having problems with delete. I've read elsewhere that a button should be used with an associated "Delete portal Row[]" script however I'm having little success. Additionally when using CurrentRecID as a hidden field the parent record was being deleted so attempted to use CurrentPortalRowNumber but this gave me a 101 error. Any help much appreciated. Iain

I am getting an xy thing at the end of my search string. I have a search graphic which I am sure is causing it, but how can I fix it? &-find=&-find.x=25&-find.y=15 <input type="hidden" name="-find" value=""> <input type="image" border="0" name="-find" src="images/search.gif" width="60" height="27" alt="Search" >

I'm trying to create some value lists for a web page. I want these lists to be populated from existing value lists in my database. The lists all work perfectly in the database, but not all work on the web page. The ones that don't work are the ones whose source is "From Relationship" I thought it might be because the field used in the relationship wasn't on the layout I was using, so I added it but that didn't fix it. Is it possible to use value lists that are created from relationships on a CDML webpage? If yes, any ideas on what I'm doing wrong? Thanks in advance, Justin

Having dug around in my manuals and other help texts, and probed the WebTools help, I'm still stuck so would love some help on the following: I have an editable record_detail page that currently returns an "x" or nothing in a text field, depending on the value of the field in the database. To make it easier to the user, I'd like to turn the text fields into checkboxes, but want them to show the current value (empty or full) of the related field in my database. I can't seem to figure out the syntax for entering a checked checkbox into my format page, but I'm sure there's a way to do it. Any ideas? Thanks in advance. Peter Knowles

I picked this script up but it does not work with safari... any suggestions? function resizeMain() { self.moveTo(0,0); if (parseInt(navigator.appVersion)>3) { if (navigator.appName=="Netscape") { top.outerWidth=self.screen.availWidth; top.outerHeight=self.screen.availHeight; } else top.resizeTo(self.screen.availWidth,self.screen.availHeight); } }

Any dates from the web in the format of 10/24/03 are turning into 1903 instead of 2003 inside of Filemaker. The field is a normal text entry field in a CDML web page. Is there a setting inside of Filemaker or in CDML that would change that? Or should I try to validate the date with javascript on field exit? Thanks, Mark Durgee

Hello all, Well my FileMaker computer just burnt out so I had to take the data off of the drive and copy it to another computer that has FM on it. My FM computer has a static public static IP and I have enabled the Web Companion. The databases seem to be working fine now. The problem is I have other computer that have Dynamic addresses like 192.168.x.x those computer cannot pull up the databases only computers that have statics within the same subnet. Any reason why? Thanks, Jaser

We are running a Windows 2000 terminal server with FM 5.5 installed. Using a monitoring application (a great one, Appsense Performance Manager), I've noticed that Web Companion is taking up 2 megabytes per session - and we don't even publish to the web. Can anyone tell a quick way to disable web companion without having to go into every user profile and check to see if it is in the prefs? Can I safely rename the dll(s) to disable it? Thanks. Chris Feyrer

Hi all, I have a site that allows users to place orders. When they submit the order, it fills in my database and then sends them (and myself) an email confirmation. This has been working fine for the past 2 years - and nothing has changed in that time. Suddenly, the emails have become hit and miss... I know that if the user submits the order and quickly closes the browser window, the redirect page will not load - thus not sending the email... Since this core group of customers has been using the system for a long time - I don't know if it's coincidence that 5 of the last 10 orders did not result in an email or if something else may be going on. A…

I am relatively new to filemaker and a stranger to web developing. I have created new databases and scripts, run into a few problems, but with the help of the forums, have gotten my databases to do everything that they need to. Then I tried to post them on our extranet. First of all the product manual didn't really help me past enabling the web companion. Then most of my buttons do not work and there are some layout changes that I would like to make, that I can't. So I search the help menus and the forums and have gotten the impression that I either need to create custom web pages or get Filemaker Developer, in a nutshell, I need something else beside Filemaker Pro …

HI, Sometime ago I found a script in this forum (see below) that systematically submits all the forms found on the page. However, I've found that this script doesn't always work (i.e., doesn't always submit all the records on that page), if the user is on a mac, and sometimes it just stops submitting records. These problems do not occur on a PC. Does anyone have an updated version of this javascript code? I've copied it exactly as I have it in my CDML code. And the CDML code is correct, becuase it works on the PC. <script> var count=0; // function editMe(){ // var size=1+[FMP-RangeSize]; // f[3].submit(); // countdown(…

I need my page to jump to an anchor after the page loads. The anchor number is generate in FPM, the onLoad script is DW's - Doe anyon have a clean solution that word on explore and safari --------- function MM_goToURL() { //v3.0 var i, args=MM_goToURL.arguments; document.MM_returnValue = false; for (i=0; i<(args.length-1); i+=2) eval(args+".location='"+args[i+1]+"'"); } //--> </script> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_goToURL('content','#[FMP-Field:a_RandomAnchor]');return document.MM_returnValue">

I'm attempting to use the article below from the FileMaker Knowledgebase to ensure uniqueness of records based on two (or more) fields. However although this works fine when tested directly in FMPRO the validation seems to be ignored when entering records via the web. Has anyone else came across this and discovered a workaround or alternative or should this work OK via the web? http://www.filemaker.com/ti/103792.html Many Thanks Iain

Hello, I am brand new in Lasso, and I am wondering how to solve the following situation : In my web site, I developped a login/password procedure, using 2/3 FMP files. It works well and, once the login/password are validated, the user is redirected to the database he should use to input some data. This database is specific to the login he introduced. Because I work in a deep regulatory environment, I would like to develop an electronic signature like this : after the fields are completed with their data, the user click on the "submit" button. At this time it should be desirable that these date are completed with the login/password values, in a 'hidden" way, in order to …

Hi guys, One of my Coworkers wants to know if we can send out e-cards, similar to hallmark.com's e-cards. You fill out the email address for the person you want to receive the card into a form and then they are sent an auto email with a link to click on to look at the card. The link would pull up the html page so that it was personalized with the name of the person who sent it and a personal message. I am thinking this is doable with FileMaker. Has anyone done anything like this before? Any suggestions?

Sorry, I'm a little new to cdml and FMP so hope I have enough info here. I appreciate the help in advance. I inherited a class registration system and am attempting to add online grading functionality. From the class registration page I have thrown in a quiz (via quizconfig.js which grades the quiz).I want to import the result back into the registration.fp6 file (ideally tied to the onclick="gradeit()" or if not at least from the results.html page. I've seen how to pull fields from the FP files and add to text but haven't seen how to do it from a javascript file. Thanks.

Hi all I have taken a quick look at Wellspring Data's 'Filespring Pipeline' (http://wellspringdata.com/filespring.html) to enable the use of existing CDML files on my Apache server. They state that no additional coding is necessary to use your existing files in this manner as the technology simple forwards the request to Web Companion. I have carried out the 'simple' installation instructions without luck and as I am not a total apache techie, do not know where to turn. If anyone has had experience in using FSP then please post a reply... I'd appreciate the help!! I'm using OS X 10.2.6, standard Apache install with the OS, PHP 4.3.0 and FMU 6. The prob…

I have a format file as below to submit data but I want the user to be able to view it but not actually change any of the data before an edit of the record. Any thoughts. <FORM ACTION="FMPro" METHOD="POST"> <INPUT TYPE="hidden" NAME="-DB" VALUE="Time_Cards.fp5"> <INPUT TYPE="hidden" NAME="-Format" VALUE="replyout.htm"> <INPUT TYPE="hidden" NAME="-Error" VALUE="error.htm"> <INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-CurrentRecID]"> <CENTER> <P><B>Employee Number:</B> <INPUT TYPE=TEXT name=EmployeeNumber VALUE="[FMP-Field: EmployeeNumber]" SIZE=5> <P><B>Employee Password:<…

The javascript in my results page does not get parsed. The source code in my text editor looks like: <SCRIPT LANGUAGE="JavaScript"> <!-- document.write("BOO"); //--> </SCRIPT> However, in the source code viewed within the browser (Netscape, IE, and Safari), all I see is: <SCRIPT LANGUAGE="JavaScript"> </SCRIPT> If I do a simple document.write("hello world!") in a file saved on my desktop, it works. But if it goes through FileMaker, it doesn't. Any ideas? Thanks!

The [FMP-Record] tag allows you to process every record. However, if I want to get a list of 30 items and show them as three columns of 10 each, how can I achieve these results? Thanks

Can someone tell me how to write the following expression correctly? What I'm trying to do is check if if the text entered in a that was entered in the search page matches the found result [FMP-if: emailaddress .eq. FindValueItem]Hit[FMP-Else]Miss[/FMP-If] I'm wanting to validate a login/password with the results page - thanks!!

Hi, I need to let my FMP ULTD 6.0 application's users to export FM data into text (Tab separated) file. Now, I've reached this goal with a CDML "-script" instruction, but I also need that these text file have different name from time to time. I.E.: the first time user XXX produces the text file, this will be named XXX001.tab, the second time the same user produces another text file, this will be named XXX002.tab and so on. Is there anyone knows the way to dinamically renaming my exported files? Thank you. E.M.

Hi I got a simple <text> & <text1> input fields (which are working perfectly) on my cdml page. When I try to insert an [fmp-if:test.eq.1]<text>[fmp-else]<text1>[/fmp-if], everything is also working perfectly.... BUT, when I try to save I got a 102 erroe (which is field missing), but it is all there and you can see on screen the data of those fields. To make a long story short <text> - working [fmp-if...] <text> [/fmp-if] - I cannot save but data is displayed correctly. any ideas??

This seems like a very common problem but I haven't been able to find any help anywhere. I want to reproduce the formatting of text fields (i.e. size, bold, italics etc) on the web without using "Instant Web Publishing". Yet the [FMP-Field:] tag in CDML only reproduces the text and there doesn't appear to be any other useful tag or even FileMaker function to access the formatting. Exporting is also useless. Are there some undocumented ways to do this or perhaps some plugin? One extremely awkward solution would be to place the desired text fields in another database on another computer with instant web publishing enabled and use scripting to access the dat…

What would be some possible causes of a search hit list not returning a consistant number of items on each page? I have the max records set to 20 from the search page. The hit list will return 20 records on the first page, then less and less records on subsequent pages. Weird thing is the record status numbers at the top of the page are correct (for example records 1-20, or 21-40 records shown). The URLs for the next and previous link also appear to show the correct amount of skip to go to the next page. So I'm at a loss on why this is happening. Thanks, Mark Durgee

Has anyone seen any example html files for a simple calendar ? I've seen the example calendars in the sample files, but I was hoping someone might have seen some example's with the cdml to use on the web.

Can rollovers be used with a find or submit action? If yes, what would the cdml code look like? Thanks in advance - Sam

I was hoping to be able to search a database using a calc field as a the key search field. Is this not possible with Instant Web Publishing? FMP 5.5 Thanks John

Hi This is my first post so please excuse any protocol and spelling slip ups. Having read the manual and the cdml tools companion, I am still struggling to return basic search content into an iFrame I can perform the search strings and get the results into a standard format file, but it all goes wrong when I try to emulate the iFrame object Any code examples that anyone already has or suggestions would be great, you know what it's like when you have looked at the same screen 100's of times! Kindest Steve

I am trying to find the correct sting that will perform a search on the web. The ASP form method is POST so the result page does not show the final string. Search Page: http://www.cpso.on.ca/Doctor_Search/number_srch.asp?Scr=FIRST Sample Number 70177 My Best guess: http://www.cpso.on.ca/Doctor_Search/number_srch.asp?Type=CPSONUM&SCR=FIRST&CPSONO=70177&Easysrch=Start+Search

I have a drop down list that I'd like to create a new record when a choice is made, then call an edit page so the rest of the fields can be entered. How do I format the onchange event? Would it be anything like this:?? onchange= "/FMPro?-db=request.fp5&-format=record_detail.htm&-lay=web&-new" Thanks, Mark Durgee

Geesh, I just can't grasp this token thing! I'm in DB1 <FORM METHOD="POST" ACTION="FMPro"> I set the token to the field <INPUT TYPE="hidden" NAME="-token" VALUE="[FMP-field: acme]"> I'm going to DB2 <INPUT TYPE="hidden" NAME="-db" VALUE="db2.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="Working"> <INPUT TYPE="hidden" NAME="-format" VALUE="showme.html"> <INPUT TYPE="hidden" NAME="-error" VALUE="oops.html"> I want to search in DB2 in the field "acme2" with the value of the token which is the value of the field "acme" <input type="text" size=12 name="acme2" value="[FMP-CurrentToken]"&gt…

does anyone have a good solution for displaying information in a grid format (3rows x 3 columns). thanks David

Hi fellow FMPro people! I've been using FileMaker for over ten years now, but am only just starting to explore the custom web interface. I have a 14-file (and growing!) database, which I want to be able to interrogate online. So far I've achieved a search, a table, and a form with portals. Simple stuff, but I need to know how to do two things: 1) How to "Go to Related Record" 2) How to use a script that contains "Go to Layout" I can't find anything in either the FMPro or CHP help about this. I'm using FMPro 4. Many thanks.

How I can to configure FMP 6 for to accept the date in the italian format %d/%m/%Y via web companion ?

I have a database of two files in FM Pro6.0 on a Mac. The files act as a time card for 200 employees to punch in and punch out for their hours worked. The first file shared has two variables, employee number and password both are global variables and two buttons on the layout, one to run a script to clock in and the other to run a script to clock out. The scripts validate the entry info and pass it to a second file to create a time card record for that day for the employee. I want the 200+ employees to be able to clock in and clock out by accessing the layout through a web page with CDML tags that will pass on the employee number and password and the a click of the first …

Hi there, I wanted to delete a foundset of records from web (web companion). It seems that I can only delete a record at a time using -recid. Is there a way I can delete mutiple records at a time? Thanks a lot for your help. Hameed I am using FX.php plugin to connect web companion PHP Scripting on Apache Server on Windows 2000 Machine FMP 6 client as webcompanion server

Is there a way to password protect my "menu page" (default.htm) via Filemaker? I'm using custom web publishing and the web publishing database. That protects the databases fine, but I'd like to lock the front door too. Thanks, Mark Durgee

I'm new to CDML and have what I hope is a simple question. On my form for adding a new record, for one of the fields (genus_id), I have a value list (genera) based on a related file. The related file has two fields an ID and description. I can get the ID's to pop up fine with this code: <SELECT NAME='genus_id' SIZE=1 > <OPTION VALUE=""> - No Selection - [FMP-VALUELIST: genus_id, LIST=genera] <option [FMP-ValueListItem]>[FMP-VALUELISTITEM][/FMP-VALUELIST] </SELECT> But what I really need to pop up is the description and then store the selected ID in the new record. In the database, the value…

Hi there, I'm looking for some basic info for updating related info. I'm using CDML and the standard "NEW" format file to enter information to the Filemaker database. I have a drop down value list for our outside guys to choose a customer by name (working fine). Now, once they make that choice I'd like that to pull related information such as address, city, state and zip from the related customer file. Fill in the blanks so to speak. So what I'm guessing is that on selection of customer, a new record gets created with the customer name and related information being served back in an "EDIT" page. I've got the javascript down, but I don't know how to come up with the p…

Please do not throw me out because i have a question about filemaker script running in a cdml environment. I think i am aware of all the risk and disadvantages. But just too be sure. I have a CDMl web enabled database. Now i want the user to be able to download the results of a query. So this is what i do: 1] User makes a query 2] records get unique id 3] run a filemaker script to export the records to a file 4] user can download this file with <a href="filename.txt">download now</a> link Okay, i agree, this interferes with the multithreading feature of filemaker. Okay, i agree there are response speed issues But any reason why i sho…

Hi all, I just encountered something which seems strange. When I use the code [FMP-IF: CurrentToken.eq.Field:ID] everything works fine. However when I use the code [FMP-IF: Field:ID.eq.CurrentToken] it doesn't work? Is there a special reason why this doesn't work? I'm just trying to get a better understanding of CDML-logic. Jos

If I build a web site that will be used around the world, what happens to character typed in other languages and if it is a discussion form how can I get the replies to appear in the proper characters?

I use CDML to develop FileMaker driven websites. What are the advantages or disadvantages of using Lasso vs. CDML? Thanks.

Hi In my website I want to be able to add a link that allows the user to step through each record in a _found_ set (like the flip folder on the left in FileMaker). I've tried using <a href="FMPro?-DB=jobs.fp5&-Format=jobdetail.htm&-Skip=1&-Max=1&-Find">Next Record</a>

Does anyone has experience with creating custom types?

I am trying to put database name, layout name and some of the field names into the variables in Lasso. I am accessing a certain layout in a certain database: [inline: -database='Customers', -layout='Form', -show] [Variable_Set:'database'=(Database_Name)] [Variable_Set:'layout'=(Layout_Name)] [Variable_Set:'FirstName'=(Field_Name:'1')] [Variable_Set:'LastName'=(Field_Name:'2')] [/inline] When I specify Layout name inside Inline, the number parameter represents the order of the fields on a layout. This is very inconvinient, because I will have to organaze the layout design around the field's numbering. Without specifying the Layout inside Inline, th…

Hi, I have 3 db's. On main page is a list (overview, organization, etc). From here user clicks on one (we'll use organization - each link is the same format). All is links, no forms: <a href="FMPro?-DB=OPD_OrgMain.fp5&-Format=OrgList.html&-SortField=Organization&-FindAll">Organizational Listings</a></td> clicking on this displays all the organizations which has a similar link which displays all departments within each organization. On the departments page I want them to click on a department and see all the people associated with that deparment. <a href="FMPro?-DB=OPD_OrgInst.fp5&-lay=List&-Format=Org_Inst.ht…

I have looked everywhere I can think of (filemaker.com, search engines, forums, 404lab.com). Isn't there a way to get the Web Companion to display a custom web page when a user requests a page that is not there (like other web servers do)? I thought maybe /Error/FileNotFound.htm would work, but it doesn't. I thought maybe an ErrorDocument directive in an .htaccess file would work, but Mac OSX will not allow files that begin with a dot. HELP!

Help! I have been puttering along on a little database that I use personally to track my work experience (in hours) as it relates to my professional registraion. As far as I know I am the only person to create a database for this particular process, but there are over 2000 other people like me that all track the same experience. I showed my database to a guy who really liked it, and he told a friend, and he told a friend... All of a sudden, there is an interest from the registration board in putting my database on the web so that all 2000+ interns across the country can record their work experience online. I've never used FMP to post databases to the web, and certai…

Hi I have a portal and some fields with popup menus inside it. One of the popups shows the result of an inlineaction find request. The problem is that this inline request is running for each portal row and is slowing down the machine . I guess I need some help with Java here... How can I store an Inline results in a variable and then use this variable in the popup menu? The inline code is : [FMP-InlineAction:-db=reservations.fp5,-lay=Webmain,User1_user2={fmp-currenttoken},-max=all,-find] [FMP-Record] <option value="[fmp-field:id]"> [Fmp-field:id] - [fmp-field:project]</option> [/FMP-Record] [/FMP-InlineAction] Tnx

Can anyone advise on the correct syntax to set a token to the currentrecID? I've tried the following without success.... [FMP-SetCookie:CookieName=[FMP-CurrentRecID]] [FMP-SetCookie:CookieName=FMP-CurrentRecID] [FMP-SetCookie:CookieName=CurrentRecID] Thanks

My clients upload photos to my server through the FileMaker database. Actually, this is not really correct. They place an order through the FileMaker database on the web. After the order is placed, they are then taken to another cgi page where they can then upload the photo (If they could upload photos through FM then I would not have the following problem). Unfortunately this process takes them out of the FileMaker database. If the client then wants to place another order and upload a photo, they have to sign in to the database again. I have tried cookies in the past that would allow them to click a button that takes them back to their home page, but if the client has co…

If I use this sample code in any FMP page the url is substituded with the FMP url that built the page. Does anyone have a suggestion. <a href="#" onclick="javascript:window.open('HTTP://www.google.ca', 'none', 'width=400,height=400');">TEST</a>

Hello ANYBODY and ALL, In our office we use FMP6Unl to host our Intranet site (used for sales). I use the clientIP tag to destinguish wich AccountManager scored an order. This works fine for a while (5-10 minutes), but after a while the ClientIP does not show the users IPAddress anymore, but instead the gateway address. (using IE6 with latest SP and WinXP/2000). Does anybody have any ideas? Please help a disturbed world citizen. Dustin

Hi all, I have looked at previous threads on this same issue but did not see much of a resolution to the issue. One of my database tables starts to return an error of "Database 'xxxxx.fp5' is not open" when being accessed through the Web Companion. These are the facts which make this rather peculiar: -The database table IS open, running on FM6 Unlimited -None of the other 20+ tables, which run concurrently, have this issue. -It seems to happen infrequently after the FM client has been running for long periods of time. -Closing the table and reopening it seems to resolve the issue. Could this have something to do with data corruption, or password …

Hi, folks! I made a form in which users submit dates et. al. via the web. I was confused when I saw the year showing up as 1903 for data submitted while my FileMaker creation/modification dates were showing 2003. After a little searching, I found this 2000 / 2001 thread mentioning something similar. Garry mentions JavaScript for his solution, but on a scale of 0-10, I am a 0.01 wrt JS -- even toward understanding his script. A search at FMP, Inc. website told me (although I missed it the first time around but caught it on a web page find) that FMP's "two-digit year date Interpretation Algorithm" only works within FMP itself and not for Web Companion (article below).…

I have a search page that the user gets to via an FMP-view URL From the DB which contains some image records I would like to pull and image from the relationship that short list all the images. -Since I get to the page via FMP-view I assumed that an Inline request is required. -The image is a url path -The path comes from a relationship. Between the InLine I have tried a straight field [FMP-Field: Name] and no problem. But when I try [FMP-Field: Relationship::Image,raw] and other variations, no luck. Here is my string: [FMP-InlineAction: -db={CurrentDatabase}, -lay={CurrentLayout}, _snA=646, -find]<img src="[FMP-Field: Relatioinshi…

Hi... I need help with the following.... My database consists of Carbrands and Types. In FMpro I have made an pop-up list for the Type field which only shows the corresponding Types based on the chosen Brand in the first field. (determined by relationship) I don't know how to make this happen in CDML. I suppose I have to submit a value to fill in the Brand field. so if anyone can help me with providing me with this "TAG" or an link to a site with such an example. I'd really appreciate it. Thanks Tianshi

I have a simple HTML form that I want to populate a .fp5 form. So far, I am able to make it work with only regular field names such as firstName and lastName. On my FM5.5 form I have named the same fields firstName and lastName. When I hit submit I get a

I would like to have my next/prev icons grey out accordingly when I am at the beginning or the end of a found set. I have solved the beginning but how do I tell when I am at the last record? [FMP-If: CurrentRecordNumber .eq. 1 ] 'icon' [/FMP-If]

What is the easiest way to have links for each page of a found set of records...i.e. if there are 100 records found and 20 displayed per page, there would be links like 1 2 3 4 5 that would go to each page of links. There is potential to have 1000's of found records, so ideally if more than 500 or so records it would only show the current 10 pages, and allow shifts to the next or last 10, like <<<<LAST 10 11 12 13 14 15 16 17 18 19 20 NEXT>>>>> Any ideas?

Hello all

Hey All... If you were around on this forum a couple of years ago you might remember a (really long) thread about FileMaker web security issues. Well, since then, I haven't posted here and I'm glad (or not) to say that nothing has changed! The issues still haven't been resolved and I'm still working on ways to make the Web Security / CDML experience easier. So.. I give you: D-Base 1.4 (for Mac, Mac OS X and Windows) It's a tool to let you remotely see your database names, layouts, scripts and fields. It basically shows you how venerable your hosted databases are. For this version, I wrote in a facility for drag-and-drop CDML. Anyway.. Let me know…

I've tried every solution I can find to get either check boxes or radio buttons working on a record update page using CDML but nothing works. In any case, is there a trick to getting values in a record to display correctly in a record detail page using radio buttons? Also, can I make them update-able? I can get the radio buttons working fine in the new record page but no joy in the update page. I am using a value list. Is it my imagination or does CDML do a fantastic job at text files, pop-ups and text area fields but stinks at radio buttons and checkboxes? Am I to assume that this is a serious flaw with CDML as I have yet to find a workable solution? …

I have created a solution which uses cookies fairly extensively. A typical example is where an order is placed and line items are then added to that order. The cookie is set upon creation of an order and is then used to populate the Order_Number field in the line items file for each subsequent associated line item placed on that order. This works fine for a single user but, of course, the problems begin in a multi-user environment where the following happens..... 1. User 1 places order_no ABC (cookie set to ABC). 2. Prior to user 1 picking a line item user 2 places an order_no DEF (Cookie becomes DEF). 3. User 1 then picks line items however as cookie is …

Have used inlineaction successfully in the past however, despite staring at the following code for 2 days I'm still no closer to figuring out why it only shows and empty drop down. I'm sure it's something simple that I've forgotten and having repeatedly ensured all names were typed correctly would be grateful for any advice. <select name="product_ID"> [FMP-inlineaction:-db=Graphics_Material.fp5, -lay=web, -max=all, -findall] [FMP-Record] <option value ="[FMP-field:Material_Code]">[FMP- Field:Material_Description] [/FMP-Record] [/FMP-InLineAction] </select> NB: Product_ID is the field to be populated upon c…

hi everybody I want to have the navigation buttons code in a text file in the "includes" folder. Seems easy but when I'm testing the html-text doesn't get included. In the browser it looks like this: [FMP-Include: includes/prod_Nav_left.txt]. An older project that has exactly the same syntax works perfectly in the same test environment. Anybody got an idea? kind regards PJ Wassermann

I have a simple HTML form that I want to populate a .fp5 form. So far, I am able to make it work with only regular field names such as firstName and lastName. On my FM5.5 form I have named the same fields firstName and lastName. When I hit submit I get a

hi there Golive 6.0 (Mac OS 9.22) keeps destroying my code. When there's a form tag it keeps inserting a form end tag right after my commands although there is a form end tag further down. Cornered brackets (sorry, I don't know the English term) get replaced by different code when they're within quotation marks. I like to have all my <input type ="hidden"....> neatly sorted for a better overview and when I come back to source code mode form layout mode it's all in a mess. Does anybody have a hint on this? Thanks and kind regards PJ Wassermann

Does CDML have File functionality like the <CFFILE> in coldfusion? I have a page in which I'd like the user to be able to upload and attach a file when they submit the form... is this at all possible? thanks!

I have a field which contains the relative path of a sound's file, called "path_file". I have a field, calculated, with text output, and the format: "ftp://192.168.1.1/"& path_file I have made a button (called "download sound") linked with a script's step "OPEN URL:path_file. I need an instant publishing with Web Companion (I'm not able to use CDML or any other program-language) and I need that when an user click on the button, Web Companion starts to download the file. It works if I access to the published database from the Host, but it doesn't when I access from a client PC's browser. (I get an error: "This link doesn't exists). Is it capable Web Co…

Somebody please help me. I want to password protect the Edit and Delete buttons on a FM4 web/database. When I set up the FM Web Security DB I put in a Username and Password and set the rights to everything, they can do all. If I do this everybody that hits the site is prompted for a Username and Password. If I put in "All Users" in the Web Security DB then nobody gets prompted for a Username and Password, but the Edit and Delete buttons are gone. How do you password protect just the ability to edit or delete a record and allow every body else the ability to browse and search?

Hi! I've seen a lot of questions about the use of URL's to access FMPro DB, but I wonder about something. If I have a DB at the following location: C:program filesdbmybase.fp5 and my web pages is in the FilemakerWeb folder how will the URL look: http://localhost/FMPro?-db=:?&-lay=layout&-format=search.htm&-view Ingar

Hi, I want to send my form outside of the filemaker web folder? Is it possible? My form contains some fields and action is new record and run script. Thanks

many thanks to this forum for helping me build my business information management tool. Although it is not finished i (an above all the clients) are please with it. Now could use some advice on using the access.log file. I want to trace everything that is done by users with the database (because of accountance certificate). Switching on the logging would do the trick because every submit is stored in access.log ( i have not tested this but i suppose it) However, i have the feeling that this log file will increase rappidly. when i run my app on a OS X server, i their i change that i will run into file limitations. Should i internediatly backup the log file a…

This has been driving me nuts and my client needs it solved now. So it goes to you guru's now You would think this is simple, but noooooo.... I have a format file used to find items. Works great, can find item by ID num, or by name. But there also is a value list that shows catagories. I want to be able to select a catagory from the VL and get all the items in that catagory. The problem is the catagory names overlap. Example; there are catagories with the names "red", "red dots", "blue", "blue small", "blue large" and so on. A find for catagory of "red" using the value list gives me the items in both catagories, "red" and "red dots". How can I …

Hi! Have the following sollution in FMP: calendar.fp5: Fields: date, name, time, NameID users.fp5: Fields: NameID, name, department NameID related to NameID, relationship is named Users. In calendar.fp5 I have a layout (list) with: date, time, name, nameID, users::department In Web companion i have an index.htm redirecting to: <a href="http://localhost/FMPro?-db=calendar.fp5&-lay=list&-format=search.htm&-findall"> In the search.htm i use this code: <HTML> <HEAD> <TITLE>Search</TITLE> </HEAD> <BODY> <H2>Title</H2> <FORM ACTION="FMPro" METHOD="post">…

Hello All, [color:"red"] [color:"blue"] We are developing an web interface for our own administration an now we came up with the following problem: We made one Database file called relations.fp5 where there is various information on the client who is subject to this record. In this Database file we refer to another Database file ( we made a relational database system) called contacts.fp5 where the user is able to select various contact persons that in this case is related to the company name. We seem to be able to display the requested data in that particular record but are not able to create / edit these fields So, we can display the reco…

Here goes.. I would like to get XML data into FileMaker by writing an XML FileMaker Gateway in PHP. The idea is that external apps will only have to call my URI & post the XML. I will then parse it into CDML format and post it using PHP and a Templating system. I would like to ensure the Gateway, how it is called and how it is secured all abide by the REST Architecture Style so that all interworkings and interfaces are future proof. Has anyone done this and documented it yet? Does anyone have any incisive advice? Does anyone have any 'make my life easier' sample code? Fingers crossed, Joseppic.

I am having some difficulties with files open via web companion dropping off the web. It appears that the files drop off the web when a web client aborts a search (like if the return is taking too long). I am using FM Unlimited 6 Version 6.0v4 on Windows 2000; it's a recent install. I looked for updaters on the Filemaker site but the Web Companion updaters stop at v5.5. Is there any way to determine what version of Web Companion is running? thanks

Hello! I'm trying to build a web page with access to a Filemaker database. I use the Web security database with a Field restriction and Exact search option. I have used All users and no password. The Web security record is provided with the admin password of the DB. When I do a search on the Web site and the Exact search criteria is not true then I want to have an error page as an result ( This works fine if I don't use the Exact search option). Instead I get a Connect to "host" box in the browser asking for User name and Password. Then I have to use Cancel to return to the search page. I think the trouble is that I use a combination of Web security and FmP…

hi, i want to make a page that includes membership. Is it poosible to log off user if the user don't click any link in 30 min.? thanks

I was trying to refine my database and ran into some kind of blind spot that I hope someone can illuminate. In the detail view of a found record, there had been a thumbnail that was also a link to an optional larger view of the image. Original code: <A HREF="[FMP-linkrecid: layout=dataentry, format=MMZWEB/MMZdetaillarge.html]" target="_blank"> <img src="[FMP-Field: photothumb]" border="0"></A> But I wanted to try having some alternate text appear if there was no image, so I created the whole line through a calculation in the DB. (If photo name field is blank, code is replaced by "Image to come" text.) Then I got a message that "thi…

Hi, I'm drawing a blank here, so can anyone post code for editing a portal record? I have a search button that searches a contact database containing a portal and returns the results (names) to a format page. This works well. What I can't get to happen is for the person's name link to go to an edit page. If I use -RecID, then I get the record holding the portal. How can I get the record ID of the portal record? Thanks!

Hi I thought that to cdml files in the CDML_FORMAT_FILES directory it is not possible to see their code, but when I do "view source" in iexplorer it shows me the whole code..... Am I missing something here?

Hi All, I have a Ticketing DB and users are able to add new tickets to the DB via the web. I have this working in a basic form. The user enters data into fields and this is added as a new ticket using the -New tag. I would like to add the following functions: - Selecting a template for the new ticket (pre-written words for certain fields) from a Templates DB. - Selecting a specific user to be entered into the new ticket from a USERS DB. This is my plan of attack, described in pages: 1) Select the Template from DDBox 2) Create a New Ticket entering template field info (hidden page) 3) Select user inital from DDBox to search Users DB 4) Selec…

I searched the forums and I'm sure I saw something about searching a database located on a different server, but can't seem to find it now. Therefore, does anyone know if this is possible? If so how? Right now I am trying the following to no avail. [FMP-InlineAction: -db=http://64.182.74.101:591/Clients_NY_.fp5, -lay=Table, -Max=All, -FindAll] [FMP-Record]

Ok Two questions the first to do with drop down list boxes: In filemaker you can create a value list with two values in it e.g. an Id and the name of the person it is assoicated to. How can this be accomplished in cdml?? I have managed to do it but it involved populating javascript arrays and then the list box is there an easier way. Second question I am trying to create a form to insert a new record via portal (so it assoicates but I keep getting a 102 error (fields missing) do I have to have all of the fields that are in my layout in the form??? Thanks for youe help D

We have several FMP 6 databases hosted with Point In Space which are accessible on the web via Lasso 5. They have set a master username and password for us to use in Lasso Security, which we can use to query the databases and output the results to web. However, so far we have mainly been using text fields and some value lists. We recently tried to serve up an image from a container, only to find it generates a login dialog (all other text field queries do not). We are using LassoScript and setting a variable to Image_URL with an Inline search block. The query itself works - it returns a path back, a unique identifier id and so forth - but it is this re…

Hi All, I simple question, I hope. I have database of meeting minutes which a user can view over the Web. I would like to be able to allow team members to be able to email the minutes to others. Everything works great until the email is sent. The email contains all the fields that are in the database being queried but none of the portal informaion. Here is the code of the format file. FORMAT FILE - meeting_minutes.txt Project: [FMP-CurrentToken:4] Project #: [FMP-CurrentToken:3] Date: [FMP-FIELD:MeetingDate] Prepared by: [FMP-FIELD:By] ------ Attendees: [FMP-CurrentToken:2] [FMP-Field:Attendees] SKAGGS [FMP-Field:OtherAtte…

Hi All! Thanks to this list and Garry, my online registration can now verify if a class is full. However, I have a new problem now. If the class is full, the alert message pops up. If you click OK it returns you to the same screen. Great, wonderful, no problem there. The problem: If the class isn't full.....now, it doesn't want to go on to the next screen which is a "login" screen. I get the error message: Unexpected error. Unable to process your request because the server encountered an unexpected condition. For more detail on error #4....... We all know that error #4 is "Command is unknown" error. Here's my code. Any suggestions…

What I'm trying to do is this: Have a widget field that the user will enter the widget to be found. Have two buttons, one to find the widgets in db1 and one to find the widgets in db2. Would like to look like this: widget search field | db1 button | db2 button I'm unclear on how to search multiple databases with CDML. Also is it possible to have one button that searches both db's? Thanks, r

I have field on a web page called country. I would like to populate it with a value list from filemaker pro unlimited 6. The code I am using is below. Any help on what I am doing wrong and how to fix it would be appreciated. Thanks <select name="Country"> <option value="">- No Selection - [Value_List: 'Country']</option> <option value="[Value_ListItem]">[Value_ListItem]</option>[/Value_List] </select>