返回首页

Questions tagged [select]

Select is a common keyword used to query data. 'select()' is also a programming function for triggering code based on file handle or other system activity. Do not use this tag for questions related to: HTML <select> tag (use [html-select]); language integrated query such as LINQ or similar, etc.

Filter by
Sorted by
Tagged with
0
votes
1answer
17 views

Mysql Foreach from one table to another

I have 2 tables, First table is user and second table is user_attendance. In the user attendance I'm inserting IN and OUT per line, so 1 line for IN and 1 line for OUT. I want a MySQL select(so I ...
-1
votes
2answers
22 views

SQL Select Max Count Nested?

SELECT N.National_PosID, N.Title, C.First_Name, C.Mid_Name, C.Last_Name, count(*) FROM National_Position N, Candidate C, Vote V WHERE N.National_PosID = C.National_PosID AND V.Candidate_ID = C....
0
votes
0answers
16 views

SQL only pull data from matching DISTINCT values [duplicate]

In our database, many part numbers have been done many times. I only want to fetch one value for each part number and then all the other corresponding values. So PartNo 1234 could have cycletime of 1, ...
0
votes
2answers
26 views

Selecting distinct values in MongoDB while using Studio 3T

I'd like to to select distinct values from my collection. My query right now, looks like this: use mongo; db.getCollection("Students").find( { "Name" : { "$exists" : true ...
2
votes
4answers
50 views

selecting suitable options from list of strings

