Link to home
Start Free TrialLog in
Avatar of pnreefman
pnreefman

asked on

online ASP access database Filter variables

im trying to filter an online ASP access database, but need the filtered item to be a variable.

this works:
objrec.filter = "townid = 7"


this is what i want:
objrec.filter = "townid = x" (where x=7 or another number)


this is the error:
ADODB.Recordset error '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.


please help
thanx in dadvance
Avatar of threeps99
threeps99

Have you tried:

"townid = " & x

This should work.

threeps99
Avatar of pnreefman

ASKER

perfect.. lol
god, an answer within about 15minutes of posting.
post the offical answer if you like and ill accept it

thanx threeps99
ASKER CERTIFIED SOLUTION
Avatar of threeps99
threeps99

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
and it was actually in nine minutes :) :)

threeps99
don't spend it all at once... ;^)
You cant actually spend expert points, but thanks anyway :)

And thanks for the A too :)