Other Internet Technologies

i have a field in my database that is a calculation. it calculates the records number in the current found set by using the Status(CurrentRecordNumber) function. it is set to not store the result and calculate as needed. on a results page on my website this field is displayed along with other information. it works perfectly when i only have one search parameter. however, when i have more than one search parameter it appears to still number the results as if i was only searching by the first parameter. in other words, my results should also show 1, 2, 3, 4, 5, 6 etc., but instead these are results are showing something similar to 4,23,25,32,43,57 the str…

i'm performing a find and want to return the results. each result must be in an html <table> or <div> tag. thats just how it has to be, trust me. the problem is, i want to tile the results across the screen, from left to right, and then top to bottom. i cant think of any way to do this with any of the CDML tags. any help?

I have an asset management system for our labs here... tables for computers, peripherlas, problems, etc... All logical names for systmes are stored in a related table of names to serial numbers... works great, just right.. the way it should be designed. I'm setting up a simple update page in CDML... all fields, using -edit to update the record... the problem is that the related field isn't updated, rather a new record is created in the related table. anyone else have a problem like this?

Did anyone tried to make encoding an option? (like a pull down menu) do you think [FMP-Field: text, field:customencoding] is going to work?

Hello all, I read some info on a Lasso group lately that disappointed me about using FM as my db of choice for myself and for my clients. It was said that FM DBs run extremely slow when even as few as 20 users log into a site. Is this true? I'm just getting to understand FM and Lasso, and now I'm panicked that I have to dump FM in favor of MySQL. What are the thoughts on that? My use for FM is two fold: (1) as a back end to small clients (under 500 records) sites and ecomm sites (2) as standalone applications/dbs for clients to run. Thanks.

I was wondering if there is a way to create a new record if the find does not have a result. Example: I search on first and last name but nothing comes back so it takes my find criteria and sends me to the page where I could edit the rest of the record with the first and last name already filled in. Am I on the right track?

Is there a way to validate this field to be a required field? The javascrpit I use doesn't work with a token. <input name="-Token.7" value="" size=30> Thank you Kent

Hi, I've posted this to some of the other sections of the forum, but to no avail. Perhaps one of you could help me... I am creating an online registration system for placement testing at my university (nearly 2000+ incoming freshman will use this service). Users will go to an online form to fill out their personal information (name, SSN, phone, etc), and then select an exam date and time from a drop down menu. I have already created the form in CDML. Here is the problem: When a certain date and time reaches more than 30 registrants, that date and time must automatically remove itself from the drop down list. However, I don't know how …

I am thinking to create a filemaker database that will contain CDML tips and tricks so people can easily find solutions on it and submit there solutions. Do any of you want to help with it? do you think people will use it?

I am publising a database just using WC 5.5 v1 and cannot get the field validation to work reliably (Not Empty simply to get a required field entry), it appears to work on a simple single field database but not on the database I am trying to web enable. I notice from searching this forum that other users have had an intermittment problem with this, any thoughts?

not quite sure how to implement this... I have some portal information I currently show on one of my web pages. I would like to make one of the fields from the portal be an active link that, when clicked on, goes to a new web page that contains CDML information to show data from the related record. Here is what I have so far that works. With my current configuration I can do a find on my web page, the find brings up a new web page with the CDML that shows the found data results from the correct record. This page also contains some CDML that shows informatin from a portal field. The portal CDML is configured thus: [FMP-Portal:Budgets] …

I am trying to put the date with currentdate into a cookie (also with time but same problem) When I look in the cookie preferences from the browser I see "currentdate" instead of the real date the cookie is set. I also tried {CurrentDate} something else: Is it possible to make an if statment that shows "(new)" in the search results when someone didn't saw it yet or when I set a new cookie the old cookie won't be used? has this to do with Filemaker 4.1?

Is it possible to make the text that a user searched for bold or italic?

My question is in regard to using servers other than FMPro to publish a database(s). It's been a few years since I have used FMPro. I've published several databases in which I used FMPro server and custom web publishing (CDML and all that jazz). Now during my time away it seems as though Filemaker has compartmentalized their product. My current understanding is that I would need FMPro 5.5 Unlimited to conducted custom web publishing using CDML. Is this correct? Also, the last time I did this I set up a Mac computer as a server in which I used FMPro Server. This time I need to put the database onto an Apache server--Unix i believe--although th…

I can't find how to this. I looked in the CDML references database, this forum and google.

