Other Internet Technologies

Help, I am submitting any date as xx/xx/02 and the results are returning as xx/xx/1902. The field is a date field and it has no validations. This only happens when I am submitting across the web. Inside the database this problem does not exist. Are there any special rules or tricks I should know about using date field with Web Companion or CDML?

Hi All, I am beginning to think that the problem I am having with the format file is the syntax for getting the portal row information into the text file. Can someone post an example so I can check? Thanks! -Skuli

Hello again.......please have pity.......I'm still very, very new to JS. What I want is this........I have performed a search on a continuing education db and returned a list of classes. Some of the classes still have space in them but some don't. I then click on a "More Information" button (a link to the record) to see information about the class like time, date, credit or not, etc. Then I have a submit button for them to "register" for this class. I want to prevent them from registering for a class that is already full. The field is on the page. I can pass it in a token - no problem. I'm in the right database to check this field. And the field is defini…

I have a webpage with form that searches FM database of 59 records. It finds searched records by supplied criteria in FileMaker very quick but it takes long to display a response page and in the end it returnes an error page with error -9995 'Out Of Memory'. What could be the reason? Thank you.

Hi I there anything wrong with "[FMP-VALUELIST: digital_line, LIST=alt_255] <INPUT TYPE=checkbox NAME="digital_line" VALUE="[FMP-ValueListItem]">[FMP-VALUELISTITEM: Always, HTML] [/FMP-VALUELIST]" Because it will not show me anything except an empty check box, even if it has a value. The alt_255 list has only one value. The field is on the layout. Tnx

Hi I have a situation where I want to set a field in a record to that of a value held in a cookie. I would normally do this using edit & currentrecid however as the value held in the cookie has been obtained through a series of steps using separate databases currentrecid is no longer Pertinent. I do however have an additional cookie, which holds a value unique to the record I wish to update. Is it possible to use this rather than currentrecid? Iain

Suddenly my PS 9.2 FM 5.5 server gives me (sometimes) this message. HTTP/1.1 200 OK Date: Mon, 04 Aug 2003 10:05:26 GMT Server: FileMakerPro/5.5v1 Dev WebCompanion/5.5v4 MIME-Version: 1.0 Transfer-Encoding: chunked Content-Type: text/html 1576 What does it mean Thanks Jitse

Hi I have the following link : "http://fmp:591/FMPro?-db=web_reservation_form.fp5&-format=testres_form_cancel.htm&-lay=web&-recid=[fmp-field:view_reservations::rec_id]&-token=[fmp-currentrecid]&reservation_id='Cancel'&-edit" The DB is sharable and without any passwords. BUT, when I press the link I get "Access restriction" because of the "-edit". Any ideas ??

Hi I have a link in my page. the code is : "http://fmp:591/FMPro?-db=web_reservation_form.fp5&-format=testres_form_change.htm&-lay=web&reservation_id=[fmp-field:view_reservations::reservation_id]&-find" and for some strange reason the "reservation_id=[fmp-field:view_reservations::reservation_id]" part is displayed exactly as it shows in the code, that means that FMP skipd this part and will not show the content of =[fmp-field:view_reservations::reservation_id] What could be the problem ?? (the field is on the web layout...] Ok, I found the problem : I am using dreamweaver, and when editing a link through it's GUI windows then…

Hi, I'm completely new to CDML and have a few very basic questions. Here is what I am working on: I have a single file database and have been asked to create an online read-only report. The database is very simple, and the query will be the same except for the users name. I have been given an HTML template entrance page with 30 buttons on it with a users name on each button. They want to be able to click the name and be taken to the report with their data displayed. I need to know how to properly setup the files, or at least a nudge in the right direction and I'll come back if I have further questions. Here is what I would like to do, but do…

HI I have applicaion to access two databases, One related to the other. I defined relationship to delete related record if the master one is deleted. I found when I delete the master record from the web, the related records are not deleted with it. Any ideas? Thanks.

Hi there, Sorry for this. I'm very new to filemaker. I just start using it. I came upon a problem displaying the value list (that I have defined in FM) on the web page. The CDML code I have is: <SELECT NAME='classname' SIZE=1 > <OPTION VALUE=""> [FMP-VALUELIST: classname, LIST=name] <option [FMP-ValueListItem]> [FMP-VALUELISTITEM] [/FMP-VALUELIST] </SELECT> It does have a drop down menu but inside the menu it display [FMP-VALUELIST: classname, LIST=name] and [FMP-ValueListItem]> [FMP-VALUELISTITEM] Am I missing something? Thanks for all your help.

Hi, Is there a limitation with folder stucture in FMPro 6 with WSC using CDML custom pages? I'm asking this because I can't see a logical explanation to the problem I have. I'm moving a set of Web sites from WebSTAR + FMPro 5 WSC under Mac OS 9 to Apache + FMPro 6 WSC under Mac OS X Server. When I call a page located at /group/db/press/FMPro I have an Apache 404 error. When I move the page up a level (/group/db/FMPro) it works, the page shows up correctly. File and folder privileges are correct. I have developped many Web sites these last years with the aforementioned configuration and I've never encountered that kind of problem; I was able to u…

