Other Internet Technologies

The cdml reference database is available at FMI's website. It is regularly recommended. It is regularly needed. It is regularly requested. Most recently I have posted the link twice in the past couple of weeks. I'm tired of the repition. I hope I've made the subject line easy enough for anyone to find this. I hope that others who are regular contributors will refer to this link for those visitors who do no research. Here is the last time I will post this link: The cdml reference database is available at http://www.filemaker.com/downloads/hqx/cdml_web_tools.zip [http://www.filemaker.com/downloads/hqx/cdml_web_tools.zip]<b>

I have created a script in FMP that searches for records that contain a number less than 8. The search works perfectly when I run it in FMP, but when I call it using CDML in a webpage, it shows me all of the records (not checking for < 8). Here is the script that I created in FMP using scriptmaker: Enter Find Mode [ ] Insert Text [select, "age", "<8"] Perform Find [ ] Here is the CDML code that I used in my webpage to call the script which is called "numcal" href="FMPro?-token=118&-db=subjects.fp5&-format=subjecttable.htm&-Script=numcal&-Find I cant figure out what Im doing wrong Thanks

I have created a webpage with a table of search results. I have many fields that are relational fields and they display fine. When I link to the individual record to go to a detailed web page, the only fields that appear on the web page are the regular fields, not the relational ones. here is an example of a relational field that works in one page, not the other: [FMP-Field: subjects::firstname] what am I doing wrong?

I have a button created that opens an IP address contained in a field. While viewing this information in WC, is it possible to ask that this script step opens in a seperate browser session? I have clients router IP address's contained in the field and it provides a 'wherever you are' db of information and ease of use to configure router settings. Thanks

I have created a search that displays many records in a table. Im trying to create a link in each record in the table that will take a specific field in the current record (called subject) that is clicked and perform a FIND in ANOTHER database. So, for example. Table 1 has for example 15 records. The user clicks on a link embedded in one of the records. I want to take a field called "subject" and do a search on a different database with "subject" and create Table 2 from the results. I know it involves passing a token but Im finding it a bit confusing. Here is the code that I used to build the first search that creates results in table 1: href="FMPro…

It is just more a curious question on my part. I have a page with a form to perform a find. After the submit button is selected a page comes up with the resulting records. The address in the browser at this point shows as: http://[email protected]/FMPro All the records that matched the find have links. at this point choosing any one of the links goes to a detail page for that record. When this is done the URL in the browser is now quite a bit more detailed...as would be expected: http://63.xxx.xxx.xxx/FMPro?-db=files.fp5&-format=notes.htm&-lay=notes&-sortfield=company&-sortfield=project&Active=Yes&submitButtonName=Submit&-m…

I would like to know if anyone has a way to upload files over the web (not ftp) either into a FileMaker database or saved into a directory on the host server? I have seen the HTML source needed for this to work, but have yet to figure out what's needed on the server side.

i am having a lot of trouble formatting text in cdml i am creating an online newsletter for our clients but with large chunks of text i cannot get it to format correctly. If i set the replacement field in html to preformatted text (as in the format it is in, in filemaker) it keeps all the returns and bullet point and so on, but it does not keep to the width of the page. if there is no carrage return at the end of line it just keeps going and going. is their any way to set a pargraph width. i have tried setting the field to paragraph 1 in html. i then lose the formatting of bullet points and carrage returns in the text and i get one chunk of continuous te…

okay...i love it (er, not) when my clients jump ahead of me with better hardware and software. in this case, finished developing a site in 5.5 and they have 6. No problem, I thought. I'll just be able to add a little to it when I install, such as the cdml files folder. however, one of the cool features i've designed using inline action does not work using 6! i mean, the same EXACT files (DB and htm) and the inline action does not process in 6, only in 5.5. Here's the code, and if anyone can test it, that'd be super. The link: FMPro?-db=calendar&-lay=master&-format=weekcalendar.htm&-view The returned page's inline action: [FMP-InlineAction: -db=calend…

hello In filemaker pro database the values in a field has line breaks, but when i use those fields with [Field:'field_name'] in the lassso file lines are not seperated by line breaks instead everything appears in a single line. How to make it appear with breaks?? bye geethanandh

I've just finished developing my first database in FileMaker 5.5. I've designed the whole thing under the assumption that it would be able to publish easily on the Web, giving our management access to the information they need. However, I've discovered that the layouts don't look right and that the scripts don't seem to run with the Instant Web Publishing. I've looked a little bit into CDML programming, but can't seem to find much in the way of reference material. Since our license is only FM Pro 5.5, I'm thinking that this may be part of the problem. Do the Developer or Server versions have any tutorials or info about CDML tags? Is this something I even want to…

