Other Internet Technologies

The long awaited release of "FX.php for FileMaker" is over. http://www.fmwebschool.com/php.htm The FX.php community is growing and FMWebschool is announcing the release of their latest book on web development with FileMaker Pro and FX.php. FileMaker web education for all levels of experience. Chapter 1. Introduction to PHP Chapter 2. Installing Apache Web Server Chapter 3. Apache On Windows Chapter 4. Apache On OSX Chapter 5. PHP Installation On Windows Chapter 6. PHP Installation On Mac Chapter 7. Getting Started Chapter 8. FileMaker and PHP: Introduction Chapter 9. FileMaker and PHP: Level One Chapter 10.FileMaker and PHP: Level Tw…

Is it possible to populate a "default.htm" page with records from the database without appending Filemaker parameters to the URL? I am trying to set up default.htm to carry 5 of the latest news articles from a database called news.fp5. I have added an inline action into the file but it doesn't seem to be working "[FMP-InlineAction: -db=news.fp5, -lay=main, -sortfield=date, -sortorder=descending, -max=5, -findall][/FMP-InlineAction]" Maybe I'm putting the inline action in the wrong spot in the file? Or maybe I can't do this? I'm just looking for to keep default.htm intact without having to redirect to a -find page or adding Filemaker parameters to the URL. Thank…

I know the web publishing on advanced server can do 100 users but heres my question.. What happends if you have a online store that has heavy traffic of sometimes 200 people on at once? Will it a)Allow the 200 people but maybe be slower than 100 since web isnt a constant send and recieve (I hope this is it) or b)Just simple not allow anyone else on (I hope not)

When I click the radio button to start instant web publishing in the FM Pro7 trial, it spins for a long time, then get a dialog that says "Cannnot share files because instant web publishing cannot be started". OS 10.3, 600 mh iBook, wireless tcp net Version: v7.x Platform: Mac OS X Panther

Hi, Instant Web Publishing is perfect for what I want, but I don't have a computer to leave on and connected to the web all the time. Anyone know of a service that lets you send them your filemaker database and they "instant web publish" it? not dealing with any critical information. Version: v7.x Platform: Mac OS X Panther

Hi there. I'm working on a database that holds survey answers and for statistical purposes it is really helpful for me to store each answer as a record in an answers database. The problem is, when taking the survey, I want users to be able to answer all 16-20 questions on one page and then create the 16-20 records in the answer database. I'm trying to get away with doing this without cookies. Can it be done with inline actions? I know I'm grasping at straws here, and I know there are some ugly ways to work around it (a submit button for each question, a seperate page for each question) but I'm posting in the hopes that there's something simple and elegant that I'…

I am developing an ecommerce website. I currenty have developed 2 databases that are related: one has merchants, the other products. In the products db, I have pulled in merchant information fields (ie. email, web address) etc. I have written most of my webpages, including one that will combine product information with merchant information. I wanted to display merchant information linking back to the product db (in the reply htm file,,,which already references the product db). When I try to put in the coding to display information from those fields pulled in from the merchants db, they don't appear. Is there a way to either display the related fields, or ref…

I'm assume (which might be my first problem) this is a really simple [FMP-If] statement I'm trying to do. I have several database fields that I only want to show on a web page if there's data in the field. These are standard text fields, not things like a checkbox or yes/no field. I would like to do something like: [FMP-If: FieldName .neq. null/blank] [/FMP-If] Or something like this. I don't want the field to show if there's no text in it, and to show if there is text in the filed. I know the syntax about wouldn't work, as it would look for "null/blank". Maybe I need to use an If, Else statement -- but I still don't know how to block a blank f…

Hello all, Don't know if this will make sense but here I go: I have couple of layout on a db that I am using, one is a detailed layout with all of my field and the other is a custom layout that we use to print out on. On my webpage that uses CDML I have the page looking at the custom layout. What I want to do is add a choose printer value list on the webpage so the user can select what printer to use. I have added the printer field to the deatailed layout and not the custom one because when they print it out I do not want the choose printer field to appear on the print out. Does this make sense so far? So in short, I want my CDML page to have the choose prin…

I want to create a form with a bunch of drop downs. There will be a dropdown list for each college, 30 of them. The drop down lists will show the different programs you can contribute money to. I want to have the drop down lists created from a related file so they are easy to update. Is there a way to combine the programs all into one database instead of having 30 different filemaker files? This would the perfect situation for a conditional dropdown, based on the college, but I could never figure out the javascript to make it work, so I am trying to find a simpler way to put the information on a form. I hope this makes sense, I'll attach my related file. Thanks. list.zip