Hi! I need to write a cookie but I do not know how to write it. Does anyone know of an online tutorial or something like that? I use FM4 and web companion (CDML). Thanks

[color:"blue"] Hi! Does anyone know if there is a way to customize the FileMaker error message that appears when a database is needed and it is not open? Any type of customized message would be useful, either an htm created by myself or modifying the FM response directly. Thanks!

I have several databases up and running fine, however I have one that prompts me for the username and password to connect to the server. I click on "Submit" to enter a new record and up this pops. I've checked and double checked the other db's configurations and can find nothing different. Any thoughts on this? R

So i came into bij trouble with iframes (see previous post), spend to much time in trouble shooting. I still nee to create multiple records in one instance, so i need frames I know some of you disagree with frames. Anyway, for those of you that consider this is some sample code (any improvement comments are welcome because i am sure no expert) <FRAMESET ROWS="250,*" FRAMEBORDER="0" border="0" framespacing="0" > <FRAME NAME="onder" SRC="onder.htm" NORESIZE SCROLLING="no"> <FRAME NAME="boven" SRC="FMPro?-DB=test.fp5&-lay=L1&-Format=boven.htm&-Error=boven.htm&-Token.0=6969&veld=1&-Find" NORESIZE SCROLLING="no"> <…

Thanks to gary i have been able to set up a HTML using iframe to create multiple records in one instance. This used to work fine when using the beta release of safari. Now that Apple has upgraded safari for beta to version 1.0, iframes do not appear to work anymore. Three topics i want too raise: 1]Has anyone enccountered problems with FM, CDML, Safari and iframes 2]Are their more generally adapted browsers that do no support iframes 3] in case of yes to Question two is their an easy way round to avoid using iframes but still being able to create multiple records without refreshing the HTML page ? The reason for my question is that i have come a lon…

Ok, I've been hacking at this for a while...and it's very annoying... I've got a simple database I'm trying to have users "login" by verifying they're in the database with 3 pieces of information. Don't get me started about a single unique identifier -- the client wants it this way... FMP will find against any field that's entered, even if the others are empty. So, to try and counter this I turned to JavaScript - at which I'm admittedly a novice...so I searched the web and webmonkey had a script that seemed to do the trick... Then, getting the form to work with the WebCompanion properly is now my problem. I've seen 2 references to making…

I have a link to a format page: FMPro?-db=Inventory&-lay=Detail&-format=search.html&-view On the format page "search.html", I have a form to query the database. I want to add a RANDOM record from a different database on the same format page "search.html" so I put an FMP-InlineAction code, but no data is displaying on the page. [FMP-InlineAction: -DB=Specials, -findany] On special this week! Manufacturer: [FMP-Field:Mfr] Model: [FMP-Field:Model] Our Price: [FMP-Field:Our Price] [/FMP-InlineAction] This code is placed after the form to query the Inventory database. Can anyone tell me what I am doing wrong and if it is possible to do t…

Hi, I'm working on a project where a search is done on a field that has a lot of spaces, multiple words, etc (it's scientific stuff). I can put on the web page to enter the search string surrounded by asterisk and quotations, *"Alpha" as an example, which will find AlphaOmega, Alpha Omega, Omega (Alpha), BetaAlpha, etc. but is there a way I can do this without the user having to do it? R

Anyone know if it's possible to pass a list of all open databases to a web page via CDML? I'd like to be able to view the status of FMPU and all open databases remotely via html. It seems like it should be possible but I can't find any reference here to anyone trying to do this before, but since IWP can show you all the open databses it seems CWP should be able to as well. I could be wrong, though, because if it was possible then the web pages that come with the Web Security database would contain a drop-down list of databases to edit the permissions on and I wouldn't have to type in the database name every time! Any helpful insight is apprciated.

I am trying to web enable our databases, but I have come across a large problem. The databases have been in existence for about 5 years and as such are large and sometimes a little awkward. I have created new layouts that display just those fields that I am referencing from the web, yet some of the fields [color:"purple"] [color:"black"] will not render their results to the web. I can create another field with a slightly different name, but the exact same properties and place it in my CDML and it works fine, yet the original field will not, its location on the web page just remains blank. Is there anyway to fix this or am I going to have to create …

Hi, folks! I am starting to use the -mailto et. al. tags in a sample db and am encountering an unusual phenomenon: My to/from/subject headers end up all in lowercase while my -mailformat page info shows MixedCase as I intended. Everything's working, but the case conversion seems weird to me. Has anyone else experienced this and know how to fix it? _______FMP-Unlimited 5.5 on Mac OS X _______testbase.fp5, smtp=smtp.mydomain.com _______dataentry.html > confirmandmail.html > thanx.html Data entered in mixed case on web form. Data displayed in mixed case on confirm page (also has hard-coded -mail tags); user presses CONFIRM (CurrentRecID, -find) butto…

