Re: [Help-gnu-radius] multiple reply_attr_query

[Ciprian Nica]

Hi,

Thanks for the info.
The problem was I had to upgrade to mysql 4.0.X to use UNION. I did that and
it works fine.
One problem I met is that, when you use UNION and  the first query returns
strings with less length than the following queries, then the result is
truncated.

Ex :
first qry result :  'Attrib1','12345'
second qry res: 'LongerNameAttrib','987654321'

The final result would be something like :
Attrib1     12345
LongerN  98765


The fastest solution i've found was to change the first query to something
like SELECT concat(attrib,'         '),concat(value,'           ')
so by putting enough spaces to the results of the first query.

Is there any simpler solution for this problem ?

Yours,
Ciprian Nica



----- Original Message -----
From: "Pavel Kuz" <address@hidden>
To: "Ciprian Nica" <address@hidden>
Cc: <address@hidden>
Sent: Monday, November 25, 2002 3:24 PM
Subject: Re: [Help-gnu-radius] multiple reply_attr_query


> On Mon, Nov 25, 2002 at 03:11:14PM +0200, Ciprian Nica wrote:
> > Hello,
> >
> > I want to run multiple mysql queryes to generate the reply pairs. That
> > is becouse I need to take some pairs from some tables and others from
> > some other tables.
> >
> > Is this possible somehow ?
> Yes, you can using SQL syntax
>
> for example:
> reply_attr_query \
> select param from table \
> union select param1 from table1 \
> union select param2 from table2 ;
>
> etc.
> >
> > Can I put more lines starting with reply_attr_query in sqlserver
> > configuration file ?
> >
> > Yours,
> > Ciprian Nica
> >
> >
> >
> >
>
> --
> --------
> Regards,
> Pavel.
>
> "He's the kind of man for the times that need the kind of man he is ..."
>