Re: Blocklist with multiple SELECT-fields

2010-02-24 Thread mouss
Jørn Skjerven a écrit : > Hi everybody! > > I'm trying to implement a blocklist based on a MySQL lookuptable. It > works for returning single values like REJECT or OK, but I want it to > return 4XX "some text" the same way as can be done using a standard > accessmap. The problem is to return the T

Re: Blocklist with multiple SELECT-fields

2010-02-24 Thread Stefan Palme
On Wed, 2010-02-24 at 09:16 +0100, Jørn Skjerven wrote: > I have tried the following query: > > query = SELECT action,text FROM blocked_accounts WHERE address = '%s' Try query = SELECT concat(action,' ',text) FROM blocked_accounts ... (don't know the correct Syntax in MySQL to concatenate str

Blocklist with multiple SELECT-fields

2010-02-24 Thread Jørn Skjerven
Hi everybody! I'm trying to implement a blocklist based on a MySQL lookuptable. It works for returning single values like REJECT or OK, but I want it to return 4XX "some text" the same way as can be done using a standard accessmap. The problem is to return the TEXT. I have tried the following que