Create The Search Results Page

This page will display all the entries in your database that match the text entered in the search box on the search page. The "short_desc" field contains the location of each property so we only need to search and display the contents of that field together with the small image of the property, the image name for this page is stored in the field "image_small". Because there could well be several properties in our database that match the search criteria we are going to use the Repeater action so all matches are displayed.

You will also notice we are going to match records in the database based on The "short_desc" field containing text which "is like" the text entered in the search box which has been posted from the search page. "is like" does a kind of fuzzy search and matches where ever it finds the same string, ie if you searched for "arm" it would match "armstrong", "longarm" and "harmful" as all these worlds contain the string "arm" but we could do an exact match so it would look for the exact same string. For searches the "is like" tends to be better as it allows more room for matches.

Step 1. First we need to do a load record action so the page knows what records it needs to be pulling from the database. So from the Action Builder Click on the + and then select Load Records	Step 2. Select the table that contains the information, for our demo select "Property_search" and then all the fields to the selected box by clicking on the top arrow button. then click on Next>> to move along to the next screen

Step 3. Now we tell the wizard how to find and match the records, on our demo database it's short_desc "is like" POST Search, make those selections from the drop down and add them to the Where: box so it looks like below. You can either finish the wizard now or continue through it to add more choices such as ordering records and limiting the amount of records to be displayed on a page.	Step 4. Click on the page where you want to display your matching records and then from the toolbox click on Repeater. Select Load From Data Source in the drop down and select or deselect the Don't repeat parent tag. The parent tag will be the headers ie property description, Picture, more, for our demo select don't repeat parent tag. (check the tick box)

Step 5. Click inside the repeater box that has now appeared on your page and from the the toolbox click on When the insert table box appears make it 1 rows and 3 columns. When you click OK the table should appear inside the repeater box, if it doesn't click on it and drag it in. Now click inside one of the table box's and then right click your mouse and select Insert > Header from the pop up menu. This will add a new row to your table so you now have 2 rows, the first row is where you can add heading like we have done below.

Step 6. Now we insert under the headings what information to be displayed from the database. So click in the box under Property and then right click and from the pop up menu select "Set Dynamic Value" then from the drop downs select "Load From Data Source" and then "short_desc"	Step 7. Now we make the Picture dynamic so it will show the correct image relating to the property. To do this click inside the box under Picture, then from the Toolbox select "" and choose a default image that will be shown if no image is available, if an image is available it will be dynamically replaced when the records are displayed. Now click on the image you have inserted on to your page and then right click your mouse and select "Set Dynamic Value" then "Load From Data.." and "image_Small" like below.

Step 8. Now we need to make the More button and make that Dynamic so it will display the correct information on the more page. Click in the table box under the heading "More" and from the "Toolbox" click on "" a yellow box will now appear in your table (see bottom of page). Click inside the yellow box and from the "Toolbox" select "" A dotted line will now appear in your yellow form box. Now press the "End" key on your keyboard and press return so a line opens up so you can now insert a "" from the "Toolbox". then in properties change it's value to More, now select the hidden field and right click your mouse then "Set Dynamic value" and "load from data..." "..ID" Like below. Now double click on the Form tag at the bottom of the screen and from the action drop down select the more page

Your page should now look something like below. You can add your design to your page and any fixed information or menus. Before you move on to the next and final page remember to save this page so that the more page will be aware of the dynamic functions on this page.

Now Create the more Page - Click Here to continue. If you would like to use our "no Image" picture right click on the image below and select "save picture as"