calicoskies

I'm so close to getting this to work 100%. It's working on 75% of my issues now. Thanks to you all for the suggestions. I've incorporated many of your ideas and a few of my own and am nearly there. I have one last IF statement that I need, but I can't seem to properly code to work in my results page. Help would be soooooo appreciated. (I've switched to Lasso tags in my If-Else because I could find better documentation on how to write those) Using FM Pro db. When a search is made for products, you'll get either 1, 2, 3, or 4 products on a results page. My coding works for displaying 1, 2 and 4 products in a certain format. However, I can't make it work for 3 in the desired format. I need another nested IF, or Else If in there, but everytime I create one, the whole thing breaks down completely. When 1 product is found, it plops my record into a formatted table cell, creates a blank narrow black cell, and then creates a blank wider white cell to show a blank spot where a second product would go. That is perfect. When 4 products are found, it displays them 2 across on the page, makes a new row and displays 2 more cells across, everything in their own little formatted table cells. That is working great. The problem is finding 3 products. I want it to put the first 2 products 2 across, and the last product one across plus add a blank white cell. I can't do it. Can anyone help? Following is the code I have so far that works. thanks very much, Lynn <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0> <TR> [fmp-record] <TD HEIGHT=215 WIDTH=1 VALIGN=TOP BGCOLOR="#000000"><IMG SRC="../Resources/_clear.gif" BORDER=0 WIDTH=1 HEIGHT=1 ALT=""></TD> <TD WIDTH=298 VALIGN=TOP BGCOLOR="#ffffff"> <BR> [fmp-field: logoURL, raw]</SPAN></FONT> [fmp-field: pictURL, raw]</SPAN></FONT> [fmp-field: Item_Name] <BR> Part Number: [fmp-field: Part_Number] Description: [fmp-field: specs, break] List Price: $[fmp-field: List] <BR> Sale Price: $[fmp-field: Sale] [if (Found_Count)=='2') || ((Found_Count)=='3') || ((Found_Count)=='4')] <IMG SRC="Resources/bigspacer.gif" BORDER=0 WIDTH=298 HEIGHT=3 ALIGN=ABSBOTTOM HSPACE=0 VSPACE=0 ALT=""></TD> <TD WIDTH=1 VALIGN=TOP BGCOLOR="#000000"><IMG SRC="../Resources/_clear.gif" BORDER=0 WIDTH=1 HEIGHT=1 ALT=""></TD> [if: (repetition)==2] </TR><TR> [/if] [Else: If (Found_Count)=='1')] <BR><IMG SRC="../Resources/bigspacer.gif" BORDER=0 WIDTH=298 HEIGHT=3 ALIGN=LEFT HSPACE=0 VSPACE=0 ALT=""></TD> <TD WIDTH=1 VALIGN=LEFT BGCOLOR="#000000"><IMG SRC="../Resources/_clear.gif" BORDER=0 WIDTH=1 HEIGHT=1 ALT=""></TD> <TD WIDTH=298 VALIGN=TOP BGCOLOR="#ffffff"><IMG SRC="../Resources/bigspacer.gif" BORDER=0 WIDTH=298 HEIGHT=3 ALIGN=LEFT HSPACE=0 VSPACE=0 ALT=""></TD> <TD WIDTH=1 VALIGN=TOP BGCOLOR="#000000"><IMG SRC="../Resources/_clear.gif" BORDER=0 WIDTH=1 HEIGHT=1 ALT=""></TD> </TR> [/if][/fmp-record] </TABLE>

Thank you both for the help. I'm part way to a solution, and wonder if you could help me with one last piece of code? (I had difficulty with a javascript error from dspires solution, and the solution from The Bridge was so close to working, but it produced a row of 4 across the page. Thanks for trying though!) I do have this working solution that needs tweaking though: code: <table ...> <tr> [records] <td> ...my fields... </td> [if repetition)==2]</tr><tr> [/if] </tr> </table> This allows me to have 2 across products on a page, which is perfectly fine. BUT, if I only have 1 product, it leaves a blank spot where a cell should be for a second product. Looks bad that way. How do I write an IF statement that will look to see if the last record in the table is a single item, and force it to create a blank cell of a certain width for that second space? Thanks again Lynn