Hi, I am having problem with editing global fields on the web. I have two db's: the first one is the list of users (User) and the second one is the activities they perform (Activities). When I open the second database, the login window pops up where I do have three global fields - gLName, gFName and gPass. If they match to the username and passowrd in the User db, then main window opens where I have a auto-entered calculation field "gLName & gFName". I am trying to do the same on the web - I ask user to enter his user name and password and then search for this record on the User db. If the record is found, I am showing the welcome message and trying to edit globa…

Hi there, Right after Microsoft released a security cumulative patch for Internet Explorer 6.1 (Q832894--http://www.microsoft.com/technet/security/Bulletin/MS04-004.asp) about a month ago After that my online clients can not use javascript based login like the one I have -->>> . var varjs; . . varjs = varjs + document.myform.mypassword.value + "@" ; document.location = "http://" + varjs + "domain.com/FMPro?-db=logo...... . . I may leave just the logon button in my form maybe without using text boxes for user id and the password but I'd like to avoid "Pop-up" login. Is there any workaround for this? Thanks for your time. …

Need help fast. Trying to use multiple tokes to transfer data across multiple web pages. I have successfully take one token across and have displayed it with [FMP-CURRENTTOKEN]. Can anyone help?

Hi, I am trying to combine javascript with CDML. On the first page the user enters some values which are stored as tokens. I pass those values in the link to the second page, and then to the third. On the third page I have two empty fields from filemaker db, which I want to populate with the passed values if the user clicks button. I am a little familiar with javascript, but I do not know if it is possible to combine CDML and javascript??? I'll appreciate any help. Thank you Jul

I've been trying to figure out how to get my CDML to work. For some reason when I load a page, all I get is the CDML tags themselves. I checked my databases and made sure they are shared using webcompanion. I have webcompanion enabled in my application preferences and I still can't get it to work. Is there anything I am missing in terms of getting my CDML to work? I have a simple HTML file with the following code: [FMP-InlineAction: -db=mytestdb.fp5, -lay=TestLayout, -Findall] [FMP-Record] [FMP-Field: myfield] [/FMP-Record] [/FMP-InlineAction] I have FileMaker Pro Unlimited on a G4 with Mac OS X. Any ideas would be appreciated... T…

Hi, I am trying to put 2 portals on the web page using CDML. At first, both of them were not displayed when I viewed the page in IE. The page was designed so that portal records will appear in a table. Then I removed the table and one of the portals appeared on the page. I did the same with another one - it didn't work. I double-checked the field names and relationships - still no results. I am completely lost. Does anybody know what could be the problem?? Thank you Yul

If I have a counter script that is used to count how many times a record was chosen from a list of records, how can I make a button using CDML to run the script and display the new results while sorting the list from smallest to largest? Basically what I want to do is have the viewer choose a from a list of general topics. Then a list of choices is displayed for each topic. Then by clicking on a button they get to vote for their favorite choice. The counter script tallies the voting for them. Any help would be appreciated. Thanks in advance.

I have a small page I post to keep clients up to date on the number of surveys received. Before I decided to dive into this stuff over my head, I used to put up a simple FMP layout using IWP. Now that I've switched to CWP, I need to set this page up from scratch. I have six fields, 3 are summaries of the number of surveys received, the number returned as invalid, and the number remailed with a corrected address. The other three fields figure the percentage of these three items. I set the fields up like this: <input type="text" name="Total_Received" value="[FMP-Field:Total_Received]"> When I open it in my browser, in the box where numbers should appe…

I'm logged into my FM solution using FMDev6. I've enabled my solution to IWP. I logged into using web browser. So now I have 2 users logged into my solution. One FM regular and one through the IWP. But FileMaker behaves like single user application, is that true? Found set, that is performed to webuser is also performed to FM user. It doesn't make a sence to have my solution on the web. Thanx for help. bzzi

Here is an example of managing a multi-page survey. Assume this is a returning user. 1. Find Survey: <html><head><title>Login</title></head> <body> <form action="FMPro" method="POST"> <input type="hidden" name="-db" value="surveys.fp5"> <input type="hidden" name="-format" value="menu.html"> Enter CaseNumber: <input type="text" name="CaseNumber" value=""> <input type="submit" name="-find" value="Find Survey"> </form></body></html> 2. The Menu Page: <html><head><title>Menu</title></head> <body>Survey Sections<br> <a href=…

Hi I've encountered a strange and annoying problem : I have a large DB with hundreds of users. almost all of them are using it through the web (html). I've made some modification to the DB to enhance web capabilities... It is working perfectly..sometime... Once in a while the users suddenly get a "access restriction" error message, and when I go and check the FMPU, most of the menu objects are suddenly greyed out....so...I restart FMPU and again it is working fine...for a while.. Any ideas what could be the cause to it??

Hi, I have a standard "record_detail" format with "submit" and "duplicate" buttons at the bottom. Hitting either button makes the appropriate changes to the database and calls the "record_detail_reply" format for to alert user. Is there a way to make the duplicate button instead call the "record_detail" format with the duplicated record opened? My users would like to be able to edit the new record immediately after hitting the duplicate button. Maybe set the button to perform an inline action? Just looking for a little guidance on how to do this. Thanks, Mark Durgee

If I have a field with some copy in it, can I get a url embedded it so when the field is displayed in a browser the will be a link?

hi there On http://www.phontastic.ch (then click on the "shop" button) there is a possibilitiy for a quick search ("Schnellsuche"). For instance search for "grimind" or "r

Help, I have a web form, long very long, I want to break it into 3 pages. One would enter data on 1st page, click next and will take user to next page to enter more data, clikc next and it will take them to last page of form and enter more data. THEN, would click submit and data from all pages would post on db as one record. I am not editing form. HOW can I accomplish this with out loosing data? ANY Suggestions or recomendations. Thanks

Hi, I am trying to create a web page for editing records using CDML. I can do delete and duplicate no problem, but when I hit edit - error page is displaed saying that "verify your submission, err# -102". Also when I am trying to edit a record only text fields remain populated from the FM db. Those fields that are pop-up lists became blank so the user has to choose value from the value list to populate it even though it is populated already in database. I am new to publishing FM on the web and these questions might seem dumb...I am really confused, Any help? Thank you Yul

I'm developing web pages with CDML. When I test I get a message that the referenced database isn't open, but it is. The db is in the correct folder, along with two others. Two of the three are not found, though they are open. One is working fine. I've closed and restarted the db and checked my coding, but its still not working. Essentially I think I've checked all the obvious things...including starting from scratch. Thoughts?

How do i retrieve a breakline from a field. When i put <br> it doesn't it actually display the "<br>" instead of doing the break line. Is there anything i have to do with field. It seems to no be getting HTML text from the field. Can anybody help me? Thanks

Before I did use the CDML tag below this one works. CDML: <a href="[FMP-LinkRecID: format=details.htm, layout=WEB]" target="_blank">order</a> Accept that I want a popupwindow which is 450px x 100px without scrollbars & in the center ect. Now you can see the JavaScript I use. The problem I have is that when the action is happend the wrong FM record is shown. (It is always the last record in FM) JavaScript using CDML tags: <script language='javascript'> var testWindow=null; function test(mypage,myname,w,h,pos,infocus){ if(pos=='random'){ LeftPosition=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100; To…

Warning: I downloaded the latest Web Companion. Now, Safari interprets the interface differently---it's all in rows. There is no evidence of the GUI from the original layout.

I 'd like to set up a search query requiring certain values to be true, and for one field the value should be one of 3 values. Thus, search for records matching: field A value = xxx AND field B value= xxx AND field C value= xxx AND (fieldZ = aaa or fieldZ = bbb or fieldZ = ccc) How is this done in CDML?

Does anyone have any suggestions on how to display a list of times and date you could sign up to use a room. It would show which times had not been signed up for yet, and would not allow you to sign up for times where it was already in use (like outlook does when you try to schedule a meeting)?

I have a portal within a form. I have a link in the portal to go to the related record. I use several tokens to pass to the related record and these are populated in the link <A HREF="FMPro?-db=Timesheets&-lay=WebForm&-recid=[fmp-currentrecid]&-Token.2=[FMP-Field: Tasks::Project]&-Token.3=[FMP-Field: Tasks::Site]&-Token.4=[FMP-Field: Tasks::Assignee]&-Token.6=[FMP-Field: Tasks::Issue No]&-Token.7=[FMP-Field: Day]&-Token.8=[FMP-Field: Month]&-Token.9=[FMP-Field: Year]&-format=te_new_task3.htm&-view"> Some of these are related fields from the portal, and some of these are fields in the form (Day, Month, Year),…

Anyone come across a good reference that does a cross comparison of what the CDML to LASSO equivalents would be. I have finally thrown in the towel and decided to start switching from CDML to Lasso. I have a pretty hefty time investment in a current solution. I am looking at around 150 web pages that I will have to start converting from CDML to Lasso. A good reference would be a GREAT asset. Larry

I'm attempting to use the following script to prevent users from deleting when this would result in orphaned records.... If [

Is it normal that there is no cdml file in the FMpro trial software ?

Hi, I've downloaded the Cdml tool from Fmpro wiste, can anyone tell me in which folder should i copy it and give me a practical example about how we use it ?? Do we use it within filemaker ? In layout mode ? Thanks for your help Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:

Hello, I am having an intermittant problem that causes a browser "Page Cannot Be Displayed" error on a reply page after a submit. I am using W2000 Server with IIs 5.0 and Web Connector and have a seperate W2000 computer with Filemaker Unlimited 6.0 and Web Companion. On the submit page in question I read the field data into a

I need to sort my result page so that the record that the oldest record shows on top, the second one afterwards, and so on. I found that if no sort field is specified I get just the opposite of that. I could use the ascending/descending sort option to solve this problem but "-sortorder" doesn't seem to work when no sortfield is selected. Any ideas? Thank you in advance

Imagine I have this link on a page: http://xxx.xxx.xx.xx/FMPro?-db=Database.fp5&-lay=Web&-error=errors.htm&-OP=gte&TIME=Afternoon&-max=10&-format=list.htm how can I show in the linked page something like this **************** on the afternoon we have: record1,2,3,4.... (all the records go here) *************** I know how to show the records from the DB but not how to extract the variable time=afternoon which is an URL variable. Does anyone knows? thanks in advance

Hello all, I don't know if this is possible but here I go. I was asked to create on our internal website an invoice. So, using CDML I created pages with Filemake to generate a billing invoice, which wasn't too hard to do. The problem now is that I'm being asked for this.... When a person fills out the invoice they just put in the billing info, like company name, address, what they need and so on. Then usually what they do is print it out and give it to someone in accounting to finish it up with the pricing info and to make any corrections. So my question is, how can you bypass the printing it out on the first part so the person can fill in the first part …

I am not sure if other users have done this, but there are times that I want to direct users to a specific DB record using a redirect script in my web pages. I use a redirect script or inline action. This then includes all the information such as -db, -format, -find and etc. The user then goes to the page containing this redirect, the script then redirects them to what I want them to see. Easier than me trying to provide them with a long URL. Cleaner than having to put a link on the page and make them click. Anyway, you can forget about doing this anymore. Microsoft just released a update Feb. 10th that makes changes to explorer on the PC. Anyone that applies this up…

Just need some tip on cdml search range. For example, I have some data range from 1990 to 2000. and let say I just want search anything between 1991 to 1997. How would I need to know? Thank you.

[FMP-If: Field: EvalrespondQuestionID::AnswerStatus.[FMP-Field: NumPortalEntries] .eq. 0] I have tried this and I think my syntax is wrong. Does CDML allow a [FMP-Field] inside a if statement after the field name? Thanks, Justin Grewe

Hello, I am using FM Server 5.5 to share my databases, however everyone in my company has access to the web companion. As far as I [color:"green"] knew there wasn't a limit on that. But the Prefereces say that there is a 10 ip guest limit. How do I change that so everyone, more than 10 people in a company of 50, can access the web companion? .....need.......help.....

I have downloaded and added a calendar pop up from www.softcomplex.com/products/tigra_calendar/ to my webpage. It calls a pop-up window with a calendar so a user can click a date and have it entered into the date field. But when the pop up is called, the window is created but then stops with this error: "Not Implemented The server does not support the functionality required to fulfill this request." Is there something with the web companion that does not support this? Is there a way around this? Thanks, Mark Durgee

Hi, is there a way to set this session cookie with an inline action: [FMP-SETCOOKIE: userid={FMP-Field:user_number}] I need to do it in another way because have a form that's delivered by FileMaker but is posted to another server entirely! thanks, jeff

Post deleted by Ptityop

I have a file that has the date formatted dd/mm/yyyy, but I want the user to be able to enter the date mm/dd/yyyy from the web form. ( I tried changing the database to use system formats but it gave an 500 error when I tried submitting data from the web form this way). Got any ideas how to do this ?

I am trying to create a field in a database called archive, where the user can check a record that is old. Then on the search page they can check the Search X-current records or X-archived records. If they click both then it should search both current & archived. I don't know how to code the check boxes so it will do search current & archived (it is just doing the or).

Hello all, I have a webpage that users input data into. This has a couple of checkboxes on it as well. After they are done they have the option to select Add record and then it brings them to the next page just to verify that all is correct before it sends it off. For some reason I can't get the checked boxes to show. I can get the other fields to show with no problem with the [fmp-field:field] tag but how do I do the checkboxes? Thank you.

I am creating just a simple basic cdml page and anything that I use CDML for is not working. Ex. [FMP-Record] or [FMP-Field: Name] Is web companion not working or am I doing something wrong. It's been a while since I used CDML since I primarily use XML so I'm sure it's something very simple. Thanks, Justin

I had posted a question a while back, but it was among those deleted by the hacker situation. Using the example below, how would I do two things: Use <input type="button" ...> instead of <input type="radio"...> and get the data posted the same as when using "radio", PLUS making the click sound, and change the look of the button so the person knows the button has been clicked. (I would prefer to use my own buttons to the ugly gray default ones.) I tried this, but it didn't work: <INPUT type = "button" name="Q2TRAD" value="1" The button changes, but the data does not go to the database. I have all the proper headers at the top of the page beca…

I have a page conatining a form to carry out a search and displaying results of an earlier search (search.html). However it is necessary to redirect users arriving at this page according to their browser (search2.html for IE5+, search3.html for Safari, etc). How can I carry the results of the original search onto the page to which they have been redirected but not to the new search results page (search_results.html). Is there some way of including an [FMP-Link] tag into the redirect javascript in the header? The browser seems to stall on search.html when I make [FMP-Link]&-Format=search2.html my redirect url. Does anyone have any suggestions?

Hi, I'm using FileMaker 6.0 in combination with WebCompanion in order to have a website in which people can subscribe to our organization. A visitor fills out a form, submits this. FileMaker creates a new record, and I want FileMaker to send a confirmation e-mail to the subscribed visitor. Is it possible to have FileMaker automatically to trigger a script each time a new record has been entered? Looking forward to your remarks... with kind regards, Rob

This is my first post to this formun, so bear with me, folks. My problem: 1. The database is located on one server with a unique IP address 2. The format file (format.htm) is located on another server with a different IP address. Can I devise a FMPRO? statement that a) first directs the <A HREF..> statement to the database (-db=) and then to the location of the format file. Thanks much. Dan Landis [email protected]

Hi Guys, I'm new to Lasso 7, lemme get that out of the way. I currently have two databases hosted on-line that incorporate CDML. Whereas in the past I could leave these pages unprotected on-line, it's become apparent that I will need to up security on them, which has lead me to Lasso. I've been friddling with it the last day or so and I think I have the basics of it down to some degree. I'm at the point though where I would like to use a login/pass popup for my on-line databases as a security measure. Here is where I'm hung up. Will I need to convert the CDML to LDML on said pages? Create these usernames and passwords using the Lasso Administration tools? Can someon…

Hello, I'm trying to figure out how to get the Previous/Next links to work correctly after an Edit. First, I have a page that lists names based on the results of a search. One can click on a name and be taken to the Detail page for that record. The detail page has Previous/Next links at the bottom that allow one to navigate through the Detail pages without going back to the List page. On the Detail page, one can also edit the record. Here's my problem: I want people to be able to click on Edit, and then be brought back to the same Detail page with functioning Next/Previous links. However, after clicking Edit the Next/Previous links are no longer accurate when one is b…

I'm trying to create an FMP-If..... FMP-Else.... statement to do the following; If the field 'Abstract' is empty (contains no text), to return the value 'Not available'. If the field 'Abstract' isn't empty (contains text), to return the value 'View' as a hyperlink to another page. The same applies to a second field, called URL. Is this possible?

Our web site uses FileMaker to power a company store. One of the databases is the CUSTOMER database. When someone places an order, they fill out their information (first name, last name, address...) and most of these fields are "required values" in FileMaker. If someone does not fill out a required field they get directed to the -error page which reminds them to fill out the field. We decided to collect an additional piece of information: "Additional Attendee Title". I added the field to the CUSTOMER database. It is NOT a required field. Then I added an input area for the field to the web page where the customer fills out their information. If this input fiel…

TOKEN QUESTION HTML code for Sellers02.html ========================================================= <input type="hidden" NAME= "-Token.0" VALUE= [FMP-Field: zip]> <br> <input type="hidden" NAME= "-Token.1" VALUE= [FMP-Field: address]> <br> <input type="hidden" NAME= "-Token.2" VALUE= [FMP-Field: password]> <br> <input type="hidden" NAME= "-Token.3" VALUE= [FMP-Field: namefirst]> <br> <input type="hidden" NAME= "-Token.4" VALUE= [FMP-Field: namelast]> <br> <input type="hidden" NAME= "-Token.5" VALUE= [FMP-CurrentToken:5]> <br> <…

I am not sure whether to use an "inlineAction" or javascript to perform this action. Basically, I am using a database that keys off a date in a global field which provides the link for portals. Thanks

is there are way to set the search criteria of one field to a token at time of submission. 1. I would like to state after the results are displayed that 'xx records have been found for the search for ( token) - I know there it the FMP-CurrentFind, but that list all value hidden and other which is not import for the user to see. NOTE!! I am sure I could capture the resulting field as it returns in the format file, but in this case the field being requests is keywords, so the result is not a single words. 2. I would like as a token as well so I can send it back to the DB to log the search words.

I am new to FM and am trying a few things to see how it works. I set up a site inside the web folder. I placed a database in the web folder as well. I want to link to the database from a html page inside the web folder. i want the database to launch in my browser, IE. I followed the instructions and have set up my computer to be a localhost, using web companion. When I tried to link to my database, I get a dialog box that states that the file cannot be located on the server. What is the code I need to place in the html to launch the database? Any help would be much appreciated.

I am trying to include a simple check box on one of my forms. Basically I want it to return a value of 1 if it is checked, and no value, or a value of 0 if it is not checked. The CDML reference guide had an example... <input type="checkbox" name="Country" value="F1">France But I dont quite get how to change it to fit my needs. I assume in the example above that if the box is checked then F1 is input into the FM field called "Country." So If I want a 1 to appear in my field if it is checked would it be something like this: <input type="checkbox" name="FieldName" value="1">0 LR

Hello all, I recently took over managing our website that has more than a few links tied to a FM database, I am not very FM savy so please forgive me if my explanation is a bit vague. We have a link on our site that is a sign up sheet for lunch time seminars, after you go to the first link you have a option to sign up or view the sign up list via a hyperlink. Okay here's the link for them to click if they want to see the current sign up list and this is where I receive the error(No Records Found: Modify your search criteria and try again.) <A HREF="FMPro?-db=seminars.fp5&-lay=detail&-format=results.htm&-max=6&rec_id=[FMP-currenttoken]&-fin…

I am thinking about a solution in which i want to have a relation build on a dynamic field value. That is not a problem. However, 1] this dynamic field is updated through a CDML form and then 2] the user can retrieve the related files from the portal. Now my question is : i their a risk that after the submission of the edit command of a field value through cdml and the next command is retrieving the portal records through cdml that some related records are missing because filemaker is still updating the related records. (* or is this just a nonissue ?*) Thanks for all your support Jitse

