WDB Help on Queries

  • Specifying Query Constraints.
  • Submitting Your Query
  • Tabular Output

  • Specifying Query Constraints.

    When you first enter a WDB query form you will see a lot of query fields like this :

    Birthday (year).. :

    These are the operands that are available for querying in the fields.
    <
    Less than.
    >
    Greater than.
    <=
    Less than or equal to.
    >=
    Greater than or equal to.
    !=
    Not equal to.
    =
    Equal to (with wild-cards, i.e. the * operator)
    ~
    As = but ignoring case.
    ==
    Exact match (No wild-cards)
    *
    Wild-card in strings ( A*B will match AB, AxB, AxxxxB, etc. ).
    ..
    A range of values (ex.: 234.56 .. 678.9 ).
    |
    OR
    Will match any of the specified expressions (ex.: =123 OR > 5000 OR < 1 ).
    So for example : To select all members with birthdays after 1970 you could enter :

    Birthday (year)... :

    When you search in text fields, without specifying an operator it will be interpreted as '~*your-text*' (i.e. a wildcard match)

    Some fields has a fixed set of allowable values from which you can choose.
    Gender...... :
    These fields normally have a default value of "Any" which means : Accept any values in this field.


    Submitting Your Query

    To get the result of your query you have to submit it. At the top and at the bottom of the query form you will see a set of buttons like this :

    In order to to submit your request press the "Search" button. If you want to reset all the fields back to the way they where before you started entering qualifiers in them, press the "reset" button.


    Tabular Output

    If you submit a query that returns more than one row of data, you will a list in tabular form like this :

    There will typically be one or more columns where the values have hypertext links. The values in the leftmost column will normally lead you to a full-screen version of the corresponding row, with all information available. Other columns will lead you to related data screens.
    Try it out !

    Several fields can be selected using the Ctrl key and the left mouse button at the same time Try it now !

    Teenage Wildlife Home Page Bowie's music Info on Bowie Other Media Have your say! Search the Site Help me!

    Toolbar (Interact)

    This document last updated Sunday, 08-Nov-1998 20:03:20 EST
    Etete Systems