Questions tagged [multiple-select-query]
64 questions
0
votes
0 answers
How do select multiple with search relationship?
I need make a select multiple with checkbox like this: http://wenzhixin.net.cn/p/multiple-select/docs/.
But I need work with select relationship like this: http://devingredients.com/2011/05/populate-a-select-dropdown-list-with-jquery/
I made in the…
0
votes
1 answer
Selecting Multiple Options in Selection Boxes and Getting Results From Database?
I have made a webpage for a school project where I have a series of selection boxes (some are independent and some are depended on another) to make selections and then apply filter to make a query. It is still in test-mode and working fine for…
barutto
- 104
- 1
- 14
0
votes
1 answer
Getting data from 2 or more tables: select or join?
Let's say there are 2 or more tables.
Table A: aID, name, birthday
Table B: bID, petType, petName
Table C: cID, stackOverFlowUsername
I want to get something like aID, name, birthday, number of cats a person has, stack overflow's username
We…
BurningJade
- 1
- 3
0
votes
4 answers
Execute Multiple SQL Statements In Stored Procedure With Single Result Return
I am looking to return a single set of data from my stored proceedure, but the result are returning just the first of the two sets. How do I return just one set of data from the following:
SELECT TOP 1 categoryname, displaypartno
FROM…
Matthew Chamberlain
- 15
- 1
- 1
- 6
0
votes
3 answers
How to query database if we need to query with an array of id's in jsp?
After selecting some products a user clicked on proceed button. Now I need to display the selected data on next page. I was successful in getting the id's of selected data using the following code.
String[] array =…
Sree
- 51
- 11
0
votes
4 answers
What is wrong in my MYSQL Query?
SELECT
( SELECT
SUM(IF(status = 'Active', 1, 0)) AS `univ_active`,
SUM(IF(status = 'Inactive', 1, 0)) AS 'univ_inactive',
Count(*)
FROM online_university
)
AS tot_university,
( SELECT
SUM(IF(status = 'Active',…
sathish
- 6,705
- 3
- 30
- 35
0
votes
2 answers
MySQL SUBSTRING using queried length and position values vs programming language substring after retrieval
I am accessing a chado structured mysql database. I search by the gene product, for this example the product is "bifunctional GDP-fucose synthetase: GDP-4-dehydro-6-deoxy-D-mannose epimerase and GDP-4-dehydro-6-L-deoxygalactose reductase".
I can…
sage88
- 4,104
- 4
- 31
- 41
0
votes
2 answers
"Multiple SELECT, INNER JOIN" sql query not working
I tested my sql query in phpMyAdmin and it works there. But when I copy it and paste in my code then it return NULL. My other code is error-free as it works perfect when I remove this sql query. Thus, I believe there is some problem with this query.…
Geek
- 8,280
- 17
- 73
- 137
0
votes
1 answer
How to query from HTML multiple select combobox against values stored as comma delimited value
I have a multiselect combobox on the html page. The actual list of countries is about 60 items.
0
votes
2 answers
.parent() inside multiple selector
I want to select a couple of targets:
Every direct li descendant whose parent is not .sub-menu (unless it's the last, cf. 2.)
Every last li element of an ul.sub-menu
Exclude all li's that are parent to a ul.sub-menu
I was thinking something like…
Bram Vanroy
- 27,032
- 24
- 137
- 239
-1
votes
1 answer
MySQL - Joining multiple select statements
I initially tried fetching data using individual queries which took too much of resources, so I am trying to combine the queries in order to reduce the time taken. The first select works fine in itself but I want to combine with the second select in…
Saad Bashir
- 4,341
- 8
- 30
- 60
-1
votes
2 answers
Mysql query with multiple selects results in high CPU load
I'm trying to do a link exchange script and run into a bit of trouble.
Each link can be visited by an IP address a number of x times (frequency in links table). Each visit costs a number of credits (spend limit given in limit in links table)
I've…
D. Ionescu
- 9
- 4
-1
votes
1 answer
Multiple Select with same table in MySQL doesn't work
i'm having a problem with my database's multiple selection. I need to do a select that returns a kind of table with some processed data, and it need to be ordered by day of month. To do this, i'm using multiple select's issue of mysql. This is my…
João Aranda
- 3
- 2
-2
votes
1 answer
Execute multiple queries of oracle with loops in C#
I want to execute multiple select queries along with for and if loops.
Tables:
A: Orderno, ContractNo
B: ContractNo, ItemNo, Price, TotalAmount
C: OrderNo, ITemNo, Quantity
One contract can have multiple Orders(Contract and Orders have one-to-many…
userhmp
- 11
- 5
-2
votes
3 answers
SQL : Increment a new column whenever there is a multiple of 5 else dont
I came across this question in a round of interview. A table has the following column.
ID
1
2
3
4
5
6
7
8
9
11
12
13
14
15
16
17
18
19
20
22
23
24
26
The question is to create a new column that…
