Posts by Valderí Leandro • 160 points
9 posts
-
1
votes2
answers169
viewsA: How to make a group by Select is done to more than one table
All SELECT fields that are grouping (fields that are not calculated as SUM, COUNT, etc.) must be in the GROUP BY clause If what you need is to see only the result without repetition you can use a…
sqlanswered Valderí Leandro 160 -
1
votes1
answer360
viewsQ: How do I store values as objects in Web Forms?
How can I store the values of my class? Every time I click the buttons my class seems to be instantiated again. My class: public class Partida { public string[] linha1 = new string[3]; public…
-
0
votes4
answers1852
viewsA: Oracle11g - Problems SELECT command
Has two extra parentheses in the WHERE clause causing error: SELECT M.ID, M.TITLE, M.DIA, M.HORA FROM MEETING AS M, MEETING_LIST AS ML WHERE (M.ID = ML.ID_MEETING AND ML.ID_UTILIZADOR = (SELECT…
-
1
votes2
answers306
viewsA: Do not select, dynamically, always the last li in the hierarchy
Use id or class selectors' html <li class="lista1"> </li> or <li id="lista2"> </li> css .lista1 {color:blue} '#lista2 {color:green} Every time you identify a tag with these…
-
-3
votes3
answers2912
viewsA: Select in Entity framework with certain columns
See if it helps: Entity-framework-select-Multiple-Columns var dataset2 = (from recordset in entities.processlists where recordset.ProcessName == processname select new { serverName =…
entity-framework-6answered Valderí Leandro 160 -
1
votes1
answer318
viewsA: Use Inner Join with Bindingsource
Oledbcommand receives a normal database query. See if this one works: string query = @"SELECT Inv. Code , Polos.Polo , Inv. Type , Inv. Equipment , Inv. Brand , Inv. Model , Inv.NS , Inv. Assets ,…
-
1
votes1
answer425
viewsA: Change object of a listview
Create a method to change the list item, add conditions to capture the specific item you want to change. You need to go item by item in the list, use the for for such: for (Object ob : listObj) {…
-
1
votes2
answers338
viewsA: Sort relation "Many To Many" using as base field of another table
See if it helps: How to order using Eloquent: https://stackoverflow.com/questions/17553181/laravel-4-how-to-order-by-using-eloquent-orm Select the first 10 lines:…
-
4
votes3
answers220
viewsA: Show query (Problem Different Id’s)
I imagine your joins are wrong: tb_details_worker1.id = tb_company.id tb_equipment.id = tb_company.id tb_company id company name 1 Samsumg 2 HP 3 Dell tb_equipment id equipment 1 computer 2 laptop 3…