Gerald,
God, it getting scary now, I'm actually starting to grasp all this stuff now.
this is exactly what I came with last nite, but just didn't understand what your
idea was when I first read it. :) This appears to be the best solution.
Thanks for your help,
Cheers,
>>On Wed, 11 Jul 2001 12
t2 has a line for each of the multiple IDs
MYKEY ID
---
key1 IM34456
key1 IM34457
key1 IM34458
key2 IM34457
key2 IM34567
...
t1 would have lines like ( using your fields instead of name,addr,city )
MYKEY NAME ADDR CITY
- - - -
key1 name1 addr1 city1
ke
Gerald,
You lost me on the second table, t2?? The t1 table would store a 'mykey' and the
multiple values(ID's) and table t2 would have the reference 'mykey' to table t1
and the ID column,... this is where you loose me??
>>On Wed, 11 Jul 2001 08:26:11 -0500, Gerald Clark <[EMAIL PROTECTED]>
>
Use another table to hold these values.
This table contains the ID that you are searching on and the key
to the other table that contains the rest of the data.
t1 : mykey , field1, field2, field3, field4 .
t2 : mykey , ID
Select * from t1,t2 where t1.mykey = t2.mykey and t2.ID="IM34485";
|| ID
like '%,$value,%' || ID like '%,$value'
-
Regards,
Rod~
> -Original Message-
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of MikeBlezien
> Sent: Tuesday, July 10, 2001 10:50 PM
> To: Rodrigo
ge-
>>> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
>>> Corp.]On Behalf Of MikeBlezien
>>> Sent: Tuesday, July 10, 2001 10:38 PM
>>> To: [EMAIL PROTECTED]
>>> Subject: Multiple column value
>>>
>>>
>>> Hi All
10, 2001 10:38 PM
> To: [EMAIL PROTECTED]
> Subject: Multiple column value
>
>
> Hi All,
>
> Quick question. We need to store a multiple value in a table
> column as we don't
> know how many values at the time of submission there could be.
> The column would
> b
Hi All,
Quick question. We need to store a multiple value in a table column as we don't
know how many values at the time of submission there could be. The column would
be storing a group of values something like this:
Column 'ID'
IM34456,IM34485,IM34478
or it could be more or less. So if we p