Just because i think that Flash makes pretty good looking interface, and is pretty uncrashable... I m trying to get access to a Filemaker pro database from a swf... (macromedia flash animation) If anybody has ever done it before, i would be glad to share info... It feels like i should try to understand the CDML usage but i have never heard of this...

Hello, I really need some assistance with a search problem. I have a text field the user uses to search from a specific field only. I only want the result to be "Equal". The only method that I can get to work is by using options pop-up, to me this looks to amateur. I would like to have the "Equal" value hidden. I've searched the forum and tried different things ( <input TYPE="hidden" NAME="-op" VALUE="eq"> or <input TYPE="hidden" NAME="-op" VALUE="="> and <input TYPE="hidden" NAME="-op" VALUE="==">) which none have worked. Here is what I currently have <form action="/FMPro" method="post"> <SELECT NAME="-op"> <OPTION SELECTED&…

does anyone know what the Lasso Pro 6 command is that is equivalent to FMP-currenttoken? Any help or ideas would be appreciated. Thanks

When I return a search result, I often use [FMP-LinkRecID] on each record returned to provide a link to a more detailed page of the record. However what I find cumbersome is having to go back to the list and click on the next item in the list. What I want is a link in the detailed page that goes to the next record in the list that they found based on their search. I tried [FMP-LinkNext] but obviously this only works when a find is returned and many records are found. How can I create a "Link to the next record in the found list" when in a format page of an [FMP-LinkRecID] Thanks.

I want to display an image from a related record on my web page, I have the related field on the correct layout and yet I get a broken image icon in my browser? I have tried a test image in the parent database and it works fine, what am i doing wrong? this is my code, [color:"blue"] <IMG SRC="[FMP-Image:Photos_NS1::Photo]" WIDTH="69" HEIGHT="52">

I saw Garrys solution to searching multiple fields but can't seem to get it working. I have began fiddeling on my own solution (a bit smilar to Garrys perhaps) but have come to a dead end. It basically has to do with handling of characters in javascript. I thought of creating two fields on my search page: one main field and one field which connects to a related database. The related field is to be updated automatically with the contents entered in the main field. When a user submits the search the two fields are searched. Here is the javascript I found on the web: <script language="JavaScript"><!-- function copyData(from,to) { to.value = from.val…

I am new at Lasso and have been getting an error that says action.lasso was not found. Here is some of my code: <FORM ACTION='action.lasso' METHOD=POST name=searchform> <H1><FONT FACE="Arial"><INPUT TYPE="hidden" NAME="-Database" VALUE="App_Pict_Db"><INPUT TYPE="hidden" NAME="-layout" VALUE="Web"><INPUT TYPE="hidden" NAME="-response" VALUE="search_results.lasso"><INPUT TYPE="hidden" NAME="-error" VALUE="search_error.htm"> Any advice or help would truly be appreciated. Thanks

I have been able to get lasso to connect to my database through a web page. However, I keep getting asked for a username and password, but there are no usernames or passwords in lasso. I would like to use the anyuser and just limit them to read since there are going to be many users. There is a password that is required to open the filemaker database. I think I must not have the permissions set correctly in lasso or filemaker, but I am not sure. I also thought it might be that I don't have the lasso filemaker host assigned in the group tab. However, when I click assign nothing happens. Any advice or help would be greatly appreciated. Thanks,

Is there any existing solution to analyse the web log produced by filemaker ? Any solution that automatically allow to publish the statistics online ? (ideally with separate views for each database) Kind regards Mirko Labbri

I have lasso 6 and FMPU 6 setup on OS X.2.6. I have setup lasso and can view my FM database through lasso's browser. However, when I attempt to connect to the database through a webpage I get an error saying that Lasso cannot connect to the database. Can anyone help me? thanks in advance.

To: [email protected] Subject: filemaker and lasso, client wants database on web. clients server does not support filemaker! From: [email protected] (roy tilsley) Newsgroups: comp.databases.filemaker Subject: filemaker and lasso, client wants database on web. clients server does not support filemaker! NNTP-Posting-Host: 68.68.35.105 Message-ID: <[email protected]> filemaker and lasso, client wants database on web. clients server does not support filemaker! I know filemaker and would like to use it for the above client but am afraid of the server limitations when using lasso for my clients and am not very exc…

Hi all, I want to know if anyone has used Ch-Ching!? I'm going to be setting up a shopping cart, and eventually have credit cards processed on-line. This is what I have: FileMaker Server 5 FileMaker Unlimited FileMaker Developer WebStar Lasso Web Data Engine Lasso Studio for GoLive 5 GoLive 5 Thanks for any input, Chris

Hi all, Im new to the forum, however I have been using filemaker 5.5 for over a year. Just recently I installed the newest version on windows server on our fileserver and for some reason I am unable to retrieve database data through my web browser. I keep getting an error code "951 unable to get status". Is there anyone out there who may know what this is about?

