Okay then, let's take this one step further....

If my DB has 2 table (many to one), such as product---<options linked on
product ID.

Can anyone think of a way to create a view that will show the option row for
a given productid as a single delimited list?

Jonathan McGuire

----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 14, 2000 8:06 AM
Subject: RE: SQL 7


> > Is one able to create a comma delimited list in a SQL 7 column.
> > If so, is =
> > this the best solution versus, adding a row.  If not, what is the most =
> > efficient way to distinguish the information between two identifiers.
>
> If I'm understanding your request, you want a denormalised list in a
field -
> in which case, just use a Text field or a Varchar field.
>
> You can put anything you want into those fields, so it can easily contain
a
> comma separated list.
>
> If you want to hold 2 lists for 2 different fields, then store 2 different
> lists in 2 fields - there is no reason to hold them in one field
>
> There are problems with denormalised lists, but for small amounts of data
> they are fine - I would suggest moving to normalising your relationships
> though, it makes the system a lot more expandable.
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to