| 12:54.32 | *** join/#asterisk-doc alerios (n=alerios@201.244.173.92) |
| 15:10.44 | *** join/#asterisk-doc jsmith (n=jsmith@199.227.185.35) |
| 15:10.44 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 17:04.05 | *** join/#asterisk-doc blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage) |
| 17:04.05 | *** mode/#asterisk-doc [+o blitzrage] by ChanServ |
| 18:48.13 | jsmith-lunch | blitzrage: We're on the same flight to Geek Week! (one leg, at least) |
| 18:48.57 | blitzrage | jsmith-lunch: yah, Lisa just told me -- I'm excited! |
| 18:49.27 | blitzrage | have fun! |
| 18:49.38 | blitzrage | I need lunch now myself (after I finish fixing this script) |
| 20:02.43 | *** join/#asterisk-doc ToTo (n=ToTo@host97-157-dynamic.2-87-r.retail.telecomitalia.it) |
| 20:19.02 | *** join/#asterisk-doc alerios (n=alerios@201.244.173.92) |
| 21:12.10 | *** join/#asterisk-doc jsmith (n=jsmith@199.227.185.35) |
| 21:12.10 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 21:28.48 | jsmith | Much... too... quiet.... |
| 21:28.58 | jsmith | And we have no topic :-( |
| 21:29.27 | *** topic/#asterisk-doc by jsmith -> Yes, this is the place for Asterisk documentation... maybe that's why it's so quiet in here. Check out http://www.oreilly.com/catalog/asterisk/ |
| 21:41.12 | blitzrage | yah, I think they reset something on the servers here on freenode the other day because a lot of channels are missing a topic |
| 21:41.29 | jsmith | Probably got hacked, now that lilo's not around |
| 21:42.07 | blitzrage | quite possible |
| 21:42.11 | blitzrage | hey, question! |
| 21:42.16 | jsmith | hey, answer! |
| 21:42.56 | blitzrage | I need to put an entry into pgsql, and once its created, I need the 'id' field (which is of type serial) back once I've done the insert. I know there is a way, but I've forgotten. |
| 21:43.44 | jsmith | Yes... this is from PHP? |
| 21:44.14 | blitzrage | actually... func_odbc :( |
| 21:44.23 | blitzrage | not even sure I can do it to be honestly |
| 21:44.29 | blitzrage | s/honestly/honest |
| 21:45.02 | blitzrage | Set(ODBC_SQL(foo,bar)=value1,value2) is a write |
| 21:45.14 | blitzrage | so there is nothing that is getting passed back there... |
| 21:45.25 | blitzrage | unless the SET() function can return it... |
| 21:45.45 | blitzrage | Set(id=${SET(ODBC_SQL(foo,bar)=value1,value2)}) |
| 21:45.47 | jsmith | Not sure what gets returned... you could do it with a stored procedure |
| 21:47.11 | blitzrage | hrmmm... maybe I'll try my SET() function idea and see if it passes anything back |
| 21:47.26 | blitzrage | guh... stored procedures :) |
| 21:51.40 | jsmith | In short, I can tell you what you need to select, ifi you can do the insert and select as part of the same transaction. |
| 22:00.20 | *** join/#asterisk-doc Alric (n=nbowyer@masq.hyperusa.com) |
| 22:00.26 | Alric | Hey hey |
| 22:00.37 | jsmith | It's Alric! |
| 22:00.42 | Alric | It is. |
| 22:01.06 | Alric | Lurking for the elusive 1.4 release, and the spandsp update that will ensue! |
| 22:01.26 | jsmith | Ain't gonna happen. |
| 22:01.32 | Alric | Which part? |
| 22:01.45 | jsmith | Both. |
| 22:01.49 | jsmith | You'll never see either one. |
| 22:02.23 | Alric | No! Say it ain't so! |
| 22:02.49 | jsmith | Ok, it may or may not be so |
| 22:03.00 | jsmith | 1.4 will be ready when it's ready. |
| 22:03.06 | Alric | Yes, I know. |
| 22:03.09 | jsmith | As for spandsp, that's up to Steve U. and nobody else |
| 22:03.24 | Alric | Yep. I know. Doesn't mean I can't lurk anxiously waiting. |
| 22:26.57 | blitzrage | jsmith-training: yah, thinking I'm going to have to create an AGI to do this. Gonna have to do this in PHP, create a transaction, then get the value back from the sequence, and then close the transaction set |
| 22:27.15 | jsmith-training | OK... gimme one second. |
| 22:27.46 | blitzrage | oh cool, will do |
| 22:29.58 | jsmith-training | 1) Start transaction |
| 22:30.24 | jsmith-training | 2) SELECT CURRVAL('my_table_seq') AS seq |
| 22:30.39 | jsmith-training | 3) INSERT INTO my_table VALUES (x, y, z) |
| 22:31.45 | jsmith-training | 4) Check value of insert, and either rollback or commit the transaction |
| 22:38.05 | blitzrage | jsmith-training: go ahead... I'm working on other things unfortunately |
| 22:38.39 | jsmith-training | http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.2 |
| 22:38.47 | jsmith-training | That' |
| 22:38.50 | jsmith-training | That's all there is to it |
| 23:58.06 | *** part/#asterisk-doc Alric (n=nbowyer@masq.hyperusa.com) |