Other Internet Technologies

CDML only allows action on one record at a time. Actually when you stop and think about it, you can only work on one record at a time in FMP as well, so it's not really a limitation of CDML, it's a database thing. The obnly way to work on multiple records in FMP is to use scripts. Use the -Script CDML tag to call a script that will do your multiple record stuff. be very, very careful to make sure that the script works over the web correctly especially if it invoves editing or deleting records.

Is it true that when setting up a db for use on the web that field names and layouts should not contain spaces but the "_" underscore instead?

Haven't been able to figure this one out yet...using FM Pro 4. I have a portal showing several records with several fields for each record. Some of the fields need to remain empty until an action occurs. The data in the portal rows/records line up as long as each field in each portal record contains data. However, if a portal record has an empty field, that field for the remaining portal records shifts up. In FMP this is no problem. I have tried using an [FMP-if] command to input an "N/A" if the field is blank but so far that hasn't worked. Any ideas would be appreciated. JM ------------------

I'm doing an online database. Upon logging in to the database the user's record is updated by placing the user's ClientIP and the Current Date in a field. This is done similar to the following: <a href="...snip...FMPro?-DB=database1.fp3&-RecID=[FMP-CurrentRecID]&field1=[FMP-ClientIP]+[FMP-CurrentDate]&-Edit"> Now I'm just typing randomly here (leaving out format and so on), so pardon any errors. This link works. It places the client ip and the current date in the field. But in another page I have a link that attempts to assign this value (Client IP and Current Date) to another field. It goes something like this: <a href="...snip...FMPro?-DB=databa…

I have a search form for a database and when a user finds a record they can view the form but I can't get the checkboxes to work. In the submission form each checkbox is next to a picture of nice anti-aliased text. In the results form this does not work, all the examples I can find use the form : [FMP-valuelist: iiCOLOR] <input type="checkbox" name="RGB" value="[FMP-valuelistitem]" [fmp-valuelistchecked]>[FMP-valuelistitem]</font> <p><font size="2">[/FMP-valuelist] <input type="checkbox" value="RGB" name="iiCOLOR"> is there is a way to set up a checkbox that is standalone and not part a list of checkboxes? Does that make sense? I…

Is there anywhere I can get a listing of all the FMP web companion Tags? Cheers

Does anyone know if there is a way to make the sliding/printing feature or something similar work for the web? I have my db in a table and one of the cells has 4 fields in it w/breaks in between each field. Not all of the records take up all of the fields so for those it leaves a big space in between each record.... Thanks!!! ------------------

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?

