Other Internet Technologies

When I do a search in the browser which is accessing FMP via WC, FMP stays in the find mode and does not return to browse. Has anyone come accross this?

Hi, You guys have helped me in the past, so here goes. I used the filemaker connection assistant to make my format files, I check the edit individual records & delete individual records box's, but the program does not create the format files for these functions. Any ideas on what I can do? I can search and add new records with no problem to my database on the web. But i also need to be able to delete records and edit existing records. I get lost when i look at doing this by hand in cdml. Is there a CDML for dummies book? Thanks for your time, Wayne

Hi..... Is it possible to use the FMP-If command to check whether or not a field has been filled in on a form? I basically don't want the user to be able to go to the next screen unless certain fields are filled in. I know that I can restrict the field in the database, but I was wondering if the web form could check this for me. I have an example in JavaScript but I don't know how to make the reference to the FM field. Any suggestions? Thanks! Donna

I've been reading about getting started with CDML on TechInfo Knowledge Base and I've managed to get the quick test to work. But what I really need to know is if using CDML I will be able to search a filemaker database on the web. The user would have some filters on the webpage to search and after he entered the submit button there would be a report webpage with the information he asked for. Is this possible to be done using CDML ? If not , does someone know how to do it using something else ? I use windows, Filemaker 5.5 and 6.

Does someone know where could I find a list of all the Filemaker Pro codes called CDML ?

Somehow i have the feeling that i am doing something that is not allowed (with filemaker that is). I have a form action to edit my records in a database. Within this form i have made a table for input of FMP fielddata and presenting other data form the record i am editing. This all works great. Now i came up with a code that makes me change the contents of a textarea by moving the mouse over a reference. So, within the table i have one cell containing a <textarea name="updateme"> I also have a reference made: <a href="#" onMouseOver="window.document.myform.updateme= "yes it works"> When i put the textarea outside the form it works ok. wh…

I've searched through the forum archives, and haven't been able to locate any information on this subject. I've got two databases, and the portal from the main to the secondary database works on the web page as intended. The data is correct, and editing the data is no problem. In FileMaker itself, the value list works in the portal. But I can't get that value list from the secondary database to show in my web page. A value list from the main database works, so I'm wondering if there is some different CDML coding I need to use (I'm using FMP 5.5), or if it isn't possible to get that portal value list to appear. I guess if that's the case, I can always create …

I have a form that is submitting to a Filemaker 6 Unlimited database. On ceertain Windows 2000 machines, it pops up a dialog for "syntax error and cannot process the form. Any thoughts?

Hi Is it possible to perform a 'constrain found set' find from a results page of a CDML search? This feature has been introduced in FM 6 - I was wondering if there was a way to do it with CDML? I have thought about calling a script in FileMaker but cannot get this to work reliably Cheers Hal-b-j

Hi Lasso people! I'm attempting to ask a million and one questions on this Lasso board, haha! I've looked up the "LDML 3.6.6 Reference DB" to find the LDML substitute for the CDML [FMP-CurrentRecordNumber]. But I can't find it. And my "CDML_Tags.mod" module doesn't seem to be able to understand the [FMP-CurrentRecordNumber] so it just leaves a blank space on the web page, where the appropriate "record number" should be..... Can anyone please help me? Thanks!

Dear princesJo, are you willing to share your working valuelist application as was discussed perviously in this forum, with me. many thanks Jitse