Hello, I am hoping someone on this list can provide assistance. I am conducting research on lasso scripts for my organizations webmaster. We would like to sort a course listing webpage (filemaker) by newest to oldest course offerings and am looking for a lasso script that will allow us to do this. Any help would be greatly appreciated. Our page is http://rockteach.org click course search and registration....the database currently lists courses by the order in which they were added to the database. Please feel free to e-mail me at [email protected] or post to the list with any information. Thanks again, Melani

I have inherited a FMP Unlimited project at work and have to solve some problems we are having with it. My number one issue to solve at the moment is improving performance on our (necessarily graphics heavy) site for customers on dial-up connections. To this end I am looking for a way of setting a http expires header on all of the graphics that go into the site. This has to include both the static images on the page, as well as the images from the database. This will allow our customers to cache the images so that they can get around the site better. Anyone have pointers for me?

I am creating a search and results page with GoLive with no success. I am receiving the error message: Attempt to load "Accessing URL: file://localhost/Applications/Filemaker%20Pro%206%20Folder/Web/ FMPro" failed. Does this have something to do with the CGI script? Is it not being sent to Filemaker? I am not very experienced in web site development, if somebody could point out what I am doing wrong, it would be greatly appreciated. I am also working on Mac OSX, so I am aware there may be a conflict between the Filemaker server and Apache web server, as Apache will attempt to override Filemaker. What do I do about this? P.S. I could also paste my …

Hi. I have a problem displaying in the Web Browser images stored in the container field of FileMaker using Lasso. They are JPEGs and I use the following syntax: [image_URL:'Products::SmallImage' ,JPEG]. As you can see, the image itself is in related database and it is displayed as a related field in the database I am trying display it from. Didn't have any problems with it when was using CDML.

In using a -edit form with a submit button, is there a way to include a FMP-If tag so that when the user hits submit, depending on the If statement, they are routed to one of two -format files. For example here is a standard -format use: <INPUT TYPE="hidden" NAME="-format" VALUE="surveystep1.html"> Can it be changed to something like: [FMP-If: answer1 .eq. Yes]<INPUT TYPE="hidden" NAME="-format" VALUE="surveystep1.html"> [FMP-ElseIf: answer1 .neg. Yes]<INPUT TYPE="hidden" NAME="-format" VALUE="surveystep2.html"> [/FMP-If] The logic of this seems right, but I was wondering if anyone had tried anything like it? LR

I have what is probably a VERY dumb question...but, as the name says, I am new to this. I have a search page with a drop down list of dates from which users select to search for information for that date's activities. Each record has about 100 fields in it that need to show. There are about 50 records total. Everything works fine, the user EVENTUALLY gets the results page...HOWEVER, it takes 2 maybe 3 minutes over a fast connection, for the results page to come up. Over dial-up, the user times out. The results page is also an edit page, when the user edits the information and submits it, it goes VERY FAST. Is it slow because 100 fields is too many or is it a proble…

Simple web page with a form and a -new submit button. It links up to my database fine. I hit the submit button and a new record is created just fine. A new -format web page then comes up. This page has a new edit form with a -edit submit button. If I try to fill out any of the fields and hit the submit button, I get the error "The format file "step2.htm" could not be found." Yet the htm file in question is there, where it is supposed to be. I have included the correct items such as -RecID, -lay, -error, -format, -db, So I am not quite sure why I am getting this message. Anyone have any pointers for me? LR

I'm using FM 5.0v1 on macintosh I have the main database open to users group with limited acces (thats working fine) I need to share via web companion to the same users group . The database only shows up in users browser window if the main db is fully open (all access allowed) is this just hard cheese? , does a newer version of fm solve this problem.

========================== FileMaker Pro/Lasso/Web Designer - San Diego, CA Pacific College of Oriental Medicine (PCOM), founded in 1986, is one of the largest and most prominent colleges of Oriental medicine in the U.S. With campuses in San Diego, Chicago and New York, Pacific educates over 1,000 students in Oriental medicine and massage each year. Pacific College has been growing steadily over the last 17 years and continues to grow. We are approximately 90% Mac. PCOM has an immediate opening for a full-time FileMaker Pro, Lasso, and Web Programmer at our San Diego campus. This is an ideal position for someone who has a solid background in database design a…

