Hash table lookup with boolean condition
Posted: Tue Oct 25, 2005 11:21 pm
I have a hash table that has a composite key (the key is composed of 2 columns c1 and c2)
I want to specify a lookup conidtion like this:
C1 = value1 and (C2=Value3 or Value4)
The first part is trivial.
The part 'and (C2=Value3 or Value4)' is where I have a problem
I assume that the logical operator 'and' goes by default, when I specify
C2=Value3 or C2=Value4 I get no syntax error but the row is not found even though it exists.
Any suggestions? Thanks.
ekareem
I want to specify a lookup conidtion like this:
C1 = value1 and (C2=Value3 or Value4)
The first part is trivial.
The part 'and (C2=Value3 or Value4)' is where I have a problem
I assume that the logical operator 'and' goes by default, when I specify
C2=Value3 or C2=Value4 I get no syntax error but the row is not found even though it exists.
Any suggestions? Thanks.
ekareem