I am using cdml to send e-mails to myself when a form has been submitted. I noticed that some of my e-mails were not getting sent to me when people submitted their forms. So I went to the Error Log and I see some of these? ERROR: -101. Error occurred while sending email. Some of the e-mail gets sent to me and I haven't seen any rime or reason for it yet. Does anyone have any insight to why this is happening? This database is running on a Windows 200 server using Filemaker Pro 5.5 Thank you Kent

I have a database that is auto serial numbering and a web site that ties into it. What I would like to do is to make it possible for the user to enter all the information including his/her e-mail address ..but obviously not the "New number" seeing as FM does that automatically. The problem is I can't get the mail tags to work in the New page with the -new button, but it will work if I place it in the Edit page using an -edit button. I have it running right now where the user creates a new record then has to confirm the information that they entered (in an edit page, in order for them to get an email reply) ...BUT I don't want them to be able to Edit This has rea…

When a -find is performed on a particular website of mine, it is very common for there to not be any matching results. This is perfectly fine. However, when this happens my format page doesn't load and that error message "No matchign record founds" pops up. What can I do to get rid of this?

on my search results page I want to see the details of my records on different pages. <input type="hidden" name="-format" value="art_page.htm"> on art_page.htm, I want to use [fmp-include:articles_[fmp-field:id].htm] code to choose which page should be viewed but id doesn't work ? I think ther is sthg. wrong in my include code. it gives that error : [Error reading format file: /articles/articles_[fmp-field:id].htm] I can see the desired pages with that code: <A HREF="articles_[fmp-field:id].htm"> but I want to use -format in my code to be able to pass token.2 to those pages Abkaplan [ April 11, 2001: Message edited by: abkaplan ]

I am following a tutorial in "Filemaker Pro 5 Bible" by Steven Schwartz and on page 580, it talks about publishing a database to the web. The instructions are to open your database, select EDIT>PREFERENCES>APPLICATION and then select TCP/IP as your network protocol. The problem I am having is that there are no options on the drop down menu where is says network protocol. I was connected to the web at the time, and I don't know if this makes a difference. I was thinking it had something to do with the installation, and I was going to go back and check that too. Any suggestions would be greatly appreciated. Thans in advance…

dear friends, i was wondering, can we use CDML tags(file maker) with PHP to develop a web-based application?? thank you, ankur.

Is there a way to send data in the URL so I don't have to make hidden forms?

is it possible to make the search result rows like: white gray white gray etc... without using a background picture that is as big as 2 rows and has two different colors? Adding a field to the database with a calculation? like if: currentrecordnumber%2=0 gray else white

How can I go about using a check or radio box, that will make a record visible or invisible on the web? Say there are 10 records, and the person would like to have 1-5 visible and the rest invisible on the web. They would just check a box for each of the first 5 records and they would then show up on the results page. Kinda like an on/off switch for each record via the web/CDML page.

This is a follow up to the thread: http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB21&Number=19032&page=&view=&sb=&o=&vc=1 I'm writing this question here because i think the other thread was way out of my league. I'm looking for a dumbed down version. Basically this is my understanding of the situation. If someone has access to your database, they can very easily view all the data in all of the fields in all of the records. My situation is as follows: I have many databases running which are accessed by many people who log in with usernames and passwords. I trust these people, so i'm not too worried about them "h…

I can think this through, but I can't program it because I don't know enough. 1) the browser treats everything that it receives through CDML as though it had been typed in the page's file. 2) this can break JS/CDML scripts if the CDML includes returns or other delimiters (drag) 3) on the other hand, it means that FM can send any JS (anything in text at all, really--and since HTML is all text...) to the browser 4) and JS can send script commands back to FM (I assume this, may be correct) 5) so you could use your browser's ability to do JS (including GREP and arbitrarily-large programs) even when you're not really serv…

I found out that when you add the url: FMPro?-db=[FMP-CurrentDatabase]&-format=[FMP-CurrentFormat]&-lay=[FMP-CurrentLayout]&[FMP-CurrentSort]-sortfield=[FMP-SortFieldItem]&-sortorder=[FMP-SortOrderItem]&[/FMP-CurrentSort][FMP-CurrentFind]-op=[FMP-FindOpItem]&[FMP-FindFieldNameItem]=[FMP-FindFieldValueItem]&[/FMP-CurrentFind]-lop=[FMP-CurrentLOP]&-max=1&-skip=[FMP-CurrentRecordNumber]&-[FMP-CurrentAction] in the record detail html page that it will show you the next record without doing complicated stuff... Is it possible to make "-skip=[FMP-CurrentRecordNumber]-2" easy?

