-Find results in a table

[Chirriras]

I'm completely lost on this one and need your help again. I have a small database for tracking alumni volunteers. I need to allow, through the web, the ability to search on several fields (one at a time). I think I can set up the search page okay, it's the results page I'm confused about. I want the results to appear in a table. For example, if they do a search on "Name", then a table comes up with the first name, last name, street, city, state and zip. This is so they can see all of it on one screen instead of scrolling through. How do I lay out the results page to show this?

I've been through the samples and I've scrolled this list, and can't find anything that I think is specific to what I want to do.

Also, as a side note, and this is a dumb question I'm sure, but just WHAT IS a token? I've never used them and I don't understand what the purpose is. What am I missing out on?

[Unable]

The SampleFile, CDML -Op values and Symbols demo, demonstrates that. Select begins with. enter the letter b. The results page displays names in a table. If you want to show data from other fields you must add the fields to this basic table display.

I believe a token's use is demonstrated in the SampleFile, CDML Linking to the next record.

[Chirriras]

I have downloaded the file, opened it, opened the database, then opened the default file in my browser. When I click the link, I get "the page cannot be displayed". What's wrong? Where does the file need to be in order to be read?

[Chirriras]

I opened each page individually in my browser, but am still lost. I see where this tells me how to create the link to the results page, but how do I set up the results page to display the results in a table? In none of the materials I have gone through do I find anything that tells me how to set up the results page--they just refer to it as where the data will go.

As usual, I'm probably making this more difficult than it needs to be.

[Unable]

Did you "Take all the files out of the folder and put them loose in your folder Web." as the instructions in the thread told you?

The db file should already be set for web sharing. Confirm that setting. Web Security should have an appropriate record set to "all users", "browse".

For reading the format files, they were originally hand-written in SimpleText. Compression may have altered that somewhat. In order to read them as text you may need to drag and drop the format files into SimpleText (Mac) or Windoz NotePad (pc). You can also view them as text under "source" in your browser. I have checked this with a copy which I downloaded and it functions fine for me.

There is no set formula for a "results page". It can be made to display data from a db file, but it can also be made to display a text message or images not related to db data.

The page in this "operator symbols" demo which displays the results from the find to which I referred in an above post is pan.htm

In point of fact, when you get the demo to run, you will find that the tag used to display the results is displayed on the page at the top of the displayed results. That tag also tells you which field is being displayed. Obviously more detail can be found on the format file itself. pan.htm is quite simple in its structure.

[Garry Claridge]

Here is a starter:

<table>

<tr><td>Name</td><td>Address</td></tr>

[FMP-Record]

<tr>

<td>[FMP-Field:firstname] [FMP-Field:lastname]</td>

<td>[FMP-Field:street]<br>[FMP-Field:city] [FMP-Field:state] [FMP-Field:zip]</td>

</tr>

[/FMP-Record]

</table>

All the best.

Garry

[Unable]

Yes, that is essentially the same as the starter to which I pointed him and which already existed here and was easily referenced here. The difference; the demo uses one concatenated field and inherently provides much more information about developing a CDML solution.

[Chirriras]

Done. So far so good. Now another question. What I am listing is the first name, last name, email address and phone number. Is there any way to put more space between the last name and email address and the email address and the phone number?

To further complicate things, there is one quetion at the beginning of the card they filled out asking if they want to assist in certain programs. When doing a search, I need to weed out the ones that say "No." Is it possible to add an IF statement at the beginning of this without totally screwing up the works?

[Chirriras]

Note: I resolved the spacing issue by using Garry's code.

[Garry Claridge]

You can use the [FMP-If] tags within the [FMP-Record] tags. So, what you wish to achieve should work fine (you can also eliminate these records by adding that parameter to the original request).

All the best.

Garry

[Steve T.]

Hi, Tucker!

I wasn't sure if you got the gist of tokens or not... Tokens are kinda like variables that you can use to remember things from web page to web page. For example, let's say a user is viewing a record on alumni projects (FMP) and they decide they want to sign-up for your mailing list (FMP). Using a token, you can "save" the recordID they were viewing when they decided to click on the link to join. After signing up, you can return them to the same record they were viewing before by doing a find for that recordID stored in the token. Tokens only have a life of 1 page, though, so you would have to renew its value on every page until you are done with it.

initial page: <input type="hidden" name="-token" value="[FMP-CurrentRecordID]">

each renew: <input type="hidden" name="-token" value="[FMP-CurrentToken]">

return find: <input type="hidden" name="-recID" value="[FMP-CurrentToken]">

--ST