Professional Web Applications Themes

1 resord set and many tables ? - Macromedia Dynamic HTML

I'm the webmaster of our local (amateur) tennisclub and I want to be able to let all our members to search in our member database on our web site. We have 1 database with member data (name, address, ...) put in a table according to the year. So we have a member table for 2005, 2006, 2007, 2008, ... Now I want a search form, that people can put in their lastname, firstname and year (via dropdown list) to search our database. But how can I direct that to the correct year, because in the recordset dialog box I have ...

  1. #1

    Default 1 resord set and many tables ?

    I'm the webmaster of our local (amateur) tennisclub and I want to be able to
    let all our members to search in our member database on our web site. We have
    1 database with member data (name, address, ...) put in a table according to
    the year. So we have a member table for 2005, 2006, 2007, 2008, ... Now I
    want a search form, that people can put in their lastname, firstname and year
    (via dropdown list) to search our database. But how can I direct that to the
    correct year, because in the recordset dialog box I have to fill in the table
    in wich to look for, but I want that table (2005, 2006, 2007, ...) to be
    dynamic dependig on what is filled in the search form.

    tennisboy72 Guest

  2. #2

    Default Re: 1 resord set and many tables ?

    Why not just have one table with a year field? That way you can search
    without regards to year. I am assuming that the year is the year they
    joined.

    For the diffetrent tables thing, you will need hand coding. The drop
    down value for the year and then subsitute the value in the query
    string. You did not say what platform or database.



    tennisboy72 wrote:
     



    --

    Philo Guest

  3. #3

    Default Re: 1 resord set and many tables ?

    ..oO(tennisboy72)
     

    Fix the table design. Use _one_ member table. This already solves your
    current problem and many others further down the road.

    Micha
    Michael Guest

Similar Threads

  1. SQL tables help
    By al_galiza in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: June 29th, 01:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139