November 18, 2008 10:39pm pst

1. grblades 132,183
2. feptias 55,675
3. DrDamnit 24,664
4. palner 22,725
5. xuserx2... 22,200
6. Joel_Sisko 16,100
7. dkwiebe 8,500
8. michofreiha 8,300
9. rpalmeira22 4,250
10. kode99 4,000
11. duncan_roe 3,800
12. uetian1707 3,600
13. MrJemson 3,500
14. e-tsik 3,000
15. angelIII 2,500
16. denisdsr20 2,200
17. objects 2,000
17. sunnycoder 2,000
17. cjl7 2,000
17. TSchug 2,000
17. ehatchell 2,000
17. j_stone 2,000
17. mwiesbau 2,000
17. EricTViking 2,000
17. cordua 2,000
17. asrobins 2,000
17. nocinfospan 2,000
17. diepes 2,000

1. grblades 191,363
2. feptias 57,175
3. DrDamnit 24,664
4. palner 22,725
5. xuserx2... 22,200
6. Joel_Sisko 16,100
7. dkwiebe 10,500
8. michofreiha 8,300
9. tvman_od 6,420
10. kode99 4,600
11. bwilks99 4,300
12. rpalmeira22 4,250
13. duncan_roe 3,800
14. uetian1707 3,600
15. MrJemson 3,500
16. e-tsik 3,000
17. angelIII 2,500
18. denisdsr20 2,200
19. objects 2,000
19. sunnycoder 2,000
19. tkfast 2,000
19. nocinfospan 2,000
19. cordua 2,000
19. mwiesbau 2,000
19. ehatchell 2,000
19. TSchug 2,000
19. j_stone 2,000
19. EricTViking 2,000
19. asrobins 2,000
19. jjmartineziii 2,000
19. cjl7 2,000
19. diepes 2,000

09.26.2008 at 02:22PM PDT, ID: 23767490 | Points: 500

	[x] Attachment Details

Asterisk mysql help with +1

Asked by Billetkontoret in Asterisk Open Source Telephony

Tags: Asterisk

Hi guys.

I have this in my dialplan:

exten => s,n,MYSQL(Query resultid ${connid} UPDATE\ brugere\ SET\ "vmail_lyttet=+1"\ WHERE\ nummer=${NUMMER})

I have an INT field in my mysql database which contains a number which I would like to increase by 1 with the command above. The command won't work, what am I doing wrong? I have tried several other posibilities, like:

exten => s,n,MYSQL(Query resultid ${connid} UPDATE\ brugere\ SET\ vmail_lyttet="vmail_lyttet+1"\ WHERE\ nummer=${NUMMER})
And others.

Help please...Start Free Trial

Keywords: Asterisk mysql help with +1

	Title
1	struggling with mysql query
2	Simple output question in MySQL.
3	MySQL Querie - selects rows with da…
4	mysql query question
5	MySQL Error
6	MySQL query by hour difference

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628