error doing a FILTER on an Access database via Asp/VBScript and ADO
Sorry Bob... thanks for the tip.
Here is the heart of it:
Build="(Price > 0) AND (Price < 10001)"
if len(Build)>0 then
rs.Filter = Build
end if
That way, I only filter *if* the string that I build (based on user selected
pull-downs)
has anything in it.
Price is a field that has the variable type of Long Int.
What gets me is, why does it work the first time, but not
on subsequent passes thru?
Thanks - any tips would be greatly appreciated.
-Joel
Quote:
> Most of us will not take the chance of opening an attachment, so if you
> could extract just the relevant piece of code from the file and post it in
> the body of your reply to this, that would help.
> Bob Barrows