I appoligize for asking a non FileMaker question, but I don't know who to ask and figured you guys would have a suggestion. I am looking for a cheap web hosting service, for my personal use so that I can teach myself how to use MySQL with either PHP or ASP.

hi, thanks for your help. i'd to make a simple edit to multiple records at the same time, using a valuelist, radio buttons or checkboxes. is this possible? appreciate any input!

Hi, I am trying to improve a custom publishing CDML solution. The dbs consist of a main file and a related file. On the FMP layout of the main file there is a portal showing one or more related record. This is a data entry db and data will be entered in the main record and in the (already created) related records. On the CDML page I display the data in a very similar way, showing, at the top, in one form the fields of the main file followed by the related record's fields in their own forms. So I end up having at least two forms per page, usually many more than that. I was asked to make it so that all the forms can be submitted using a single button. This wa…

I have coded checkboxes where the FMP-ValueListItem tag draws the values out of the database. However, this particular value list has about 200 items on it, and right now it's formatted with a break <br> after each value item--but the page is still really long. Is there any way to format the Value List so that possibly a table can be created of the Value List? Possibly with two or three columns? I'm not sure if this is possible. This is the code I currently have. It all takes place within a single table cell right now, so I'd like to add a table within this cell if this is possible. <TD colspan="3" height="33"> <p><font s…