I want to make a field that has to equal the number "6621" I used the validation in filemaker, but people can stillput in any number without getting an error. This is not acceptable (it's an approval code). How can i go about this, javascript is probably what i will revert to but i'd rather not have to go searching the numerous javascript sites with no guarantee of finding one that works with every browser, etc. etc etc. Any help ASAP would be appreciated. Jeremy

How do you refer to a specific repeating field using CDML.. I thought it might look like this... [FMP-Field: FieldName, 1] but that does not work. Can anyone tell me?

Is there an online CDML tutorial or reference guide? The "handbook" I got with Filemaker Pro 5 says nothing about CDML ???

I am looking to execute multiple finds from the one form posting, when doing a search in fm you can create new find request and perform finds for multiple criteria in a single field. How is this possible via the web companion? Is it possible? Cheers

You can display a repeating field on the web, using the [FMP-Repeating: fieldname] CDML tag. The FMP4 reference states: Repeats the HTML between [FMP-Repeating] and [/FMP-Repeating] for all the repetitions of the specified field. The tag [FMP-RepeatingItem] is replaced with the contents of a specific repetition. [FMP-Repeating: Extensions] Alternate phone extensions: [FMP-RepeatingItem] [/FMP-Repeating] So no, you cannot address a specific repetition of a field, you get them all. Now, don't change over to Access because of this. I meet a lot of people who change from Access to FMP because they are jack of the hoops you gotta leap through to get the same functional…

I have a page that returns a list of records containing dates, like this... [FMP-Record] [FMP-Field :Date Field], [FMP-Field :Date Field].... and so on... [/FMP-Record] The HTML output looks like "10/20/2000" I want it to look like "10/20" Is there a way to specify date formating with CDML? Thanks, G [This message has been edited by spragueg (edited October 20, 2000).]

OK - What's the real deal with dynamic value lists and CDML.? I was told there is a two step process, but I'm having problems with it. In Filemaker I have a value list where users can select a group. When a group is selected another value list (use values from field, only related values) lets them choose a person in that group. I used HomePage 3.0's Filemaker Connection Wizard to make my HTML pages. The CDML tags for the value lists are normal: <SELECT NAME='Group' SIZE=1 > [FMP-OPTION: Group, LIST=Group] </SELECT> AND <SELECT NAME='CS Rep:' SIZE=1 > [FMP-OPTION: CS Rep:, LIST=CS Rep] </SELECT> Obviously when I create a new record on t…

I'm in the process of instituting a filemaker database to be accessed over the web, initially using web companion, then probably will integrate Lasso. What I want to know is how much 'pressure' can a filemaker database take over the web. In terms of how many users hitting it before it begins to give problems? And what problems will then be encountered? Thanks much for your helpful replies.

Does anyone know if there is a way to send a "logout" command to the web security database? I need diferent users to be able to login to a database from the same machine. Once "user a" logs in FM seems to assume that any additional accesses are from the same user. Is there a time out feature? BTW I'm using CDML "Custom Web Publishing" with FMP5 and MacOS 9.04

Does anyone know a good web log analysis tool to run analysis on the Web.log file? I usually use Webtrends or custom CGI for my UNIX, and NT servers. But the log file format from FMpro is not being recognized by any of my usual tools. Thanks.

ok here we go. i have been trying to figure out this problem since friday. I am using this code to call a field to show up on my web page [FMP-field:CADDrawing Notes]. The field name is correct, it is on the correct layout, and all the other cdml codes on the page work. can anyone think of any reason it might not be working. Thanks Bman is it possible that is has to do with the fact that the field in filemaker has alot of information on it.. it is the only field i am using that runs more than one line. PLEASE HELP ME [This message has been edited by bman (edited October 23, 2000).]

I have a form allowing requests for service. When someone enters a text string in one of the fields it automatically inserts a paragraph marker before the text string. It does not show on the web page (cause straight paragraph symbols are ignored) And this only happens on one field. Any suggestions? ------------------ sadly....i'm am more confused than ever and the trend seems to be accelerat

I can't seem to find a way to make the -Op thingie to work with my searches. The code: ---------------------------------- <form name="sort" method="post" action="http://130.100.101.101:591/ctnz/FMPro"> <input type="hidden" name="-DB" value="[FMP-CurrentDatabase]"> <input type="hidden" name="-Format" value="tablice/[FMP-CurrentDatabase]-list.htm"> <input type="hidden" name="-Max" value="[FMP-CurrentMax]"> <input type="hidden" name="-Lay" value="CGI"> <input type="hidden" name="-Error" value="tablice/[FMP-CurrentDatabase]-list.htm"> <input type="hidden" name="-Op" value="bw"> <…

In FMP preferences select Web Companion and select Form View.

Here I am again, getting closer to finishing this project, but again stuck on if statements. I'm confused about FMP-If statements. What are the required tags needed and where does the If and else statement go? (I'm using Homepage and the filemaker_forml.hlb). I want to compare a number that has been entered into a global field with a indexed field from another database. I'm hoping something like this will work [FMP-IF: streg: assword .cn. gPassword] Show this link [/FMP-If] I've searched the web and found lots of info about FMP-If, but very few examples of the actual code and where it needs to be placed. If anyone can help, I would be most appreciatative. T…

There's been a bit of discussion about "Logging out" of a filemaker database on the web and a thought struck me: - in the discussion, everyone keeps saying that the reason you can't "log out" is because releasing the client is a "browser" function, not a filemaker one. So does anyone know the browser function that does this? It is HTML pages after all. Maybe we could provide a link that "tells" the browser to release the client without having to exit the browser. Another consideration is that maybe different browsers have different ways of doing this. It would be interesting to get the answer to this one.

Can anyone tell me where I can download a copy of the Filemaker CDML Reference DB? Thanks.

I am trying to create a Search Page to search a FMPro5 database using [FMP-fieldname] as a search parameter and display the results on the Search.Result Page. In this case, let say the value for [FMP-fieldname]is Value1 before the search and after the search the value of [FMP-fieldname] is Value2. Is there anyway I can display [FMPro-fieldname] with Value1 as a heading on the Search.Result Page.

Is it posible to use the 'Filemaker results table' option on tables in HomePage to display portals when using the custom web publishing? Many Thanks ------------------ Ger Somers It Manager Murray O'laoire Architects

Is there a way to attatch a date created field to just one field in a record rather than the entire record? I have a database that acts as two. Each field has it's own date created field. Is there a way to have one fill in only if there is valid data in it? ------------------ Rich

