返回首页

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
30 views

Remove the checkbox when deleting an item

There is a problem with the code: if I select elements, they are added to the .selected-items block; if I remove the checkbox in the upper row of elements, the elements disappear in the lower row but ...
0
votes
1answer
25 views

Select filter on column of type STRING

I'll try to explain as simple as possible. I have a Database table 'DB_JOURNAL' that has only 2 columns 'Date' and 'Journal' type String. example : 01.01.2020 | I played football. 02.02.2020 | I ...
0
votes
1answer
34 views

“Each GROUP BY expression must contain at least one column that is not an outer reference” with “grouping set”

I have the following SQL query, my goal was to make a subtotal and a general tota, grouping the subtotals by products, but my problem would be that if I use only the "group by" he would have to add ...
0
votes
0answers
29 views

How to Select data in a SQLite database with an AND condition using Android Studio [closed]

Please Help me This Method Is Perfect Working. public Cursor getEnumData(String HHid) { SQLiteDatabase db = database.getReadableDatabase(); return db.rawQuery("select * from " + Section_1A +...
-4
votes
0answers
14 views

How to show results when Spelling of keywordsl doesn't match correctly [closed]

Hi I'm making an simple search algorithm for my website and I want to show results when the keyword doesn't match correctly. For Example :- If a user search gooogle And correct the spelling is ...
-2
votes
3answers
39 views

unable to execue the following select statement getting error

when i execute the following select statement i am getting the below error. I am trying to execute the below statement in Oracle server 9.1. I believe due to this i am getting this error. I know ...
1
vote
1answer
23 views

How would select() return anything other than -1, 0, or 1?

This is definitely just a dumb misunderstanding on my part, but the man page for select() states: The timeout argument specifies the interval that select() should block waiting for a file ...
0
votes
3answers
41 views

Adding values from previous row into current row

I have a simple table and I want add a value from previous row into current and value of current in next row so it keeps on going until the end. Please have a look at the following table data. ID ...
0
votes
0answers
6 views

How to select subset of dataframe in gui

I have some time series data that follows an underlying functional form but which can have noise as well. I’d like to be able to select the portion of the data that I want to fit the data to. A simple ...
0
votes
0answers
5 views

How to forward data between FDs until one of the FDs dies?

I need to forward data between two file descriptors (socket, pipe, whatever) until one of the ends dies. When the input end dies select reports the FD as readable and it gives error on read which ...
1
vote
0answers
21 views

mysql insert into not working but select does

The following sql code works: SELECT T1.id, IF(hours_per_week IS NULL OR hours_per_week = '', 0, 3) as hours_per_week, IF(T2.rate_per_hour IS NULL OR T2.rate_per_hour = '', ...
0
votes
1answer
30 views

Laravel update or delete in sql multiselect field

I have multiselect option in my website. <select multiple name="genres[]"> <option value="1">action</option> <option value="2">adult</option> <option value="3">...
0
votes
0answers
15 views

Correct way to show various possible parameters for selection by user, when running Script from inside a ERP system

This is sample data Report_parameters I'm currently designing a SQL report, to be run from inside a ERP system. The idea behind this code, is to bring all AR open items, with all these fields in ...
0
votes
2answers
34 views

how to update data from two tables if the value is the same

I have two tables in both tables have a BSONUM column, I need to update table1 column REIS if in both tables BSONUM = BSONUM made a query in SQL Server but does not work
0
votes
2answers
40 views

SQL handle select with split strings

I have a request whom looks like this : "SELECT CLCLEUNIK ,NOM ,VILLE ,CODEP FROM CLIENT WHERE NOM LIKE :nom COLLATE Latin1_general_CI_AI" the :nom is a String, whom can be one word or many words....
0
votes
0answers
5 views

Select tag with ngModel and event.value default option not working in angular 7

i want to display by default option in select drop down when an components loads. <select class="form-control" [(ngModel)]="currencyForRound" #currencyRnd (change)="selectedCurrency($event....
-1
votes
1answer
29 views

How do I select doctors that didn't admint any patients

In my database there isn't any doctor that hasn't seen any patient, so I would like to have under first column a text ' There is no doctor who hasn't admitted any patients'. SELECT d.FistName + ' '...
4
votes
2answers
39 views

Finding winner of each player group in a tournament - PostgreSQL

This question on PostgreSQL is bugging me for quite some time now. Iv'e tried myself and searched everywhere I could but could not end up with a result that takes the player from group 3 into account....
1
vote
0answers
17 views

how do i innerhtml a select list element in javascript? [duplicate]

function opchk() { var val = document.getElementById("ops").value; document.getElementById("f9").innerHTML = val; } this will print out op1 or op2... i dont want to change the values of them ...
0
votes
3answers
52 views

How to choose a <select> option value automatically from an URL parameter?

I have 2 step form and I'm passing the first name in the URL from step 1 to step 2, but I'm not sure how to do the same thing for a select field. As an example I have this: In the URL: ?firstname=...
0
votes
1answer
27 views

How to using If else for conditional <select> option in PHP?

The scenario is, I have 3 level user (Employer,Manager,Cashier), if the employer login the page, the employer just can see Manager and Cashier option in the select box;if the manager login the page, ...
1
vote
4answers
53 views

How to make dropdown selected if URL matched with value?

I'm trying to make a selection in the select box based on the URL. The urls are tied to the value attribute of option. How can I do this in jQuery? <select> <option value="http://name....
0
votes
5answers
36 views

can i use onblur on a select list in javascript?

when i choose another option than the first in a select list i want the asterisk to be removed! <script> function opchk() { if (document.getElementById("ops").value = 'Select size') { ...
-4
votes
0answers
20 views

Combine select options with same value

Here I want to combine the selected option below as one by jQuery <select data-target="secondList" class="firstList selectFilter form-control"> <option value="-1">Country</option> ...
1
vote
0answers
10 views

UIPressesEvent pressType Select doesn't work in swift

override open func pressesBegan(_ presses: Set<UIPress>, with event: UIPressesEvent?) { for press in presses { if press.type == .select { self.view.backgroundColor = .red ...
0
votes
2answers
21 views

Unable to select an option from a drop down in Katalon studio

I am new to Katalon Studio and I am facing an issue regarding selection of the drop down. Please find below the details: This is the HTML : I have tried using selectByIndex with the object xpath as: /...
2
votes
1answer
24 views

Access Select query where source field is based on another column

I am using MS Access for FX rate data. I have a table which lists currencies and their associated FX rate. Each column has the rate for a different month. e.g. "January 2019", "February 2019" etc I ...
0
votes
2answers
33 views

Selecting variables as individual rows in table [closed]

I'm trying to select different variables into a temporary table as individual rows, but I'm being advised that 'there are fewer columns in the insert statement than values specified...' How would I ...
-1
votes
1answer
23 views

Mysql order by sorting not working as expected descending

i am facing a a very strange behavior regarding mysql orderby sort, I am trying to sort the records by fee_range high to low which is being computed in run time first 3,4 rows have lowest values and ...
0
votes
4answers
50 views

Kill Db2 select statement after the declared time

In Db2 LUW 9.7, how to implement a query timeout? When performing queries, is there is a 'timeout' parameter that I can declare/implement somehow that will make a given query abort after a certain ...
2
votes
1answer
32 views

select2.js get event target

I have two <select> elements and for both initialization is same. But their ids are different, and I want to access their id attribute inside the initialization. <select name="names[]" id="...
0
votes
0answers
12 views

Client-Server - select() system call modifies the timeout value

Below code is written at CLIENT side, here client is reading response from Server using Select(). I observed select() introducing some delay in response. Gone through the google for this, find select()...
1
vote
1answer
42 views

SQL Queries for division

I am working on Excel VBA where I am writing SQL code to fetch date from Access database. I am concerned about a division query. I am writing a SQL query in vba to get the aggregated sum from a ...
1
vote
2answers
51 views

finding distinct pairs in sql

I was trying to learn non-equi joins when I encountered this problem. I have a table pops: +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | ...
0
votes
1answer
30 views

How do I select a json column with such a structure for Mysql 5.7

I have a products table with the following attributes in my mysql5.7 database table Products id : Integer attributes : Json Type price I have inserted the following record: INSERT INTO `products` (`...
0
votes
0answers
38 views

Python SQL Select drops leading 0 from string column

A Python 3.7 SQL SELECT request, using MYSQL Connector, is returning a list of integers from an SQL table that is made up of an INT column and a TEXT column. Although the TEXT column is made up of ...
0
votes
0answers
19 views

VB Code to Select All Sheets except the First Two

I am creating a report where I need to run a macro that will select all worksheets except the first two ("Intro" and "Contents"). The names of the first two sheets are constant, but the data sheets ...
0
votes
1answer
36 views

Select Max() of SUM() for a Group

SELECT tname , pname , SUM(Goals) FROM team as t , player as p , matches as m WHERE t.TID=p.TID AND p.PNB=m.PNB Group BY pname , tname ORDER BY `SUM(Goals)` DESC I need to Select only the player ...
-3
votes
0answers
33 views

Oracle database missing right parenthesis [closed]

I use the oracle database, and also i have this query: select max(cast(substring(EMPLOYEE_TRIP_CARDS0_.trip_Card_Number, 1, position('/' in EMPLOYEE_TRIP_CARDS0_....
-2
votes
1answer
36 views

The same table SQL Joins

I have two select statements, my purpose is to display the sum of billing and the sum of penalty. Can it be done using joins? SELECT SUM([Amount]) AS 'BILLING',(SELECT SUM([Amount]) ...
-1
votes
0answers
13 views

Como eu faço para salvar uma opção de um SELECT no banco de dados com o laravel? [closed]

Eu Tenho um Select com várias options e quero saber como salvo o valor do option no banco de dados. ATENÇÃO: eu estou utilizando o tipo de relação many to many. Este é o select: Este é o model Book: ...
0
votes
0answers
46 views

Error Code: -802, SQL State: 22023 SQL0802

I have a problem with an update (Database is AS400): UPDATE TABLE1 t1 SET (t1.VRNUMO,t1.VRNUSE) = (SELECT XVRNUMO,XVRNUSE FROM TABLE2 t2 where t2.XVRPRTE = t1.VRPRTE AND t2.XVRPROG=t1....
0
votes
1answer
23 views

HIVE SQL: what is the fastest way to select only one value from a huge database

Background: there is a customized SQL database based on HIVE, lots of SQL functions can not work there, such as SELECT */ current_date/ 'datetime'/'relativedelta' etc, the only solution i can find is ...
0
votes
1answer
21 views

How to display all cards when no input is given to filter in angular?

I am trying to filter multiple cards in angular using Pipe, filter is working good but when no input value is given it doesn't display any cards. I want to display all cards when no input is given or ...
-2
votes
0answers
25 views

Product price from select product in input field [closed]

I have data on inventory table with column item_name,price,quantity. I have a form with select input field where value is inventory_id. I want that, when i select an item from select field price and ...
1
vote
3answers
36 views

How do I select how many pantients every doctor has?

I have a table of Visits on the Hospital, included DoctorID, PacientID, Date.... I did like this but I recieved an error. SELECT d.DoctorID, COUNT(v.DoctorID) FROM Visits v left join Doctors d on ...
0
votes
0answers
45 views

SELECT statements behave like INSERT INTO statements

I have a very simple VB.Net program that allow me to filter items from a data table through SQL queries inserted in a textbox. However, when I select incomplete rows, the program will increase the ...
0
votes
4answers
30 views

Pandas: Selecting rows by condition on column and index

Assume we have the following dataframe: d = {'col1': ['a1', 'b1', 'c1', 'a1'], 'col2': ['a2', 'b2', 'b2', 'c2'], 'year':[2011, 2011, 2012, 2012], 'rank':[1, 2, 1, 2]} df = pd.DataFrame(data=d)....
0
votes
1answer
20 views

How SQL selects between two strings/texts?

In SQL if I've the following select statement: SELECT * FROM Products WHERE ProductName BETWEEN 'Geitost' AND 'Pavlova' It run successfully and display the output records, but I'm a little bit ...
-3
votes
0answers
14 views

Is there a JavaScript library for creating Dynamic Collection Select like one on Firestore or Amazon Seller Central? [closed]

Below is a sample of how my data is structured. Is there any javascript library I can use to create Dynamic Collection Select something similar to the Image? [{"id":"5e204dfe4c2d282b941c91a1","name":"...

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