Hi there I have been successfully using the asterisk command "MYSQL" to read information from a MySql database, but was wondering if there was any way of WRITING data (ie user input data) to the database ???, looking through the parameters of the MYSQL command it seems as though this function isn't available....is there another application for this??? Cheers
Brett, Gary wrote:> Hi there > > I have been successfully using the asterisk command "MYSQL" to read > information from a MySql database, but was wondering if there was any > way of WRITING data (ie user input data) to the database ???, looking > through the parameters of the MYSQL command it seems as though this > function isn't available....is there another application for this??? > > > CheersThe MYSQL command you speak of should support any query supported by MySQL. exten => _9.,1,MYSQL(Connect connid 210.55.55.55 asterisk asterisk asterisk) exten => _9.,n,MYSQL(Query resultid ${connid} INSERT INTO testtable VALUES ('himom','hidad','hisister')) exten => _9.,n,MYSQL(Disconnect ${connid}) (the above is untested) -Matthew
You can do nearly anything you want with AGI. Writing to databases, sending instant messages, swapping log files, updating a web-site or ordering pizza.> -----Original Message----- > From: Brett, Gary [mailto:gary.brett@cetelem.co.uk] > Sent: Tuesday, May 24, 2005 6:37 AM > To: 'Asterisk Users Mailing List - Non-Commercial Discussion' > Subject: [Asterisk-Users] writing to MYSQL database > > > Hi there > > I have been successfully using the asterisk command "MYSQL" > to read information from a MySql database, but was wondering > if there was any way of WRITING data (ie user input data) to > the database ???, looking through the parameters of the MYSQL > command it seems as though this function isn't > available....is there another application for this??? > > Cheers