Is it possible to create a form that will add or edit a repeating field? Since the field name is the same no mater how many cells, is it possible to submit information to each cell? <form action-"FMPro?> <input type=hidden name=-db value="mydata.fmp> Enter a sku <input type=text name="sku"> Enter another sku <input type=text name="sku" <input type=submit value=-new> </form> This isn't the final HTML, just trying to get the point across. Anyway around this? I know I can define multiple fields, but hopefully I can get around this. Thanks Rich ------------------ Rich

I know this isn't directly FMPro related, but I have a text field in FMPro that loses all formatting when I put it in a browser if I use the <span> tag. When I use instant publishing, FMPro uses the <span> tag, but somehow breaks up the text with <br> whenever there is a line return. Is that being done through a script? How can I do that? Using <textarea> keeps the formatting, but I want it to be read-only, which I don't think can be done in <textarea>. Is there a tag that will keep the formatting but will also make it read only? Thanks for any help.

Here's a tough problem, that I think may require scripting: I have 2 databases: Jobs (job postings) and resumes (from job seekers). In both databases, the poster/seeker can check off items in a value list of what profession(s) the job listing (or seekers) applies to. Here's the difficult part: When the job poster submits a job, I would like the resumes database to be searched for anyone who has at least one of the job fields the poster checked off, and emailed with a form letter (using the email address in the resume listing). There are a few key problems to this: a - it's all CDML. All online, and I would like the search/email to be automatic. b - I believe, si…