hi, im sure my cdml language is a bit rough! i'm looking to pick several records from a find list using checkboxes, then transfer only those records to the next page. can this be done with out multiple 'finds', does this require tokens? also, besides the cdml reference db, is there other documentation that gives examples and more expanded info on tokens? im a newbie, and i think tokens will help me, but i need lots more info! thanks.

I'm using FMP6U on XP with CDML. All the required fields that I have that are text fields work fine - requiring that something be entered before processing...yet the fields that are checkboxes are NOT requiring an entry even though I have them set up in Filemaker to do so. Any idea or explanation as to why it is doing this and how to get around it? Thanks, Bruce

I am having a problem in FM 6 that this techinfo article describes perfectly (108421). ISSUE: The Web Companion in FileMaker Pro 5.0 and FileMaker Pro 5.5 does not recognize the field validation option to require that a field be 'Not Empty' when creating a new record through custom web publishing. If a new record is submitted through a custom web publishing link or form, and no value was entered for a field set to "Not Empty' in it's validation options, the record would be created and no error would be displayed to the web browser client. Databases published using Instant Web Publishing were not affected by this limitation and under the same circumstances using I…

I'm not sure this is possible given the limitation of the FindAny CDML tag but here's what I want to do... I want to pull a random record from the database but want to include specific criteria about which records to be chosen. Anyone know if this is possible? Or does anyone know another way other than to use -FindAny?

