Recordset question ASP

[M@rk]

Hi I have a recordset which lists all the sites Users with the access
levels of (Admin, Employee, Guest) What I want is to filter recordset to just
show 'Admin' and 'Employee' It should be simple but I just can't work out the
SQL. This is what I've got so far SELECT * FROM tblLogin WHERE Access_level =
'Admin' Thanks, M@rk

[Manuel Socarras]

SELECT * FROM tblLogin WHERE Access_level = 'Admin' OR
Access_level = 'Employee'


M@rk wrote:

> Hi I have a recordset which lists all the sites Users with the access
> levels of (Admin, Employee, Guest) What I want is to filter recordset to just
> show 'Admin' and 'Employee' It should be simple but I just can't work out the
> SQL. This is what I've got so far SELECT * FROM tblLogin WHERE Access_level =
> 'Admin' Thanks, M@rk
>

[Alexandro Colorado]

On Thu, 24 Mar 2005 15:07:41 +0100, Manuel Socarras
<msoc**no-spam**@airtel.net> wrote:

> SELECT * FROM tblLogin WHERE Access_level = 'Admin' OR
> Access_level = 'Employee'
>
>
> M@rk wrote:

>> Hi I have a recordset which lists all the sites Users with the
>> access levels of (Admin, Employee, Guest) What I want is to filter
>> recordset to just show 'Admin' and 'Employee' It should be simple but I
>> just can't work out the SQL. This is what I've got so far SELECT *
>> FROM tblLogin WHERE Access_level = 'Admin' Thanks, M@rk
>>

We currently have a product called impakt which have a good level of User
authentication including the ACL = Access Level.

You can easily set it up from a Graphic user interface and assign a level
to this. If you want to see a demo of a ACL login set up please check this
site.
[url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Overview/[/url]

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312