Other Internet Technologies

I have a 57000 record database which works fine in FMP 5 v2. However, when I use Instant Publishing or Custom Publishing (IE 4 or Netscape 4.7) I receive the following error messages trying to view or change a record beyond the 309th record. Instant Publishing: I can search for and view any record in the 57000 record database but cannot submit any edits for any record beyond the 309th record. Receive the following error message: "Your attempt to save record failed because of the following...Unknown error number 101". Custom Publishing (Home Page 3): After 309th record receive message: "Record not found". This happens in several large databases. FMP works fine...web p…

Hello, I have a web page that makes a find request to a articles DB using a single text field, the value of this field is used to find the articles in the database. I thought that if I captured this value I could then do a calculation field that could give me the number of occurrences of the search term, this could be done with a PatternCount function, and this way I could sort the found articles by their relevance. How can I do this? I have not found a function to catch the current search word. I thought there was a CurrentParthArgs or something with web companion but I can't seem to find it. If you do a Find at the FileMaker web site it brings results with a "Relevance …

I am very new to fm.I have downloaded the trial version.I want to know more about web publishing,any resources.. also is it possible using fm that i can put up a database on the web and give options for adding/deleting records on the site itself,something what ASP can do with access/sql databases. also what is the use of fm server,is it used for tasks what i just mentioned, can fm be used for interactivity in web pages generated from database..like changing database online. please let me know any resources related to web companinon,fm server,etc. I just have the trial version which does not contain any help on above topics. also can i get somewhere fm server w…

Here's a weird one: I create an order in my orders.html file and then add a product by linking to a productedit.html file. When I go back to the orders.html, my portal is not displaying the products I just added. BUT if I then get out of the order and find it, using the same orders.html file, it displays the order with the portal no problem. Does this make sense?

I have a database site based on web companion and CDML. In the near future I may be required to go to Lasso. However, I don't want to convert all at once (maybe convert the site part by part). Is it possible that Lasso can interpret CDML pages as they are? If that is the case then I can convert some pages and let it run all the pages until the rest are converted. Can Lasso interpret CDML as is?

I'm creating a web page that allows users to edit records. I'd like to simulate the pop up lists on my database by using <select> in the html. Normally, I'd just use: <select name="name"> [FMP-option: fieldname, list=listname] </select> However, because users can also enter their own data in addition to using the pop up list in the database, I want to test for what's in the field and match it against my value list before creating the <select>. Here's what I'm trying, but it's not working: <select name="name"> [FMP-If: fieldname .neq. valueListItem] <option>[FMP-FIELD: fieldname] [/FMP-If] [FMP-option: fieldname, list=list…

ok.. when i do a search i want the records to sort by 3 fields, first the year, then the month, and then the day.. makes sense.. seems easy enough.. but here is the catch.. i am writing out the months not using numbers to represent them.. i want the to show up in chronilogical order not alphabetical.. can this be done.. i know i can do it in file maker by telling it to sort according to the order of a value list.. but is there a way to do this in CDML or will i have to go back and have the months represented by numbers?

My web page uses JavaScript to take the elements of a form and create a URL to submit edit requests to FM 5. I've added a <textarea> element to the form, and the length of the text is too long for the URL when an edit is made and submitted. Does anyone know of a way around this, or am I going to have to do a major overhaul and read a book on CDML?? Example of the current URL: /FMPro?-db=All_Activity.fp5&-format=-fmp_xml&-recid=33196&-fieldname=waytoolongtext%20moretext

Every time I post a question I think it is the last thing I am needing to know to finish this project. I was asked to have multiple sort options on the form I currently have. I need to be able to sort by record number and two other fields, but not restrict the user to have to use these sorts. This is the way I tried it, but only the first one works. <b>Sort By Bug Number:</b> <input type="hidden" NAME='-SortField' value="Number" size=2> <SELECT NAME="-sortorder"> <OPTION selected> <OPTION>ascending <OPTION>descending </select> <b>Sort By Severity:</b> <input type="hidden" NAME='-SortFie…

I am stumped. I have a text field on a form that often exceeds the size of the field on the layout. Is there any way that I can get the entire field to PRINT even though it does not show up completely on the layout (without clicking on that field)? In other words the field may be 2x3 and the contents will be 4x3. How do I get the last 2 lines to print? Sometimes the contents may be only t lines of text, other times it may be 100 lines of text. Jo Ann

