<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>I need to insert/update multiple MySQL columns in a single row with the func_odbc function at the SAME TIME.<br><br>Someone showed me how to use ARRAY to retrieve multiple values at the same time, but I need to SET multiple values.<br><br>Can this be done?<br><br>If not, I will just stick with MySQL, but that's a pain in the ass because the asterisk-addons package has no default rpm spec file for building an RPM.<br><br>I had something like this in func_odbc.conf:<br><br>[VOX_LOG_CALL_LEG]<br>dsn=MySQL<br>write=INSERT into CallLog (Source,IDDCode,AreaCode,ProviderId,SIPReply) values (${VAL1},${VAL2},${VAL3},${VAL4},${VAL5})<br><br>but it doesn't like it. In order for this to work, I'd have to have several LOG_CALL_LEG functions, each taking one parameter, and then requiring several database
updates!<br><br>Doug.<br><br><br></div></div><br>
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a></body></html>