Is there any reason why records are still getting created after submitting and getting the error page? Normally the errors are that users are inputing the date fields incorrectly, ie 31 days in months that have less 11/31/03 or 2/29/03 thus getting sent to an error page. The problem is that new records are getting created upon every error.

I have created a site for a client and it is all CDML driven. Now one of thier clients said that they could not see the site because thier company firewall was blocking it. Is there a way to avoid this from the developers end. Is there something I can put in my clients pages to avoid the problem.

Hi I need some advice regarding Lasso error reports. For example on a form with 10 fields, all required, the user forgets to enter data on one of the fields. How can I on an error page, identify that particular field that was left blank. Or in case the entered data is incorrect on a specific field, how can I alert the user that that particular field has incorrect data. Thanks Daniel

Lasso 3.6.6 and MacOS9 w/ FMP6. Can you update related fields using the Update action? Example: <INPUT TYPE=hidden NAME="-Database" VALUE="Orders.fp5"> <INPUT TYPE=hidden NAME="-Layout" VALUE=Test> <INPUT TYPE=hidden NAME="-RecordID" VALUE="[FMP-FIELD: 'recidnum']"> <INPUT TYPE=hidden NAME=Status VALUE=Closed> <INPUT TYPE=hidden NAME="-UpdateResponse" VALUE="CheckOut.html"> <INPUT TYPE=hidden NAME="-Response" VALUE="CheckOut.html"> <INPUT TYPE=text NAME="Account Number" VALUE=""> <INPUT TYPE=text NAME="Customers::Email" VALUE="[FMP-FIELD: 'Customers::Email']" > <INPUT TYPE=submit NA…