I need to do a complex find that combines a Logical Operator and request with a Logical Operator or request. I need to be able to find records that are marked "must read" in one field, and marked "07" or "09" or "04" in a second field. Is this even possible? Or am I stuck with separate links for each value in the second field?

In another thread, garrycl says that var textInput = "[FMP-Field: course_materials]"; will assign the field's data to a JavaScript variable, but I can't make it work. If I write var textInput = "[FMP-Field: course_materials]"; document.write(textInput); I get [FMP-Field: course_materials] and not the field contents. Any suggestions? If I could crack this, then I could use JavaScript's GREP on displayed data and that would be very powerful. Thanks Doug

I want to set up a search for records where a particular field begins with a user-supplied string. For example, if they enter "Canadian" the result should include "Canadian Association of FileMaker Developers" and "Canadians Against Fresh Water" but not the "Association of Canadian FileMaker Developers" or "Too Many Canadians". Of course, in FileMaker the search string is... ==Canadian* in the search field. Naturally, I don't want to require the [color:blue]==color=blue> and [color:blue]*color=blue> characters to appear in the text input box itself (since that exposes the user to a quirky bit of FileMaker search technique). Then I read Keith M. Davie's refere…

is it possible to send a search request to two frames?

I need to keep track of the search values for two of the input fields. I would like to put the values in two tokens. Is this possible?

I have a website in which my members will be adding different amounts of funding that they have received. They are filling in number fields. I would like for the web page to total the amount as they add numbers. They will then click on the "Next" button and go on to fill in more text information on the next web page. I have a calculated field that is totaling the amounts in the db. It works just fine there. Is there a way that the calculated field will "refresh" itself? I thought perhaps the Inline Action command might do this......I have never used it before. Any help would be appreciated. Thanks!

