Forums
This topic is locked
Filter Multiple Varialbes
10 Nov 2002 22:55:54 Head Mr. posted:
ok, i've seen this asked a few times on here, but no-one has answered, at least that i can understand.how do i filter 2 variables that are coming thru, so that only records that meet BOTH conditions show up?
please speak in noob langauge haha
any help is greatly appreciated!
Replies
Replied 11 Nov 2002 00:31:01
11 Nov 2002 00:31:01 Dave Clarke replied:
this is a basic answer, it depends on what conditions you want to check as to how you do it.
but this will work.
SELECT ALL
FROM rset
WHERE rsetField = 'varible1' AND rsetfield = 'variable2'
ASP|VBScript|IIS5.1|WinXPPro & WinXPHome
but this will work.
SELECT ALL
FROM rset
WHERE rsetField = 'varible1' AND rsetfield = 'variable2'
ASP|VBScript|IIS5.1|WinXPPro & WinXPHome
Replied 12 Nov 2002 00:44:34
12 Nov 2002 00:44:34 Head Mr. replied:
that's what iw as doing, but i was screwing up somewhere else, but i found it thanks. i guess number variables arent in ' '
oops
-I am beyond the line of Morality and therefore, beyond caring.
oops
-I am beyond the line of Morality and therefore, beyond caring.