I have created a Filemaker database which I am trying to convert into a website using custom web publishing. I am having trouble understanding how my Filemaker scripts work with CDML. The key to my database is a script that checks to see if the person has already created a record (based on a random number password assigned). It looks like this Go to Field ["gPassword"] If ["IsValid(stureg::Password)"] Go to Layout ["Student info"] If ["IsValid"(svote::Password)"] Go to Layout ["duplicate vote error"] Else Go to Layout ["Votever"] End If Else Go to Layout ["error"] End If Set Field ["Password", "gPassword"] I am tr…

Folks I've just upgraded to FMP 5.0v3 with eb Companion 5.0v6 on a Macintosh G4. I've done a lot of custom web work with FMP4 and am just getting a feel for the differences with the new version. Not many, but one appears to be the way Web Companion 5.0v6 handles field-level validation. In FMP4, I have a db with a field that has its validation set to "Not Empty." If somebody tries to submit a -New action with that field empty, FMP4 Web Companion will create the new record then check the record's validation: if the validation fails FMP4 Web Companion returns the error HTML file (with error 509) and, if "delete record" privileges are available, web companion deletes the in…

hi there. i want to specify HTML page with -format tag, but do not know, how to pass a frame reference. top frame with navigation loads fine, but the bottom one with all details comes with in line FMP codes. Do arefresh, and it all works. any ways around this one? thanks in advance

When I press enter after filling in a text field instead of clicking the submit button of a form i get error code 4. When I do press the button the search goes on Ok. Does anybody have a workaround? Roko Here's the form: ----------------------------------------- <form method="post" action="http://130.100.101.101:591/ctnz/FMPro" name="sort"> <input type="hidden" name="-DB" value="[FMP-CurrentDatabase]"> <input type="hidden" name="-Format" value="tablice/[FMP-CurrentDatabase]-list.htm"> <input type="hidden" name="-Max" value="[FMP-CurrentMax]"> <input type="hidden" name="-Lay" value="CGI"> <input type…

It used to be that you had to use Claris Emailer to have FMPro send mail. Is that still the case? All I have is a v1.0 Emailer and it's compressing things and I don't know how to set the default to not compress. Help!

Ok... this is strange, maybe somebody has seen this before.... I have a page with a bunch of CDML... everything works correctly, but all If tags seem to fail! If I put in: [FMP-If: ClientAddress.neq.bull.nonsense.blahcom] Hi, Keith! [FMP-Else] This is what shows up! [/FMP-If] the if test fails, and I always see the "else" html. If there is no else section, then nothing displays at all. Any ideas? I've tried a bunch of different samples from web pages of "valid" samples, but none of them work. EVERYTHING else loads fine on the page... fields, popups, etc. Any ideas at all? [email protected]

Correct me if I'm wrong but I thought there were "format" pages for Web Companion so existing databases could be integrated into web pages. The files were stored in the Web directory in FMP 4.1. Does anyone remember? Where did they go. I just installed FMP5 Unlimited and I cant find the format files. Are they obsolete?

hello i am writing a webpage of questions, accessed from filemakerpro, but each time the page is accessed, i would like a different situation, also from the database, to appear at the top of the page. Is there anyway i can do this randomly? thanks, kim

<AndyRooney annoying="on"> Why is it that when the FileMaker displays an embedded graphic on a web page via a database container field that it can't make a white image background white? </AndyRooney> Anyone else seen this or have an answer for it? When I put a graphic in a container field for a web page, it gets dulled quite a bit when displayed. Whites turn grey-ish. It's like the FMP converter just won't do whites. I have pasted the image into the container field as both a metafile and a bitmap and both format yield the same greying effect (but the bitmap version looks MUCH sharper). I have also done, 16, 256 and 16 million colors and all versions …

I am having a problem with a Filemaker Pro5 Database only returning a maximum of 25 records when using the web companion. I am using javascript with the -findall request which should find all records. I set the layout to reflect one field which exists in all records. I even tried running a script to show all records before doing the find. It seems no matter what I do I only get 25 out of 54 records. Does anyone know of any limitations or have seen this problem before? Everything works fine from Filemaker. I only see the problem when connecting with the Web Companion. I am using Internet Explorer 5.0 on Windows 2000. Thanks in advance for any help. Matt.

Does anyone know if there is a way to detect if a particular cookie has been set in a users browser? I'm using FMPro 4.1. Users must login to a certain section of a site, on successful login their user id is stored in a cookie. If they leave that section and then return, I want to test if they already have a cookie so that they can bypass the login screen. I don't have any problem setting up two branches using and IF statement, but I can't get filemaker to successfully determine which to go to. Thanks

I want my users to be able to sort specific fields on the web of my database. I am using FMPro 4.1. When I converted my db to the web w/Claris HomePage and said yes I want the user to determine the sort order it gives all of the fields in the database to sort with. But I only want them to be able to sort w/3 out of the 5 fields. I can I specify only those fields? ANY HELP???

I am a newbie to FM Pro. In a nutshell I want to be able to, in Table veiw in a web browser, Turn on cell padding (from "0" to "1") so that I can see the lines, there are hundreds of records and I want to see which lines are which. Also is there anywhere to download or a way to customize themes? Any help would be appreciated.

Pardon my english! I want to use FM on the web to make changes to a catalog but the tables that shows the x and y cannot be shown as a table but as continuous text. I hope someone understands me. In some cases I have 6 collumns and 5 rows, and to show as continuous text, it is a pain to read. Can someone help me?

Is there a solution for making "buttons" work when a file is published to the web using web companion?

Problem #1 -- I have web pages accessing an old database through the web companion, the database called "timeoff.fp5". When I set up a new database called "reserve.fp5", and tried to have an entirely new set of pages in the "web" folder (those being the only pages in there) it keeps saying that "The database "reserve.fp5 is not open" - when it clearly is. Also, if i make a change to the "default.htm" page, I have to rename it and redirect the web companion to the newly named page for the changes to take place! It seems like everything is being cached somewhere, but how? The memory guides in the FM books don't help, and this happens on PC and Mac....anyone got a solut…

I'm sharing a database with web companion. The opening page loads fine... except for the fact that ALL cdml tags are just ignored... [FMP-CLIENTIP] just shows up as "[FMP-CLIENTIP]" not 102.43.21.129 or whatever. Everything else breaks too! I have web companion on, so why isn't FileMaker 5 parsing anything? Any ideas? Is there some checkbox somewhere I forgot to mess with?

I have a database that I'd like to search the field "creation date" by a range. I know in FIlemaker its something like this.(ie. 08/01/2000..10/20/2000) but I can't figure out how to do it on the web. PLEASE HELP. Thanks, ------------------ Rob Young

Hi, There appears to be a lot of good feedback on this board so I'm hoping someone can help me out. Currently using Filemaker 4.0. I am trying to link to a related record contained within a portal. I would like the user to be able to click on the portal record which would then take them to a new web page showing the related record. I have tried the following code with no luck: [FMP-portal: Certifications] <A HREF=[FMP-linkrecid: format=cert_edit.htm, layout=form_view]>[FMP-field: Certifications::Cert_Name]</A><BR> [/FMP-portal] I am able to link to related records within Filemaker but I have been unable to accomplish this so far on the web. A…

If I understand your question correctly, all you need to do is add a <BR> or <P> tag after your portal field value. Example: [FMP-portal: Certifications][FMP-field: Cert_Name]<BR>[/FMP-portal] The <BR> tag will place each successive portal value on the next line. Hope this helps! JM

Is it possible to call a cookie in an InlineAction? I've tried the following script but it won't work. [FMP-InlineAction: -db=orderrows.fp5, -lay=cgi, OrderID="[FMP-Cookie:OrderID"], -sortfield=brand, -sortorder=ascending, -find][FMP-Include:small_cart.htm][/FMP-InlineAction] please help! thx

