untitled

 


 

6 - How to do a Search with the Cataloguer using <> and = symbols

By Leanne Simmons

 

To next Tutorial (Search Facility using 'Like')
 



 

I will be using the same Catalogue used in the previous search tutorial for simplicity reasons. (By the way John's Motorcar catalogue has meantime grown to include some 500 pictures. Nice work).

 

 

I will use the speed field to search using the criteria 'not equal to' ("<>") and its opposite, the 'equal' ("=").
I'm curious to find out of these 500 vehicles, those that can travel at a top speed of 350kms. I am told some do.

 

 

I Click the icon for the Search

 

 

Pick Any Category (I will search the entire catalogue)

 

 

There are no Sub-Categories, and I would not use specific ones either as I want the whole catalogue searched

 

 

Click to tick the 'Also use this criteria' box

 

 

My choice is 'Speed'

 

 

Pick the criteria "=" from the next droplist

 

 

type in my value of 350kms and 

 

 

Click the find button. This should bring me all of John's vehicles catalogued that can travel at that fast speed.

 

 

It finds two vehicles that are catalogued accordingly.

 

 

These vehicles are different makes and stored in different storage points, the Lamborghini is in Disc No. 15 and the Porsche in Disc No. 17 (each in its own CD disc - see how its done in earlier tutorials and confirm it at the previous tutorial). I am going to use that knowledge to narrow this search further, and force the Cataloguer to bring only the one image from disc No. 15 only. I click the box to also include the next criteria.

 

 

Pick the disc no. choice

 

 

and using the "<>" (not equal to) symbol (I can now use it to 'exclude' the Porsche Vehicle which I know is stored in John's Disc No. 17).

 

 

type the value to exclude, 17 as the disc No. (the summary runs as follows so far: I searched the entire catalogue to isolate the 350kms speedsters, found 2, I know their Discs Numbers as I clicked each image and referred to their respective data details, and now can confidently narrow the search to a known result to test the search of the catalogue - it should bring only the 350kms speedster stored in disc 15, that is not the Porsche but the Lamborghini)

 

 

Yes, that's what get as a result too.
This tutorial shows how to use the search criteria, separately or combined.

 


To CML SoftDev Website - to the Index page

Next Tutorial

                  


Report Content · · Web Hosting · Blog · Guestbooks · Message Forums · Mailing Lists
Easiest Website Builder ever! · Build your own toolbar · Free Talking Character · Email Marketing
powered by a free webtools company bravenet.com