Posts by user2287892 • 57 points
7 posts
-
0
votes1
answer35
viewsQ: Concatenate query [MSSQL]
I have a question on how I could concatenate the email column, as query below: select * from orcam INNER JOIN ccusto as a ON orcam.Ccusto = a.Ccusto INNER JOIN grupo_email b on a.Ccusto COLLATE…
sql-serverasked user2287892 57 -
0
votes1
answer172
viewsQ: Add 0 after the comma
I have a string str(owner.Vr_real).replace('.',',') which receives values of the type: 2045.5 3040,45 4042,05 Note that the first number does not complete with 0 (ex: 2045.50). What function could I…
python-2.7asked user2287892 57 -
0
votes1
answer244
viewsQ: Array and Mimetext - Python
Why it is not possible to use Array to add inside a Mimetext type variable (msg = Mimetext(body, 'html'))? Explain: for row in cursor.fetchall(): for owner in cursor.execute("select * from orcam…
pythonasked user2287892 57 -
0
votes1
answer835
viewsQ: How to show only a result of a specific column [MSSQL]
I have the following QUERY: select id_cc_ponto_saldo_vecto, id_planta_re, tbl_cc_ponto_saldo_vecto.re, ponto_saldo_atual, convert(varchar(10),vecto_ponto,121) from tbl_cc_ponto_saldo_vecto INNER…
sql-serverasked user2287892 57 -
2
votes3
answers2314
viewsQ: How to calculate two columns and compare the result with another column?
I have a table, where I am bringing two different results with the query below: select sum(qtde_pontos) from dbo.tbl_cc_ponto where re = '9289' and natureza_operacao = '2' and data_lacto >=…
-
1
votes1
answer82
viewsQ: Leave a fixed option on a dynamic table - JS
I have a dynamic table, which changes according to the user’s select done in HTML. However, every time the page updates the selected option ends up changing too. I thought of two possibilities that…
-
1
votes2
answers48
viewsQ: Show different values in a table - JS/Html
I am trying to show different tables according to what the user chooses. I have an example of a user who shared his code through the link: http://jsfiddle.net/onury/kBQdS/ The table is updated via…
javascriptasked user2287892 57