Hi there. i have a solution that is very simple. i have 3 fields. firstname, lastname, and sound. the first 2 are text, the 3rd is a container that has sounds. i want to just show all the records in a portal. would i be able to have those sounds (quicktime) playable or linkable? Peter

Hi I have a CDML page with an If/Else statement on that always results in the first case being seen as true regardless of what I compare it to! The field (includeimage) is a calculation field which either contains No or Yes. Simplified, the CDML looks like this: [FMP-IF:Field:includeimage.eq.Yes] Yes [FMP-ELSE] No [/FMP-IF] : [FMP-FIELD:includeimage] I added the [FMP-FIELD:includeimage] tag so I could compare what the if statement responded to with what is in the field. Whether the Field was Yes or No though, the If statement always printed the Yes…

I had planned to use Filemaker Pro Unlimited and JDBC to have my 100 or so users interact with the Filemaker databases. I've been finding that the databases quit responding if more than one use hits the databases at about the same time. I called Filemaker Tech Support and was told that Filemaker doesn't handle queueing of requests well, and that this was a "known problem". We used to use FMPro 4.1 and lasso on a Mac and did not have these problems, but I inherited that system and really don't understand what Lasso is contributing here. Would putting Lasso in between my Java code and the Filemaker databases "cure" my problems? Does Lasso help regulate the requests to …

Hi I think that this probably isn't possible, but I was wondering whether I can use Filemaker to send an email from a form. I already know how to do this with the -mailto, --mailsub, -mailhost, -mailformat, etc tags in a form, but I have a query form in a Filemaker site and would like whatever is entered into it to be sent to me without adding anything to a database. ie. the -mailformat file would include data entered into the form but that data isn't added to any databases. Basically I want to use Filemaker Web Companion as a formmail CGI. Any ideas? VS

I used to do some development for Lasso 3.6 and FM 5.0. An old client is thinking about turning the old Webstar 4, Lasso 3.6, FMP 5.0 on OS 9 into something a bit more modern, and I have a bunch of questions... I'm looking into Lasso 5, Webstar V and FMP 6 or maybe 4D. How is the does the performce? For example, currently the system is on 3 computers: Webstar -> FMP 5 Client -> FM Server. On B&W 350 to 400 G3s. It is quite slow. I'm hoping to put it all on one G4 550 with OSX 10.2 and have it faster? As well, there is the FMP vrs 4D, I hear 4D is way faster and more up to the task the FMP? Would 4D be worth it? What about Webstar V,…

Hi . . . I appreciate all of the useful info shared in these pages. Between hints here and many calls to the psychic hot line, I'm making progress with my FileMaker site. I'm new to FileMaker; just loaded v.5.5 a week ago. All's been going well, but I'm hitting a wall and could use some help. Our car club database is in two related FM files, FinRost2 and FinCars2. They're related via the record number FM automatically assigns to each record. In the FinRost2 database, the member car list shows in a portal in the primary FinRost2 member record. You can edit the existing list of member cars, or there's a new blank record at the bottom of the list always waiting to …

Gentlemen, The biggest drawback I see with use of CDML is that your code is visible on the web. Any "ELEGENT" idea about how to protect your code? I guess there is several options are available 1. Disable right click using JS - so source of page is not visible 2. Use FMP-Include 3. Make windows without location bar so users can't see where they are.. But I can crack them all. Also, if a user gets to know the database name - they can easily strip contents/modify using XML. Anyone ever thought of anything?

When using [FMP-InlineAction] tag what would be the correct syntax to insert dynamic fields and cookies? For instance, in the following example I need ProdID to be equal to the value from the ProductID field and TransID - to CookieName. What I wrote here - doesn't work: [FMP-InlineAction: -db=Database1.fp5, -lay=Form, TransID={Cookie:CookieName}, ProdID={Field:ProductID}, -find][FMP-CurrentFoundCount][/FMP-InlineAction]. Any help is appreciated. Thank you.

I've set some -Token variables on a start page:- <FORM ACTION="FMPro" method="POST"> <input type="text" name="-Token.0" value="[FMP-field:dbasename]"> <input type="text" name="-Token.1" value="[FMP-clientusername]"> <input type="text" name="-Token.2" value="[FMP-field:Game title]"> <input type=submit name="-Find" value="View"> <input type=reset value="Reset this form" name="reset"> </FORM> (I've set them as text for now for debugging purposes) On the page, the text boxes display the correct text for each of the Token boxes. When I click on the "View" button, I get taken to the correct page, where I …

Hello again! I'm having problems with links inside a generic intranet-site that I have published on our LAN. Here's what I'm trying to achieve:- - Users start in a main index page, with ~10 database links. - Each database link takes them to the same web folder: "http://database_server/generic_dbase/FMPro?-db=DatabaseX.FP3&-lay=Main&-format=search_results.htm&-max=10&-findall" - in each link, "DatabaseX" will be the name of that individual database. - User clicks on a link, and the page "search_results.htm" is opened, listing the entire contents of the selected database (as intended). - At the top of the page are links to SEARCH th…

