SELECT 1 AS 'Exists'

SELECT 'Exists' = 1

IF EXISTS (SELECT * FROM admin WHERE UserName = 'jSchmoe') SELECT * FROM admin WHERE UserName = 'jSchmoe'

SELECT * FROM admin WHERE UserName = 'jSchmoe'

if rs.EOF then
    response.write("No record found.")
else
    response.write("We found a record for user: "&rs("UserName"))
end if

quote:

---

Originally posted by NewToASP

IF EXISTS (SELECT     *
                        FROM         ADMIN
                        WHERE     UserName = 'jSchmoe' )
   SELECT 'Exists' = 1
ELSE
   SELECT 'Exists' = 0

It is verified in the query builder but then says its unable to parse the query text. I actually need to verify if a couple of parameters exist but I can't even get this hardcoded query to work.

I just need to check if a username and password exist in the table. I have a class that will check session variables and I want to return the results of this query since it should be a boolean.


Thanks.

---

SELECT 'Exists' = 1

SELECT 1 AS 'Exists'