Some of my customers are getting error 4's from links where the url is made up by web companion. They are not experiencing the same when they use a search form just from urls. Here is one of them. <a href="fmpro?-db=mycandidatedatabase.fp5&-format=result.htm&-LOP=or&-max=all&-sortfield=surname&-sort=ascend&-token.1=[fmp-field: username]&-token.2=[fmp-field: password]&-max=30&source=[fmp-field: source]&-find"> The only thing I can think is that their username which is placed in the url contains a space and we companion is not putting %20 in instead of the space and this is causing a problem. Although it doesn't happen from my…

ok.. i am trying to use the include tag to include a text file. i want to include the text file based one something i pull from a cookie.. this is what i tried.. it didn't work, i didnt think it would really, but it was worth a try.. [FMP-Include: [FMP-Cookie: Cookiedept, raw].txt ] i assume if i want to do this i will have to use IF statements.. but i just wanted to know if someone knew a better way..

Got an odd little behavior problem with the web security databases that I thought I'd run by everyone here to see what you thought. I have 2 FMPro 4.1 clients runnings the web companion. I have recently switched over from regular FM security on all web databases to web security. I'd like to mount the security databases on our FM Server and then have each FMPro client load the security databases through a start up script. That way I have one security database that both clients use instead of two separate local databases that I have to update in tandom. I've taken this approach and the FMPro clients appear to acknowledge the Web Security.fp3 database as mounted and ope…

I created a group of databases to run in conjunction with a web server. Because FMPro 5 is running alongside the web server, I instructed the folks on-site to make aliases to the results pages inside the Web folder and set FMPro's port to 591. I've tried the site out and straight away I get the message: An unexpected error occurred: No default and no address for database users. Can anyone shed any light on this? Thanks in advance!

Who could direct me to the best source for Lasso Training?

Hello all. I have search the message boards here, and I can't seem to find a topic that fits my situation. I hope someone can help. We have a FM database called graphic library. We have set this up with custom web publishing as a web page for our customers to go to to search for their graphics. We didn't want other companies looking at each other's graphics, so I set up, with the web security databases, the exact search. Each customer has a code that they must enter with each search to find their stuff. Some customers have mentioned that they don't like to have to type their code in for every search. So, cookies came to mind... I have tried to work them in, but, with n…

Hi, I have a database which I'd like to put online. Here is my problem: each record has a unique, specific layout. On each layout is a button which performs a script which is unique to that layout. The script pastes a value into a field and then goes to the next record and layout. Can this be done in a way which will work online? Thanks, Rvk

is there anyway to have 2 conditions in an if statement... like code: [FMP-IF: this=that and what=where] display some stuff [FMP-ELSE] dont display the stuff [/FMP-IF] or would it be easier just to use nested if statements: code: [FMP-IF: this=that] [FMP-IF: what=where] display some stuff [/FMP-IF] [FMP-ELSE] dont display the stuff [/FMP-IF]

I have published a database using custom web publishing and when somebody performs a search FM sometimes gives an error message (err #4). There were 49 error#4 in the FMlog. As I said this doesn't happen all the time maybe every 15th search gives an error message. What could be causing this? It's frustrating that people who perform searches sometimes get these errors. If there are problems with the HTML code I suppose it would either work or not. Now it works mostly? The server is a G4 with FM4. Thanks for any help

We have a page on our site which allows members to edit their "specialties" in our database. I use the following code: code: [FMP-ValueList: Main_Specialties, List=Main_Specialties] <input type="checkbox" name="Main_Specialties" value="[FMP-ValueListItem]" [FMP-ValueListChecked]>[FMP-ValueListItem] The code works just fine when members submit new specialties (they are recorded in the database), but when members remove (de-select) a specialty, the change isn't saved. Does anyone know what I need to do to the code to make it work? Thanks for your help!

I have a database of 61,000 records of old photographs where users search on fields called "subject" (a repeating field of up to 10 entries) and "Description", a text field of up to fifty or so words. When searching for subject "hockey" and description "bobby orr", the correct two records are found in just a couple of seconds, but if it is only description "orr", the system whirrs for five minutes then filemaker quits with "error type 2" and the whole system (MAC G4) must be rebooted. It appears Filemaker is searching the Subject field for all records and then the Description field for all records, not just the found set for Subject. Is there any way to control this? It d…

Hi, I have a database which I'd like to put online. Here is my problem: each record has a unique, specific layout. On each layout is a button which performs a script which is unique to that layout. The script pastes a value into a field and then goes to the next record and layout. Can this be done in a way which will work online? Thanks, Rvk

Hi, I have a database which I'd like to put online. Here is my problem: each record has a unique, specific layout. On each layout is a button which performs a script which is unique to that layout. The script pastes a value into a field and then goes to the next record and layout. Can this be done in a way which will work online? Thanks, Rvk

Hi, I haven't used web companion before and I'm getting in a bit of a bind with it. What I'm trying to do is to put a database of IT Courses online. The aim is that visitors can choose a course and book it online. They can also register so they don't have to input their details again. Specific problems I have are: 1) I've used the FMP connection assistant in HomePage 3. This gives me a great search results page for the courses. When FMP has found a course, how do I add the option to book it? Presumably I can do this by creating a new record, with the course no. and a space for the visitor to enter their logon name and password. But how to get FMP to copy the course no fr…