Hi everyone. I have a CDML drop down box and I need to have a default option selected everytime a certain page is loaded (the page is it's own format file). Say I have the following code: <select name ="Course"> [FMP-Option: Course, list=class_alpha] </select> and the following items are in the value list on the FM DB: <blank space> BIOL CSCI MATH How would I get the <blank space> to be the default option when the page loads?? I know how to do it if I completely abandon the database and go with a static list of stuff in the HTML, but I need the list as dynamic as possible with the stuff changing in the list. Thanks f…

does anyone know how to test CDML without internet access in osX. The help file in 6 describes it for win and os9 but not osX.

Please help, I'm completely stuck with this!! I have a custom web front-end running on our intranet, which accesses numerous databases. Each of the records in the the database will be assigned to an individual; what I need to do is, when a user accesses the database via the web front-end, a FIND is performed based on their access password, and displays ONLY records that have been assigned to that user. I can do this easily with a script, but this only works when accessing the database through Filemaker itself. I have tried calling the script via an HTML link without success. Anyone got any ideas? TIA, Dan

Arrrrghh..I am having a tough time getting a related field to show up in a search result..Currently have 2 DB's orderitems items Relationship between the 2 called "sku" in orderitems, it will pull the "description" from items based on a matching sku. sounds simple enough! and it's working in the FMP side, the data is pulled over OK. here is my CDML - this is the whole file <HTML> <HEAD> <TITLE>al;skdfj</TITLE> </HEAD> <BODY BGCOLOR="#FFFFFF"> <P>[FMP-RECORD] [FMP-FIELD: sku] [FMP-PORTAL: sku] [FMP-FIELD: sku :: Description] [/FMP-PORTAL] [/FMP-RECORD]</P> </BODY> …

Is it possible to host database(s) on your own computer but have all the format files hosted on another ISP? If so...how do I re-direct the -db and -format tags to go to the database on my computer. I am running Windows and my database is in this directory: c:/ddrive/filemaker 5.0/web/database.fp5 Thanks!

Hey all, I'm trying to have Filemaker read/write to a cookie. However, the format files that do this are contained within a frameset, and the cookies aren't being created or read. When I access these files without frames, it works. In frames, nothing happens. Can anyone give me some advice about this? Tim.

Greetings Exalted FM Gurus, Once again I find myself seeking your esteemed counsel. As it were time is not on my side with my deadline to get a simple database published for a gaming guild for whom I am a member. I have been perusing the help files and this forum, but what I need is a guide to actually get to the point where I can type in my address and see my database in a browser. All me to preempt: First of all I have a cable connection and FM 5.5. I know how to enable Web Companion, but the "how to" of getting to a published database is eluding me. I do have a dynamic DNS setup so the dynamic IP issue is a non-problem. I have downloaded Sambar web se…

Has anyone seen a set of CDML tags for dreaweaver6?

Hello, I have a database that users use in the web browser, the question I would like to ask is, when performing a find on the browser view in file maker 5.5 in the TYPE drop down box it alway comes up with BEGINS WITH is there any way of making it automatically come up with CONTIANS? THanks for any help Chris Brown IT Support Manchester

I am setting up a web server and network and was wondering if FM unlimited is need for sharing with Lasso on the net. I understand it is needed for web companian when you have machines talking directly to it but since 1 server and 1 IP address is loggin into FM for info via Lasso why is Unlimited needed?

It depends on your concept and HW and SW setup.

On my form there is a field 'client_id' that is defined to be a pop-up list which displays values from a field. I have chosen to use values from 'client_id' and display values from 'name'. This works fine locally but when trying to select a client by browser, I can only see the client_id and not also the name field. How can I get this to display both client ID and Name field?

Hey All, Quick question. Has anyone come up with a solution or know of a solution that would allow FM to automatically email a predefined list of recipients the URl to a newly created record? For example. I have a database called meeting minutes. When new minutes are added to the database I would like an email to be sent to all those involved with the project that would conain a link pointing to a format file that would contain those minutes. In essence, it would have to display the find criteria, similar to the email you receive if you are sent an Evite. TIA.

I am trying to use the iser id typed in the web login box to be used in a script to find the files realting to that user id. Any ideas? Duncan

Hi, i

I made a page from the CDML Tool template. Security is set to Filemaker Access Privileges, and I have not defined any groups or passwords. So it should be wide open, right? Anybody can edit? Then why do I get the message: "You do not have access privileges to perform the action: edit"? I can search and create new records via the web, no problem, but I cannot edit. Working with CDML is like target shooting in a pitch black room. CDML Tool and CDML Reference both suck. <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-DB" VALUE="GSCustomers"> <INPUT TYPE="hidden" NAME="-recid" VALUE="[FMP-currentrecid]"> <INPUT TYPE="h…

I want to display a number field on a page (a price). The field is in my main DB through a relationship. The field appears unformatted (5.2 instead of 5.20)on the web. I tried specifying a number format on the layout that I use (in the main DB), it didn't change the format on the web. How can I specify the number of decimal to display on the web ? Thanks

hey hey, is there anyway to make it so a link like this: FMPro?-DB=Art.fp5&-Format=searchareaofpracticeresults.htm&RealAreaofPractice=sculpture&-find will only display results which are equal to what im searching for...? ...adding <input type="hidden" name="-op" value="eq"> to the top of the page didnt seems to do anything : thanks in advance!

Once upon a time, long long ago my firm did a whole slew of FMP/Lasso sites. Back then we used FMP4, Lasso, and GoLive. The great part about that combo was that in GoLive in WYSIWYG mode you could see the Lasso tags (actions, includes, etc. etc.) as 'bricks' in GoLive. This allowed our web designers, with some basic Lasso code training, to easily design their pages in WYSIWYG mode and not worry about messing up the Lasso Code. You could even drag and drop includes around a page, or indeed from page to page. Now I use primarily Dreamweaver, but cannot for the life of me preview Lasso pages in WYSIWYG mode. I can include .las pages to open up, but they're all in c…

Hey, im having a bit of a problem with the search page template the CDML Tool generates...everything works fine if i leave the fields the way they area... but if i delete one of the fields and then try do a search (by pressing enter to submit) i get unexpected error number 4....but if i dont press enter to submit and instead click on the submit button....it works any idea's?? any help would be greatly appreciated

Hi All, Is there any way to serve some PDF files with webcompanion? I need to create some records each with an associated PDF file. I'd like to be able to have users use the database via a browser, and with a button launch the associated PDF. So far all of my experiments have failed :-(. For one, I am not sure what to set the URL to in my script. No matter what I do it won't see the PDF file when I use the database from the web. Any ideas? CH

Hi folks, CristyCT's post "Formattting a value list on a search results page" speaks of putting check boxes in a search results form with the field value from the record checked. My twist is this: How is it possible to have the checkboxes displayed with all the values that have been selected from a REPEATING field, rather than a normal field? When I try the normal approach to this (i.e. [FMP-VALUELIST: , LIST=] <INPUT TYPE="checkbox" NAME="" VALUE="[FMP-ValueListItem]"[FMP-ValueListChecked]>[FMP-VALUELISTITEM] [/FMP-VALUELIST] ) All it checks is the value that is in the first block of the repeating field. Thanks in advance for all your help.

Is there a maximum of number of characters a field can contain when using Web Companion?

I've got a FM 5.5 db with a custom web interface (built from scratch). I've got things working so that there is an inline action for that looks somethign like this: [FMP-InlineAction: -db=database.fp5, -lay=Layout #1, -recid={FMP-currentrecid}, [email protected], [email protected], -MailSub=new entry, -MailFormat=mail.txt, -MailHost=smtp.hohum.com][/FMP-InlineAction] the mail.txt looks like this: <html> <body> A new record in ejob has been created with the following information: <form action="FMPro" method=post> <input type="hidden" name="-db" value="database.fp5"> <…

If you were to encounter "%3cbr" in a url, you probably would assume it was an escape code (i.e. a special character). Does this "%3cbr" mean "<br"? Any knowlegde why this would be attached to a url? Any idea about its purpose?

Has anyone out there found a solution to being able to upload a file. I am serving my web page with Mac OS X Server. I would like a solution that allows a FMPro form to be filled out and after being submitted the user would be taken to a upload page where a token would be carried over to a form field they had filled out in the form and then they would be able to upload up to 3 files. Thanks in advance for your help

I'm new to CDML, so I hope somebody could help me on this one... I have a database with a text field "Location" . Every record could have multiple locations (Displayed as a standard field in FM, users click enter after each location if more than one is required) Each record also has a checkbox field "Remove". (Value "checked" when checked) I need to display a web page that would display every single "location entry used on the DB (there may be a few in each location field) as a header (there would be as many headers as there arer location entries), and records listed after each header that has this criteria (Location contains "location header text" AND "Re…

Another token question. I want to create a search with the search field hidden and use a token as the field to search. In this example I am using the record ID as the token. I have not been able to get the search to search that token record Id. What happens is the search results give me the first record id in the database not the specific record id that the token indicates (example: the token shows record id 027, but when I get to the search results the record id is 004 - the first record in the database. How do I create a search using the -token record id that will return a search on that specific record id. Once again, thanks for your help

1.) I am converting my database to be web friendly and have spaces between a name such as John Smith that I would like to convert to John_Smith. I have over 800 records that I would like to convert. Could some generous soul give me the script for such an action. 2.) Another script I need is to grab the last 4 numbers of a telephone number such as 000-000-(0000), and have the results placed in another field. I have over 100 records I would like this script to perform on. Thanks in advance for your help.

Greetings, I want to: connect FM server 5.5 to two FMU to web*/lasso.... to connect a RAIC to lasso. From searching this and other lists I realise this can be done and it would appear that I need the WSC running with one of the FMU (ie not on same box as Lasso). OK. But how? The WSC install gives me some java files and a Web* plugin: can the java files be run alone (not via Web*)? I have tried MRJ Applet Runner but without any idea of even Step 1 here I am floundering. Thanks for any help or pointers, apologies in advance if I have missed the blindingly obvious. ==============

Hi there, I have nearly completed my real-time sign in program and what I need now are the stats that it produces. I have compiled one day's worth of data fine using a URL like: http://10.4.1.102/fmpro?-db=studentsignin.fp5&-format=itemized_stats.htm&-op=eq&date_of_creation=06/17/2002&-find But what I need now is a way to show all the days in in a period itemized (say for a whole month) as seperate days shown on the same format file. I've tried: http://10.4.1.102/fmpro?-db=studentsignin.fp5&-format=itemized_stats.htm&-op=gte&date_of_creation=05/01/2002&-op=lte&date_of_creation=05/31/2002&-find And it gave me al…

Hi, Just a question about displaying a selected checkbox on a search results page. I am using a value list to hold the values. When the value list is displayed online, it is in the form of checkboxes. When the user searches for his/her records, and then sees the search results on the search page, how do I display which checkbox the user has selected? I know to display other fields, such as name, it would be [FMP-Field: FirstName], so forth and so on. I just don't know how it works for value lists displayed as check or radio boxes. Thanks for any insight, Cristy

I have used web companion to make a web page that shows the last order in a database but i don't know how to edit the layout of the page. The address for the page is http://131.111.46.215/FMRes/FMPro?-db=fly&-sortfield=order&-sortorder=descend&-format=FormVw.htm&-lay=&-max=1&-token=25&-find and i guess that FormVw.htm defines the page layout but i cant find this file anywhere on my system. I have tried copying the HTML code for is page and saving it in the web folder but if i add a new order to the database it doesn't update to show the last record. I have also tried opening the FormVw.htm file in internet explorer and saved it in the web folde…

Hi Folks, I could really use some help today. All of a sudden when I click on submit using Instant Web Publishing with the web companion, it is generating a new window this never happened before and is not what I want. If someone could please help I would really appreciate it. THANKS!! [email protected]

I have a database with a portal which I have published using Web Companion (WC) on V5.5v1. Hassle is that it doesn't display the related record and merely shows the first record in the related file. I have another database that works perfectly well with WC in this respect and all of the settings are identical. When I select the "Go to Related Record" in the faulty files I get the following: http://myIPaddress/FMRes/FMPJS?-db=Test%20Comms.fp5&-layID=1&-token=25&-max=1&-format=formvwcss.htm&-mode=browse&-findall When I try it in the files that work I get: http://myIPaddress/FMRes/FMPJS?-db=Maintenance%20Log%20Items.fp5&-layID…

Hello. I've got a FMP 5.5 db on the web using a custom web interface. The database I'm using has several repeating fields. When I try to get them to show up on a detailed record view page, only the first value in the repeating field shows. How do I get all the fields with values to show up? Jackson

Hello, i need to know how to do this: Unique search on custom web publishing that reports in the result page the number of records related to categories. Something like: pictures (2) video (3) text (1) The db is organized with a field called "category" in wich i put (pictures or video or text). Thanks and have a good day

I am installing FM6 in a small ethernetted office. One secretary will run FM and I want another machine to access her database through IWP. The problem is TCP/IP. How do I get the intranet ip address of the host? The host and client machines each access the internet through their respective internal dial-up modems. The ISP assigns them each a temporary IP. I have found that FM does serve to that temporary IP, but of course that is not the one I want. I want the one that the ethernet hub uses, ie. the LAN IP. How do I get that? In my own office I have solved it with a router. The ISP assigns the IP to the router and my individual machines have permanent office-w…

Hi, Here we go again...just a little background first and then I'll get to the problem... I am creating an online database so that students can register for placement exams. They must select a date and time from a list of radio buttons. If a date and time is full, I need to tell that student to select another date and time. I orininally tried to run a script to give me this functionality, but since there is no way to catch any errors generated with it in CDML, I decided to try using the FMP-If statements. I have calculation fields within the database that keep track of how many are registered for a given date and time. My "new-reply.htm" format file con…

I work for a college in Manchester (UK) and we have set up the colleges database that stores all student records in FM 5 with FM Server 5. We have up to approximately 15 - 20 members of staff using the system at anyone time. Unfortunately with some of the complicated lookups etc it can often take the student file quite a long time to open, some of the staff only want to view the system quickly and are put of with the time it takes to load up. I have decided to publish certain files and certain data on the intranet but I am concerned that with the amount of usage that the system will not work. Do I need another version of Filemaker??? I am also looking for gui…

I'd appreciate if anyone can tell me the simple way to do this... I really just want to pull an image through from the database record to a webpage...and of course I'm using my own designed page not FMPs awful templates. What would be the simple command just to link one image to one specific record? Appreciate the help.

I have made a dropdown menu with the code below made using the cdml tool in filemaker pro 4. But all it makes is a dropdown menu with one field called [FMP-ValueListItem] [FMP=Valuelist] when it should be displaying information from the name field in my database. i have made a valuelist called name in the database. name: <select name ="name"> [FMP-ValueList: name , name] <option> [FMP-ValueListItem] [FMP-ValueList] </select>

I have an [FMP-InlineAction] tag on a web page, and I use the [FMP-Record] tag to loop through the found set. Within the loop, I have a [FMP-CurrentRecordNumber] tag. It returns the correct value on the website itself, but it doesn't evaluate when I put the intratag form as a token in a nested [FMP-InlineAction] as follows: [FMP-InlineAction: -db="firstdatabase.fp5", -lay="Layout #1", Field="find_value", -Find] [FMP-Record] [FMP-CurrentRecordNumber] <---This evaluates correctly [FMP-InlineAction: -db="seconddatabase.fp5", -lay="Layout #1", Field="find_value", -token="first_token", -token.1={FMP-CurrentRecordNu…

I am a novice at CDML and programming. Please forgive me but I have read all the messages that relate to tokens and I think I'm just missing that piece of the puzzle that will make it all click for me. I know what the command should be, but could someone explain where these commands are located at? My solution has a search page, followed by a list (a user might get back 1 item or 20). Then I have an "edit" button which goes to a web page and lets them change the information on all fields for the first entry. For simplicity, I have put each section of questions on a web page with a "next" button that lets them continue to the next section of questions (there a…

Hi experts, I am absolutely new to CDML. I know some Microsoft ASP scripts. The CDML tags are included within an HTML file and it seems they are only processed when there is an action command like -find, -findall-, -view .. But if the user directly types in the URL of that format HTML page they can see all the CDML codings. It is very very inconvenient or insecure to show these to the user. In ASP all its tags/codings are always processed before the request is received in the user's browser. Is there anyway to accomplish the same in CDML? Thank you very much for your help.

Hi all, I have a web page used to update a database. Up to now, I would update the main info of this database through the web page, and only display the Portal Information. I now need to update the portal info as well. When I do that, even if my submit button has an edit value, i get a new portal row added every time I hit submit. Any idea How I can just get the edit fucntion, and not add a portalrecord every time? I have 2 text file,one for the portal and one for the main file. They are merged together by the HTML file. My code would look like this: <form name="editform" action="FMPro" method="post"> <input type="hidden" name="-DB" value="11111.fp5"&g…

I currently use the 30-Day Trial of Claris HomePage to make proper html pages to interact with my published databases. I am hoping there is another program iether published by Apple or another company that will provide basic wizards to customize the cdml tags (if i am right) to interact. If not where is a good place to learn all the tags and get a nice dictionary/script reference? Thanks.

I am currenly making an internet based ordering system which a user registers from a web browser. when a new user has registered i want there name to be added onto a dropdown menu automatically on the main ordering page. so when a user wants to place an order they select there name from a drop down menu in the web browser. i am using the following code to display a drop down menu but don't know how to get the selections of the menu from my file maker pro database <P><B>Group</B><BR> &nbsp;<SELECT NAME="Group"> <OPTION VALUE="" SELECTED>Select Group <OPTIO…

can you use pattern count in cdml for an IF statment

Hi, Is it possible to host same database with web companion and FM Pro server ? Will there be any technical problem or performance reduction if I do so ? I would appreciate any feedback. Thanks Aditya

Hi Can anyone help me out with a precedure for configuring OSX so that i can publish and test my db without being online. I can do this in OS9 but OSX seems to be more difficult. Thanks in advance

instead of setting a token by a hidden value in a form i want the user to set a token value to a country of their choice is this possible with a pop up menu

When entering the password in the browser User Name and Password prompt, I would like the users name to automatically show up on the search page. I am using tokens to achieve this, but in order for the tokens to work I have had to create another login html page that queries my database. Is there a way of doing the above without have to have my visitors renter their password? Thanks in advance for your help - Sam

Under Mac OS 10.1.5 since updating to Microsoft Internet Explorer 5.2.x, the following Table View request reproducibly fails (hangs) from my FMP 5.0 server: http://xxx.xxx.xxx.xxx:591/FMRes/FMPro?-db=property.fp5&-lop=and&-skip=0&-format=zTableVwCSS.htm&-error=zErr.htm&-lay=Listing-Table&-max=25&-token.0=25&-token.1=&-find while this one still works: http://xxx.xxx.xxx.xxx:591/FMRes/FMPro?-db=property.fp5&-lop=and&-skip=6&-format=zTableVwCSS.htm&-error=zErr.htm&-lay=Listing-Table&-max=25&-token.0=25&-token.1=&-find There are 17 records in the database file in question. Trying to T…

Hi All, Can someone please help me with the following question. When in a search-result webpage, I want the user to be able to update certain field of a record. I've created a link which will open another webpage with some fields displayed, and tried to do it like this <FORM ACTION="FMPro" METHOD="post"> <P><INPUT TYPE="hidden" NAME="-DB" VALUE="studionl.fp5"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="zoek layout LTP"> <INPUT TYPE="hidden" NAME="-Format" VALUE="update.htm"> <INPUT TYPE="hidden" NAME="-Error" VALUE="update.htm"> <INPUT TYPE="hidden" NAME="-recid" VALUE="[fmp-currentrecid]"></P&…

Can you have FM get client screen resolution? Thanks, Frank

I am new at using the scripting functions and calculations and am having problems trying to figure out how to create the calculations for a pop up window on the search page that will allow doing a search on all records created "today" and "the last week" and "the last month". I can create the pop up window, but do not know how to create the scripts for the above 3 time periods. If someone could reply with to this with the scripts, I would be very grateful. Thanks in advance for your help - Sam --

I've noticed that the file I intended to share using Web Companion that is hosted by FM Server does not automatically enable Web Companion when the file is loaded. Is there any way to do this?

Hello people, I am using Web Security Database to control access over the web. Is there anyway to do logoff with Web Security databases? I mean say a user logs in with his/her uname/passwd. And once they have done whatever they are supposed to do - they log off.. How do I implement this logoff feature with web security databases? Or do I have to close the database window with self.close() in javascript? I have searched the web security manual but found nothing. Any ideas/suggestions/comments welcome

Hi there, I have just created a simple search, list and form. The search form has a few input fields and a preset hidden field. the format file is List.html the error file is Search.html which is the search form as well. Everything works fine. I can do a find and goto the list and form. The problem occurs when the database failed to return any records and it redirects to the search form again (I display a red color text showing there was no records found) . Then I tried to enter some other texts for the search. It gave me the following error: [color:"red"] Command is invalid: Unable to to process your because the server encountered …

Hey everyone, I've worked with Javascript previously to calculate simple things like numbers in a CDML fields in a layout with multiple CDML fields to produce a total like this: <script> eng1=[fmp-field:grandtotaleng]+0; document.write("&nbsp;" + eng1); </script> The "+ 0" is in case the field is blank and so Javascript knows to just stick a zero in there by default, otherwise it will not calculate. Now what I would like to do is the comparison of the time a CDML field has and the time it is now (in JavaScript) . Being a minimalist, I know the formula would be ([fmp-field:begin_session]-timeitisnow). Here is what I have so far:…

I've got a "result" layout that calls several FMP-include txt files that perform multiple finds (via FMP-InlineAction tags). My problem is that each seems to be limiting the results to 25 per "FMP-Include" request? Anyone seen this before? Any ideas on how to increase the "-Max" From what i can tell adding "-Max=100" to the [FMP-InlineAction] tag doesn't seem to help. and either has adding the "-Max=100" to the previous page's request (where the inline Action carries some other info over from). -Arin

On one webpage I have multiple inlineactions that get data out of the same database. In the database I have a calculation field: status(currentrecordnumber)-1 this calculation only works with one inlineaction and that is the inlineaction with -findall. Is it possible to solve this? Or is it a bug and will filemaker fix this?

Now that I have a working solution running on a Mac OS 9.2 server, my IT person just informed me that we are going to be upgrading to Mac OS X. Does FileMaker 5.5 or WebCompanion have a problem with that? Is there any pitfalls that we should know about? Thanks, as always, for your help! Donna

in my style sheet I have all text set to 11px for the whole page. Is it possible to override a portion of that text to 15px. I know I can override it with <font size="2"> but i would like the same pixel control that I have with style sheets. Is this possible?

Hello everyone!. I'm a novice with FM, and I experiencing the following problem: I loaded a database on the web and configure it with the Instant Web Publishing Interface and noticed that images don

Hi All, Maybe one of you can help me. I am trying to run a script on a web page that facilitates online registration for exams. Within FM, my script checks to see how many people are registered for a given date and time, and if there are more than 4 people for a given date and time, an error message is generated telling the user to select another date. However, I tried to use this script on the web, and nothing happens. If an error is being generated, how is the web user supposed to recieve the news? Here is the tag I'm using online: <input type="hidden" name="-script" value="CheckClassFull"> Here is the link to my page as well: …

If you decide to access the link that I provided, you will be asked to enter a user name and password. You do not have to enter a user name, but for the password, enter "ccsu." Thanks!

I have a page at http://24.226.84.43/Queens_Ed_registration/pages/aq_new.htm that currently works fine as a static front end for a database. In order to make my popups work, I gather that I must access it through FMPro using the format: http://www.domain.com/?FMPro-db=name&-lay=layout&-format=filename.htm&-view In this case, that would translate to http://24.226.84.43/?FMPro-db=aq_online.fp5&-lay=devAllFields&-format=Queens_Ed_registration/pages/aq_new.htm&-view This (and a billion or so futile variants) simply takes me to an Instant Web Publishing Directory. If I turn off Instant Web in Preferences, I get a "Not Implemented..." err…

Using several related databases that are shared through Web Companion (most recent version of FM for Windows - 10 user version), we have a database that *seems* to change which password it is opened with . It may be that the database is closing and re-opening using a lesser password. Doesn't seem, however, that there are any "unexpectedly quit" database signs, like checking blocks etc. The database is called by others through a relation and is also edited directly through Web Companion. The database is shared through Web Companion with 3 users at a different location and 1 user who edits it directly at the host location via Filemaker connecting to it …

Bad Request The server could not process your request due to a syntax error. I just bought Filemaker Pro 5.5 unlimited. With mozilla and internet explorer everything works oke but OmniWeb gives that error. I don't know what to do because everything worked fine with Filemaker Pro 4.1 I searched in this forum and found about spaces but that is not the problem here. OmniWeb won't even load an url to an image.

I have my osX machine publishing to itself fine by putting the ip address in the browser. My os9 machine doesn't get it however. My osX machine file shares (through appletalk) to the os9 machine so I know there is a physical ethernet connection. Has anyone succeeded in this? Although my os9 machine can connect to the osX machine via appletalk, I get an error (Server not responding, try again.) when I try to connect to it by entering the ip address into the chooser. Could this be a symptom of the same problem?

I am wondering if anyone can help me out here. I remember using the Mac Version of FileMaker Pro 4.1 I believe and inside the web folder was a template for an e-commerce site amongst other things, including templates for Claris Page to build the needed html pages. I am now serving using Windows, but since the databses are cross platform this template would really help. But in version 5.5 the template no longer comes with the product and I no longer work for the company that I obtained Version 4 from, so I was quite disapointed when the old templates where not in the web folder of the newer version. Could anyone help me out and zip up the contents of the web fo…

I have a simple search page that returns a results page with FMP-Record tags to return multiple records. On that page I need to be able to edit one of the field. It does contain <P><INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]"></P> between the record tags and the form info before the record tags. Everytime I try to edit a record it edits the first record of the next set of results. Like record 26 if it returns 25 in a group or 11 if it returns 10. This shouldn't be this difficult and I am probably missing something simple. listview.txt