I have a list of sentences. For example: x = ['Mary had a little lamb', 'Jack went up the hill', 'Jill followed suit', 'i woke up suddenly', 'I just ...
0
votes
0answers
19 views

Display react array from axio url in select box in opt group

I am trying to display a drop down with two attributes email and names what i want is them to be displayed when one group has completed its elements than second should start if i put users.ids or ids. ...
0
votes
1answer
14 views

Problem with select in redux-saga. Error: call: argument of type {context, fn} has undefined or null `fn`

After looking through some answers to similar questions here, I just can't get my selector to work. Here's my selector.js: export const getButtonStatus = state => state.buttonStatus; (That's the ...
0
votes
1answer
27 views

How to bind select options to a JSON object using Angular?

I am attempting to build a web application that has a dropdown menu of industries. This is what my current list looks like: <mat-select placeholder="Industry" [(ngModel)]="selectedIndustry" > &...
0
votes
1answer
20 views

How to properly use select2 in WordPress?

This question is not a duplicate because using the methods in other (similar) questions does not work. I have a select box: <select id="order-statuses" name="order-status" class="order-statuses" &...
0
votes
2answers
30 views

How can i select multiple values in react js?

I am trying to select multiple value from from select filed but i can only select one field and i fetch data from api and in api endpoint i can select multiple user like user=1,2,3 and i also want to ...
0
votes
0answers
19 views

How to get the index of selected <option> inside <select> in React?

I want to get the index of the selected <option> from the <select>. I have tried jQuery, acquiring the object's attributes directly (which shows that _this2.selector.current is not defined)...
2
votes
1answer
34 views

Hide div when clicking on link inside div with jQuery

on my website I have a mobile menu. When I click a link a link in the menu the menu doesn't disappear. From reading other posts I have a quite good idea what I have to do. But I don't get the code ...
0
votes
1answer
22 views

Mysql gives me unrelated results

I am new in Mysql and have a table where I'm going to select based on an integer column, the problem is that when I use an string on this column! I got no error but it gives me back all rows. for ...
0
votes
0answers
23 views

T-SQL: can I script a INSERT from a SELECT?

I have a set of records on my home computer that can be retrieved with this simple query: SELECT * from mydb.dbo.topics where name like 'about%' I would like to convert the result of the query above ...
1
vote
1answer
60 views

Using Selector on SocketChannel

I'm trying to wait on multiple socket channels for data to read. I've copied example code from the web but it's not working for me. The problem is that the "select" call properly blocks until the ...
0
votes
1answer
13 views

SQL change all items

How can I select all items which start with an i, instead of Items.ItemCode = '107669' SELECT p.ProjectNr AS Production, gbkmut.oms25 AS Description, (CASE WHEN SUM(gbkmut....
-1
votes
0answers
32 views

I hava a error using openssl socket with select() (C++)

I have a problem with my code. I use C++. I use Openssl socket and select() multi thread program If I connect three at the same time, one may not be connected. one client return -1 at Connect() code....
-1
votes
1answer
23 views

Select all the clients that are in the hotel between two dates knowing tha date of arrival and departue

I have a table clients with the date the client arrive and the date the client depart. I want to select which clients stays in the hotel at least one day between 18-10-2019 and 22-10-2019. For ...
0
votes
2answers
31 views

Avoid hardcoding the date that I want to search for in SQL?

Here is the issue: All the employees (full names please!) and the skills that need updating in the next year. Do not hard code the date in your query. Below shows the way that I have done it but ...
1
vote
0answers
16 views

How to use onchange to render ejs via a select element

I am using Node.js to render EJS files. I want a user to fill out a log form and have their data sent to a database. The initial part of the form is in log.ejs, is rendered via log.js, and is ...
0
votes
0answers
14 views

Advice With Forcing Option In Drop Down To Default Instead of First Item In The List Being Chosen

was wondering if someone could offer advice on where to place the select.value (or whatever would work best), to force an item from a drop down list to be selected by default was advised to use the ...
0
votes
0answers
8 views

Select element setting url parameter to remember option

Using the following I am able to set a parameter in the url: function setParam(name, value) { var l = window.location; /* build params */ var params = {}; var x = /(?:\??)([^=&?]+...
0
votes
1answer
18 views

jQuery filter() for country/state/city list with already loaded data (no ajax calls)

I am creating a form with three dropdowns, country, state and city. On select of a country, filtered state dropdown should appear and based on state selection respective cities. I am working in a ...
0
votes
0answers
15 views

textarea becomes empty if I select an option from select input in a form why so?

I have a form where there are select and textarea fields if I change the value ( select an option) in select. then textarea goes empty. why so? google doesn't have this answer..
-1
votes
1answer
42 views

How can i insert multiple loop in an axios array.? [on hold]

I have been trying to get two strings out of an axios array but somehow it keeps on giving me an error help me please. I want a dropdown with groups which should be divided by opt groups and when ...
0
votes
0answers
15 views

Highlighting specific text parts in jTextPane

English isn´t my first language, sorry if I got some mistakes in my text. I am getting started in coding java and I am trying to code a program which is pulling specific text parts from a desired ...
0
votes
0answers
20 views

Get group selection with axio json data

I am trying to get multiple checkboxes in groups of data for multiple selection I am having trouble getting all the data in same dropdown. I have already tried the optgroup tag but it has not worked ...
-2
votes
0answers
12 views

How can I make iphone safari show completely text when option is too long?

My problem is that the options is too long and it can't show more than two lines on iphone safari. How can I make option show completely? Thanks.
1
vote
1answer
73 views

select() selects more columns than I tell it to. Why? - R

For example, when I use select() from dplyr: mtcars %>% select(., cyl, disp) It selects correctly cyl and disp. But when I do it in the dataframe I'm working on, (let's assume it's iris): iris %&...
-3
votes
0answers
26 views

Erich Hynds multiselect set some values via DOM [closed]

I need than a client input set/unset some options in an already charged Erich Hynds multiselect. After search for it, I can't find a way to select/deselect the values (via methods or JavaScript). ...
0
votes
1answer
27 views

How to divide one row in various?

I have a column data in a postgresql table that receive data like this: |A|C|F|L|T|U| The others columns are name, date Example: NAME | DATE | DATA ALYSSON | 2019-01-01 | |A|B|C| How to ...
-1
votes
0answers
19 views

Select statement for unique total accounts have won contracts this fisical year and dont signed before any contracts

Dears I have task to get the total number of accounts who have won contracts signed this fiscal month and this fiscal year with conditions that this accounts dont have any other contracts signed won ...
1
vote
2answers
21 views

How to select a record if it is equal to any record of a column from a different table?

I have a table with adresses, which were separated by spaces into different columns. Since the name of the streets can be made up from 1-2-3 etc. parts, the street suffices are placed in different ...
0
votes
2answers
57 views

Ajax call with PHP / MySQLi query returning wrong results [duplicate]

I am trying to check if an input value already exists in my database. So far I got the following but this always returns me "Invalid" (even if I enter a matching value) so my guess is I have an ...
0
votes
2answers
25 views

Can't use subquery in select statement. Returns “FROM expression missing”

I'm struggling with a subquery in a SELECT statement. I'm getting an error with FROM expression missing(ORA-00923). I want to have the result of counts in one row thus I'm trying to use subqueries in ...
1
vote
1answer
28 views

How to get the last timestamp date from sqlite table

I want to get the date when the SQLite table was last updated. I got a DataHelper Class. // Get the last sync date form app mysql table. public Cursor getlastsyncdate() { SQLiteDatabase db = ...
1
vote
1answer
25 views

<option {% if 'condition.' == 'condition…'%}selected{%endif%}> </option> not working in Django custom select

I am passing two objects 'editsub_obj' and 'cat' both key-value pairs to the template. The main aim is to keep option tag selected when name from both object list matches but the code is not working. ...
-1
votes
0answers
36 views

How to fix: 'Error in .f(.x[[i]], …) : object 'GDP2016' not found'?

I'm taking a course on how to analyse data using r and have run into a problem (a couple actually and they are all of the noob variety), anyways: The goal ultimately is to calculate the mean gdp for ...
-1
votes
1answer
28 views

Make new dataframe from top 3 values per group

I want to make a new dataframe from the top 3 rows for the 'value' column for each 'gr'. So basically a dataframe with the top 3 'values' for 'gr' 1,2,3,4,5 in the example below. Here is an example ...
0
votes
3answers
36 views

Select Exists always return true in mysql

I am trying to make a login form where I have to register user before that. But this code always says that user already exists even if it's not the case. What am I doing wrong? connection.query("...
0
votes
2answers
17 views

Select an object with different assignation in another column

Simplified my problem with this table, I want to select in PostgreSQL only the people that have paid, I have another guys that have paid and have not paid I want to exclude those people, thank you ...
0
votes
0answers
14 views

Get a {{mondoDB query}} passed to a handlebars template and run a javascript module to get data

I'm stuck with this. I'm working with nodejs, handlebars templates and mongoDB. In a handlebars template, I'm trying to set options for a select when the value of another select changes. My first ...
0
votes
2answers
34 views

JQ - how to display objects based on on the value of objects in an array

I have a JSON file that looks like this: { "InstanceId": "i-9KwoRGF6jbhYdZi823aE4qN", "Tags": [ { "Key": "blah", "Value": "server-blah" }, { "Key": "environment", ...
1
vote
3answers
30 views

Refactor string in MySQL field

I searched and couldn´t find something to solve this. I want to update the following table: +--------------------+ | description | +--------------------+ | Interna_172_16_1 | | ...
0
votes
2answers
30 views

Selecting result from two tables in SQL Server

I have the following tables. Terminal: Outlet: vpos_out: When I execute the following query, everything looks good: SELECT TOP 2 o.id, mt.id AS [activated_device], vo.id AS [outlet] ...
0
votes
0answers
15 views

sqlite select query top X% for every item

i making get topX% query SELECT CAST(ROUNT(COUNT(*) * 0.1)AS INTEGER) FROM person; But syntax error ,, This is the kind of query I want to finally make. SELECT*FROM person ORDER BY vote DESC ...
0
votes
1answer
28 views

Select Random Values for Grouped Dataset

I'm no whizz at SQL. However I'm using the following query: select count(*) as countis, avclassfamily from malwarehashesandstrings where behaviouralbinary IS true and avclassfamily != '...
0
votes
1answer
27 views

Jquery - multiple dropdown lists, disable selected entry in other lists

I've got multiple dropdown lists, when I select an entry in one I want it to be disabled in other so it can't be selected. But if it is deselected, then I need it available in the other lists. So ...
0
votes
1answer
12 views

unable to parse unicode data(marathi font) from sql xml

I am trying to parse sql xml to get marathi data fonts from it, but i am getting ???????. i have tried NVARCHAR in xml but still facing error, any suggestion please? please click sql query link to see ...
1
vote
1answer
27 views

How to put a row on top in Codeigniter

is there a way to order codeigniter select query by a specific value? I know that it can be done in mysql from this answer, but I'm wondering if there is a "codeigniter" way of doing it, here is what ...

返回首页
杏彩计划 杏彩官网 杏彩APP 杏彩走势图 杏彩下载 杏彩官方 杏彩网站 杏彩怎么玩 杏彩官方 杏彩靠谱吗 杏彩代理 杏彩骗局 杏彩投注 杏彩倍率 杏彩开奖 杏彩漏洞