Professional Web Applications Themes

database design and asp question - Dreamweaver AppDev

I have a company that grows food. They have 60 plots of land. For each plot I have a plotID and I have other information like startdate, enddate and product and others. What I want to do is to create a table on a page and put a map of the property in the background. Then in the cell for each plot , I want to show that plot information and the vital information. My problem is that I don't think I designed the database correctly as I cannot figure out how to call the information of each id to ...

  1. #1

    Default database design and asp question

    I have a company that grows food. They have 60 plots of land. For each plot
    I have a plotID and I have other information like startdate, enddate and
    product and others.

    What I want to do is to create a table on a page and put a map of the
    property in the background. Then in the cell for each plot , I want to show
    that plot information and the vital information.

    My problem is that I don't think I designed the database correctly as I
    cannot figure out how to call the information of each id to show separately.

    I can do a repeat region and show all the info, but you it where I want on
    the page I am drawing a blank.
    Michael


    Michael Guest

  2. #2

    Default Re: database design and asp question

    To show just the information for just one particular record, filter the
    recordset by the ID number.

    The SQL would look like SELECT * from table WHERE PlotID = MMColParam


    --
    Nancy Gill
    Team Macromedia Member: Dreamweaver MX/UltraDev
    http://www.macromedia.com/go/team/
    Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
    Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
    Guide, Mastering Macromedia Contribute
    Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

    "Michael" <it> wrote in message
    news:d9glop$rkm$macromedia.com... 
    plot 
    show 
    separately. 


    Nancy Guest

  3. #3

    Default Re: database design and asp question

    Thanks Nancy, but then I would have 60 recordsets as I have one cell for
    each plot on the map. I thought that to have more than one or two was not
    advisable?
    thank you
    Michael


    "Nancy Gill" <com> ha scritto nel messaggio
    news:d9lhda$m3s$macromedia.com... 
    > plot 
    > show 
    > separately. 
    >
    >[/ref]


    Michael Guest

Similar Threads

  1. Replies: 3
    Last Post: August 31st, 01:14 PM
  2. Database Design Question !!
    By Adam Knight in forum ASP Database
    Replies: 3
    Last Post: August 14th, 08:45 AM
  3. Database Design
    By Mohan in forum Oracle Server
    Replies: 10
    Last Post: July 15th, 10:05 PM
  4. Database Design
    By Sampangi in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 13th, 09:28 PM
  5. Database design/optimization question
    By AMIT in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 1st, 07:02 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