<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 style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Alex,<br><br>Yes, but the issue isn't MySQL. The issue is func_odbc and passing multiple values to it.<br><br>Douglas.<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Alex Balashov <abalashov@evaristesys.com><br>To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com><br>Sent: Thursday, December 6, 2007 10:23:02 AM<br>Subject: Re: [asterisk-users] Setting Multiple Values via func_odbc ...?<br><br>
<br><br>On Thu, 6 Dec 2007, Douglas Garstang wrote:<br><br>> I need to insert/update multiple MySQL columns in a single row with
the <br>> func_odbc function at the SAME TIME.<br><br> If I understand your question correctly, this can be done using a <br>standard SQL UPDATE query.<br><br> UPDATE tblname SET col1 = val1, col2 = val2, .. WHERE field =
criterion;<br><br>--<br>Alex Balashov<br>Evariste Systems<br>Web : <a href="http://www.evaristesys.com/" target="_blank">http://www.evaristesys.com/</a><br>Tel : +1-678-954-0670<br>Direct : +1-678-954-0671<br><br>_______________________________________________<br>--Bandwidth and Colocation Provided by <a href="http://www.api-digital.com--" target="_blank">http://www.api-digital.com--</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></div><br></div></div><br>
<hr size=1>Never miss a thing. <a href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"> Make Yahoo your homepage.</a>
</body></html>