i have two questions that i think i know the answer to. I just want to make sure. With either one, if someone would like me to expand the issue, i will. 1. Am i correct that i can only run a script from a search page? I need a "button" to insert the current day and time on a record detail (editable) page. 2. If i choose restrict IP address in the application prefs, does that apply to ALL databases open on that machine? If so, how can i restrict just one DB's IP addressess? Unfortunately for me, both of these problems are for the same solution. Any help on either one would be greatly appreciated. Jeremy [This message has been edited by yafreax (edited Sept…

Andy- From my experience, I've found that value lists are generatd in the web page only when the page loads (that is the only time when FM sends data to the browser). So if you are using dynamic value lists within FM the relationship is updated immediately in the database, but since information for a web form is only sent to the browser once when the page loads, you cannot dynamically update a second related value list without resubmitting the value from the first list to FM and then receiving a page back with the updated second value list - Clear as mud! Hope this helps. Jeff

I'm using Filemaker Pro 5 for a creative request website. If I enter "00" for a date in FMPro it shows up correctly as the year 2000. If I submit a request via the website and use "00" it shows up as 1900. Do I have to force format everyone to 4 digit years? Here's a sample of the cdml; [FMP-field: due_date] any help would be appreciated! ------------------ ~~~~~~~~~~~~~~~~~~~~~~~~~ Tom Beidler Orbit Tech Services tbeidler@mindsprin g.com ~~~~~~~~~~~~~~~~~~~~~~~~~

When I put number fields into a published database (made with Home Page) they look like this : 123456 What do I have to do to display them formatted like 123.456 or 123,456? Setting the number format options didn't work. Patrick

Hello everyone! I used to just build a web site but now I have to learn these things (database, server admin, etc.) which are very powerful and interesting but there aren

Does anyone knows how to have Web Companion shows correct greek characters on a web browser? Greek Iso 8859-7, Greek (Mac), Greek (Windows) have the same trashed output Any idea?

I am having difficulty trying to get my webpage database to appear on our companies intranet. I'm a Windows person and not very experienced with Macs. The Mac is connected with TCP/IP protocol and I have the option for FileMaker to create its defalt home page selected. When I open the browser and enter the IP address with the port number (that I entered into FileMaker), my browser can't locate the page giving me an error message stating that the site may be down (the DB is opened in FM, and the browser can locate other sites). The users Guide is not giving me much info to get through this problem. Any suggestions?

