Posts by Ricardo • 97 points
8 posts
-
-2
votes4
answers2153
viewsA: Function to invert a string
good morning, Example of a function to invert a string: string novaStr=string.Empty; string strOriginal; int i; strOriginal = "TesteInverter"; for (i = strOriginal.Length-1; i >=0; i--) { novaStr…
-
2
votes2
answers764
viewsA: SELECT from the last 365 days (12 months) in sql
good morning, Validate if this is what you want SELECT COUNT(id) AS id, DATE_FORMAT(create_time, '%m-%Y') AS data_mes FROM ticket WHERE ticket_state_id = 2 AND DATEDIFF(day,create_time…
-
0
votes1
answer24
viewsA: How to synchronize file writing
Hello, From the moment you make this code: Set filetxt = filesys.OpenTextFile(path&"\data2.json", ForWriting, True) any other attempt to make another opening for writing to the file will give…
-
4
votes1
answer56
viewsA: Error bringing a Log Data to a label
Try it this way: DataTable ds = new DataTable(); da.Fill(ds, "Preco"); if (ds.Rows.Count>0 ) label4.Text = ds.Rows[0]["Preco"];
-
0
votes1
answer29
viewsA: Preview Excel, Power Point, Word on a website
Hello, The browser can’t preview word or excel unless your clients have extensions for it like office webapps Officewebapp The other option is to have paid/free third-party components that do this…
-
0
votes1
answer136
views -
1
votes1
answer177
viewsA: sub-query with main query parameter
Hello, I think this is what you need, you have to do a subquery to merge the current with the previous one, like this: select * from (SELECT SUBSTRING_INDEX(NomeArquivo, ' ', 1) as NomeArquivo,…
-
-1
votes1
answer35
viewsA: Compare dates from different months
Try something like this $dferiasinicial->diff($da)->d