|
|
Posted by @sh on 05/19/06 12:58
A very simple one I hope?
I have a table like this...
ListID PropertyID MessageBody
1 75,62,2,4 erter tdfgs fd
2 6,25,75,23 dsfgsdfgsdfg sd
3 2,7,36,2 dfsdfgs dfgsdf
4 4,73,75,4 s dfgsdfg sfdg
I want to select a recordset containing only properties with a PropertyID of
75, I've tried this...
"SELECT * From Tbl_ListIDs WHERE " & Request("PropertyID") & " IN
PropertyID"
But I'm getting a SQL error of incorrect syntax? I appreciate that normally
the conditions of the IN statement are visa versa but is there an easier way
to achieve what I'm trying to do above?
Cheers, @sh
Navigation:
[Reply to this message]
|