Is there anyway to test a field in a database for contents before displaying some HTML code? Example: I am trying to test to see if there is an image in one of my fields before I put a link to that image. Some of my records will have images and others won't and I don't want some of my records to have bad links. I tried doing a boolean test on the field hoping that filemaker would return a true if an image was there and a false if not. That didn't work. I would appreciate any idea. Thanks in advance. Chris Taylor

I am currently converting a production reporting system to a FMP database which will be accessed via an intranet within the company I work for. 99% of the fields/material are straight forward, entry level stuff. However, it would be of great benefit to be able to present some of the data graphically (ie bar graph showing # units produced over a given time period). There are solutions for FMP , but what about over the web? Any ideas? Thanks in advance pc

Hi, I'm displaying FileMaker 5 portals in Lasso/Dreamweaver and everything looks great. How do I create a hyperlink in the portal view back to the record itself displayed on a different web page? Lasso tech support mentioned using a Choose command but I cannot figure it out or find any resources on it. Anyone know how to do this? Thanks! Jeff Abraham

I am using FMPro 4.1, and would like to be able to access the database from a cgi (preferably in MacPerl, but I'm flexible depending on what is easiest). I would like the FMPro -format page to be returned to my cgi for further processing. Does anyone know how to send a request like this to FMPro from a cgi, including how to pass the parameters? Thank you, Phil K

Hi, I am looking for a tool that to build a website to allow the user access to my FMP 5 database. I never build a webpage before. I heard that Lasso is good web tool. Any information or advise regarding Lasso? Thank you Hung Pham

Hi, I am trying to create a online survey with FM. The survey will be two pages long. And my question is how to have the two pages on the web submitted into one record. Another I wanted to create a coutinue button on the first page and a submit button on the second, but I can't seem to figure out how to combine both pages into one record. Please help... Thanks for any input

We have a group that fills out an Excel spreadsheet with specific experimental information. It currently is automatically downloaded to an Oracle program. The question is - is it possible to have the Excel form filled out via the WEB and automatically (script perhaps?) downloaded to a FMP database, already being served by HTML Forms via the WEB? Jo Ann

I am using FM 4.1 and I have a ID field defined as an auto-enter serial. This ID is supposed to be assigned automatically and users don't see it until the record is submitted properly and a confirmation message is loaded. (i.e. The record with ID "x" has been sucessfully created.) This field is always set to a value of "0" in a hidden field and when the form is submitted, FileMaker re-assigns it a value based on the "next value" auto-enter serial value it finds. The problem I am having is this: when a new record is submitted using a form and there is an error this serial number increments even though a new record was not actually created. When the form is finally comp…

I created a filemaker pro5 file added some buttons in it . When I viewed from the browser it seems that the buttons with perform script- "Go To Lay out " only is working and other buttons are seems to be inactive .Why it is happening ? Am I going in a wrong way? Any body having solution for this Please help me?. ------------------

Hi, I want to create a form that performs a search based on values in a FMP value list. I have got the basic form working without the list and it performs the find no problems. Integrating a dropdown based on a FMP values list is where I fall down! I know it has something to do with [FMP-ValueList] but I can't make any sense of it and can't work out where it fits into the <input type ..etc> of the form. Any help is certainly appreciated. Cheers, Andy.

I have to upload images via html into my FMP5 database. I know the tag to upload is <form action="" METHOD=POST enctype="multipart/form-data"> <input type=file name=image> </form> but... what i have to do to insert the uploaded file to my database?:

Hi, I have to publish my database over the web and the instant web publisher is not an option. However I don't know anything about CDML. Can anybody point me to a good resource for CDML for beginners? Also can the web solution handle auto entered fields, validation, scripts, sorting, summaries etc. Thanks, Andy.

On a CDML page I am passing a query via a link that originates a page containing data from database A. This data is the name and address of a manufacturer. Each manufacturer is assigned to a category. On this page I am also passing an FMP-inlineaction to search another database, database B, that searches for this manufacturer's distributors based on this category. [fmp-inlineaction: -db=databaseb.fp5, -lay=table, category={fmp-currenttoken.1}, manufacturerid={fmp-field:manufacturerid}, -find] Database B is a many-to-many join table that features many occurences of the manufacturers id as each time a distributor is assigned the maunfacturer id is also assigned to each …

ok having a problem with cookies.. i can set them fine.. but when i call the info from the cookie i have a problem... it displays the cookie tag instead of the cookie info when i call for the cookies.. here is my code code: <html> <head> </head> <body> <B> <P>Hello [FMP-Cookie: Cookiename1, raw] [FMP-Cookie: Cookiename2, raw], aka [FMP-Cookie: Cookieuser, raw]. Your password is [FMP-Cookie: cookiepw, raw]. <BR> [FMP-Cookie: Cookiedept, raw] [FMP-Cookie: Cookielevel, raw]. </B> </body> </html> and this is what it displays in the browser when i call it. Hello [FMP-Cooki…

I have written a test-taking code for coaches, where there are two versions of the test: "A" and "B" and where there are variable questions at the end of the test, depending on the sport in which the coach is involved. The problem is that I've tried nesting my "fmp-if" cdml inside of my form tags. This crashes FMP on my machine, when somebody tries to access the page. However, if I nest the form INSIDE of the "fmp-if" tag, it doesn't crash. Is there a reason why this should happen? Is there someway around this (or else I have to have very long HTML to contain every full version of the test in its own form)? Thanks

ok, I

I would really appreciate any help: I don't want to put multiple search fields on my custom webpage. Is it possible to just add one text field to the web page that would search from multiple fields in the database (name, phone, address, etc)? How do I do this? What's the correct CDML code? This is the current tag, so how do I change it to include phone, address, etc fields in the search? <INPUT TYPE="hidden" NAME="-op" VALUE=eq><INPUT TYPE=text NAME="CompanyNAME" VALUE="" SIZE=30> If that's not possible I thought about creating a field in filemaker that would have all the information from different fields copied into it. But my problem is that the database …

Good day all, If I have a field in a form that is not a filemaker field. Just a field created in the form. And I want to pass the value typed in the field to a filemaker field via a link. How do I do this? Thanks in advance.

Has anyone seen a solution for doing a file based upload (rfc 1867) via FMPro web companion? I'm trying to avoid running another web process (IIS or similar), and would like to have this all fit into the FM paradigm...

hi. I

Are there any alternatives to Web Companion for FMPro 4 on a mac out there? I'm looking for a more powerful web server that will still be able to handle FM stuff. Anyone know of a free plugin that does so?

I have experiance with web development and filemaker, but have never used them togeather. We lost the book when my department moved locations, so I have little to nothing to refer to. Is there anywhere to refer to to get a list of syntax, commands, or anything else along those lines? Thanks in advance. Regards, Chris [This message has been edited by ctaylor (edited November 24, 2000).]

I am a total newbie to FM/Web Companion/Lasso I have been approached by a FM MAC developer to do an install of FM/LASSO on NT Server. I have persuaded FM/LASSO to co-operate on NT in a uer environment, the next stage is to get FM to run as a system service so that it is not affected by user logon/logoff. I am using SRVANY.EXE from the NT Resource Kit and have added the service to run as a system account and to interact with desktop. However whenever I start the service FM runs and opens the requisite databse, but then the NT Service Control Manager eventually times out with 7009 timeout waiting for service to connect, 7000 Filemaker service did not respond in a timel…

every better web-server app. hast a option to declare what file-types are hosted on the server. such as .html; .txt; .jpg; etc. In my case I

i

I have found that Filemaker is caching a copy of the custom home page and other static pages such that even after I update them they appear incorrect when accessed over the web. Does anyone know of a way to clear the cache?

I have been trying to use the Web Companion External Functions... but no success. I have defined a calculation field with one of these funtion. But nothing happens when I access a database via my Web browser. Any suggestions??

I still have a problem with tokens and would appreciate some help. I have a URL to a page that contains the token, -token.1=categoryname. On the following page is a field that's used to display the contents of the token, [FMP-currenttoken:1]. This all works fine. My problems start when I try to carry forward token 1 to the next page and collect token 2, -token.2=[FMP-field roductcategories: roducttype] from this page. The entire URL looks like this: <a href="[FMP-link:dlrfsktma]-db=manufacturerindex.fp5&-lay=table&-format=manulist.htm&producttypename=[fmp-field roducttypejoin: roducttypename]&manufacturerfinished=1&-sortfie ld=manufacturername&am…

Can someone offer me some assistance in using the token tag (-token; [FMP-CurrentToken]). I am not quite sure how to use them, and where they would go. I've read the simple examples <type=hidden name=-token value=[FMP-CurrentToken] I understand the concept of the token which passes information to a format file. But does it pass information from one file to another? Any insight would be greatly appreciated. I am working on a project an would like to understand this feature to implement. ------------------ Rich

No need for you to worry about all this stuff. Just use the [FMP-LinkPrevious] and [FMP-LinkNext] CDML tags. These are used thus: [FMP-LinkNext]Next Record[/FMP-LinkNext]

We have a form that has been successfully linking WORD docs to a container field. Now one of our users needs to link in a PDF file and it does not seem to work via cdml. Any suggestions?

Im new to this board and im from Norway.....so if I spell some words wrong I hope you can bare with me. I have made a box to insert usename and password. I have redefined the submit button to a roll over with an animated gif wich will serve as submit on click when the animatin is done. My problem is however in how I make filemaker pro 5 understand that I have my own password box and not the one built in windows. I have made all the html documents with all the records and actions I want and just need to link my password box to the index file. Do I need to set up the web security in a special way? any input on this would be truly apreciated....... best regards Ole [T…

i am running my filemaker database server on a windows NT machine, is there a way to set up a cgi-bin on the server so that i can run cgi scripts?

What if any are the significant improvements to custom web publishing from version 4 to version 5? I'm tring to figure out if I need to upgrade to version 5 or not. Any advantages to the unlimited version 5, version 4 is already unlimited is'nt it? Many thanks ------------------ Ger Somers It Manager Murray O'laoire Architects

Can anyone recommend a good FileMaker Pro book that deals specifically with web publishing. I went to my local Barnes and Nobles and they had a few Filemaker books but none that specifically address the details of custom web publishing.

Can anyone help me with the following problem. I'm trying to display the list view by default but I keep getting the form view instead. The code for my link is: <A HREF="FMRes/FMPro?-DB=project%20reports%20dbase.FP5&-Lay=Indivdual&-Token=25&-Max=All&-Format=ZformVwCSS.htm&-Error=ZErr.htm&-Findall">Indivdual5eb</A> The Format file is the one that the web compaion has created by default. Do I have to create my own file, or have I the Max in the wrong place. Help... please...

We have published some files to the web. We are able to acces them in the same layout as built. However, with Netscape the layout is changed and all the fields are in one large column. Any one know how to fix the problem in Netscape?

Is it possible to have a list of related records (portal) on a web page and have their links open a new window of a certain size. I have got the linking working with it opening a new window and I have been able to get new windows to open of a particular size using javascript, but I can't seem to get the two working together. Using Home Page /FM 4.1/Custom Web Many Thanks Ger

Anyone have any experiences using Flash 4 or 5 with FM? I can read content of a FM Database out of Flash but not the opposite. thx s.

I'm trying to set up a web based password system for a client using FileMaker Pro. I already have the passwords and ID generated. What I need to know now is how I get it to look at the database, spawn a matching ID and password set to the screen and then remove it from the database. The passwords and ID are already hardcoded into the users area in the server settings under WebStar. I've got the database to hand off variables to the secure e-commerce system of the client (Hosted on another system), once the credit card is validated then it comes back the original server and what I'd like to have happen is that the user then gets the unique ID and pas…

I have a database that I am custom web publishing. It is searched most often by date and more specifically with the "gretaer than" search operator selected and x number of days ago enetered. I would like to add a canned or predetermined search with the click of a button since most people want to see the last 2 or 3 days of postings. So far I have created a field in the database that is a calculation of Todays date minus 2 which gives me the correct date of 2 days ago but I haven't been successful in getting the search to execute from the web page. Any help would be appreciated.

<a href="FMPro?-DB=db.fp3&-Format=rslt.htm&-Script=My+Script&-FindAll">Run script</a> i am using a link similar to this to run a script from my page.. how do i make it so the script runs without trying to leave the page as well.. i just want the script to run after i click on the link.. i don't want to leave the current page i am on. Thanks in advance for any help Rick [This message has been edited by bman (edited October 25, 2000).]

I'm using one value list to select from for multiple products in a database for administration. The value list is created by the data in the "brand" field. Each "category" of product only uses a certain subset of the value list. I'm trying to allow the web user(because this is a product selection capability on the web) to make a selection based on the category, and only show those "brands"(from the value list) that are related to the category selected. Does anyone have any thoughts on how to do this without having to create a separate value list for each category? Thanks for any help.... [email protected]

Anyone have experience with a database that FileMaker suddenly develops a sharing problem with? I have a database mounted on an FMP 4.1 client that is being web shared and periodically, FileMaker stops sharing it. If I try to look at the Sharing option for the database (via the File menu), nothing happens. I can select the option but the sharing options dialog box never pops up. Plus, the Define and Change Password options are suddenly greyed out. When this happens, the web companion stops sharing the database but it is still responsive in FileMaker and information can be added/deleted or changed. The database structure is quite large (nearly 500 fields). I have 2 …

This is a really advanced question. I hope that somebody can help me with this one. I'm designing a database driven website. It has a couple of databases. One of the databases is a member database. Here a user can "sign up" - create a record with his username, password, and other information. Now what I want to do is when he comes on the site, it asks him to "log in" using his username and password...and it verifies that the information he types is correct (exists in the member database) and consequently gives him access to the entire site - the various other databases and so on. In other words, something like the Web Security Database, except I c…

I created a web enabled FMP solution with Homepage. I wanted some summary fields to be displayed on the top of the search results page. They do not show anything though. They display fine on the normal detail page. I was wondering if this is some limitation of CDML or Web Companion. Or if I have done something wrong. I actually just copied the table from the detail page and pasted it on the search results page. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-=

I've been using this in my database now for a while, but I'm having a problem recently... One of the pages doesn't replace this tag with the user name like it should, it leaves it blank. Does anyone have any information about this tag that would make it work on one page and not on another? -db is the same database, everything else is exactly the same as well.

This is strange. I have a database with CDML pages that I'm serving on the web. If the database and the CDML pages are in the same directory and I set a cookie, it sets properly. If, however, I move the CDML pages to a subdirectory and leave the database in the main directory, it doesn't set the cookie. I thought that cookies were set on the browser machine. Confused with this one.

i know that its possible to do requeststs by having a static url witch asks to find something(for example "president=bush&-max=5&-find") but is it possible to input data into the database via the url? Please tell me that its possible... thx s.

I agree with sentiment expressed by many here that the documentation on CDML is pretty minimal. How about setting up an on-line database documenting CDML tags & solutions that people can add to. It would organized both by cdml tag and by type of problem/solution. It wouldn't be that hard to do. I'll help design it if someone can host it (I could host it in about 6 months, but not until). Anyone interested? -Don

Do it in your database, not on the web page. Make a new calculation field Left[textfield, 100] or if you want points for style <grin>... Left[textfield, 100] & If[Length[textfield] > 100, "...", ""] ...this will put "..." at the end of the text to show that there is more. Display this new calculation field on your web page, not the original. [This message has been edited by Vaughan (edited November 07, 2000).]

i`m running a database on mac OS 8.1 ASIP 6.0 and FP 4.1. If i login on the server via TCP/IP and want to open the database filemakter tells me that the database is in sungel user mode or used. The funny thing is: sometimes i can open the database and sometimes i can

Hi there Hope i can get some help. I have an import script running on filemaker, but when i search in the database from the web using CDML the script i shut down :? Why is this, and more importaint can i do anything to prevent it ? Eske

I have a problem understanding tokens and was wondering whether anybody could demystify this technique for me. I am passing the following url, FMPro?-db=contentindex.fp5&-lay=table&-format=channelhome.htm&pubdateconf=1&sitechannelid=1&-sortfield=pubdate&-sortorder=ascending&-max=10&-find to access a set of records that are returned between the FMP-record tags shown below. [fmp-record][FMP-if:contenttypeid.eq.1]<A href="[FMP-linkrecid:Format=channeleditorial.htm]">[fmp-field:headline]<br></a>[/fmp-if][/fmp-record] You'll see that I'm using the dynamic FMP-linkrecid as I wish to access the full record. However, herei…

I have an html form with checkboxes that update fields in my database. Here's my code: [FMP-Valuelist:Answer_a,List=A] <input type="checkbox" name="Answer_a" value="[FMP-ValueListItem]" [FMP-Valuelistchecked]> [/FMP-Valuelist] When a checkbox is checked it updates the database. The problem is that when I uncheck the checkbox it stays checked. How do I make it stay unchecked? Cheers, Mike

We currently are running version 3.0 server connected to WebStar via Tango. We have about 15 databases distributed on the web. We are averaging 20,000 hits in FileMaker via the web daily. We are planning to upgrade to 5.0 and wish to know what the best method is?? Do we need Tango still? Do we need FM pro Unlimited? If so, how many copies? Just one for the server? We will have about 300 users with FM Pro and need to know what we need to put those 15 databases on the web.

I have a related field in my database that is a container field storing .gifs. When a user types in a thread color the container field displays the gif of that color. The relationship works fine in FMP, the related field is on the correct layout, etc., the problem occurs in the browser. I keep getting a broken link icon in the container field. The CDML I have is [FMP-Image: RelationshipName::RelatedField], Store Compatible graphics is checked in Document Preferences, and Store Only a Reference to the File is unchecked in the Insert Picture dialog box. Can anybody tell me if I missed something or if this is even possible to do?

I've been having an endless series of problems with the ISP that hosts our FM databases. Anybody have some good suggestions for companies we should be talking to that offer good service?

First I want to thank everyone for this list...in one night of reading I solved four separate problems that I was having developing a new web solution! Keep up the good work! -My question: I need to submit multiple find requests to a database from a browser with a single submit button. The "-Find" action only creates one request. While very simple to do within FM (creating multiple requests), I can find no way to do this from the web without scripting (which is not an option since I am submitting multiple variables simultaneously). Any input would be greatly appreciated. Thanks. Jeff

Is there a way to refesh the web page from CDML or Lasso? I'm setting up user name and passwords, which is set up, but the user can easliy bookmark a page and get in that way. What can I do to validate their entry from anywhere? ------------------ Rich

Here's one for everyone to chomp on... My users are creating new records. On the "New Record" format page, I'm passing simple information to speed the data entry (i.e. the current date, their username, etc.) I am also setting up some of the fields as entries with Value Lists....Now the curious thing is this all works...EXCEPT! When I use a Value List that shows only "related values" it doesn't work...zilch....nothing. But change the exact same value list to show ALL values from a field and it works fine. Go figure! My best guess is that FileMaker doesn't index Value Lists within itself...and as we all know, if a relationship isn't indexed...FileMaker chokes on sending i…

I've created a database which allows teachers at our school to reserve videoconferencing equipment and alerts our tech person as to the availability of it. I want to allow users to search for bookings between certain dates. The date fields are currently formatted as drop-down choices to enter into three separate FM fields (day, month, and year). I'd like to allow people to search for all bookings between, say, 10/16/00 and 11/15/00. However, I don't know if I need to use different fields for a gte and lte search query (to produce a range of bookings after the first date -- gte -- and before the second date -- lte). So far, all I get is "find all" results or bad command re…

I have a web form that enters some text in fields using some of the Central European characters (Croatian). When I set the code page of the form to either win-1250, iso-8859-2 or unicode, the characters in Filemaker are all messed up and the search or sort of those chars don't work. When I retrive those characters using CMDL ([FMP-field: field, raw]) they display correctly in the browser. Yes, I have set the font in Filemaker layout to Arial CE, and it still shows garbage in the textarea. Roko Roic

Can anyone please tell me how the navigation history is shown on a web page such as: Home > Technical Support > Downloads. Where each page reference is a dynamic link back to that page. Thanks Gary

I'm trying to set a cookie within a Link. I used the code: <a href="http://userip/test/FMPro?-DB=database.fp3&-Format=format.htm&-Token=[FMP-Field: tokenfield]&-RecID=[FMP-CurrentRecID]&user_ip=[FMP-ClientIP]&-SetCookie:usercode=[FMP-Field: cookie field]&-Edit">Go to next page</a> and it takes me to the next page. On the next page I have a link set, which uses the cookie. The link looks like this: <a href="http://userip/test/FMPro?-DB=database2.fp3&-Format=format2.htm&user_field=[FMP-Cookie: usercode]&-Find">Next Link</a> But it is giving me an error. When I view the source it appears that in setting the coo…

Hi, I have users submitting request for our services via the web. I have input boxes and textboxes. I would like to use a hidden text box to submit the date and time when they submitted this request. I have tried the following but it gives me an error. <INPUT TYPE="hidden" NAME="submitted" VALUE="-[currentdate]"> what is the correct way to phrase this. my database field is named submitted and is a date field. Any help is appreciated ------------------ Robert Hernandez Programmer http://www.rgvwebs.com

This is a little off topic for the Web Companion list, but has anyone come across an add-on package that acts as an email server (aka Outlook) that routes incoming email to the application and allows you to send email from the applications and log/save the correspondence? I have tried to get .mail.it from Dacons working with no success. Thanks for your assistance.

What does the source code for the HTML that FMP is putting out look like?

Novice question here. I'm trying to query a set of records from a database based on four criteria. 1). The complete flag is checked. 2). The ID is relevant to the query. 3). The Publish Date is today or has past. 4). The Publish time has also past on the Publish Date. The first two are easy - via a nested FMP-if:.and. statement but I cannot seem to get a response for the others when I use CurrentDate and CurrentTime. Any ideas? Many thanks. Gary

If you are updating a database using a form, and a related field is on the form, the CDML is [FMP-Field: relationshipname::related field] This is simple. Now if I'm updating a field using a url it's just the field name, the equal sign, and the value (be it an actual value or a cdml tag), but if I want to update a related field in a link/url, what code do I put? Thanks in advance...

http://intranet:81/office_schedule_db/FMPro?-db=officeschedule.fp3&-lay=Form%20View&-format=detail.htm&-view how do i change this URL so it links directly to a certain record of the database. [This message has been edited by bman (edited November 01, 2000).] [This message has been edited by bman (edited November 01, 2000).]

I have a contact database joining an individuals and companies databases. Editing of the two databases takes place in the Join file via portals. When using the web companion, the fields in the portal are duplicated several times on the web page. Additionally, when attempting to edit, an error message is generated upon submission of the edited record indicating a field access definition error. Not allowed to edit. However, the record is actually updated. Any ideas on 1) Why the fields are being duplicated down the web page and 2) Why I might be getting this error. Note: The individuals and companies databases are both edited from the web companion with no problem…

I'm having trouble getting a script to run from the record detail page. the script is the right name and all that mumbo jumbo and it's in the same place at it normally would be (i.e. on a new record page or search page). But nothing is happening when i hit the edit buttons. so i have two questions. 1. anyone know why or what i should try to fix it? 2. I know that it could be put in a link such as <a href=FMPro?-db=database&-layout=layout&-fromat=format.htm&-script=script, etc.> the etc is where i run into problems. what is the corrent syntax to have a link such as the one above adding a link rec id tag so that it stays on the same rec on the ne…

I have a link on a page that finds a group of records. What I want to do is on finding these records I want to provide a link that will delete all of them. Now I'm not sure Filemaker allows you to do this in CDML. I'm thinking maybe I should set the link to activate a script to do it, but I would prefer to use CDML to delete it. Now I find it kinda weird that they didn't give you a delete all option in CDML. Dangerous? yes...but useful. Please advise. Thanks

I'm struggling with the method described for CDML record navigation with FMP Link Tag described here: http://www.maclane.com/cdml/cdml_record_navigation.htm Everything seems fine. RecordSkip looks great in FMPro. But when I include [FMP-Field:RecordSkip] in my link, it uses the value of [currentrecid]-1 of the entire dataset rather than the found dataset in sort order. This totally screws with the next/previous link. Is there a workaround for this? Is there something I'm missing? I've tried specifying the sortfield and many other variables in the link, but with no luck...always the same odd result. Here's my link: <A HREF="[FMP-Link:rmk]&-format=dt_doc_detail.ht…

ok here is what i am trying to do. its not that important, its just something that would be nice to have on the page. I am trying to put something on the bottom of the search results page that will let me resort the search result by a different field.. not exactly sure how to do this.. This is what i tried already but it didn't work.. <FORM ACTION="FMPro" METHOD="POST"> <INPUT TYPE="hidden" NAME="-db" VALUE="caddrawingdb.fp3"> <INPUT TYPE="hidden" NAME="-lay" VALUE="Drawing Entry Form"> <INPUT TYPE="hidden" NAME="-error" VALUE="errors.htm"> <INPUT TYPE="hidden" NAME="-format" VALUE="formats.htm"> <P align="left"><B>&lt…