I absolutely second this.
  ----- Original Message -----
  From: Dick Applebaum
  To: CF-Talk
  Sent: Friday, September 10, 2004 8:32 AM
  Subject: Re: inserting structure data into a database

  Tim

  One of the basic rules of good relational db design is that each entity
  (record, row, column) should be atomic -- represent only one thing,

  You should not insert a structure into a db

  Rather, insert each cassette as a separate row (record) in the db

  If there is a relationship among the multiple cassettes that you
  currently have in the structure, consider adding an identifier (group)
  to each record in the db.

     ID
     Title
     IssueNumber
     IssueDate
     Group

  Dick

  On Sep 10, 2004, at 5:23 AM, Tim Laureska wrote:

  > Just learning structures, but here goes:
  >
  >  When I insert structure data into a database, it's inserted into each
  >  field as a comma delimited list.  
  >
  >  In this scenario, I'm inserting audio cassette tape information into
  > the
  >  database from a form when multiple cassettes are entered at one time.
  >  There are three attributes to for each cassette... title, issue date
  > and
  >  issue number, which are the fields in the database (along with an
  > autoid
  >  field).
  >
  >  So if three cassettes are entered and subsequently inserted into the
  >  database, the data goes in as such:
  >
  >  Auto id    title field        issue number field     issue date
  >  field
  >
  >     1       title1, title2, title3  issue1,issue2,issue3
  >  date1,date2,date3
  >
  >  This seems to present a problem in that each cassette does not have a
  >  unique autoid to identify it individually and that may present issues
  >  further in the application...
  >
  >  My questions are:  1) is this analysis correct and 2)how can you
  >  maintain a unique id for each cassette in this situation ... do you
  > have
  >  to assign a unique number for each cassette using some sort of CF code
  >  or is there a way to still utilize the DB's automatic unique id
  >  assignment feature?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to