: Wednesday, March 27, 2002 1:05 AM
To: adam nelson
Cc: [EMAIL PROTECTED]
Subject: Re: binary expansion?
adam nelson queried:
iPersonType is a list in the form of 1,2,4,8,16,32,64
so, let's suppose that szPersonType for 8 is lawyer and szPerson type
for 2 is redhead
a value of iPersonType of 10
It's been a while since I've done this, does anybody remember:
If I have 2 tables:
tblPerson (
iPersonID int
szPersonDesc varchar
iPersonType int
)
tblPersonType (
iPersonType int
szPersonType varchar
)
iPersonType = iPersonType (foreign key between the 2 tables)
iPersonType is a list in
From: adam nelson [EMAIL PROTECTED]
It's been a while since I've done this, does anybody remember:
I'd like a query that looks for lawyers...
Have you thought about using an unsigned int and doing bitwise math?
---
Rodney Broom
Programmer: Desert.Net
sql
On Tuesday 26 March 2002 3:30 pm, adam nelson wrote:
It's been a while since I've done this, does anybody remember:
If I have 2 tables:
tblPerson (
iPersonID int
szPersonDesc varchar
iPersonType int
)
tblPersonType (
iPersonType int
szPersonType varchar
)
iPersonType =
adam nelson queried:
iPersonType is a list in the form of 1,2,4,8,16,32,64
so, let's suppose that szPersonType for 8 is lawyer and szPerson type
for 2 is redhead
a value of iPersonType of 10 would mean redhead lawyer.
I'd like a query that looks for lawyers (ie. iPerson type is any