| 00:47.18 | *** join/#asterisk-doc infobot (ibot@rikers.org) |
| 00:47.18 | *** topic/#asterisk-doc is Welcome to the Asterisk Documentation Project! User support in #asterisk. Get a free copy of the book at http://www.asteriskdocs.org, or read online at http://astbook.asteriskdocs.org. We also chat about a lot of things in here that are not Asterisk related. |
| 02:42.08 | *** join/#asterisk-doc file (~file@asterisk/developer-and-muffin-lover/file) |
| 12:40.08 | *** join/#asterisk-doc leifmadsen (~Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 12:40.08 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 14:18.05 | *** join/#asterisk-doc elliot98 (~elliot@bzq-79-183-7-57.red.bezeqint.net) |
| 14:18.35 | *** join/#asterisk-doc elliot98 (~elliot@unaffiliated/elliot98) |
| 14:31.56 | *** join/#asterisk-doc leifmadsen (~Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 14:31.56 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 14:43.20 | *** join/#asterisk-doc RobH (~robh@2620:0:860:2:21e:c2ff:fe03:2465) |
| 16:18.05 | *** join/#asterisk-doc RobH (~robh@2620:0:860:2:21e:c2ff:fe03:2465) |
| 17:48.50 | *** join/#asterisk-doc elliot_ (~elliot@bzq-79-179-39-102.red.bezeqint.net) |
| 18:01.04 | *** join/#asterisk-doc RobH (~robh@cpe-173-169-30-118.tampabay.res.rr.com) |
| 22:17.38 | *** join/#asterisk-doc infobot (ibot@rikers.org) |
| 22:17.38 | *** topic/#asterisk-doc is Welcome to the Asterisk Documentation Project! User support in #asterisk. Get a free copy of the book at http://www.asteriskdocs.org, or read online at http://astbook.asteriskdocs.org. We also chat about a lot of things in here that are not Asterisk related. |
| 22:35.17 | *** join/#asterisk-doc infobot (ibot@rikers.org) |
| 22:35.17 | *** topic/#asterisk-doc is Welcome to the Asterisk Documentation Project! User support in #asterisk. Get a free copy of the book at http://www.asteriskdocs.org, or read online at http://astbook.asteriskdocs.org. We also chat about a lot of things in here that are not Asterisk related. |
| 23:04.57 | ctooley | leifmadsen, still got some examples of func_odbc usage around somewhere? |
| 23:05.17 | leifmadsen | ummm, I could just give you some examples if you need :) |
| 23:05.31 | ctooley | that would be awesome |
| 23:05.33 | leifmadsen | let me see if I already have a blog post setup, if not, I could write up a quick one for you |
| 23:06.09 | ctooley | I need to pull a couple of fields out of a database for a new Conferencing app. |
| 23:08.31 | leifmadsen | ah gotcha... that one is easy. Give me about 30-40 mins? I have to finish this conference call, then I'll show some examples |
| 23:08.34 | leifmadsen | 1.4 or 1.6.x? |
| 23:08.51 | leifmadsen | quick and dirty for retrieval (to get you going) |
| 23:08.59 | leifmadsen | [CONFERENCE_INFO] |
| 23:09.03 | leifmadsen | prefix=GET |
| 23:09.13 | leifmadsen | dsn=name_configured_in_res_odbc.conf |
| 23:09.46 | leifmadsen | readsql=SELECT foo,bar FROM ${ARG1} WHERE bob='${ARG2}' |
| 23:09.47 | leifmadsen | <PROTECTED> |
| 23:09.55 | leifmadsen | extensions.conf: |
| 23:10.12 | leifmadsen | exten => _NXX,1,Set(RESULT=${GET_CONFERENCE_INFO(first_arg,second_arg)}) |
| 23:10.38 | leifmadsen | <PROTECTED> |
| 23:10.41 | leifmadsen | res_odbc.conf: |
| 23:10.48 | leifmadsen | (I just use the MySQL example) |
| 23:10.49 | leifmadsen | [mysql2] |
| 23:10.49 | leifmadsen | enabled => no |
| 23:10.49 | leifmadsen | dsn => MySQL-asterisk |
| 23:10.49 | leifmadsen | username => myuser |
| 23:10.51 | leifmadsen | password => mypass |
| 23:10.53 | leifmadsen | pre-connect => yes |
| 23:10.55 | leifmadsen | <PROTECTED> |
| 23:10.57 | leifmadsen | change enabled to 'yes' |
| 23:11.10 | leifmadsen | the dsn in res_odbc.conf is what you have in /etc/odbc.ini |
| 23:14.14 | ctooley | leifmadsen, thanks |
| 23:14.51 | ctooley | Now I just need to figure out how to set the different parts of "RESULT" to different variables. I might just make it easy and do multiple queries |
| 23:15.13 | ctooley | Or... nevermind, figured out an easy way to do it. |
| 23:21.05 | leifmadsen | HASH() or ARRAY() |
| 23:21.39 | jsmith | ctooley: You pinged (yesterday)? |
| 23:22.06 | leifmadsen | Set(ARRAY(foo,bar)=${GET_CONFERENCE_INFO(first_arg,second_arg)}) |
| 23:26.00 | ctooley | leifmadsen, you're a life saver |
| 23:26.10 | leifmadsen | I used to be a lifeguard too |
| 23:26.27 | ctooley | jsmith, Kevin answered my question. |
| 23:31.50 | jsmith | ctooley: Cool |
| 23:32.48 | leifmadsen | ctooley: need any more than that? |
| 23:33.12 | ctooley | leifmadsen, nah, that helped a lot, thanks. |
| 23:33.16 | leifmadsen | np! |
| 23:33.20 | leifmadsen | saves me a blog post :) |