The first time the user loads in the search page on my site, they should see the three text fields that are available for searching, and the text fields should be blank. Subsequently, when that page is loaded I want the fields to be filled in with whatever search parameters were entered the previous search. In other words, I want the search page to always behave like FileMaker's Records > Modify Last Find command, except when the page is first loaded and there's no "last find" to modify. (Clarification: When I say "previous search," I mean the user's previous search within the current visit to the site. I'm not trying to carry user preferences f…

Hi there, I made a search form to search for one word in one field. When i see the results after searching there are some result that do not have the word i was searching for. How is this possible?? :s this is my search form: <form name="searchfield" action="fmpro" method="post"> <input type="hidden" name="-DB" value="sdugb_site.fp5"> <input type="hidden" name="-lay" size="24" value="web"> <input type="hidden" name="-Format" value="found.html"> <input type="hidden" name="-Error" value="error.html"> <input type="hidden" name="-Max" value="all"> <input type = "hidden" NAME …

can an HTML string be created in filemaker. i.e. If I have a calc in FMP that results the following: <td><img src= "artists/pb/pb_02.jpg"></td><td><img src= "artists/pb/pb_03.jpg"></td> can it be loaded into the web page? (kind of like an include file, but the string is coming from a field)

Hello again When I try to assign a multi-line field to JavaScript, (i.e., var textInput="[FMP-Field:course_materials, Raw]";) it chokes. I've had this trouble before since JS appears to treat the assigned data as potentially part of the program (which could be very useful, but not right now). Thus, single quotes and newlines in a field will cause the program to fail. I've dealt with it before by using a calculated field to convert these characters to something inoffensive and then converted them back later, but this is tr

I need some help with this one.. We are creating PDF forms that submit information to a hosted filemaker file.. We had purchased a tutorial from alqemy.com on how to implement all this .. Everything is working fine . Creating a new record with the data to be submitted to filemaker is done thru the link method... ie all information to be submitted into FMP is in the URL created by the PDF file.. This works fine for 10 or 15 fields We are getting ready to tackle a larger job with upwards of 200 fields to be submitted thru the URL method and I need to know what the limitations are submitting info this way thru filemaker.. Is there a l…

For each record there could be 1-20 images that will be load from a directory. So if I loaded 3 images into record one's directory (01.jpg, 02.jpg, 03.jpg) I would then set the records image count to 3, and then CDML would generate a list (image1, image2, image3) and each Item would have a url that would load the image. Can I calculate the string and then use it in the generation of the page? I know I could do it with a relationship but I am trying to create a single file web solution. David

[FMP-IF: TicketN.eq.[FMP-CurrentToken]] How can I get this to work?

Does anyone have an idea on the limit to the amount of data WC can handle from a single POST action. My setup Box1 WebSTAR 4.5 ...... Mem allocated 150 meg Lasso 3.x ...... Mem allocated N/A WSC 1 ...... Mem allocated N/A Box2 FMPro 5U ...... Mem allocated 100 meg Box 2a FMPro 5U ...... Mem allocated 100 meg Box 3 FMPro Server 5.5 ...... Mem allocated 100 meg Scenario: I have a form with eight text elements and 4 text areas. The text areas each have c. 150 words ("average" sized words). When I post this form using lasso update (wc = edit) action I get an e…

I am trying to show in a pop-up menu, the values of a certain field called "diagnosis" in the database so the user can do a search. Do I have to hard code it? I've tried the following code to see if I can get it to dynamically display all the different diagnosis fields in the database: <SELECT NAME="Diagnosis"> <OPTION VALUE="" SELECTED>All [FMP-option: Diagnosis] </SELECT> The above code is contained in a webpage called search.html which I am calling by pressing a button on a different webpage. Is the above code correct? Also, what should the button that calls it have in its cod…

Hi- I'm currently using FileMaker Pro 5.5 Unlimited on a G3 Server with OS 9.0.4 and I'm having a problem. We have an on-line registration fom that adds a new record to the database. Before a user even gets to the form, we have an instruction page that is hosted within the FileMaker Web folder but doesn't have any CDML in it. However, users will frequently get an error saying the request could not be processed due to a syntax error when trying to access the page. It has been encountered on numerous browsers and various operating systems and it's not occasional. Once it starts, it happens for everyone until I close FileMaker and reboot the server. Th…

If I uncheck a checkbox can why wont it clear the field? (value list has one Item in it)

I am having trouble with Filemaker Pro Unlimited 5.0v3 running in Classic on Mac OS X Server 10.1.3. The application hangs at the splash page, and I have to force quit. I have set Filemaker to run on port 8080. Is it even possible to run such a config? Or should I stick with my trusty beige G3 to run my online Filemaker Pro stuff? I would like to run both on this OS X server without having to drop another grand in another FMP upgrade. Thanks for your thoughts

You need to read this thread: http://www.fmforums.com/threads/showthreaded.php?Cat=&Board=UBB21&Number=19032&Search=true&Forum=UBB21&Words=chazboi&Match=Username&Searchpage=0&Limit=25&Old=1year&Main=19032 All of it. Do it when you have an hour or more.

POINT IN SPACE ANNOUNCES LASSO PROFESSIONAL 5 WITH MYSQL AND FILEMAKER HOSTING GT. BARRINGTON, MA, May 14, 2002 - Point In Space Web Hosting today announced immediate availability of Lasso Professional 5 hosting in combination with MySQL or FileMaker databases. MySQL is the world's most popular open source database, designed for speed, power and precision in mission critical, heavy load use. Combined with Blue World's new Lasso Professional 5 Web Data Engine, the pair provide powerful new features. And, as with past Lasso versions, Lasso Professional 5 can continue be integrated with FileMaker Pro, allowing for more advanced graphical user interface…

hi there, i have a field called 'scores' with a numeric value. i'd like to create a calculation field called 'ranking' which will assign a number next to a record based on results of a 'current find' i.e., highest score='1', next highest score='2', 30th highest score='30'... here's a link to give an idea of my dilemma... http://tutsan.forest.net/ssv/FMPro?-db=ssvdb.fp5&-lay=master&-format=rankings.html&-Op=eq&Group=Adults&-Op=eq&Gender=M&-SortField=highscore&-SortOrder=descend&-Max=500&-Find i'd appreciate any help, thanks!

Hi everyone I enter to db with following link: "FMPro?-db=Berichterstattung&-Format=nVerzeichnisse/FM/Berichterstattung/BerichtRedirect.html&-findall". The "BerichtRedirect.html" redirects to: "[FMP-link: ra]&-Format=nVerzeichnisse/FM/Berichterstattung/BerichtListe.html&-lay=CDML&-skip=0&-max=25&-token.0=25&-token.3=[FMP-currentDate]&-findall" (This Redirect is not the Problem. I have do to it, to get the currentdate). Every things ok on PC, with IE5, on Mac Netscape and OSX on Mac. But on Mac OS9.21, IE5 the Browser-Window stays blank. It hangs in status receiving data. If I define t…

I have just added a shopping cart button from PayPal to my FMP website. My problem is, that I dont know the proper syntax for sending a variable or token over to the description of the item that goes into the shopping cart. The name of the description of the item in my database is called "asset code". I attempted to place [FMP-Field:+Asset+code] directly into the link but it does not show in Paypals cart. In fact, the only thing that seems to show is if you hard code a description. PayPal's shopping cart button looks like this: <a href="#" onClick="window.open('https://www.paypal.com/cart/add=1&[email protected]&amp…

Hi everyone, Is it possible to group data with CDML like we can do with summary layout in FMP? I mean if I have 10 records witch have the same thing in my find key (ex.: 10 records in witch the field 'name' is equal to 'Christian'), is it possible to make them appears just once with all data cumulated? Thank's to all of you!

The title says it all... how do you using a form submission edit the contents of a repeating field? Every time I try to edit the contents the pre-existing data is lost or overwritten. I have a repeating field with the max set to 15. Some records have one entry, others have up to 7, how can I display and edit these records? Right now I have a three stage form submission. Page one edits a portion of the record then results to Page two, whose only function is to edit ONE repeating field and pass it to Page three, which is a final page. I've tried: In reply to: <p><input type="text" name="directory" size="24" value="[fmp-fiel…

I have created a table using CDML. The table lists the records in my database by rows. Each row contains several fields. How do I embed a button in each row, that when pressed, will select the chosen record, and display more fields of that record in another webpage? I know how to embed the button, but I dont know how to get it to "read" the proper record and display more of it. I have cut and pasted the code for you to see: When I press the button, as it is now, it shows a blank screen: <!--The following CDML code displays a row for each record. --> <tr> <td width="140" height="63"> <!-…

Hi all, What I'm after is a script that can tell Filemaker (via a form) what filename to use after someone has uploaded a file. Perhaps a script to upload the file, but then the filename stays in a field (protected) until they submit. That gets put into Filemaker. Is that possible? Thanks

Using 5.5 web companion, have a simple product dbase with ID, description and sub-category fields. When I attempt to use a value list in the find screen I get no records found. No value list is derived from the values in the description field and obviously mapped to this field in the find screen. Any thoughts? Also when it does return a find (this only works on the ID field) or on entry of partial free text in the description field as opposed to assigning a value list when searching, it always opens the search results in a new browser window when running the session inside a frame. Is there any way round this? Thanks

Howdy all: New to CDML and I have 2 question: 1. I need to grant access to a set of layouts in m FMP 5.5 database which i am thinking of publishing bt way of CWP as apposed to IWP. Cna this be done thru cdml? 2. I have in my database about 10 buttons that i would like to continue to use if possible. I know in IWP they do not function as they appear on the screen, can these buttons me attached to a script in CDML to make that happen? Any help you can offer would be great! Cal

Hello! I'm trying to make a range search from my search page using: <P><B>SPR Corrected in Build </B><SELECT NAME="-OP"> <OPTION VALUE=eq SELECTED>equals <OPTION VALUE=gt>greater than <OPTION VALUE=gte>greater than or equals <OPTION VALUE=lt>less than <OPTION VALUE=lte>less than or equals <OPTION VALUE=neq>not equals </SELECT><B>:</B> <B><SELECT NAME='CSCI_Rev_Corrected' SIZE=1 > <OPTION VALUE=""> - No Selection - [FMP-VAL…

A very useful tool. Just found out about this. For Mac OS 8.1 - 9 http://datapixel.net/resources/scripts/script011.html You want this. Really you do.

I have a database which is collecting information from our membership on an annual basis through CDML. The member searches the database for their record and then updates their information. The questions are quite involved and there are at least 15 to 20 web pages worth of questions. Is it possible when all is said and done for the member to "click" and print out a pretty copy of all of their answers? I saw something about using PDF forms with CDML to make this happen. Is this a developer's tool? Can anyone point me in the right direction? Thanks in advance!

I have to validate a field in a form, I beleive that my problem is not solvable with Javascript. The form is a competition which all entrants only can apply once. And the only workable solution to that is to make sure that people can't enter with the same e-mail address twice. The form and format page have to check if someone tries to enter the competition twice (or more) with the same e-mail address. I have javascript validation on all the required fields (such as name, phone ...) and I've tried to use the FMP control attributes on fields (such as: required value, not-empty and so on). But all that happens is that I can get the format page use the e…

I'd like to parse CDML output to a page using JavaScript and don't know if its possible and don't know how to delimit it. If this worked, it would look like this: var textInput = [FMP-Field:course_materials, Break]; document.write(textInput.replace(/(http:[s|.S|,]*)/gi, "<a href = $1> $1 </a>")); but it doesn't work, nor do single or double quotes outside the square brackets. This line of code changes any full URLs in the field into links. It can be done within FileMaker, of course, but it's ghastly complicated, so being able to use the regular expressions in JavaScript would be nice. You seem a clever lot, can it be done? Doug

can somebody help... i have added this line of code to a search result page of db1: <tr><td>[fmp-inlineaction:-db="cov.fm",-lay="covdata",-findany] [fmp-field:no][/fmp-inlineaction]</td></tr> which cov.fm is a second db. it works. but it has slowed down the performance tremendous. thanks for help mimmo

well i have a database working with web-security, i have a set of webpages from which only authanticate users can enter their projects and report information, but the problem is ,after login to the database anyuser can edit anybody's else project report, i don't know how to allow the users permissions on to the complete form(contains many fields). if anybody knows how to solve this ...please let me know as soon as possible.. thanks, goyal.

I have a set of related DBs that I wish to put on our intranet. I have set access on the files fully open (read, write etc. all on). The whole this is currently being developed on my OS X Mac. Now, when I open the files with IE v5.5, I can create new records as indicated by the status area on the left. When I open them with Netscape 6.2, I can only show all (can't edit, create new etc.). With Netscape 4.7 (style sheets on), I only see the Fern Green interface, not the Blue & Gold 1 that I specified. I can, though, add new records. The problem is that I lose all my script-controlled buttons under Fren Green. The final application is intended to run unde…

Just a bit of trivia. Filemaker, 1924, by Ambassador IV, out of the mare Filante, won one of thirteen starts. That victory came at age four (during the Roaring Twenties) in the Maturity Stakes, which had a total purse value of $2500. Lifetime Filemaker earned $2,975. from his racing abilities. As a sire he failed to produce a stakes winner.

Hello, I have a form that people enter basic information. If someone enters their name and it has a special character in it like an accent over a

I've been trying to figure this out for the last few days. I just came on this job where they are using FileMaker pro, and they want me to develop a web-app to interface with it. I decided that using FX.php, in php would be pretty easy, and so I went about trying to enable Web Companion so that I can query the database. So, I'll open up a database, enable WebCompanion in Preferences -> Applications and then in File -> Sharing, and set the port to 591, which is filemaker's registered port. But here's the problem, I then port scan the filemaker server, to see if 591 is open, it's not. Then I'll close the datbase, reopen it, and then WebCompanion in File->Sharing is…

Hi, I'm new to the Forum, and FMP 5.5. We will be using a dedicated Windows computer and Instant Web Publishing to post our related database of applicants to the web so that a four-campus committee can view data and especially peruse scanned images of the aplicant's paper file. I'm using the contents of a field called ID# to create a calculated field DOCUMENTS that contains the ID# and ".pdf" which is the name of the file the person scanning will assign to the document. Can I add a field to the layout that holds file://path/documents ? Would that translate as a hyperlink? Or Is the best way to use the Open URL file script? If so, where do I p…

Help! This works with Filemaker 5, but I can't get it to work in 5.5. I have an Information Database, related to a Users Database. I have set the Web Security db to exact search by the UserName & UserPassword fields in the Users DB. Here users can edit their own password/authentication information. The Information DB is set up in the Web Security db to exact search the Users::UserName & the Users::UserPassword fields. I have also set it to exact update with the Users::UserPassword field. This way users can only view their record & I can require them to enter their password to edit. Here's the problem. In FMP5.5 when a us…

Hi, I have a strange problem happening here and I wonder if anyone else has had a similar problem and a solution. I have a number of databases that are being shared via the web using CDML. They all are performing nicely except that periodically, when for example searching or clicking a link to a page with a search form, FMP doesn't respond. The machine doesn't freeze and if I go to the machine that is hosting the files, they are working fine as well. Quitting and restarting FMP solves the problem, but it isn't an elegant solution especially when I am in San Francisco and the databases are in New York. I am running FMP 5.0v3 unlimited and web companion …

I use an FMP-InlineAction in the middle of my HTML document to search another database. If the Find comes up empty, I want to be able to a simple error message rather than the blank space that comes up. I do not want to leave my HTML page where the InlineAction call is coded.

..does anyone know any way to add or delete values from a FMP ValueList using CDML/HTML?

via the web, i'm accessing a particular record. after successfully viewing the record, submitting changes, and coming back in to view the changes 3 or 4 times, something strange happens. the browser hangs, and refuses to respond for a LONG time. It loads the page in sections, but ends up taking up to 2-3 MINUTES to load the entire page. Once this has occurred one time, it's always like that for this record. OTHER RECORDS ARE ACTING NORMALLY, until you go in and out of them 3-4 times. while this is happening, the server is responsive and acting normally. I'm accessing a single database, with no relationships. I'm not changing Cur…

Hi, I recently upgraded from FileMaker V4 to V5. Under V4 the web security was working fine. On the search page users (teachers) were able to enter their class code and a password code I built into FMP, thereby restricting them to accessing only their classes (unless they knew of course another staff member's password) When they hit enter they received the security access screen wherby they entered a second unique username and password.The fields subject code and teacher password were set to exact search in the web security. I have found that with V5 this does not work. The access privileges are the same and the web security access is the same…

hi, this is my first post and glad this forum exists, thank you steve and you wonderful CDML gurus. on a results page with one record showing, i'd like to create a link that will call up only the very next record on a new results page. i've been trying different configurations using [FMP-CurrentRecID] and [FMP-LinkNext], finding i can't trick [FMP-LinkNext] with a -Max=1 value into doing my bidding (hey, i was desperate)...can this be done with javascript? i appreciate any help.

Hi, Does anyone have answer to this problem? I have a invoice page at the end of the order process. In this page I have a portal to look up the ordered items (orderitems -db) I would like to display the price (which is the same for all items) which is on the host -db (orders) . I have use a normal cdml tag to get the price i.e. [FMP-portal] [FMP-field:voi::item] price = [FMP-field:price] - *this bit* [/FMP-portal] it works on the first record, but the ones after it just leaves blank. any ideas? Lewis.

I am visiting one nice company and I was trying to show something from their databases on web. Everything works OK but the Value Lists are quirky. Some of them are working, some of them not. I am simply replacing the name of Value list in HTML page and some of them works all the time, some of them never. Any experience with that issue?

I can

You could use two format files: #1 assigns [FMP-Field: includeName] to a token. #2 uses [FMP-Include: {CurrentToken}] The first format file uses: code: <body onload="Javascript:document.myform.submit();"> This auto-submits the first format file. I use this type of auto-submit for return from '-edit' etc. Hope this helps. Garry [ April 19, 2002, 01:05 PM: Message edited by: Garry Claridge ]

I want to creat a web form where the user can enter a url. Then I want to create a search page to pull up the url that was entered. I also want them to enter their email address and have that be a mail link. How do you do that ?

Hi everyone! I am wandering if it's possible to check if a CDML result page has been called by the good page instead of being typed directly in the address space of the browser. Cause if a page with CDML tags is called directly by typing the address, I would like to trap it and redirect to an error page... Thank's!

Is there a way to test for an empty portal before entering the portal? Here's a sample of what I'm talking about. [fmp-if: poral is empty] show this number [fmp-else] [fmp-poral: MyPortal] [fmp-field: MyPortal::name] [/fmp-portal] [/fmp-if] Any ideas or code would be appreciated.

Hi, I have a simple URL that makes a search on a database and redirect the results to my format file. The thing is that I have the error "BD not open", althought my bd is really open... Any ideas? Thank's!

Hello How do I include information from a portal with CDML? I have created a portal whith much help from the portals forum. It works fine on my FM layout. But when I trie to inculde the information on my web page something goes wrong. What I am trying to do as follows. In a form doing something like this: [fmp-record]<option value="http:// ... &lay=Layout1&Keywords="And here I want the info from my portal to appeare"&-max=100&-find">"And here I want the info from my portal to appeare again"[/fmp-record] For each <option... a new value from the portal should appeare. I have managed to do the same in …

I've just been designated the takeover person on a project for a woman who decided to leave without much notice. I'm pretty good at FM but ain't never touched CDML before yesterday (well, I'd looked at it awhile back but nothing beyond that). The last two days I've been frantically doing my best to grab this but, alas, the gray cells ain't what they used to be. I would pay $100 for some phone questions and answers if anyone is interested, money tranferrable through PayPal. I'm on a bit of a deadline and this is kickin my sorry behind and I need some sleep dammit! Would prefer someone that doesn't live in the far reaches of Mongolia to keep the phone cost down. If…

Let me see if I can keep this clear and to the point. In a database of mine (we'll call it employees.fp5) I have a portal (we'll call it Departments) Where by each employee has their own record. The portal Departments is used to list all of the departments that employee services. The departments may contain from 0 - 50 different departments kept in another database). Now on the HTML side of things, I want to test on the Departments portal to see if in fact there are any departments listed. Here's a sample of what I'm talking about. [fmp-record] [fmp-field: namef] [fmp-field: namel] [fmp-portal: departments] [fmp-if: field: departments::n…

Hey All, Anyone have any experience running FMPro on an OS X Server? Specifically, speed, stability, connection to Apache? TIA> Skuli

Somewhere along the line, I list the ability to view images in my db through web companion. I created the site with Homepage Data connection assistant. CDML tag for the field is: [FMP-image:Image URL] When the page is sent to the browser, here's what the image source is: <IMG SRC="FMPro?-db=design%20information.fp5&key=http://192.168.0.200/0/1.jpg&-img"> See anythig wrong??? Thanks!

Okay, I've done the searches... sifted through the results, and still have not found my answer to this question. If this question has already been asked, please forgive me, but I couldn't find it. I am looking for a way to have a field contain a value updated by a script. One field named "month" which will contain the current Month And one field named "year" which will contain the current Year I would like those values to update themselves. Via a script, if possible). So when a user on my site performs a search, the script will be activated, the fields will be updated to the current month and current year (respectively) and the search will p…

Searching the forum, I see this topic has come several times. Of course we can't do the upload directly with the WC, but there appears to be several other options for doing an upload -- javascript, server side, ASP -- as discussed in a previous thread... http://www.fmforums.com/ubb/ultimatebb.php?ubb=get_topic;f=22;t=000430 Not being a web guy and with little experience in these matters, what is the best means to get a file out there into a folder in here with some degree of security? [ April 19, 2002, 08:49 AM: Message edited by: jfmcel ]

Hi everyone, I'm trying to do a 'find' action with an empty field... I tried '...&MyField=""', '...MyField=''', and nothing seems to works... Anyone to help me? Thanks!

OK, I am trying to search multiple fields using various multiple form tags on the same page. Is this possible? (I figure I am dreaming if it will really work.) You will quickly see by my code that I have tried several options in the SELECT tag, leaving them there for your reading pleasure. I can get the checkboxes to work if I only use the checkboxes. Here is my code: <TABLE width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> <FORM action="FMPro" method="post"> <INPUT type="hidden" name="-db" value="district_goals.fp5"> <INPUT type="hidden" name="-l…

Hi, I am new in this forum and I need help with this: I have installed FM Pro 5 to publish database on the Web and everything was fine. To accomodate a larger number of connexion we have decided to install FM 5.5 Unlimited. The problem is when I try to publish my db with 5.5, FM freeze and I cannot access my db from the web. I have installed the latest version of Web Companion 5.5v3 with no success. After reading a lot of letter in this forum I think I might know what the problem is, on the same server I have Lotus Domino Server installed. Could this be the reason? Is FM 5.5 Unlimited more "fragile" than FM Pro 5?? Thanks for your help Brigitte

The [FMP-CurrentDate:short] tag produces a date in the MM/DD/YY format. FileMakerPro's short date format is MM/DD/YYYY. So an search generated via a CDML tag will fail. Anyone know a way around this? Thanks, PK

AFAIK there is not mechanism in FM to get authenticated. Set your email server to require no authentication from FM WC IP.

I am having some problems and am hoping someone can help me out

Hi, I have FM 5.5v2 at work and my computer has died so I am working from the home until the new one arrives. At home I have Developer 5.5v1. I have now am using the same files from work to complete the work. However, when I do the localhost/anyfile.html I simply get only the spinning wheel (IE 5, OS 9.1). I also am entered the IP address with the same results. Any thoughts? Many thanks, nati

Hello Can anyone of you gurus explain this? We have a FM database to serve certain issues. FM4.1 is hosted on a PC, Win98 and we can access the database via the web. On two specific computers we repeatedly get the red and white standard error message that I think would read "Database NNN.FP3 not open" or something similar in english. But the database is open, you can at the same time search it on any computer near you. You get the same result when using Netscape 4.x and Internet Explorer 5.5. Sometime it helps to empty the cache. I don't understand this. The error appears randomly on these specific two computers, but not on any other one. Not as far as I know anyway.…

Hi, I would like to know if there is a way to print a layout from the buit in solution. I mean, I have a form that I want to print out but without all the information that the built in solution have. I just want to print the form without the name of the file.... the menu and so... any idea? Thanks.,

Hello, Can FileMaker Server 5.5 software support CDML? Or do I only use FileMaker 5.5 unlimited to do this? Kent