Hi I got a simple JS calculation on my page and I need to insert this calculation to a link raw example : "http://fmp:591/blahblah..&-token="js result"&..... where the "js result" is a simple variable within the script.... I tried many many sevral ways...no luck... is it possible?

Hi, I've got some calculation fields that do some complex calculations to end up at a dollar amount. The calculation itself uses the Round() function to trim to 2 decimal spaces. And I have the number format set to 2 decimal places as well. All the numbers show up fine on filemaker layouts, but when I put them on a web page: [FMP-Field: QuoteQty1Amount] Some amounts show up with more than 2 decimal places. Is there a way to prevent this? Thanks,

I want to disable an inline action. Suppose this peace of JS code in a top frame i have a variable perform=0 in a data frame i have this peace of code if (not perform) { [FMP-InlineAction] [/FMP-InlineAction] perform = true } Now the first time this page is called the inline action is excecuted. The next time this page is loaded by the user (in the same session) the page should be loaded but without the inline action. My Q is this : does the if statement indeed stop the inline action from executing after the variable is set to true. I did some testing my self and i think indeed it works, but i am not sure. Can any o…

I have a form which the user fills out on the web, but whenever they press the 'Enter' or 'Return' key it executes the "Submit" action (which actually edits a record in the database.) I really only want the form submitted by clicking the "Submit" button. Is there any way of disabling the 'enter' key from executing the submit action?

