zoeriley

I recently created a database/web solution using CDML and successfully hosted it on my computer via FM Companion. But my company needed to have the website online all the time, so we selected a Filemaker hosting company and now the database is on their servers. Only problem is, they use Lasso. They told me that the only change I would have to make is change the form action to "action.lasso", which I did, and most of the CDML format files work fine, with one exception. That exception is that value lists that I'm calling dynamically don't work. The website has a page where our members can edit their own profiles. The non-value list fields, like "type in your name" come up fine with database information intact, but the checkboxes and radio buttons are blank, not reflecting the data that IS in the database. On another page, the same value lists are called (but without editable fields) and the value list items that are checked for each profile ARE there--it's only on the page where the fields can be edited that they're missing. Our web host says that Lasso is 99% compatible with CDML, and that this must be a glitch. But this glitch is huge! Does anybody have any insight into this? I've been all over the web and to Blueworld's website, and the general consensus seems to be that Lasso should be converting the tags--but it isn't. ANY help would be appreciated. Thanks.

Thanks, Garry!!! That worked perfectly. Thank you SO much, you have solved a major headache for me! :-)

Hi Garry, I pasted your code right into my HTML file, replacing the code from above. Unfortunately, it didn't work. When I ran it through a browser, nothing showed up, just a blank area--where before it was drawing a the long column of value list items from the database. Any ideas?

I've been searching the forum, and I've tried the various solutions at the link that Garry provided, but I cannot get any of them to work. None of the solutions seem adapatable to checkboxes and pulling value lists. Does anybody else know of a solution for this? Basically what I have is a list of 200 countries in a value list, and letting them run in a single column down the webpage makes the page very long to print out, which is what visitors will be doing. Does anybody have any other ideas?

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

Thanks for responding. It is currently on a Mac 9.2. When it goes to my client's, it will either be on a Mac machine or Windows machine. That's undecided right now. But if it's similar in either case, where would I go to find out about how to do this?

I have successfully completed a database/website for a client via CDML. The database is currently located on my computer, but it will be moving to a dedicated computer at my client's workplace. My questions is--knowing that the format files are located in Filemaker's Web folder--is there any way to get access to these via FTP from a remote site, such as my office? It worries me that these pages will not be "updateable" if needed. (I am a freelance web designer, and I'm used to being able to connect to any given website for updates as needed.) If anybody has any insight into this, it would be appreciated. Thanks.

See if anyone can solve this one: I have a working Search page, which searches a database of members by multiple parameters. What I would like to do is have a Search Results page that not only lists the members found from a given search, but also has a single link that when clicked, would be an e-mail link to all of the "found" members. Is there any way to set this up? I suppose it has to be some kind of dynamic field that is based on the search results of a particular search.

Woo-hoo!! Got it to work. It was the calling page/hard link issue. Thanks to everyone to helped--this is a fantastic board!

Bevin, it seems to me that you may be right, but I'm having trouble with that tag. I've made a new link via the "FMPro?" link (per your instructions) but I keep getting an error message that the format file can't be found. It's just called "search.htm", which is what I substituted for "mypage.htm". Also changed "mydb" to the name of the database and "web" to the name of my layout. The search.htm is in a subfolder from the default.html page. I tried adding the folder name before "search.htm" but the browser still can't find the format file. What am I doing wrong?

Yes, the correct layout is specified, and the field is on it, and the field contains the appropriate value list. The "text-entry" fields in the Search format file work file. It is only this menu bar that doesn't work. The [FMP-option] tag just appears as code on the menu bar, rather than being replaced with the value list items. When I poked around in the Employees database (the sample file) I noticed that their menu bar on the search field, Department, has something interesting happening in the database. The field "Department" has a value list specified when you select the field and go to "Field format", but when you go into the "specify fields" box and select "options", the field "Department" doesn't show a value list attached. Needless to say the employee search format file works fine with the menu bar, so is this what I'm doing wrong? But I can't figure out how to get the field to show up with no value list in the "specify field" box and still have the value list attached on the layout itself. Thanks, everyone.

Added the noedit code...I'm assuming that the same HTML code that works in GoLive will also work in Dreamweaver. It seems as if the FMP-option code is maybe misplaced in the code or not drawing from the value list in the database. Which is strange because I just added my field name and value list name to the template from the CDML database. Don't know...I've spent most of the day trying to reconfigure this, and I'm running out of ideas!

I made the field and the value list both the name "taxa" in FM, then added your code to the format file (changing the list value to "taxa" as well to reflect the new name of the value list.) Still nothing, and Dreamweaver insists that the option code in brackets is redundant. Any other ideas?

Thanks Bevin, but it didn't work. That was actually the code that was in the CDML database, I think. I still haven't figured this out...but I know the other search paramters on the page are working (first name, last name, etc.) so it's not the way the page is talking to the database, it must have something to do with this individual CDML tag.

I'm using the format file "search" from the CDML "employee" example database, and I've become stymied on the drop down menu. This is the code I have: <SELECT NAME="Taxa"> <OPTION VALUE="" SELECTED>All [FMP-option: Taxa] </SELECT> I'm trying to do a drop down menu using the field "Taxa" and the value list "taxa of expertise." But all I keep getting is one item on the menu bar that reads "All [FMP-option: Taxa]--in other words, the code is on the menu bar. I've tried to use the FMP-option code from the CDML database, and my HTML editor told me that that code was redundant in part, so no help there! Anybody have an idea as to what I'm doing wrong? I have successfully modified the browse and detail format files for my own database, but unfortunately I'm really stuck on this one.