searching

[vlitim]

I have a column which is a varchar and holds from all to 1 of the below codes in a comma delim list

USA,EUR,LAT,PAC

when someone logs on to the system one of the four codes is assigned to a session cookie.

What I need to do is have a Select Query which brings out only the data that you have access to. Ie if I can only look at USA products how do you create a select query that looks in the column to see whether you have access.

any help

cheers

 

[motte]

vlitim,

I am a bit confused on your question. Do you have a column that means 'access to certain products'? I will call if for this example, Col_Access. If so, just do something similar to this:

select Product from tablename where Product='USA' and Col_Access='Yes'

You can just replace USA with whatever you pass in from a form...request.form("fieldname_of_product&quot

That's really all I can give you not seeing or knowing what you have.

Mike