Hello, I have a FileMaker DB hosted on a server running Lasso. But, I am using mostly CDML tags (except for the call tag) since Lasso can read those. The web site uses a search page to find a group of products, then it is displayed on a results page. The results page has the following code,and works well. code: [fmp-record] [fmp-field: logoURL, raw] [fmp-field: pictURL, raw] [fmp-field: Item_Name] Part Number: [fmp-field: Part_Number] Description: [fmp-field: specs, break] List Price: $[fmp-field: List] Sale Price: $[fmp-field: Sale] [/fmp-record] This makes the products all display, but, they display one after another vertically on the page. I'd like to be able to display 2 or 3 across on a page, and then have it start filling the next row with 2 or 3 items. (now it does one across and then down) How do I code that? I had suggestions from lasso developers, but I just don't understand the lasso code enough to convert my pages Help? -Lynn

I found the answer....thought I'd share it with you in case someone else has the same trouble. code: The problem was the placement of the [FMP-linknext][/FMP-linknext] and [FMP-linkprevious][/FMP-linkprevious]. The [FMP-linknext] tags create a hyperlink around the element. However windows will not allow you to link a <TR></TR> table row. I moved the tags around the image itself and it works.

My clients found a bug that only seems to happen on PC's, not Macs. I can't figure out why this is happening to them. To find products a search is conducted. At the top of the results page are some graphical buttons for "NEXT" and "Start a new search" etc. On the mac, these buttons work fine, however, on a PC I'm told "NEXT" or "PREVIOUS" don't work. These have been tagged with markup language as such in the Table Row Markup shown below (Start a new search has been tagged differently through Freeway; Freeway is my web design application and it works fine.) code: before <TR> [FMP-linknext] after <TR> [/FMP-linknext] This makes the graphic only show up when needed (as in when there are actually items to go to next, or items in a previous page) The PC users see the graphic, but they can't click on it. However, all this works fine on the Mac (at least on my macs it does). Do you have any ideas what is going on? Or how I could solve this? I'm stumped. You can see the site here My clients site....with the affected database Just click on furniture showroom and then pick a manufacturer like Martin. Thanks very much, Lynn

I've been working on the search pages of my web site. There are currently 2 drop downlists, one is named manufacturers and the second lists subcategories of products that the specific manufacturer makes. That subcategory should be specific to the manufacturer. Right now, in my database, it's not specific to a manufacturer. I need it to be though. I did try using a case function calculation like this: Prod_Type_Case = Case(Manufacturers = "Hon", Hon, Manufacturers = "Martin", Martin, Manufacturers = "Creative",Creative, Manufacturers = "LaZBoy", LaZboy, Manufacturers = "Hooker", Hooker) What I had hoped this would do is have it look at whether the choice of say "Creative" had been made, then it would look for the field named Creative which is a text field with a value list listing all the categories specific to Creative. I can't figure out how to make it truly work though. Someone suggested I need a second database and to make it relational (with a 3rd database inbetween) but that seems like overkill for something like this. Not sure though. I'm a database newbie and I might be all wrong. Isn't there a way to do this in one database? Help is really appreciated, I've been stuck on this issue for days and have reached burnout. thanks, Lynn

I'm using Inno-Tech [ http://www.inno-tech.com/macaddict/ ] They are reasonably priced with their special of $40 / month for life. (note that is applicable if you mention Mac Addict, or sign up through the link shown above. Cheaper yet if you pay a year at a time. No set up fees. No weird fees. Free first month hosting. Read their site for all the neat perks. REAL PEOPLE actually helped me get going with my first database there, and they answered me quickly! I've been really happy with them in the short time I've had my stuff there. Good luck.