I am setting up a website/database that serves graphic. Which is the fastest method to store the graphics: within the FileMaker database or outside (by choosing 'Store only a reference etc.)? The graphics are already in JPG or GIF format. Or to put it more technical: the web companion converts graphics from 'FileMaker format' to JPG on the fly, but this takes CPU time. Is this avoided when the graphics are already stored in JPG? In other words, does the web companion grab the JPG files directly or does it still goes through the conversion processes?

I am trying to submit a form automaticly with an onload method (javascript) which is not working. The form by itself does and so does the onload method. However, together they don't work. Why doesn't it work?. I am using File Maker Pro 4. Is this why? Can it work with FMPro 5? <html><head> <title>Counter</title> <script> <!-- function autoSub() { document.john.submit(true); } //--> </script> </head> <body bgcolor="white" onload="autoSub()"> <form name="john" action="FMPro" method="POST"> <input type="hidden" name="-db" value="counter"> <!--<input type="hidden"…

(Please forgive the cross-posting. I wasn't sure which forum to put this question.) I've set up an online database using FMP 5 and CDML on Windows NT. It works just dandy with Microsoft Internet Explorer, but I've run into a problem with Netscape Navigator (tested with verison 4.7). When I try to submit a new record using Netscape, I get the following JavaScript Application error message: File Access Restriction: You do not have access privileges to perform the action: new Weird things are: 1. It works fine with MS IE. 2. If I use Netscape and the Instant Web Portal, I *am* permitted to enter a new record. So, seemingly I *do* have access privileges. The HTML/CD…

Is it posible to enable standard directory listing with FMP Web companion? thanks, roy

This might be too stupid a question to ask but bascially I want to know the process of getting a built Filemaker Pro 5 db onto the web so that people can browse and enter data into it. I'm doing this for my college to create a Jobshop and have so far been unable to test the database online b/c I'm working from my computer at home. Do I need to wait until we have our server running with Filemaker installed on it to web-enable the database? Is there any way I can test it from my machine at home using regular ISP-access?

When I do a search for records, I want the page to come up with the selected record and it's correct data, but the drop-down menus should have the correct data selected. Im using the following code to have the drop down menus contents entered, but it puts 'checked' in the <option> tag when I really need it to add 'selected' to the tag. <select size="1" name="D1"> [FMP-ValueList:drop,list=drop] <option [FMP-ValueListChecked]>[FMP-ValueListItem] [/FMP-ValueList] </select> How can I get it to fill in the drop-down menu and still select the correct item in the menu? Again, 'checked' doesn't work. I've tried using [FMP-IF:] stateme…

cant find any way to make a value list created by a field from a related file to work. in filemaker its working properly and i cant find any documentation how to display a value list of that kind on the web. please give me some suggestions.

Is this cdml correct? FMPro?-DB=request.fp4&-Lay=duedate_schedule&-Format=cs_duedate.htm&due_date_calc=1...2&-Op=neq&sta (it continues). I created a field called due_date_calc that returns a 1 if it's due in a week, 2 due in two weeks, etc. I then created a jump menu, with the cdml above, that finds requests due in one week, two weeks, one month. It doesn't seem to be working correctly. How can you search by range with a cdml link? ------------------ ~~~~~~~~~~~~~~~~~~~~~~~~~ Tom Beidler Orbit Tech Services tbeidler@mindsprin g.com ~~~~~~~~~~~~~~~~~~~~~~~~~

I have a solution that only allows any individual user to insert data into a specific record 4 times a day. After which, i need a message to show stating that he can't do this, yada yada yada. Very easy to do in filemaker of course with the Show message step. How can i do it over the internet though? I've thought about cookies, but in this case, that's not safe because it has to be 100% accurate and who knows which users are scared of cookies! Any ideas? Jeremy

I have 6 container fields in a database. Some will get filled with a picture and some won't. I want to display these images if they are there. I dont want to lay down <img src> tags if I dont need to. How can I write a page so [FMP-if:Field:image1.eq.true]<img src="[Field:image:image1]">[/FMP-if]or something like this will just check the container field. All my efforts have returned nothing, a blank area. A repeating field for some reason returns the number "1" instead of a picture. If anyone can help, I'd appreciate it. Rich ------------------ Rich

I ran into a problem that i hope is easily fixed. I have large database that is actually made up of five databases. In the main file, I only use two fields and then every field from the other databases are included in the main database as reference fields. I would prefer to keep it this way so that i can have easier access to each specific database. When I created the web page using Home Page 3.0 and submit a new record, i get an error message 102 which is a "Field Missing" error. BUT I created the pages without using the assistant so if I needed to make any changes I wouldn't run into many problems that I sometimes would if I used the assistant. I thoroughly checked eac…

I've maid a search form with only one field. The forms works fine if the user enter a word and then presses the submit button. But if they hit the return key they get an error (no records found). Do I have to control the form with a Javascript or can change something in my form to make it work even if they press return? I've searched FileMakers Tech Info, but didn't find any answer. /Liveman

Hi I don't know if there is a solution to this problem, anyway. I'm building an online store. When someone enters the store I asign a token with the current recID for the new order. This works fine. The problem is that you can see the token in the address field in the browser and because I'm allowing the visitors to change their order they can also change previous orders by changing the token in address field in the browser... please help me out!

I have been trying to publish a database to the web, and have created a database and an awesome layout, only to turn on WebCompanion, make all the appropriate changes and get the stupid FERN layout.... I am under a serious time constraint though my bosses, please let me know any ideas soon!

Many if not most people eventually find instant web publishing too limited and make the great leap into custom web publishing -- and never regret it.

Hi: I have set up Web Security for my fileMaker 4 database and now it is working with no problems. I've created an HTML hyperlink that creates for me a new record. The I've used the hyperlink so that I can display the user ID number. My question would be how can I include in my hyperlink a username and password so that a new form will be generated without the enter password box. TIA

I want to be able to print (to web/html) a large formatted textfield. I have no problem with the small fields, but this large one comes as one whole string. In Web Companion this field comes out allright*. I tried the <PRE>-tag, but it didn

Hi. Can I send emails to more then one email address using the -mailTo command? Please help.

I have a counter database that is incremented by creating a new record whem the page I need to count is linked (default.htm). It's working fine that way. However, whem the page I need to be counted is bookmarked, the counter does not increment anymore. My question is How can I increment the counter from the counted page which is also using a database (FM Pro). <html><head> <title>Counter</title></head> <body bgcolor="white"> <center> <li><a href="http://192.168.0.133/kpg-msds/FMPro?-DB=Counter&-format=default.htm&-error=errors.htm&-new"> <font face="Arial,Helvetica,Geneva,Swiss,SunSans-…

I have a web form which, when completed and submitted (-new), loads another html page which confirms the record was created successfully and displays the contents of the new record to review and edit in case of data entry error. My problem is that the field where the ID number for the record, which is generated via a script, is blank. Currently my two work arounds are: a) immediately click on the "Update" (-edit) button, which saves and re-loads the same record, and take out the display of the record and provide a link (ie. click [HERE] to review the record) in the confirmation message. A similar problem occurs in the fields where I am showing information from a relat…

I am using Filemaker Pro 5 Unlimited with Web Companion on a Win NT server. Are getting these errormessages ("FileMaker Pro Web Companion internal resources missing") constantly. Must be doing something very wrong : What? Any suggestions? I am a FM newbie (as if you couldn

I am trying to make a field in CDML on my web page a required field on the web page only. The field is not required (via validation) in the FMpro 4.1 DB because I do not want it filled when a new record is created. The field in question is a password field. I do want the user on the Web to fill in this field and not leave it blank on an Web Page with an EDIT form action. I know in HTML you can make form fields required but I do not know how to do this in CDML. I would be eternally grateful if someone could show me how to make the following field required on the web: <INPUT TYPE = text NAME=password VALUE="" SIZE=9>

I have seen that FileMaker does not pack the CDML Reference folder in FMP 5.0+. Dang unfortunate for those who are just getting involved. I got lucky and am using 4.0v3. <p><form action="FMPro" method="post"> <input type="hidden" name="-db" value="The_Tracker.fp3"> <!--leave no spaces in your db name, and FMP 5.0 may require ... .fp5--> <input type="hidden" name="-lay" value="layout name"> <!--if only 1 layout this is not necessary--> <input type="hidden" name="-script" value="Tape Number"> <!--names the script--> <input type="hidden" name="-format" value="success.htm"> <!--successful action--&g…

Does anyone know whats going on here - in my filemaker pro 5 database i have a date field. this automatically adds the current date when a new record is added. The date displays in filemaker in UK format which is consistent with the set up of the machine. However!... when i return a date to a web page thru my browser (netscape and explorer).. its in american format with the day and month reversed... also when i enter a date to search the database via a web form i have to type it in american format for the search to work the way it should!... but in the actual filemaker database file it is in UK format and so is the setting of the machines i have tested it on! what…

I would like to start out by saying that I am new to web based databasing & any help is greatly appreciated. I have started a database on the web & have had good success but to one point: the database has a relationship (using a portal) to another database. Both are hosted on the same server. They are member records the main database includes all of the member files, while the second maintains billing records. I create the page (in Home Page) & upload. In preview all is ok, but on the web the portal & all tags disappear. What am I doing wrong? Is there an easier way?

I have database with different groups. These groups have password acces to different fields. Each user can only see the fields he is authorized for. I would like to enable the users to change their password directly from the web. Has anybody a solution? Thanks and regards R. Boesch

Does anyone know who to perform a find to find records that "begin with". I use bw except that it will find that have any word in that field that begin with what ever I ask. For example... If I want to find all records that begin with the letter S, the results will come up with those beginning w/S such as Staff Analyst and also those that have a word in them that begin w/S such as Research Staff. I want to find only those that do not have anywords in front of the letter S.... HELP!! Thanks!

I've tried many times I could not configure the Web security data base to make an ExactSearch. Every time the reply is :"Field Access Restriction. You do not have access privileges to perform the action:find". All other restrictions work properly. The platform is windows 98. The data base is FileMaker Pro 5 Unlimited. Could anyone suggest me a solution? Thanks a lot!

I am running FMP5/U and allowing Web Companion to function as web server. There is no other web software installed on my machine. Almost daily, however, FMP fails, and on restart shows the error "...port number conflict. Please configure plug-in to use a port number other than 80." I have reinstalled FMP, moved to another server, and still get the same results. A "test" version (using a separate license), developed at the same time with the same code, however, has yet to fail in that way. I can run them side-by-side, and whichever machine the production version is on is the one where FMP fails. Could server load be an issue? If FMP is overwhelmed with HTTP request…

Wow! Used web companion the other day. Not only did it work first time, the layout looks great! How can I squeeze more life out of it? In particular I want to: 1) Bypass the homepage completely. I only have one database. Is this possible? 2) Filemaker shows the current record by default. How do I change this to show, say, the last record or a particular record no? 3) Can I get rid of the default layout (eg that navigation bar that appears in FM5). I'd like my database to appear without any reference to Filemaker. 4) How do I get to the HTML code? Can I open it in Dreamweaver or BB Edit? 5) Can I insert an animated GIF? Would this work the same as any other image? Ho…