I have a related double-clicking problem, but mine is not generating multiple new records. I have an error and an access log and can trace the problem as follows: when a user clicks multiple times in the same instant (e.g., three clicks in one second), it causes the "database not open" message to appear. Filemaker continues to run behind the scenes, but with no more web access. It takes the computer being restarted in order to clear the problem. Looking at the error log, it records that an "HTTP session has been connected" in the same second that the multiple click happens. Now, I guess I could put that javascript code in every page to prevent the post from be…

Hi All, Just starting playing around with Lasso. I've downloaded the demo and have been learning quite a bit along with the help of Duncan Cameron's book - and the neat LockIt login system. I'm at a point now - and I'm stuck - and looking for some help. I have a database that has a jobs list with each record tagged with a unique 8 digit code. In my other database, I have a list of users with their 8 digit code. There is also a 'super-user' field that I will key in all codes that this user also has access to. On my webpage, I have 2 links: "My Jobs" (when clicked shows the user a list of their jobs) and "All Jobs" (when clicked it shows them all t…

Please excuse me being new to publishing a FM db with lasso but I've started to learn using lasso and I'm running into some problems. I've made a .lasso page which can update a record. The record is specified by a unique fieldentry. Until now all goes well and the page displays the correct information. But when looking through the HTML source in the browser I can find the record id for the currently displayed record. Of course this is an major security problem since people can now easily request the page with a ?-RecordID= and change data. How can I limit this? Thanks!

Hi, How would you define the function for java script <SCRIPT language="JavaScript"> <!--hide function newwindow() { ...................... } //--> </SCRIPT> for the following <a href="javascript:NewWindow('[FMP-Link:r]&-format=magnify.html')"><img.... Thanks,

I hope I am asking this using the correct verbage. I cant quite figure out how to do the following... Web page (CDML) that does a find. A found page is then displayed. That page contains some text from my FM database found record as well as a link( generated by the FM database). The link is to a external JPG file on a ftp server. As it sits right now, that link is programed to open up the .jpg image in a new browser window. The only thing that gets displayed in that new browser window is the external image, no FM / CDML data. Here is what I can figure out how to do...I would like to include in that new browser window some of the text imformation that is in the f…

Hello All..... I'm trying to get an FMP-If/FMP-Else statement to work. From the FileMaker site, I found this: [FMP-If: (Field:name.Eq.david).or.(Field:name.Eq.dave)] Welcome David! [FMP-ElseIf: Field:name.Eq.eric] Hi Eric! [FMP-Else] Hi Stranger! [/FMP-If] Even though I've tried to follow this code for my solution it doesn't work. I would also like to add an .or. statement to the Else line (if that's possible). This is my code so far. What it should be saying is if the event isn't full or you are allowed to register, a button appears to proceed to registration. If the event is full or if you are NOT allowed to register, a statement appea…

