sfsmith

I am using a Password field with CDML and I cannot get FileMaker to return an exact match. I've tried a few different things, but this is the code I have right now: <input type="hidden" name="EIN" value="=="> <input type=text name="EIN" id="EIN" value="" size=30 class="monospace" tabindex="1"> <input type="hidden" name="-Find" value=""> <input type="submit" name="-Find" value="Submit"> I've tried an op=eq tag, with and without an id parameter in the text input field, etc. Can anyone see what I might be missing? Thanks!

I export FileMaker data, including text box data, to a SQL database. The data looks fine in FileMaker, but when it is imported into SQL, carriage returns are displayed with a square character. Has anyone else experienced this and do you know how to prevent it?

I'm just interested to find out if anyone ever discovered the solution to this problem? It just today started happening to me, too. I am running FM 5.5 from a Mac G4 on OS X and using a custom publishing solution that has been running for quite some time. The only thing that's changed recently is we upgraded from OS 9 to OS X, but all the preferences on FM are the same. Everything on IE works fine, but Netscape now tries to download the default.htm page to the hard drive instead of opening it as a web page.

I've been experiencing this same error and here is what I discovered... I got the "format file not found" error as long as I did not include an -Error page as part of my data submission. When I added this tag to my form submisssion, <input type=hidden name="-Error" value="/newop/search_error.html">, I no longer got the "format file not found" error. Instead, my error page was returned to me where I had inserted the [fmp:statuscurrenterror] code and the error code that was displayed was Err: 102. A quick search of the FMP TIL for Err: 102 revealed this little nugget of information: RESOLUTION Check that all fields that you are attempting to add to the database exist on the layout specified in the HTML document. Voila! Two hours of troubleshooting fixed! You may all have different kinds of errors, but try adding an error trapping page to your submissions to see if what's really going on is a database error. Good Luck!

I thought I read that neither instant web publishing nor CDML allowed you to use portals in your web interface.

I'll be interested to see if you ever figure out how to publish URLs without attaching them to buttons; I've never tried to do that. Here's what I know about publishing databases to the web...(I hope other members will correct any of this if it's not exactly right) There are two ways to publish your database to the web with FMP - instant web publishing and custom web publishing. Instant Web Publishing is done through Web Companion and you can select how your data will be displayed from a list of pre-defined web styles that FileMaker gives you in the "Configure Views" section of the Web Companion setup. If you do not choose a style from the list, you will get the default style. You cannot modify or add to these pre-defined styles. Custom Web Pulishing is done by adding special tags to the source code of your web pages. You take the web site that you've already designed, and you add instructions in code about which database to pull information from and which fields you want displayed, etc. All of your stylistic formatting is still done in HTML. To do this, you need to learn the FileMaker Pro specific tags that send instructions to the database. These tags are very simliar to HTML, so if you code in HTML it will be fairly easy to pick up. You can use CDML, which stands for Claris Dynamic Markup Language, and is the set of tags that FileMaker put out for this purpose, or you can use LDML, which is Lasso Dynamic Markup Language. LDML belongs to the Blue World product called Lasso, and it is more powerful and able to do more than CDML. CDML is free. LDML comes with a purchase of Lasso. Everything I've needed to do to get my database info on the web, I've been able to do with CDML. When I learned CDML, I found the documentation to be pretty poor. I think there have been books published on it now, so it should be easier.

It's fixed! You won't believe what the culprit was...a corrupted FileMaker Unlimited running on the workstation that the web server was trying to access!!! Reinstallation of FMUnlimited on that workstation solved the whole problem. Crazy, huh? This was a case of two heads are better than one...my FMP consultant came in today to work on the accounting database. I asked him to look at this for me, and in the course of showing him the setup, we discovered that Unlimited was broken. A happy ending here! PS - Just to be safe, I also bumped up the memory on FMUnlimited since it was only on the suggested amount. That never hurts.

quote: Originally posted by Anatoli: Where you see the #3 error? Which application is showing that? If FM, ask FM Inc. If server... I found a FMP TIL article that said that common issues between FMWSC and ASIP are that I have to be running Java Runtime Environment 2.1.4 or later (got that), and that the Plug-ins Memory in the Web Server has to be set to 512K or larger (mine was too low). I reset the Plug-ins Memory to 768K, restarted the web server, and now I'm getting a different error - Internal Server Error 500. So, there's definitely a problem between ASIP and either the FMWSC or FMServer. What that problem is is anybody's guess. FMP has moved me up the tech support chain to the Advanced Techs and they're supposed to be investigating. Happily, FM Tech Support has not passed the buck to Apple, because FMWSC is supposed to work with ASIP. I will post any resolution that I get to this problem on the board. ------------------

I just set up a RAIC running on all Mac machines and using Apple Share IP 6.02 as the web server. In addition to the web server, there's FMP Server and two workstations running FMP Unlimited. If I point my browser to either of the two workstations, everything works fine. But pointing to the web server (which is how it's supposed to work) gives me an Error #3 as soon as the FMP find command is executed. Has anyone else had this problem and do you know of any fixes or possible troubleshooting I could try? ------------------

quote: Originally posted by Anatoli: Is the connector serving the web server? Yes. And I have configured the Web Server Connector to point to two hosts (my two workstations running Unlimited) and one database.

NEVER MIND!! While reading over my post, I discovered my problem. It's always such a simple thing, isn't it? I had the textarea named "textarea" instead of the FMP field name. So stupid! Putting in the right name for the textarea solved my problem. Thank you!

I want to include a <textarea> tag in my format file to let my clients submit edits to a large body of text. But the textarea tag doesn't seem to work with CDML. I keep getting an ERR:102, which translates into "Make sure the field you want to modify is on the layout you're using." It is. Now the -Edit works just fine if I make my input type a standard "text" field. Has anyone else experienced a similar problem with using <textarea>, and is there a way around it? Here's how I've set up the table using the textarea tag with the CDML. Actually, here's a sample of the whole form: <form action="FMPro" method="post"> <input type="hidden" name="-DB" value="OnlineDB.fp5"> <input type="hidden" name="-Lay" value="Marketing"> <input type=hidden name="-Error" value="onlinedb/edit_error.htm"> <input type="hidden" name="-Format" value="onlinedb/edit_reply.htm"> <input type=hidden name="-recid" value="[fmp-currentrecid]"> <table width="528" border="1"> <tr bgcolor="#99CC99"> <td><font face="Arial, Helvetica, sans-serif" size="2"><b><font size="3">Human Interest Story</font></b></font></td> </tr> <tr> <td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"> <textarea name="textarea" rows="10" cols="55" wrap="PHYSICAL" VALUE="[FMP-Field: RLS]">[FMP-Field: RLS]</textarea> </font></td> </tr> <tr> <td><font face="Arial, Helvetica, Palatino" size="2"> <input type="submit" name="-Edit" value="Submit Changes"> </font></td> </tr> </table> </form>