Hi all, We have a web based survey, using 4 computers setup on a private LAN. One computer is the server (Mac OS-9 with FMP v5 installed) and the other are clients (IBM and Mac's) using Internet Explorer 5 or higher. I have several web pages within the survey that require an FMP script to run when the user clicks the continue button. One of the scripts is used to randomised the participant into a group by copying the value from one field to another and incrementing a global field - the other scripts are used to record the current data and time. The problem....: On day 1 of the survey, we tested the survey and all scripts worked perfectly. On day 2, the rand…

Can I use a replacement tag inside a link tag, like this; <a href="[FMP-Field:MyLinkField]">Click here</a> It doesn't work for me, I have tried using all different encoding types to no avail. Can this be done? If so, How? Thanks Halbj

Working on doing an online survey. I use a CDML link which includes the standard -layout and -find at the end. This takes the user to the survey database file and to layout 1. My web page then has a submit form. The user fills in the 2 fields with questions, and hits the submit button which then creates a new record with their answers. My question is regarding the -lay file that the web browser then goes to after hitting submit. The new -lay file is linked to the new record and is still linked to layout 1, but is there a way to have the new -lay page be linked to a different layout, say layout 2? This way I can have a whole new set of survey questions from layout 2.…

Is it true that a value list based on a field in another file doesn't work in CDML? Anyone find a way around it? I have a "code" value list that is used to fill in three fields with "theme," "story" and "subfocus." When you change the code from the Web, however, only the first field is changed. I tried creating three calculation fields to match the "code" field, and used them in three separate relationships for each of the fields. Changing the "code" field causes all three matching fields to be altered, but again, only the "theme" field is filled in correctly. The other two retain their old values. Seems very odd. If anyone else has come up with a workarou…

Hi ganag! U just wanted to "take a post" and thank you all for being patient and so helful in the last few months. You have educated me and opened a whole antoher world of design, programming and database conecpts. Wihtout pointing out any names....I just wanted to THANK YOU! All the best!

I have a boxed, unregistered, unused FilemakerPro v5 Unlimited available if anyone is interested!

I would like to set up my site so that one may first choose a division from a value list (ex, piano repertoire), then be able to a) search for either composer or title in that division, or : view all piano repertoire records. I have set the value list selection as the token: <select name="-token"> <option value="Piano Repertoire">Piano Repertoire <option value="Piano Methods and Supplementals">Piano Methods and Supplementals <option value="Piano Technique">Piano Technique <option value="Jazz, Pop and Rock Piano Music">Jazz, Pop and Rock Piano Music <option value="theory">Theory, Ear Training and Sight…

Hi First post so please be kind... (!) I am currently hammering through Filemaker Pro 6 Web Development in conjunction with a live project (I am a fool to myself). My background is the web side rather than Filemaker and I am using my experience with Javascript & HTML to beef up what I can achieve with CDML. I may be going about this completely the wrong way, so please step in at any time... I need to set a 'month start date' and 'month finish date' for a calendar using a calculated result (from a javascript) and an inline... phew! This is what I have placed in the body of the html file: <script language="JavaScript"> document.w…

I'm trying to do a simple search on 2 fields, cc & Unit #, and I get a Javascript error that says check out Status(CurrentError) 4, when I click on the link. I am trying to bring up a detail page from a list of records by populating my link with the Unit # of the part. Here's my link in the template: <a href=FMPro?-DB=InventoryDatabase.fp5& -Format=WBDetails.htm&cc=476252R378&-Unit#=[FMP-FIELD: Unit#]&-Error=WBError.htm&-Find>Details</a> Here's how it comes back populated by web companion: <a href=FMPro?-DB=InventoryDatabase.fp5& -Format=WBDetails.htm&cc=476252R378&-Unit#=BR4778&-Error=WBError.htm&a…

