SQL Para listar meses em um PARAMETRO (Webview)

Citação de Kindrazki em 18 de dezembro de 2013, 15:30

SQL Para listar meses em um PARAMETRO (Webview)

[code]
connect $v{datasource2};
sql
Select
1 as id
,'Janeiro' as descr
From
dummy
Union all
Select
2 as id
,'Fevereiro' as descr
From
dummy
Union all
Select
3 as id
,'Março' as descr
From
dummy
Union all
Select
4 as id
,'Abril' as descr
From
dummy
Union all
Select
5 as id
,'Maio' as descr
From
dummy
Union all
Select
6 as id
,'Junho' as descr
From
dummy
Union all
Select
7 as id
,'Julho' as descr
From
dummy
Union all
Select
8 as id
,'Agosto' as descr
From
dummy
Union all
Select
9 as id
,'Setembro' as descr
From
dummy
Union all
Select
10 as id
,'Outubro' as descr
From
dummy
Union all
Select
11 as id
,'Novembro' as descr
From
dummy
Union all
Select
12 as id
,'Dezembro' as descr
From
dummy
sql_var(sql_meses)
;
[/code]

[i][b]Dica: [/b]Criar uma include para esse sql!
Nome sugerido: script-sql-meses-parametro[/i]

Depois para usar, somente:
[code]parameter mes label="Mês: " type="integer" values="sql_var(sql_meses)";[/code]