Quick SQL design help

2002-02-13 Thread James Carrier
Hello MySQL users I was wondering if one of you could advise me on the best solution to a problem I'm having - I'm sure this has been done before but haven't found anything in the archives. Basically the problem I am having is how best to handle multiple values for a specific column, in this cas

Fwd: Re: Quick SQL design help

2002-02-12 Thread tj marlin
>Date: Sun, 10 Feb 2002 16:06:55 -0800 >To: [EMAIL PROTECTED] >From: tj marlin <[EMAIL PROTECTED]> >Subject: Re: Quick SQL design help > >the SET data type comes to mind. there is a limitation of 64 for the set >size. > >ciao > >At 05:23 AM 2/10/02 +

Re: Quick SQL design help

2002-02-12 Thread DL Neil
Hello James, > Basically the problem I am having is how best to handle multiple values for > a specific column, in this case the values in question are coming from an > HTML SELECT MULTI box processed by PHP. > > The way I have been doing this so far is to have a delimited value stored > in a var

Re: Quick SQL design help

2002-02-12 Thread Amer Neely
> Hello MySQL users > > I was wondering if one of you could advise me on the best solution to a > problem I'm having - I'm sure this has been done before but haven't found > anything in the archives. > > Basically the problem I am having is how best to handle multiple values for > a specific col

Another question - Re: Quick SQL design help

2002-02-12 Thread James Carrier
Hi Amer Thanks for replying - I wonder if you could clear up a point for me. I'm going to have many, many possible multi values - too many for a SET or ENUM column as some other people have suggested. I'm happy using the following tables: parts (partid int, partname varchar(255)) cat

Re: Another question - Re: Quick SQL design help

2002-02-11 Thread Amer Neely
James Carrier wrote: > > Hi Amer > > Thanks for replying - I wonder if you could clear up a point for me. > I'm going to have many, many possible multi values - too many for a SET or > ENUM column as some other people have suggested. > I'm happy using the following tables: > > parts (

Re: Quick SQL design help

2002-02-10 Thread Amer Neely
> Hello MySQL users > > I was wondering if one of you could advise me on the best solution to a > problem I'm having - I'm sure this has been done before but haven't found > anything in the archives. > > Basically the problem I am having is how best to handle multiple values for > a specific col

Fwd: Re: Quick SQL design help

2002-02-10 Thread tj marlin
>Date: Sun, 10 Feb 2002 16:06:55 -0800 >To: [EMAIL PROTECTED] >From: tj marlin <[EMAIL PROTECTED]> >Subject: Re: Quick SQL design help > >the SET data type comes to mind. there is a limitation of 64 for the set >size. > >ciao > >At 05:23 AM 2/10/02 +

Re: Quick SQL design help

2002-02-10 Thread DL Neil
Hello James, > Basically the problem I am having is how best to handle multiple values for > a specific column, in this case the values in question are coming from an > HTML SELECT MULTI box processed by PHP. > > The way I have been doing this so far is to have a delimited value stored > in a var

Quick SQL design help

2002-02-09 Thread James Carrier
Hello MySQL users I was wondering if one of you could advise me on the best solution to a problem I'm having - I'm sure this has been done before but haven't found anything in the archives. Basically the problem I am having is how best to handle multiple values for a specific column, in this cas