Text fields are easy, but how do you upload images to a FMP database over the web. It must be possible. any ideas ??

An online catalog: Click through a list of products using CDML <a href="http://xx.xx.xx.xx:591/FMPro?-db=database&-format=format.html&category=shirts&-find>shirts</a> this link will list all shirts in database. the cdml for the format.html page looks like: [FMP-record] <a href="[FMP-Linkrecid:format=format2.html]>[FMP-Field roduct]</a>[/FMP-Record] Format2.html is the final product page, which displays the details of the product listed from the previous page. All of the above works fine. I just wanted to explain the situation. Here is my problem. I have images on my page which are placed from the database. They are thumbn…

Hello all, I need some help getting my web database to calculate and show the total. I have detailed the setup below in hopes that may help you help me. First calculation field is a text field with a value list and no additional text: $345 $395 $695 $0 Second fields are identical in text format, no text: $45 $45 The calculation field needs to show the total. This is the calculation that worked the last time: "TextToNum(Early Registration Fee) + TextToNum(East Additional Tickets) + TextToNum(West Additional Tickets)", with the fields respective to the above order. This field is then used in an encryption code to be sent via a secure secondary server t…

Hi, I got the following problem: A text-field (t) and 4 boolean-field (b1-4) Now I'd like to do a query similar to this: (t==demo) AND ( b1==true OR b2==flase OR b3==true OR b4==true) Do you have some ideas how to do this ?

