I'm pretty sure the stuff you need for mod_sofia is found here:
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core
However, I'm not sure what exactly you mean about the query in the dialplan. Could you clarify what you mean?
-MC
hi guys,i have created mysql database name "x" using ODBC in freeswitch,now i have the table named "y" in the "x" databases;now,how can i connect the sipuser in my direcroty to the "x" database so that use the result of quert for taht user?and how can i insert query into the dialplan to connect myuser to mysql table
how can i do that ?thanks alot