Received: from funredes.org (funredes.org [205.160.164.9]) by hub.org (8.9.3/8.9.3) with SMTP id LAA84773 for ; Fri, 13 Aug 1999 11:05:56 -0400 (EDT) (envelope-from mike@fieldco.com) Received: from mike (net0port48.tricom.net) by funredes.org (5.x/SMI-SVR4) id AA04496; Fri, 13 Aug 1999 11:08:28 -0400 Message-Id: <008701bee59e$0e951f80$0200a8c0@mike> From: "Mike Field" To: Subject: Multiple values for a field Date: Fri, 13 Aug 1999 11:11:00 -0400 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0084_01BEE57C.869A09E0" X-Priority: 3 X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3155.0 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3155.0 This is a multi-part message in MIME format. ------=_NextPart_000_0084_01BEE57C.869A09E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi- Does anyone have any ideas on the following? In my database that categorizes research documents and publications, I = have in some cases more than one author, more than one region, subject, etc. = per document. You mentioned yesterday that the best way to handle that is = to have a table for say, authors like this: docid | authorid and have more than one row for a document if that document has more than = one author. My problem is that I'm pulling the info out of the database on the web, = and I find that I have to use a loop for the fields that have multiliple values - and since I have several of those fields, many loops starts to = bog down the processor. My objective is to try to get all the data out, for = all documents, in one single query - so that I can make a list of all the documents and their pertinent data. Do you see any problem if I put the actual names of the authors, comma separated, in the author field (for example: Mike Field, Tom Lane, ZZ = Top)? I would do the same for my six fields which may have multiple values (author, region, subject, related_projects, doc_type, translations) I = have about 550 documents to put into the database. I know using text fields would take up more space relative to just using = a number to refer to the author... but using a number makes me perform = more loops and thus, more processing time. Let me know what you think. Thanks, Mike ------=_NextPart_000_0084_01BEE57C.869A09E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi-
 
Does anyone have any ideas on the following?

In my database = that=20 categorizes research documents and publications, I have
in some cases = more=20 than one author, more  than one region, subject, etc.=20 per
document.  You mentioned yesterday that the best way to = handle that=20 is to
have a table for say, authors like = this:

docid  =20 |   authorid

and have more than one row for a document = if that=20 document has more than one
author.

My problem is that I'm = pulling the=20 info out of the database on the web, and
I find that I have to use a = loop for=20 the fields that have multiliple
values - and since I have several of = those=20 fields, many loops starts to bog
down the processor.  My = objective is to=20 try to get all the data out, for all
documents, in one single query - = so that=20 I can make a list of all the
documents and their pertinent = data.

Do=20 you see any problem if I put the actual names of the authors,=20 comma
separated, in the author field (for example:  Mike Field, = Tom=20 Lane, ZZ Top)?
I would do the same for my six fields which may have = multiple=20 values
(author, region, subject, related_projects, doc_type, = translations) I=20 have
about 550 documents to put into the database.

I know = using text=20 fields would take up more space relative to just using a
number to = refer to=20 the author... but using a number makes me perform more
loops and = thus, more=20 processing time.

Let me know what you=20 think.
Thanks,
Mike
------=_NextPart_000_0084_01BEE57C.869A09E0--