Is there a good source or documentation of what FM features work with WC and what won't? I want users to be able to create a new record in one database, with the first field being their auto-assigned ID #, which they will need to access a separate related database later in order to add data. The problem is the auto-assigned field shows as empty when accessed via the internet, although the data is there if I check the record on the server. Other fields involve calculations, and I haven't found good documentation on what features work over the Web. A layout might include a "submit" button, for example, that works if the file is accessed directly and displays but d…

I want to build a search over three fields and am not sure how to combined the first find with the second, and then the first and second with the third. Each step refining the search to a smaller amount of records. For example, first -find would result in everyone in a particular city (from the "city" field). The resulting page would not show results but allow the searcher to find everyone in that city (just searched for) that has a cat or dog or chicken, depending on the creteria they select in a drop down menu. The next page would also not include results but allow the searcher to narrow their search to color of dog: black, brown, white, all (for example). Each se…

Hi all - I know similar posts have been made. I have gone through them all and tried everything suggested and still have a problem. I am hosting three identical web pages all using different sets of HTML files and different FileMaker databases. The HTML files, including format files are in subfolders of the Web directory in the FileMaker directory. There are three subfolders, one for each of the web pages. The only difference between the HTML files in each of the subfolders is the FileMaker database that they reference in the code. The Filemaker databases are stored outside the FileMaker directory entirely. They are in a directory at the root level. When o…

Does anyone know how to make a script that notifies me via e-mail when a record is added over the web and how to start a script to send e-mail? Thanks,

Is that limitation of WebServerConnector or something fishy? We have set new server as IIS --> WSC --> Our Security Filter --> WC --> FM When we address the Security Filter on port 591 directly, everything works as always. When we are going through IIS and WSC, everything works OK, but not the passwords! There is no documentation whatsoever about WSC.