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
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
ASKER
perfect.. lol
god, an answer within about 15minutes of posting.
post the offical answer if you like and ill accept it
thanx threeps99
god, an answer within about 15minutes of posting.
post the offical answer if you like and ill accept it
thanx threeps99
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and it was actually in nine minutes :) :)
threeps99
threeps99
ASKER
don't spend it all at once... ;^)
You cant actually spend expert points, but thanks anyway :)
And thanks for the A too :)
And thanks for the A too :)
"townid = " & x
This should work.
threeps99