I'm trying to export a text file that is based on the record the user is viewing via the web interface. I will be using the text file to import the information into another program so the file has to formatted exactly right. I have calculation fields that put all the information I need into a comma seperated string. For each file, I need 3 of these strings on seperate lines. example: /SOHDR,USMOWER,O,31010,35205,35205,7/21/2003,7/21/2003, /SOLI,P,USM-250104,"Mount, Pivot Base, Mach",,,6,0.00,0.00,0.00,2,N /SOSUM,,,,0.00,0.00,0.00,0.00,0.00,0.00,US MOWER,ADDRESS Those 3 lines are each contained in seperate calulated fields, I need to export them t…

I have the my hosting machine setup with remote admin w/password turn on. When I use the url to open the file I still get a password dialoge box even though I have entered the '-Password=secret' tag. Any suggestions?

Basically I have a database of schools, teachers and students. When doing a search for a specific school, for example, I would like to see something like - Teachers - Mrs. Red - Mrs. White - Mrs. Blue Boys - Larry - Mo - Curly Girls - Hope - Joy - Faith Instead, what I get is - Teachers - Mrs. Red Teachers - Mrs. White Teachers - Mrs. Blue Boys - Larry Boys - Mo Boys - Curly Girls - Hope Girls - Joy Girls - Faith What modification do I need to make to my format file so that the category (Teachers, Boys, Girls) does not repeat for each record? Thanks in advance!

Calc field - External ("Web-ClientIP";0) or Text field - Autoenter - by calculation - External ("Web-ClientIP";0) They both register the IP adress of the person creating a record, but when later changing the record, the IP adress is not registred. According to the manual: External ("Web-ClientIP", 0) Returns the IP (Internet protocol) address of the Web user whose HTTP request is currently being processed by FileMaker Pro Web Companion. Do I misunderstand 'HTTP request'? Is creating a new record different from altering it? Or is this another 'IWP oddity'? (Note, that the manual says "Web-ClientIP", 0) (with a comma) and that the …

Hi, Is there a way to remove spaces from a field? I am using firstname and lastname fields in a url to pull up a search page, if they enter a space in the field by accident when they input their name, the url which is created from that is broken. I don't know much about scripts, but thought maybe it could be done. http://www.url/xmas/FMPro?-db=card&-lay=data&-format=[FMP-field: format]&-error=search_error.htm&-op=eq&firstname=[FMP-field: firstname]&lastname=[FMP-field:lastname]&-Find Thanks for the help.

what do I need to admin a cdml site. The files are being hosted on a PC (fmp6) web companion has remote admin with password turned on. So now on my remote mac what is require? I am assuming that I can get a browser interface to open and close files. Is this true?

I get a "The page cannot be displayed" error when I browse to the internal IP address of the server where I installed FMP 6.0 (http://internalIP:591). It works fine if I use (http://localhost:591). I installed FMP in a subfolder on the server (not in the root) and I put the FMP database I want to publish to the web in the same subfolder where I installed FMP. I'm using TCP/IP and the server has a fixed IP address and is running NT. I opened the database from my desktop over the network. Did I miss something? Everything I read says that if it works under localhost, it should work.

Hi! I have an odd (perhaps dumb) question..... I have an opportunity to upgrade the computer that has the Web Companion software on it from a G3 384 MHz to a G4 700 MHz. The FM Server machine is still a G3. My question ---- for faster access from the web, would it be better to use the one G4 that I have to replace the Web Companion computer or the FM Server? Again, I'm looking for faster access via the web not in-house. Thanks! Donna

I have a database which has a field that is in HTML. If I export it and view it on a browser, it works fine, but if I try to show the field via CDML, it shows all the code rather than processing it as code. I have tried to replace the code (the < >) with a global field that has that code in it, but it doesn't make a difference - it still does not work. I know that I could create a CDML page that has the same properties as the field, but one of the combinded fields is a long field that has returns in it (the final output is for news stories online). Is what I am trying to do possible? If so, how? How have others done this? Thanks in advance for yo…

We are using CDML in form tags to allow the web user to do a search on a FM database. We're hosting on an e-Mac running OSX 10.2.8 and FM 6.04 Unlimited, and using web companion as the sole webserver (we get less than 1000 hits a week). We allow the web user to enter text into a form text field which we use as a search parameter. The submit does a find and then returns the results to a format html file. (We've followed the CDML examples) Here's the problem: Safari returns results correctly. Explorer returns 0 records found. Anything we should be looking at particular to Explorer? The code has been checked and rechecked. Any one have an idea? Thanks for your help. I…

Hi, What is the syntax (if there is one) for structuring a not equals in a CDML URL to FileMaker???