Re: [Help-gnu-radius] multiple reply_attr_query

[Pavel Kuz]

On Tue, Nov 26, 2002 at 12:56:45PM +0200, Ciprian Nica wrote:
> 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 ?
Use postgresql ;-)

> 
> 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 ..."
> >
> 
> 

-- 
--------
Regards,
Pavel.

"He's the kind of man for the times that need the kind of man he is ..."