Does anyone know of a way, once a user has logged in with a username and password, to have their personal info (i.e. name, dept, phone,etc) automatically entered on a web form? I am trying to automate data entry via the Web and being able to "access" the username would be really helpful. I don't want them to have to enter their info repeatedly. I'd appreciate any suggestions or advice. Thanks.

I have recently developed an intranet where our team can access different DB's from the web. I have each of the databases password protected (and I'm using the Web Security DB), and have used HomePage 3.0 to design the site - is there a way that I can password the index.htm page of the site? Either with a JavaScript or something within Filemaker? I'm hoping to add the extra wall of security.

Hi. I have a couple FM DB up on my company's web site and I know the computer is old (110-MHz Power Macintosh) but is there a way to increase the responce time? I gave FM 55+ MB ram and it fills it about half way. I heard turning file sharing off may help but am currently using it for FTP. Any suggestions. Oh btw, if you want to check out the db: http://databases.seyboldreports.com/ ------------------ ======================== Mike Zornek, Web Development Seybold Publications 428 East Baltimore Avenue P.O. Box 644 Media, PA 19063, USA Phone: (610) 565-2480 x131 Fax: (610) 565-4659 Email: [email protected]

I am creating a basic database using FMP 5 Unlimited. My goal is to let this database be accessed over the web by the company I work for. When I submit a new record using the Web Companion, I get an error which reads: Data Entry Error: Your attempt to save changes to the new failed because of the following: Unknown Error number -50 Any and all help would be greatly appreciated! Thanks, Chris Stotts [email protected]

I am trying to do this, using custom web publishing, FMP 4 and Claris Home Page: - a web page with 2 frames - in one frame, a simple search form is displayed, with a submit button ('find') - in the other frame, I want the search results displayed as a result table. Nothing special, but when I hit the submit button, the results are always displayed in the same frame as the search form! Am I doing wrong something or is this something that can't be done? I have added 'target=xxx' as extra HTML to the submit button, where xxx is the name of target frame, but that doesn't make a difference :-( Thank for help, Hans Erik Hazelhorst Database and Internet Consultant e…

I've created an HTML form to create records in my database. I'm using a combination of CDML and HTML forms. I want to be able to deposit/upload a Word document into a container field via web browser. Is it possible to do this - if so, HOW?

Is it possible to have my web hosted database print only at the server? I am interested in doing this to retain the aesthic (and mechanical) properties of a report; rather than having it print as a web page. Any help would be appreciated.