Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringQuery help

Query help

Printed from: Snitz™ Forums 2000
URL: https://forum.snitz.com/forumTopic/Posts/68807?pagenum=1
Printed on: 05 November 2025, 03:14

Topic

Author : Jorrit787
Subject : Query help
Posted : 26 July 2009, 13:12
Message :

I have a table in my Access DB that contains a field with lists of comma-delimited usergroup IDs. How can I select only those records in which the usergroup ID of the current user does not appear in the list of usergroup IDs in the database?
Something like this doesn't work:

SELECT * FROM TABLE WHERE " & m_usergroup & " NOT IN exclude_usergroups"

m_usergroup in this case could be "4", and a particular record could have an exclude_usergroups field value of "1,2,5,6".

Replies ...

Reply Author: ruirib
Replied on: 26 July 2009, 16:21
Message:

What is the table that has the usergroups to be exclused?

Reply Author: HuwR
Replied on: 26 July 2009, 16:33
Message:

you need to do

SELECT * FROM TABLE WHERE '" & m_usergroup & "' NOT IN exclude_usergroups"

Reply Author: Jorrit787
Replied on: 28 December 2009, 00:07
Message:

So, late response, but better late than never, right?
I tried your suggestion Huw, but I get this error:

Code:

Microsoft JET Database Engine error '80040e14'

In operator without () in query expression 'sectionid=103 AND '0' NOT IN usergroup'.

Reply Author: HuwR
Replied on: 28 December 2009, 02:38
Message:

try
SELECT * FROM TABLE WHERE '" & m_usergroup & "' NOT IN (exclude_usergroups)"