This content has been marked as final. Show 4 replies
i am saving ID's ....
"Help" <firstname.lastname@example.org> schrieb im Newsbeitrag
> HI all,
> I am string ID's of records choosen by the user in a Cookie.
> Values are stored as following:
> LB41 = 41
> LB441 = 441
> LB442 = 442 and so on
> I want to filter a recordset based on the cookie values, so only the
> records with the ID in cookie such as 41, 441 and 442.. will be filtered
> and then mailed to the user.
> The only missing part is the filtering of database.
> Any hint to a tutorial or help will be highly appreciated.
Just edit the sql query to use the value stored in the cookie. I guess I don't really understand where the problem is.
well i did that.
In the cookie there are more than 1 ID (value) stored.
So it has to go through a loop. ID's in the cookie are matched with the ID's
in the recordset and only the matching records are filtered.
"bregent" <email@example.com> schrieb im Newsbeitrag
> Just edit the sql query to use the value stored in the cookie. I guess I
> don't really understand where the problem is.
>So it has to go through a loop. I
Loop through the cookies to build a string of comma seperated values and then use that string with the SQL IN predicate.