SQL & ANDing

Discussion in 'OT Technology' started by ibjhb, Feb 20, 2005.

  1. ibjhb

    ibjhb the original ib

    Joined:
    Feb 9, 2005
    Messages:
    6,114
    Likes Received:
    0
    Location:
    St. Petersburg, FL
    Doesn't anybody know anything about SQL & ANDing. I'm trying to figure it out but am not having much luck with it. :sadwavey:
     
  2. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    what do u need to know? be easier if you posted what you are working on.
     
  3. ibjhb

    ibjhb the original ib

    Joined:
    Feb 9, 2005
    Messages:
    6,114
    Likes Received:
    0
    Location:
    St. Petersburg, FL
    I have a table that recursively joins on itself to create a Parent --> Location --> Individual tree. I need to be able to store that path in a single field. I was thinking of using a delimiter (e.g., 924|432|11 ) and just looping over that set to figure out the path.

    Someone said to look into "anding" the numbers together but that doesn't seem to be a good option given there could be an infinate number of contacts.
     

Share This Page