[Asterisk-Dev] Query on SQL Query

[brian k. west]

SELECT * is fine if you return it as a hashref.

bkw

----- Original Message ----- 
From: "Karl Brose" <karlbrose at optonline.net>
To: <asterisk-dev at lists.digium.com>
Sent: Saturday, April 24, 2004 1:55 PM
Subject: Re: [Asterisk-Dev] Query on SQL Query


> Yes, from a dba point of view this is definitely a robuster solution,
since
> it is independent from the actual layout of the table. Just using '*' is
> common beginners mistake asking for trouble later on.
>
> ----- Original Message ----- 
> From: "Olle E. Johansson" <oej at edvina.net>
> To: <asterisk-dev at lists.digium.com>
> Sent: Saturday, April 24, 2004 14:26
> Subject: [Asterisk-Dev] Query on SQL Query
>
>
> > http://bugs.digium.com/bug_view_page.php?bug_id=0001479
> >
> > This patch changes SQL SELECTs in MYSQL_FRIENDS for IAX2 and SIP from
> > SELECT * to SELECT <fieldnamelist>.
> >
> > The contributor feels that this is a better way. If you agree or
disagree,
> > add your notes to the bug report so that we can move this forward or
close
> this
> > report.
> >
> > Thank you for your contribution!
> >
> > /Olle
> > _______________________________________________
> > Asterisk-Dev mailing list
> > Asterisk-Dev at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-dev
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-dev
>
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev
>