[Asterisk-Users] Retrieve multiple variables from database using MYSQL cmd

Are london3 at gmail.com
Sat Nov 19 11:53:06 MST 2005


Hi Ben

If I remember correct you have to do one SQL statement for each value you
want to return.

technology = select technology from mytable where type=1
username = select username from mytable where type=1
password = select password from mytable where type=1
servername = select servername from mytable where type=1

This is the reason I prefeer to work with PERL script in AGI having perl
talk to SQL.

--
Are Casilla
http://astartelecom.com - Independent VOIP Telecoms Broker. Asterisk
Consultants
http://astbill.com - Open Source Billing, Routing and Management software
for Asterisk and VOIP
AstBill DEMO: http://demo.astbill.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051119/26be5f80/attachment.htm


More information about the asterisk-users mailing list