[Asterisk-Dev] Query on SQL Query

Karl Brose karlbrose at optonline.net
Sat Apr 24 12:55:42 MST 2004


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




More information about the asterisk-dev mailing list