Lookup-Error

[herrhans]

Since the latest SC-update i had an issue with this lookup statement:

SELECT op_users.name
FROM op_users, op_users_groups
WHERE op_users.login = op_users_groups.login
and op_users_groups.group_id = ‘[opuser_group]’
ORDER by name

Generation of this form-application rans to endless loop! No error message!

[Kleyber_Derick]

@herrhans

SELECT op_users.name
FROM op_users, op_users_groups
WHERE op_users.login = op_users_groups.login
and op_users_groups.group_id = ‘[opuser_group]’
ORDER by name

Wouldn’t be:

SELECT op_users.name
FROM op_users, op_users_groups
WHERE op_users.login = op_users_groups.login
and op_users_groups.group_id = ‘[opuser_group]’
ORDER by op_users.name

?