Hi. I have a web page where I'm trying to use [FMP-Include: header.htm] (Data returned here) [FMP-Include: footer.htm] But they don't pull up the HTML, just the code itself. Is there a special trick to using FMP-Include? I really don't want to hard-code the header and footer into every file, but right now it looks like I'll have to. I did put all the top HTML code in header.htm, including <html> and all the bottom HTML code in footer.htm, including </html>. Is that wrong? Or is there someplace on the FMP server where FMP-Include has to be turned on? A Google search for [FMP-Include finds a lot of sites with broken code. Any …

Hello, I have an Add format file into which people type their personal info and submit it to a database. There is a text field for an email address included in the form. I would like to be able to add this address to the database and have an email automatically sent to that address when the submit button for the add form is clicked. I have consulted the CDML reference and can not see how to have the email text field act as a -Mailto form and a form that adds the email to the database field at the same time. Is this possible? I have tried incuding the -Mailto function as a hidden item and included [FMP-field: Email] as the email address but I think the problem i…

I want to let users edit and delete only their own records. Can someone tell me how? I saw similar qestions a while ago but could not find the thread any more.

I have a form action which creates a record in a file and returns to a page. On that page is an inline action to send an email. I am using an inline to allow it to grab the email address of the record that was just created which is a calculation. The problem is in the email that is recieved. When ever I try to add more than a line of text or any fields from the record it doesn't send. I have used the -mailto function many times with hard coded email addresses and never had this problem. Is the inline not finding the record to pull info from? It must be finding the correct record because it is sending to the correct address. Here is the inline. <P>[FMP-I…

I have a popup list created using a value list of dates in my database. Using CDML, I created a search page that contains this list, and I want the popup to appear with a date that I have set in a Global field by default. For example, when I set the date to 7/1/03 in my global date field, and the search page is accessed via the web, I want my date popup to show: 6/1/03 - 7/1/03 8/1/03 9/1/03 etc.... The user can select another date if they wish, or simply accept the default when submitting their search. Any ideas how to accomplish??

Hi I have a web page with a link to delet a record. The problem is that most of the time it is working, but sometime it sais that "the record was not found" although it is ( i trippled checked it)... <FORM ACTION="FMPro" METHOD="POST"> <P><INPUT TYPE="hidden" NAME="-DB" VALUE="web users"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="WebMain"> <INPUT TYPE="hidden" NAME="-recid" VALUE="[fmp-currentrecid]"><INPUT TYPE="hidden" NAME="-Token" VALUE="[FMP-CurrentRecID]"><BR> [/FMP-IF][FMP-IF: reservations_history::released.eq. Y] <<META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859…

I have an html page that has an inline action in it. I then have a link for each of the records in the inline action to delete the record using the records' -RecID. The -format is the current page the inline action is in. The thing that I notice is that when I try to delete the record, the record actually gets deleted but the record is still shown in the html page. However when I create a new record and the format page is the current page as well (since it contains the inline that displays the record), the html page actually shows newly added record. Does anyone know as to why when deleting a record, the page doesn't seem to refresh with the proper content? It…

If I set a Token to some field value, can that token be passed to the format page of the form which will then be used to set the value of a different field. i.e. In form A, the token is set to the value of [fmp-field B] and when the form is submitted and goes to the format page, I want to use the token that I set from the first page that contains form A to set the value of a form field found in the format page. Thanks.

I have many clients who access the database through the web by signing in with last name and their password. It works for everyone except one client who is using Windows 98 2nd Edition. They get the following message when they try to sign in:

CDML doesn't do nested portals, right? Like: [FMP-portal:P1] [FMP-field:P1::fieldp1] [FMP-portal:P2] [FMP-field:P2::fieldp2] [/FMP-portal] [/FMP-portal] ... or is there something special needed? Thank you. Bradley

This is driving me crazy, It's great that a user can't see someone elses records however it's no so good that their valuable screen space is taken up by <No Access> messages. How can I suppress these records. Thanks in advanced.

To start a web session I use a redirect page. Other then using frames can I have the string hidden like it is hidden when you submit a form with method 'post'

I am using custom web publishing and I am looking for a way to track each time a record is accessed in my database. From these statistics a top list of the most viewed records is to be created. I was thinking of a field for each record containing the number of times it has been accessed. Creating the top list would then not be a problem. Anyone got any hints how to solve the tracking problem? All help appreciated. Thanks, Kevin

I have a results page which also has a form on it to create a record in another file. Everything works fine except I want to place a value list on a field which is conditional based on a relationship from the original queried file to another file. If I hard code the names into a value list everything is fine it seems it doesn't like the conditional part. Any ideas?

I can do a search on a user id, but can I do a search on multiplule id's at once? Same with dates.

OK, I've looked @ all the email questions. My delima is, I have a form which ask for email address and when the submite button is clicked I want it to send an email to the person that filled the form out. I found one item here that used a re-direct, <META HTTP-EQUIV="refresh" content = " 3; URL=FMPro?-db=uwprojcare.fp5&-lay=layout#1&-format=reply.htm&-mailto=[FMP-field:NotesName]&-mailfrom=UW&-mailsub=Thanks&[email protected]&-mailformat=mail.txt&-recid=[FMP-Currentrecid]&-Find">. When I try this I get an error code 4, which means "Command is unknown". I'm lost, can anyone help me? thanks David

I have a search results page that is formatted as a detail page - ie the search is canned and will find only one record. On this results page I have 3 portals for relationships as follows; 1. DB1 - DB2 2. DB1 - DB2 3. DB1 - DB3 Relationship 1 and 2 are to the same file but ref different fields. Relationship 3 is to a third database. The problem I am getting is that, if there is 1 related record for relation ship 1, and 2 for relationship 2, only 1 of the records in relationship 2 will display. In other words, relationship two will only display portal rows for records that relationship 1 has. I could split Database 2 into 2 databses but would …

So I have Mac OS X server, on 2 machines, one is the web server with lasso 6 pro, the other the FMP host configured for sharing port 591, memory cache moved to 1000 and web companion enabled. When I add host in lasso, it will go for about 2 minutes thinking and finally accepts that there is a server with FMP on the IP address and port, but then I go to look at FMP on the other computer and the mouse icon just spins and spins it is still spinning and I will have to force quit again. Help por favor.

I have two files: Accounts and contacts. I would like to have one search form to keep things clean. Has anyone seen a solution where a popup of 'company or last name' would direct the search string to the proper field to query and the proper format file?

OK, who can help me out on this one please! Using: CDML FMU 6 W2K I have a record_detail.htm page. This page contains radio buttons amongst other things. The page works fine - someone does a search, results page shows, user clicks on a result, it brings up the page and all details can be seen. Now I have put this page into a framset. Still works, user searches etc etc the record_detail page shows all the information, but the radio buttons are blank, I checked the DB and the radio buttons are still selected, but are not showing on the web page. As I said, it shows when I open it in a normal page, but not in a frameset. I am sure this was working a…

I have a string to find a list of records for a specified date. How could I create a next and previous date button after to found set is displayed?

Hello....after a brief hiatus (doing my real job) I am back trying to get a Registration solution to work. Background: I have three database (these were all written back in 1996 and not by me) The first db called CE_Events lists all of the offerings we will give in Continuing Education and Training next year. The second db called Personal lists all of the clients we work with. The third db called CE_Registrations registers those clients for the CE_Events. Our events are closed to the general public and are offered only to a select group of individuals based on their affiliation with an organization. Scenario: I have a webpage that l…

Here's a dumb question..... Can you use instant web publishing and custom web publishing at the same time? I'm having a mental block here.......thanks! Donna

Hi I'm having a couple of problems with sending emails from the web companion - the email are sending fine but if there is an ampersand in any of the fields it displays as &#38; - I know this is because it's a special character, but I'd like to elinate them. Does anyone have any ideas? One solution I had was to use a conditional within the portal for the data in the mail format file but for some reason the conditional doesn't work within the portal (but does outside the portal) - any ideas how to get this to work? Thanks!!

Hi, I've just put some files out on Web Companion. It seems that the Filemaker Record Navigation and some Filemaker Side Menu options are missing in: Mozilla 1.3 Netscape7 but are working in IE5. Is this a CSS2 issue? My people use a mixture of browser and platforms, does anyone have advice as to which browsers are compatible? Can someone direct me to docnn which can guide me thru which scripts work and which don't too please - I'm not able to launch scripts which are behind buttons within a portal. thanks for your continued help, J.

if someone adds a record via the web, is it possible to have filemaker send an email once that record has been added?

Hi I've read in a couple of posts that is possible to display related data more than one relation away using calculated fields. Grateful if someone could either explain how this is actually done or point me in the direction of any relevant posts. Thanks Iain

In Filemaker you can perform an export of your records as a tab-delimited file. Is there a way to create a button in an HTML document that take the search results one queries form a database and export in the same maner? In trying to build my custom solution(s) I'm thinking of ways to import and export data via the web rather then buying addtional licences of filemaker. Here is one idea I have. We have a product database in Filemaker that gets its info from imported Excel documents (prices, SKU numbers, etc). Once in Filemaker, we add information like product description, wether it has artwrok available, etc. I would like to get this database online for ou…

I have a database of links, The have a field named urls and they have a category field (html,flash,perl,asp). Can you format a search results page which would have a title for each category and then list those urls, then the next category tile, then those urls, ect. ? (example) html links url#1 url #2 url #3 flash links url #1 url #2 Photoshop links url #1 url #2 url #3

I have designed my cdml web pages with GoLive and have used Actions that work in files that are located in the cdml_format_files folder. When I try to use Actions in the default.html file that resides in the Web folder they will not work. Example: using ShowHide to display a floating box and/or OpenWindow and ResizeWindow. Am I doing something wrong or will Actions not work from the FileMaker Web folder?

Hi All, I have the following code used to send an email to two people when a user creates a new ticket. The user completes a form on the newticket page and submits, this goes to the newticketemail page (where the code below is) to send the email to the customer and the account manager, and then onto a confirmation page. <META HTTP-EQUIV="refresh" CONTENT="2;URL=FMPro?-db=DB.fp5&-lay=Layout&-format=newticketconfirm.htm&-mailto=[FMP-Field:Email]&-mailto=[FMP-Field:AccManEmail]&[email protected]&-mailsub=Support&-mailhost=host&-mailformat=includes/newticket.txt&-recid=[FMP-Currentrecid]&-token.0=[FMP-CurrentToken…

Oh I am trying to connect locally, also on both FMP's when I set the web companion to a port below 1024, the change setting box appears, I say ok, and it will give me the error message "Web Companion cannot share files over the web because it does not have enough memory or TCP/IP networking could not be started. (-1)"

Hi I am using the search and results CDML templates from FileMaker web tools with Adobe GoLive. At first, they worked perfectly. The next day, it couldn't find the 'results.html' format file. Now, it is not recognizing the form action 'fmpro' at all. Are my format files in the wrong folder or something? Thanks in advance, Catherine

The user enters a value in a field, I perform a find on this. If there are records found, it goes to the -format page of "view_results.html" fine. However when a -find returns no records it will go to the -error page "view_error.html" and in here I have a form that they submit to add a record, -new request. Going to these pages are fine. The problem is when at the -error page and submitting a form here for a -new request. For some reason, when they submit the form for a -new in the "view_error.html" and I get the error page for this form request and it shows that it is a 102, which is field missing. I double check, triple check and I have asked people to check m…

How can I make a custom home page that still links to FMPro databases open through web companion sharing? I understand how to make another page and put it in FMP's web folder, but I don't know how to re-link that page to the databases. I suppose this requires CDML? FMPro doesn't seem to include any CDML tools/tutorials/reference. Is there any code anywhere I could just borrow? I'm really just trying to add a link back to our intranet site from the web companion home page. Thanks! yyh

I'm a newbie here, so please excuse me if I'm missing something obvious... We want to share a FMPro6 db via Web Companion on our departmental intranet. Right now, a link on our intranet site goes directly to http://server:591, and all is well. The problem is, our server is actually a workstation that people use, and there's no way to insure that the database--or FMPro itself, for that matter--stays open. I'm trying to figure out how to write a script or something--we're using PHP, though I suppose it doesn't have to be in PHP--on a redirect page to automatically open the the FMPro file. That is, when people click on the "marketing database" link, it will …

I can browse my database and view images online using the [FMP-Image:Picture] tag, but the problem is not all of the records have pictures. When they dont have pictures i get nothing but a space where the pic is suppost to be and an x on top, ie picture not found. This is understandable but I would like a way to put a generic image that says something like "No Picture" rather than having this nasty looking box with an x on top of it. Any ideas?

Hi I got : DB_A, DB_B, DB_C . The page is on DB_A The Inline Is from DB_B : [fmp-inlineaction:-db=DB_B.fp5,-lay=main,ID={fmp-field:id},-max=all,-find] [fmp-record] <input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51> [/fmp-record] [/fmp-inlinneaction] Im trying to save the chenge I made using "-edit" but it wont let me... Why it will let me edit a portal row, but not an inline? and is it possible to edit rows with inline?

How do I sort my data with links, I cannot find a generic syntax for me to follow this is what I want to do.. Sort by the category Artwork Display All I tried doing it with this link, but it didnt work. .../FMPro?-db=Inventory.fp5&-Lay=List&-Format=browse.htm&-Error=err.htm&-Category=Artwork&-SortOrder=Descend&-Max=10&-FindAll All this did was show everything in the DB Is there any resource where I can find out how to compose these kinds of links?

I am currently trying to develop on online evaluation form. The database as it stands right now is 1 evaluation record has many questions (1-many). Then each user who takes the online evaluation would create a response to each question and obviously each question can have many responses submitted by each user. My problem is, figuring out how to execute creating multiple response records at the same time after the has answered a set of questions. The HTML page would display 10 questions at most(but may continue onto a new page for the next batch). What I would like is that for each page of an evaluation form that contains the set of questions, the users answer th…

Here is my code, its acting like its not even recognizing the tags, I am using FM 6 Trial. <HTML> <HEAD> <TITLE>Web Page Title</TITLE> </HEAD> <BODY> <FORM ACTION="FMPro" METHOD="POST"> <INPUT TYPE="hidden" NAME="-db" VALUE="Inventory.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="Form"> <TABLE border=1 align=center cellpadding=3> <P> <TH>ID</TH> <TH>Item</TH> <TH>Cost</TH> <TH>Sold</TH></P> [FMP-record] <TR> <TD>[FMP-FIELD: ID]</TD> <TD>[FMP-FIELD:Item]</TD> <T…

Hello, Is it possible to test against a valuelistitem in an if directive? Example: <select name="from_the_list"> [FMP-ValueList:theList, list=myList] <option value="[FMP-ValueListItem]"> [FMP-if:ValueListItem.eq.specificItem] Display custom item [FMP-else] [FMP-ValueListItem] [/FMP-if] </option> [/FMP-ValueList] </select> The code above doesn't seem to work for me. Thank you in advance for any insight. Bradley

Okay, very new to Filemaker and CDML. I basically have a photo database that has the photo in a container field along with a ton of information fields. There is also a keyword field for every record. I want to create the functionality so that when someone on the web searches for a certain keyword, the database will return all the corresponding images and arrange them in a table that is 4 <td>'s wide and however many tall to accommodate the results. I am not a programming whiz, but I assume this involves a for loop of some kind, is this possible in CDML? Is there another way? How could I return the first 4 results, and then close that row and either start a…

I'm trying to figure out how to use a field value to be used in the [FMP-Record] of an [FMP-InlineAction] Below is what my code looks like: (well similar to it) Somehow I need the value of the field "coreKey" which is a field in the outer [FMP-Record] to be used in the HTML code generated by the [FMP-InlineAction]. I can't use [FMP-field: coreKey] since this is not a field in the database in the InlineAction. Is there a way to pass the value inside the InlineAction? I realize that looking at my code it may seem strange and illogical but I I do have my reasons... Thanks. [FMP-Record] html code here [FMP-InlineAction: -db=Selection_, -lay=TableListin…

Hi How can I use [inline] instead of [portal] ?? I tried : [fmp-inlineaction:-db=units_history.fp5,-lay=main,sys_id_dummy={fmp-field:reservations::id},-max=all,-find] [fmp-record] [fmp-field:unit_id] [/fmp-record] [/fmp-inlinneaction] But it is not working... any ideas?