Questions tagged as 'select'

Tagged questions
3
answers

assign the value to a variable in the onchange event of the select

Well my problem is this: Since a while ago I have been trying to modify the select that appears in a table, this modifies the row where the select was changed but since the data is displayed by means of a foreach it only works with the fi...
asked by 17.08.2018 / 18:11
2
answers

Multiple data in where variables in SQL

Well, I'll tell you a little bit. I have a query in SQL like the following > SELECT * FROM TABLA WHERE Priority <> 'P1' AND Region = ISNULL(@Region,Region) AND PM_Name = ISNULL(@PM,PM_Name) AND Priority = ISNULL(@Priority, Priority)...
asked by 21.11.2018 / 16:16
2
answers

Multiple SQL SELECT

I have 5 tables with many records. Each table has "Date" columns, in which there may be only one date per user (the last date on which a user modified their profile is stored, for example) or many dates per user (the dates on which the user has...
asked by 15.05.2017 / 09:36
2
answers

Help with jquery dynamic select

I have a problem with some dynamic selection fields, what I want is that when changing one of the select (a) the other select (b) is also changed and vice versa, the problem is that it must be done using the data- attribute cod, for example if I...
asked by 08.12.2017 / 17:14
1
answer

Unable to convert type 'System.Int32' to type 'System.Object'

I am working with Entity Framework with mvc and on the client side I have implemented a Select2 for this I have created the following model: public class Select2 { public int id { get; set; } public string text { get; set; } public...
asked by 26.12.2018 / 17:15
3
answers

Insert name, not value of a select to my BD

I have an update form, where is a select and you can choose the area if you want to edit, when choosing any, in my database update the value of the option. These data are filled through js, they are not static inside the html. In an...
asked by 26.11.2018 / 17:34
1
answer

query in LINQ, select with different tables

see this method, I repeat the (from Proyectos in db.Proyectos select Proyectos.idProyecto).Max(); I do not like it, I want in var db , get the name of the table, this table previously had already made an insert and in this method...
asked by 29.11.2018 / 18:31
1
answer

Doubts in PHP and SQL Ready Queries, SELECT Statement and Show Data

I try to update some systems that I have created, in which I try to add consultas preparadas to improve mainly the security. I'm trying to do a SELECT and it's not clear to me how I could go through it. $sql = "SELECT * FROM c...
asked by 08.09.2018 / 15:46
1
answer

Syntax error in FROM clause

I am trying to add the values that return these two queries in MS Access , and I receive the error    "Syntax error in FROM clause" I have already tried in many ways to achieve the sum of these two queries, someone could tell me w...
asked by 04.08.2018 / 21:44
2
answers

query sql that counts how many days of each month there are two dates grouped by months

I come to you because I have searched and I have not found anything that can help me with the problem I have. I must show in a query in SQL Server how many days of each month there are between two dates but grouped by months (I have an Initial d...
asked by 04.01.2018 / 14:22