Hi there I have a question regarding a conflict I came upon. I made the following code: <script> cdml_1 = ("FMPro?-db=Accesses&-format=index.html&all="); cdml_2 = ("&-New"); cdml = (cdml_1 + content + cdml_2); window.location = (cdml); </script> where content equals a variable calculated in a javascript function. In internet explorer (I've tried both IE 5 and 6, both in Macintosh and Windows) it works great, and I get the info posted on my database in FMPro. When I try it in Mozilla (in linux) or any Netscape from 4.0 to 7.01, it "hangs". Anybody knows a "workaround" for this? Thx in advance.

Hi All! Situation: I have a web database that I have prgramed to create all HTML & JavaScript Coding. This database is currently setup for the USER to select the "Database", Select the "Layout", then select the "Field(s)" they want to make available on the web. Once they have done that, they hit a button that say's "Send to WEB" and BAM! it's a done deal. Problem: I had to hard code the names of the Layout Names in a script that will export the field with all of the WEB language in it. It's not that bad, but I would like to make it more dynamic by taking the "Selected Layout" and using THAT as the file name of the exported file. …

i want to get free my own FM data base with webcompanion. It works in our intern net but another user cant find it on the web. why?? the port is 80 and we use adsl. thanks for answers

Hello, I am trying to see if anyone has experienced a problem with the look of their DB using instant web publishing (FM 5.5) on different browsers. I am using a entry-only layout for my DB. The layout is perfect when viewed with Internet Explorer 6.0, but horrible with 5.5. I don't know about other Explorers. The entry-only page looks o.k. with Netscape, but is still not perfect (ie. some fonts change, text boxes misplaced) Is there a way to solve this problem. I was suggested to use cascading style sheets to change the fonts. However, since the HTML for my entry web page is generated by FileMaker is it possible to add in HTML code to solve the problem? Is there anothe…

I have a file where there are some scripts where the user can search for dates and see report layouts. The scripts don't work when using the browser. Why ?

Hi, I'm trying to figure out CWP, and would really like to look at the example they use in the CDML tool, guest book.fp5. Does anyone know where I can download it? It says it should be in the web folder of FileMaker 5, but I'm using 5, and all I have (had) in my web folder was a file called readme.htm. Thanks, Jo

Hey all, Me again. I've been chugging along on this CDML stuff, which for the most part seems to suit my needs. But, I've run into a situation where conditional pop-up menus are necessary via web entry. I've learned this is not possible via cdml since the web form needs to post back to the db before it can alter the lists. I was going to work around it by dividing the html form process into two separate pages (one which submits the initial data the the other which edits it using the conditional value lists). But, this will not work because my conditinal list is based on related values (another thing CDML does not deal with it seems). So, …

i am sorry that i have to ask this question, but i have been looking in the web for the last 7 days to get an answer - for hours here in the forum - without any result. i simply want to show some record fields frome my database in the browser (using ie5). as only result the browser just displays the cdml-tags as plaintext. i am quite sure i did all the preferences with the webcompanion properly and the database is running. what have i done wrong?

I have made a form for editing a record using the standard approach. On the web page i see a button (edit) which does the work (when i click the record is updated). Now instead of the button i want to use a graphic object (which is a file, forexample calculate.gif). I have been playing around with href commands but this did not work. Could anyone show me how to get my graphics object have the same functionality as the edit button in the edot foorm of filemaker. Thanks Jitse

My question is probably so basic that no one else has needed to ask it here--at least I couldn't find the answer... I have a format file with a portal on it. The portal works fine. I'd like to display each portal row with alternating colors in the background. I know how to do this using an HTML table and style sheets, but how can I do this with the portal? I can't figure out how to alternate the color based on the style since the same style info would be repeated for each row of the portal. I'm sure it must be fairly simple, but the solution escapes me. Thanks!

Hi everyone, I hope you can help me with this one. One Mac with Webstar 4.5, Lasso plugin 3.6.6, Filemaker 5.0.3 and Webcompanion 5.0.6 on Os 9.1 Another Mac with Filemaker server 5.5.1 on Os 9.2.2 serving all databases The first lasso page using an inline is served ok. But Webstar won't listen anymore to more requests. And it hangs when i try to quit webstar. But when i open the same databases directly in filemaker client, then there is no problem and every page is served ok. So it seems that the link between client and server is behaving strangely. I tried switching from appletalk to tcp and back. The same problem is occuring with fm server 5 but …

Hi there, I've a big problem and I hope you could help me to solve it. In a few words, I need to comunicate between a Flash movie and a FileMaker database. I've seen the CDML syntax and now I'm able to retrive data from the database getting that information in XML format using the parameter: format=-dso_xml. My big problem is how to add/modify information on the database. I know I could use the -add or -edit parameter as specified on CDML systax but I would like to post the information to the database directly as XML. And if it isn't possibile, is there another solution? In some conditions, the Flash movie contain some record in XML format and I would like t…

Hi, I've searched through the archives but haven't found much that helps me. I just want a drop down list on my search page, it sounds like such a simple thing I have the drop downs working on my edit page, there is no problem there, but I've tried everything I can think of for the search page, and it normally just comes up showing the actual text. I found this in a previous thread: "For a new record or search it should be: <Select name="field name here"> <option value=""> - No Selection - [FMP-ValueList: field name here, List=value list name here] <option [FMP-ValueListItem]>[FMP-ValueListItem][/FMP-ValueList] </Select&…

Platform: E-mac G4 System: 10.2.3 Server: Apache 1.3 Database: FileMaker6 Unlimited Lasso: Version 6 Question: How do you allow a browser to choose a search operator on a field and have it operate on that field in an inline search (in a different format file), preferably in Strict Lasso 6? The <select name="Operator"> <option value="eq">equals</option> etc

Hi there, I've a big problem and I hope you could help me to solve it. In a few words, I need to comunicate between a Flash movie and a FileMaker database. I've seen the CDML syntax and now I'm able to retrive data from the database getting that information in XML format using the parameter: format=-dso_xml. My big problem is how to add/modify information on the database. I know I could use the -add or -edit parameter as specified on CDML systax but I would like to post the information to the database directly as XML. And if it isn't possibile, is there another solution? In some conditions, the Flash movie contain some record in XML format and I would like t…

I'm looking for help with a problem getting the -mailTo set of tags to work consistently within a html form. I'm using version 6.04 on a Windows box. The form in question is intended to allow the user to enter their subject line and message to be broadcast to a list of email addresses that have loaded with the page from a portal in the user's record. When the user submits the form the message body is entered in a global field (using the -edit action tag) which is ultimately contained in the -mailFormat text file. The html seems well formed and works as expected with some records but with others the edit occurs correctly but no email messages are sent. No error's a…

I need to run a script immediately after a record is created from a form. I am wanting to do this using a refresh-redirect page that executes the script. So far, I have found examples of script execution from forms (buttons)and links, but I haven't seen this done using a redirect page. My best (bad) guess at the refresh code is: <META HTTP-EQUIV="refresh" content = "1;URL=FMPro?-db=NewHOSC.fp5&-format=HOSC_Success.htm-error=HOSC_Error.htm&-NAME=-Script&-VALUE="SetCalculations"&-recid=[FMP-Currentrecid]&-Find> Can someone please show me an example of this that will work? Also, if there is a better method of doing this, I'd apprec…

Hi, I'm trying to find a way to keep a search, if that make sense. Once a person has done a search for a set of records, they will from then on only need to see those records. The found records display in a list, and there is an 'edit' button for them to edit it, but after it's edited, I want them to click a button to go back to the current found set. Any suggestions on the way I should go about it? Thanks, Jo

Hello, can anyone help me figure out how to get text fields created by the lasso site builder in GoLive to become text areas? Basically, alot of input to my database may be hundreds of lines of text, and I want my add and update pages with text input to be formatted as large text boxes with scroll bars. How do I accomplish this? The only text area object I see is in the regular GoLive form builder outside of the Lasso objects. Thanks in advance for any suggestions.

I am creating my first FM database for a Resume/cv database and with scripts, managed to create an email button which when clicked goes to Outlook with the current record info I requested .. so far so good. ( this is so clients can request a persons c.v via email) When I have listed what fields (including the email field/button)to upload thru Web companion the "send email" area has reverted to a blank field and is "unclickable" and doesn't work. Is there an easy way for clients to request a c.v while viewing the summary data I have load into the web page FM supplies?

Hi everybody, I have some problems about my databases on server. They sometime closed but i dont know the reason and some times closed because server machine has been reseted. So my databases do not work in that stuation. I can not use startup items method because problem is i can not reach filemaker if the databases open via startup items folder. So i tried to use -DbOpen CDML tag but i did not work. What do am i do now?? Please help me. Best Regards Adam Djuby

Hey everyone! FYI While surfing the web I found a new program called "wData Builder" from a company called AppMac (www.appmac.com) that helps in creating CDML links and is a basic FileMaker-friendly HTML editor. It doesn't have a graphical front-end, but it still could be helpful to those who are just starting out. For one, it has the entire CDML library built in as a list of commands and links directly to the CDML Reference database for help. Pretty simple app, but I think it might be nice to have and it's not too expensive. Let me know what you all think. -Jeff (I do not work for, know anyone who works for, or receive any kind of compensation from AppMac. Excep…

Hi, I'm trying to display my database in a list, with columns. It seems like such a normal, simple thing to do, but it's not working. I'm using the CDML tool etc, but playing with things myself. I've tried putting the form in the table and putting the table in the form, but nothing works. The best I have is after the search, the first record shows in the table, then the others are just in a list as text underneath. With it working this way, when I 'start', with it using that htm page, it shows none of the details, just the link that I have in the left column of the rows. I'm assuming this is connected somehow. If anyone can let me know what I'm d…

Hi all! I've been searching here for an answer, but there is so much good information that I keep getting side tracked and haven't found anything specifically on this topic yet, so sorry if it's a repeat... Scenario: Two files, "Clients" and "Jobs". "Clients" has two fields - "Client_Name" and "PK_Clients" (the primary key). Both fields require unique values. "Clients" has a value list which uses values from the field "Client_Name". In my format file, I have a popup menu that uses the value list for selection. This all works fine so far. What I want to do but can't figure out, is how do I make a selection from the value list and then search the file "Jobs" for r…

I am performing a search using: <input="hidden" name="-Op" value="eq"> The search is working basically correctly. If I search for "Smithsonian", then it finds it. But it will also find "Smithsonian - African Art". How do I constrain the search to find only exactly what the original search string is? The field that is being searched contains only unique values, but when indexed, the separate words cause the search to find more than one result. Thanks again! Ken

Sorry I know this is kind of a repeat, but previous answers didn't help me. I'm running filemaker server on OS 9.2.1 and I can't get web companion to stay on. I know I'm supposed to take the database down from the server and open it back up in filemaker pro on another computer (This is the advice I've been given so far). Once I do this, and go to File, Sharing, I'm not able to select Web Companion. The single user option is selected instead of the multi user option and I can't change this. If anyone has any advice I would really appreciate it. I'm sure it's something simple that I'm overlooking. Thanks!

I'm hosting a FM 5.5 database published to the Web (IWP) from a G4 with a static IP. Generally things are OK, but the client wants more functionality--like printing reports. I should be able to make that work with a layout in "table view" in the browser, except that the browser shows no vertical scroll bar and prints only ONE PAGE even if there are more records listed. Is this a limitation of Instant Web Publishing, or of the browser? (I'm testing with IE 4.5.) Anyone know of a workaround that doesn't require me to learn HTML? One other glitch: If the client does a search for a set of records, then edits and "submits" one of those records, the found set is lost.…

Probably an easy one... I have an e-mail DB that can send + receive using a commercial plugin. Amongst other items, the message of the email is contained in a 'Content' field. When a plain text message is received this is correctly rendered to the browser using a -field tag. But when messages are in rich text/HTML format these are also only rendered as text. The question is - how can these messages be shown correctly? Any ideas?

I want to make a connection from Dreamweaver UltraDev to FM5. Macromedia says that there is no mac only solution. There must be a way. Any ideas?

Hi Everyone! I'm back again with more goodies! Scinario: I'm creating a pop-up window for searching within' a database. I've managed to create the following: Field Name Selection (drop down list) Search Operation (drop down list) Text Field for data to be found. JavaScript: function show(field1,dummy1){ var selected1= field1.selectedIndex; var fname1 = field1.options[selected1].text; document.find[fname1].value=dummy1.value; document.find.submit();} HTML: <a href="#" onClick="show(document.find.field1,document.find.dummy1);">Start Search</a> <form action="FMPro" method="post" name="find"> <…

Hi, I am in trouble about updating order quantity. I have a db that contains orders. I show orders in shoping card in list view. I want to give ability to user to update quantity. When user enter quantity field the update button become active. But if you want to update by holding enter key instead of clicking button, a blank page open in browser. Please help me. Thanks. Adam Djuby

I have two fields that I would like to compare, and if the same change the text colour to highlight the field. My code is, however it does not work. Both fields are numbers, and if I substitute a number for "{FMP-Field:Currentday}" it works fine! My code is; <FONT [FMP-IF: Day5.eq. {FMP-Field:Currentday}] COLOR="#ff3300" [/FMP-IF]> [FMP-FIELD: Day5]</FONT> Using Mac 9.2, FM 4.1. thanks ger

Hi there! I read in the WebPublishSecurity.pdf about the cdml_format_files folder, but can anybody help me with this?? I wanna know how to use this one, i have an seperate ADMIN folder which contains a login file (login.html) with an -format tag.

Does anyone know how to do a "Global Search" of a database via the web? I want to create 1 "Search" field that will check every field in that database (or layout) for whatever the criteria and display it back to the user. Not quite sure how to tackle that one. Any help would be greatly appreciated! Thanks! ~Addam~

Hello everybody I have made a dynamic website for a smal travel agency and it has a backoffice that allows edition of new journeys. When making a new record (new journey description, price, dates and so on) I would like to upload 1 or more (ideally 4) images in related database (image database). I don't see how to do it with CDML tag. The solution I have found up to know is to send the image via FTP and then fill the path to the very image in the appropriate field, but it is not very convenient. PS: I am using Filemaker unlimited 5.5 If someone has a solution....thanks in advance

Hi, This is almost a follow on, or a repeat of the thread "Instant web publishing vs. custom web publishing". I've read through all of that in detail, and it helped a bit, but I'm still not quite getting it. I have IWP working perfectly, but need more functionality. I have a fairly good understanding of FM, and know HTML well, but have never used CDML. I'm also working on a PC, windows XP. Can anyone give me some 'steps' to follow or something to get it working? I have used the CDML tool to make a few file, but I'm not sure what to save them as, in my web folder. Just a htm file? They're default saving as a cfm file, but that doesn't seem to work any…

All Can you use replacement tags in javascripts? I've have a simple pop-up menu generated in js. The menu contains a number of links that refer to dbs using simple search and sort critera. I now want to refine these links by integrating user data from a cookie. I have tried inserting the cookie replacement tag in to the link but find that the tag is not rendered. Consequently no records are found! Any help would be great :-) Chris

Each of my clients has their own web page through FileMaker. This is where they place new orders. When they place an order they are taken to a redirect page where mail is sent to them and me confirming the new order. At the redirect page is where one of my clients is getting this error message: "Microsoft Internet Explorer Bad Request The server could not process your request due to a syntax error." He is on Windows and is using IE 6. Another client is also on Windows with IE 6 and he has no problems. Any suggestions will be appreciated. Is there something in my mail redirect that could be causing the error message for just one client and not others…

I have a search page with 4 fields on it and it works fine but the client has an additional request. They want the searches to be an exact match. A search for dog returns "dog" and not "dog breeder". This can be done by placing hidden tags just prior to the field set to "==". If I put the tag on 1 field and search on it works fine. But when I put the hidden tag on all the fields it returns no results because the empty search fields have data in them in the records and the search wants them == to empty. I have tried operators and logical operators and can't seem to fine the right combination. Any ideas??

as I can use the function " RANGE" (. . . ) in the web? Excuse for the grammar, I am translating that message with electronic translator [email protected]

I have a database that I would like to post on-line as a "read-only" file. I know Web Companion offers a "Search Only" option. However, the screen format is less than attractive and hardly user-friendly. I'd like to use one of the "cascading" screens (Lavender), which looks much nicer and is easier to use. Unfortunately, "New Record, Edit Record, and Delete Record" are listed on the side bar. I don't want the user to have access to these commands. It was my understanding that the db's Access Privileges would prevent users from changing the db. In fact, Steven Schwartz writes in FileMakerPro5 Bible: "Those who use Web Publishing...can protect their published dat…

This is a two-part problem: Part 1. I am trying to display the text contained in global fields on a form used to create a new record. I understand that the page with the form (and global text fields) on it has not yet been processed by the Web Companion and, therefore, the text in the global fields won

I am developing a website that toggles between two different domains. Using CDML, is it possible to store a cookie BY DOMAIN A to be later read (accessed) BY DOMAIN B. For example: DOMAIN A (unsecured domain) collects a product ID and stores it in a cookie intended for DOMAIN B. DOMAIN B (secured domain) reads the cookie with product ID and matches it to customer information to complete purchase transaction. Is this an accomplishable scenario?

Hi, Is there a way to make an EDIT Record page by duplicating a NEW Record page, and make a few changes? I don't know how to get this line, to read my records in my DB, <INPUT TYPE="hidden" NAME="-recID" VALUE="FMP-currentrecid"> I do not have a field called, "FMP-currentrecid" Do i need one? Its probably easy, but I am over looking something, thanks in advance for any help at all. I tried using the web tools helper but I am still missing something. Wayne

I want to email a link to customers asking them to fill out a survey. I also want the survey in a frameset so that customers can't manipulate the URL to view or change some other customer's survey. But if the survey is in a frame to hide the URL, how do I direct each customer to his own appropriate record?

Ho, ho, ho folks! Please help if you can but I can live with this annoyance if I must... On my EDIT page, I have a field with a valuelist and radio buttons. I want it editable and to look like this: O meeting O lecture O workshop O other ______________________ (line is input box for FMP-field:eventtypeother) I was going to use an IF during the valuelist loop to show the FMP-field:eventtypeother input box, but I couldn't get it to work. Then I read in the posts that other folks have had trouble with IF's inside valuelist loops. So now, I almost have it the way I want without the IF, but I have to have an extra <BR> at the top I don't wan…

Hi, I'm trying to use a web form to submit information. For some reason I cannot get the [FMP-Portal] tags to work in displaying portal fields, however, I was able to successfully submit data using the following code: <P> Show Name: <input type="text" size=12 name="TimeCardID::t_show.1" value="[FMP-field:TimeCardID::t_show]"> <P> But, alas I cannot figure out how to properly add a pop-up value list display to these fields. Any thoughts? PS I'm familiar with HTML and am currently learning CDML as I go with that reference tool. thanks! Nate

Hi, I've been using CDML for several years, but not Lasso and I now have to answer a question about a site that's hosted externally for one of our companies. It's running Lasso/FMPro (sorry, don't know the versions yet) on NT and I think the problem is very simple: When there are non-ascii characters in the database, like an acute accent, they are delivered to the web page as junk. If it were a FileMaker tag in CDML, I'd just get it to perform HTML encoding, and in fact a made a little demo using the same database to show this. Doesn't Lasso work in the same way? the hosters are saying it's not easy to fix. thanks, Jeff

I have 2 related databases, set up similar to an invoice file. FIle_A has all customer information. FIle_B has Items Purchased information. I need to add a new record to File_A and have the Item Purchased field be populated in File_B. I know this can't be as hard as I'm making it. Thanks in advance for any and all help PS I'm also looking for some good documentation on CDML in general or possible filemaker related XML. Thanks again

Hey All! I've been all through this forum and I'm sill haven't found anything. Ok... Is it possible to have a set of records submitted all at one time!? If so, does anyone care to share? Work Flow: I have a set of records that get displayed. THEN the user will check a check box so they can edit the ones THEY want to edit. After that, the press a button (or link) that says "Edit Selected", they get taken to an "Edit" format where their selections are available to them to edit. Once they've made their changes, they press a button (or link) that say's DONE and they get sent back to the original page with their changes showing. I can do this in Jav…

We have a database (SpEvents.fp5) hosted on an FMserver. We then have a filemaker web server on another server (both OSX... FMP 5.5 unlimited on web). We developed a series of web pages using Claris Hompage's Filemaker Connection Assistant (we have done this a million times). Most of the pages and dbfs we host are "read-only", but in the past (when this server ran 4.0) I did make a solution just like the one I am working on now that allowed a user to EDIT data in a related (on the real server) database. So, the web database (Sp_EventsWWW.fp5) has one key field in it to relate back to SPEvents. Then on the WWW layout, all other fields are related fields. The s…

According to FileMaker documentation these are script steps that support multiple script steps in Instant Web Publishing. When I try and use Exit Record followed by Go to Layout in the same script I get the following error on execution of this step via a button while in data entry: "Data Entry Error: Your attempt to save changes to the new record failed because of the following: Unknown error number 102." Any thoughts - thanks - Ubo

A find on my custom web solution is initiated, the resulting html page shows the resulting FM record. The record is shown on my web page with CDML. The web page also displays the contents of a portal from the FM record in a table. [FMP-Portal:Tasks] <tr height="15"><td class="text" align=LEFT valign=MIDDLE width="106" height="15"><span class="text">[FMP-field:Tasks::T]</span></td> <td class="text" align=LEFT valign=MIDDLE width="68" height="15"><div align="left"> <span class="text">[FMP-field:Tasks::S]</span></div></td> <td class="text" align=LEFT valign=MIDDLE width="65" hei…

Hi everyone - I'm sure this has been asked/answered a zillion time on this board, but my limited searching has come up empty. I've been charged with assessing how our company can provide clients an order form system tapping into our FMPro Inventory DB. Their access would be via the Web. Here's what we run: Windows NT/2000 Server FMPro 5.5 The Instant Web Publishing functionality is obviously so limited that we are interested in the Custom options. I have enough HTML/JavaScript knowledge to get the ball rolling, but here's my question - is it true that I need FMPro Unlimited before getting into the Custom Web Publishing? If I'm wrong, then I'm missing…

Here's the nutshell: Webiste that contains arts and crafts show info. here's the 'problem': From the main page you can do a search. The search results page has a little blinking arrow GIF which indicates the new shows. It doesn't show. It's blanked out. BUT, if you click on one of the search results for the detail of the show, then say, click on the link we have to pull up ALL shows from that particular sponsor (a quick link), the same search results page displays...with the graphic. I've been doing web development with all sorts of DB technologies and languages for a number of years and this one...this one has me stumped... http://www.acnshowguide.…

Hi Guys, I've almost got this, but as usual a bit stumped by something. I have a database of sets of photos, with a portal to a second database that details each image in the set. I'm trying to generate a page to show the sets as a slide show. I'm getting stuck on a drop down list that needs to be populated with a url and image title for each image in the set. Works fine when I manually enter the data, but I can't work out how to have it populated using filemaker. The code that works is: <TD bgcolor="#330099"> <DIV align="center"> <SELECT name="Oneslide" onChange="Onechange();"> …

Hi, I have a few InlineActions that perform a find, but when I observe the Db while some pages are loaded, it's processing data as it should but also 'refreshes' the window alot. I'm not sure, but if I *could* freeze the window, would that reflect on any new Inline-search? I mean, will it refresh on the next reload of that page? My db's are used alot online and I see the statusbar jumping around. I've tried to cut down on lay-out processing by creating an all-white lay-out thats opened as a default (leaving all CGI lay-outs in the background). Does this contribute to anything? Thank, JP ps. does FMserver speed up webconnections compared to a …

First the ownup: I have virtually zero understanding of web publishing. I have a fairly small runtime database that I need a few people to be able to edit online. Several people need to be able to edit the different fields in the same record. I access the internet through an ISP and a modem and so do the other users - all different ISP's I have no idea where to start or how to publish it so that the users can get to the data. So if anyone feels like taking pity on a total novice then please give some advice in VERY simple terms. I would be REALLY grateful. Thanks

In recent weeks there has been some discussion about using PHP with FMP. It also appears that some have had success in linking FMP dbs with PHP. I am hoping to spur additional discussion on this topic with this post (primarily for my own edification). As I understand, PHP is a scripting language developed to link high-end databases to the web. PHP scripts are embedded in HTML documents and provide the link betwen the web server and the db. This adds security to the db since it is not published on the web per se. PHP is closely associated with SQL dbs and Apache web server software. In my situation, the IT boys are currently not interested in publishing FMP dbs …

I'm currently using the built in webcompanion for instant web publishing, but I certainly has some limitations. What exactly can you do with custom that you cannot do with instant? I wanna know, before I buy the developer version - which is nescesarry, right?? What I wanna do is: A person creates a new record: a new advertisement. This advertisement consists of several different products: size, number of colors, placement etc. Each of theese products has a serial number, which should be enterede in a related database. So, i have the master database, advertisements, which relates to several products in the related database, products. Is it p…

I've checked all the threads in this forum and other online forums. I have read through the CDML Reference and have used the CDML Tool, and I cannot get the dropdown menu to work with a FMP Value List! I have been trying for two days to no avail. Here are the particulars: the database is named call.fp5 the layout is named user the text field is called equipment_type the value list is called equipment i have instant web publishing off my code is as follows: <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-DB" VALUE="call"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="user"> <INPUT TYPE="hidden" NAME="-format" VALU…

I'm setting up a DB with Instant Web Publishing. In the Web Companion setup views dialog, I select the "Sort" tab. I choose the option to use a specified sort order every time and select my fields to sort on. The fields I am selecting are related fields. In the browser, the sort seems to be ignored. Are related fields ignored for sort order even though they appear as an option in the setup dialog? Is there something else I'm supposed to do to configure this to work? I'm using the latest FMP 6.0v4 standard edition. IE 5. FMP hosted on OS X v10.2.2. Thanks for any help! Ken

Run into a slight problem which is probably easy to fix but it escapes me. Below is my htlm form...... <form action=FMPro method=post> <input type=hidden name=-DB value='test_login_'> <input type=hidden name=-Lay value='admin2'> <input type=hidden name="-format" value="editwelcome.htm"> <input type=hidden name="-Token" value="[FMP-CurrentRecID]"> <input type=hidden name="-error" value="new_error.htm"> <input type=hidden name="-op" value="eq"> <input type=text name='email_name' size=30> <input type=hidden name="-op" v…

<td> [FMP-IF:url.eq.""][FMP-Field:name] [FMP-Else] <a href="[FMP-field:url]" target="_blank">[FMP-Field:name]</a>[/FMP-IF] </td> This should show that if the field "url" is blank then the field "name" and otherwise the field "name" as link and open in new window if clicked, yes? They all show as link and open in new window but if "url" is blank then new window of same window comes up. many thanks, nati

hi, I'm executing an inline action to post an email from a page. The code works perfectly under OS 8.6 (old server). When upgrading to OS X, it fails. It simply doesn't send email. Any ideas if there are syntax changes for OS X that may be relevant? What about authority (my html file has 777 rights...). Here's the code from the html file that's sending the email: [FMP-InlineAction: -db=app2002.fp5, [email protected], [email protected], [email protected], -mailsub= (TEST) Confirmation # {field: _Current Record ID} has been approved by Sales Analyst {field: _02_emailstatus}, -mailhost=aaa.abc.com, -mailformat=sls_to_slsmgr.txt, …

So, finally after searching everywhere within this forum and others (goolge found my/this solution). I have found the best software for emailing within HTML and FileMaker. It's called "SMTPit"( http://www.smtpit.com/ ). Within 10 minutes you can put the code in your FileMaker file and place the script call in your HTML page and you're done. I'm placing this post, so that when persons do a search for emailing with FileMaker/HTML they'll fine this. Paul

I've got two database files involved with this problem. There's CClogin.fp5 which holds the user names and passwords for people who can log into the system. People log in with a form that has two fields on it, Username and Password, both with a -Op hidden input tag that is set to .eq. Logging is works fine. Each login record has a field called CarrierID. On the format page that people are brought to when they successfully log in has a linked called Browse Claims that has the following link: FMPro?-DB=CCclaims.fp5&-Lay=web&-Format=claim_list.htm&-Error=browse_error.htm&-Op=eq&CarrierID=[FMP-Field:CarrierID]&-Max=25&-Find So, I…

I thought I understood this and, in turn, wrote my CDML correctly, but I guess not. I've scoured the previous posts to no avail--please help. I basically have a bunch of tables filled with fields I want people to be able to edit after they've entered their data. However, everytime I click "Edit", I'm brought to my error page. Sorry for the length, but I'll post the entire page here. Also, the last table is filled with portals, my understanding is I can't edit portals, which isn't germane to my problem as I usually take that last table out as I've been trouble shooting (i.e. the portals aren't my problem). Like I said, this should work. In fact, I'm really sur…

Hi everyone, I've been tearing my hair out for a few hours now, so I'm hoping someone out there can save me some time. I am part way through building an online shopfront, and have everything working product wise, but not order wise. So far all the sites I have seen start off by creating an order via an initial entry button. I do not want to do this because it adds an extra front page to the site and because it leaves a lot of dead orders behind when people don't actually place the order. Since most online shopping is browsing, I only want an order record created if someone actually chooses to buy. And thats where I'm stuck. I can't work out how to have the …

I am a bit lost on this one. I have a page with CDML tags that show all the information from matching fields in my database. However, there is one field that will not display any data in CDML. I have checked and double checked my CDML tags...everything seems to be configured correctly. All the other CDML tags work fine, just this one field. The field data in question is a calculation field in my database. Is there any types of calculation fields that might not be able to display their data in CDML? Larry

All, Maybe a simple question - but can you execute a FM script from a HTML page using CDML? If so what code is required. Thanks in advance Chris

Am I correct that there is no way to do a -edit URL or Form without including the -RECID for the record you are editing? If this is the case, considering that the recid is a serial number that developers have no control over, isn't it extremely easy to hack a URL and find data for other users?

I'm trying to create a table of data but I need records to populate both rows and records. For example the results should bring back fields to a cell, then the next record populates the next column this continues to the first 3 records. Records 4 through 6 on the next row and so on. The results on this page will only have a photo and a record name, where the record name falls under the photo. The next record should appear to the right of the previous, then after 3 records, record 4 record should wrap to the next line. R1 R2 R3 R4 R5 R6 R7 R8 R9 and so on I tried this many ways. Using photos alone I can achieve this as aligning the photo left will set…

Hi all, I have many records like for each semester for past 5 years.I want to edit these records.But i want to edit only those records which are related to current semester and year.i have a field like semcode this has year and sem like 0311(03 is last two letters of 2003 and 11-a code for spring).may be we can use this field for checking(not necessary). I tried many methods but i am not getting exact results. any suggetions ... thank you in advance sri

I know it must be something simple (or at least I hope it is) but I just can't get this to work. I have a database with a ID# text field and a Password text field. On the web page, teachers can pull up their registration by entering both their ID and their Password. <Problem enters stage left> Either field can be entered and it will pull up their info...one can be left blank and it lets it in. How do I make it look for *both* using CDML? Or, would it be easier to copy/paste javascript for the required fields? Here is what i have at the top of the form: [color:"green"] <FORM ACTION=FMPro METHOD=post> <INPUT TYPE=hidden NAME=-DB VALUE='competency…

Hello, I've got a standard web form that performs a Find. I would like one of the text boxes to do a "contains" search. For instance, I'm looking for a list of reports with the word "BLANK" in the name (a same name would be DLBLANKRRD). Can this be done? Thanks!

I'm having trouble figuring out how to do a complex find with CDML. I have a web page where users can enter find criteria in a number of different fields. Here's an example of what I'm having trouble with: - Text field called "Name" - Checkbox field called "Class" with the following options: Freshman, Sophomore, Junior, Senior. The user needs to find all Freshman and Sophomores with the name "Smith." User enters "Smith" in the Name field and checks off "Freshman" and "Sophomore," and clicks Find. If I use the -LOP "AND" I get a message of "No Records Found." If I use the -LOP "OR", I get records for Freshman and Sophomores who aren't named "Smith", etc. …

I'm lost, once again.. I have multiple inlineactions in my website, all working just fine, but I wanted to build in an extra reminder for some webusers and it's not working..aaaarrrgh! When a user posts a new message (read creates a new record) it returns an 'ok' page. Wich is good. But on that 'ok' page I want a summary of all the records that person entered today. The inline works ok and based on a cookievalue containing the users password, but when I put a date function in it, it returns nada. What should I use in the inline? I've tried DateIn=today (also tried using '{'), DateIn={fmp-currentDate} but it just won't work And yes I've searched the fo…

I have created html pop-ups for use with my CDML custom layouts before, but is there a way to have the contents of the pop-up be based off of a value list from FM instead of having to hard code the values? LR

I'm hoping to use Instant Web Publishing for the sake of speed in developing my database. I've tried the various formats that are available when I setup Web Companion and I've noticed something: In the versions that support newer functionality, a portal will be displayed in a listbox with a scroll bar on the side and all related records are in this window. If there are more records than will fit in the display, you can scroll to see additional records. Clicking on a record takes you to a page that allows you to edit one or many of the related records, as well as any other fields on that layout. In the versions that support only older functionality, when there is…

Hello, I would like to have a field that the user can type into (this will do the search), that will be related to all fields. In other applications, I would create a field and label it "name="_allSearch". The reason for this request, I want the user to have the option of going to fields that are label for the search request (::search:: First Name, ::search:: Date Submitted) OR just have a generic field (search Any Field) that they type the request, and all fields are searched to return possible results. Boy- i'm sure i typed this more complicated than it needed to be. BTW: here's a page i created that shows what i want. http://www.pdawax.com/TrashMe/…

Is it possible that when a user hits the submit button, the data can be updated to two files or more. here's my calls right now: <INPUT TYPE="hidden" NAME="-DB" VALUE="DieBeta.fp5"> [in this area could I add another file to update to?] <INPUT TYPE="hidden" NAME="-LAY" VALUE="MainLayout"> [in this area, both files will have the same layout name] Thanks for any advice Paul

Using tokens has totally escaped my understanding. Can someone explain this to me or direct me to a complete tutorial? I have seen a bunch of bits and pieces, but the total picture is what I need. Thanks!

hi, Is there a way to add fieldrelated errormessages in a HTML form, without using the -error tag but using the IF statement? Example: field 1: Name -> not empty field 2: Address -> unique field 3: Age -> not empty field 4: Car Brand -> unique If the user fills in this form and leaves field 1 blank, I would like to see a message in a tablecell behind that field only. If both fields 1 and 3 are empty the message should go to both fields. The -error tag I use on general pages, but this would make things easier for clients because they now can see what they did wrong. I have been trying some javascript stuff but I don't get it to do what I want.…

Hi, I'd like to have a value list where the displayed value is different from the value passed to the database, like: <SELECT NAME=stuff> <OPTION VALUE=1>first item <OPTION VALUE=2>second item </SELECT> ...rather than <SELECT NAME=stuff> <OPTION VALUE=first item>first item <OPTION VALUE=second item>second item </SELECT> is there a way to get this from Filemaker, rather than just write it into the page? thanks, jeff

I have a database which lists a library. The authors are in a different database and the 2 are linked. In my library database i have a layout which has a portal which displays all the authors for the record. When i do a search in the library database for an author, the only records that are retrieved are the ones where the author is in the first portal row. How can i search every row of the portal? Thanks

Ok...here is my situation: Database: Field 1 (10 options): 1, 2, 3, 4, 5, 6, 7, 8, 9, 0 Field 2 (10 options): A, B, C, D, E, F, G, H, I, J What I need to do is find how many records have both 3, and D as field entries. And I need to output to a webpage. I dont know if I'm just having major brain blockage here but I cant think of how to do this.

I recently switched to osX from os9. I do quite a bit of work from my laptop in places where i don't have web access. in os9 i could open my files and then open explorer and view them from the browser without an internet connection. I can't make it work in osX. works fine when i'm on line but not much good when traveling. Any Ideas???

My problem: I don`t use web security in my databases and I don