Classic ASP Discussion - SQL Select question

Print Page | Close Window

SQL Select question

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1061
Printed Date: 29 March 2026 at 4:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Select question

Posted By: vdub
Subject: SQL Select question
Date Posted: 16 March 2003 at 11:42am

I have a quick question maybe someone can help me with.

I am trying to pull info from a database that dosnt belong to the user trying to pull it. each user has a number (DBID)

heres the code that dosnt work

SQLcount = "Select * From users Where points > 0 & DBID not "& networkuser

Any one have any ideas

Replies:

Posted By: michael
Date Posted: 16 March 2003 at 11:56am

I don't really understand your question but the SQL is wrong.
SQLCount = "Select * from users where points > 0 AND NOT DBID = " & networkuser

That is if networkuser is an integer otherwise it needs quotes.

Posted By: vdub
Date Posted: 16 March 2003 at 12:02pm

Cool thanks. Thats worked perfict.