[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Help-gnu-radius] multiple reply_attr_query
From: |
Pavel Kuz |
Subject: |
Re: [Help-gnu-radius] multiple reply_attr_query |
Date: |
Tue, 26 Nov 2002 13:07:52 +0200 |
User-agent: |
Mutt/1.4i |
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 ..."