Re: Reject user from SQL-DB

2008-03-04 Thread JB
Phil Mayers (29.02.2008): JB wrote: Phil Mayers: JB wrote: I'm sorry, I have to ask again. Have you found a way to let the reply query know that the user has already been rejected in the check-query? I'm trying to avoid executing the same queries twice and also to avoid using temporary

Re: Reject user from SQL-DB

2008-02-28 Thread JB
I'm sorry, I have to ask again. Have you found a way to let the reply query know that the user has already been rejected in the check-query? I'm trying to avoid executing the same queries twice and also to avoid using temporary tables. Thank you, JB JB (08.02.2008 14:00): Phil Mayers

Re: Reject user from SQL-DB

2008-02-28 Thread Phil Mayers
JB wrote: I'm sorry, I have to ask again. Have you found a way to let the reply query know that the user has already been rejected in the check-query? I'm trying to avoid executing the same queries twice and also to avoid using temporary tables. I thought I'd answered this? What you could

Re: Reject user from SQL-DB

2008-02-28 Thread Phil Mayers
JB wrote: Phil Mayers: JB wrote: I'm sorry, I have to ask again. Have you found a way to let the reply query know that the user has already been rejected in the check-query? I'm trying to avoid executing the same queries twice and also to avoid using temporary tables. I thought I'd

Re: Reject user from SQL-DB

2008-02-08 Thread Phil Mayers
JB wrote: Return: attr = 'Auth-Type' op = ':=' value = 'Reject' Of course! How embarrassing. ;-) I actually tried that before but during the reply-items-query which has no effect. Returning Auth-Type := Reject from the check-items-query does the trick. Makes sense, doesn't it? Ok, now I'm

Re: Reject user from SQL-DB

2008-02-08 Thread JB
Phil Mayers (08.02.2008 12:03): Ok, now I'm returning Auth-Type := Reject from my check-items-query and I hoped to be able to send a little more in depth information along the way in the Reply-Message attribute, but unfortunately this info gets lost. It seems that I have to fill this

Re: Reject user from SQL-DB

2008-02-07 Thread Phil Mayers
JB wrote: Hi, I'm afraid I'm currently not seeing the wood for the trees, please help me out. ;-) I'm using stored procedures in MySQL to query for check and reply items for users. I don't need (or want) user groups so there's always a positive Fall-Through attribute returned. Be aware

Reject user from SQL-DB

2008-02-07 Thread JB
Hi, I'm afraid I'm currently not seeing the wood for the trees, please help me out. ;-) I'm using stored procedures in MySQL to query for check and reply items for users. I don't need (or want) user groups so there's always a positive Fall-Through attribute returned. There are quite a

Re: Reject user from SQL-DB

2008-02-07 Thread JB
Phil Mayers (07.02.2008 19:27): JB wrote: Hi, I'm afraid I'm currently not seeing the wood for the trees, please help me out. ;-) I'm using stored procedures in MySQL to query for check and reply items for users. I don't need (or want) user groups so there's always a positive

Re: Reject user from SQL-DB

2008-02-07 Thread JB
Return: attr = 'Auth-Type' op = ':=' value = 'Reject' Of course! How embarrassing. ;-) I actually tried that before but during the reply-items-query which has no effect. Returning Auth-Type := Reject from the check-items- query does the trick. Makes sense, doesn't it? Ok, now I'm