Also asp code contains ADODB connection

Hi Balmukund ,

Only this error is occuring....No other error occurs

Thanks a lot....

I got the solution.

John,

Can you give me the query for executing this...

Thanks

Nisha

I want to display the list of users except the admin users from the users table.

So what query will help to fetch these records.

SELECT U.uid,U.name,U.mail,R.name

FROM users U

INNER JOIN users_roles Ur

ON U.uid=Ur.uid

INNER JOIN role R

ON Ur.rid=R.rid;

This query displays the list of admin users.

I tried the following query using WHERE condition for listing out authenticated...

I have wrote query for listing out the admin users

But I dont know how to write query for listing the authenticated users.

Thanks a lot Ian

It works perfect!!!

Hi Kenneth

Thanks for your answer

Stil I am unable to get the names of the blocked user..

I am able to retrieve their id's alone...

I want their name also along with the...

table:travelbagcontent

tbid int

nid int

uid int

name varchar

description text

recordurl text

etc...

table:node

nid int

vid int

type varchar

title varchar

uid int

status int

etc...

table:node_revisions

nid int

uid int

title varchar

etc...

type contains data like forum,blog,travelbag,picture,video

For eg:In the application it contains several options like

add...

Thanks a lot

It's working fine

Thanks VAIYDEYANATHAN

Thanks a lot Matjaz

It helped me a lot...

Thanks a lot everyone for your replies

Create Table ItemDetail(Itemid int, ItemCodeDescription text)

The table contains 20 million records.

Now I want to increase the performance ie.Change the table scan to seek

for the following query

SELECT * FROM ItemDetail WHERE...