In SQL SELECT capitalized is SQL query language for "select this row from a table of a relational database." In C and C++ select() is an important system call used by C and C++ programs and libraries that avoids busy waiting for network activity and other I/O to complete. In HTML ...
1
vote
0answers
14 views
jquery ui multiselect does not work with multiple + single select
i am using this plugin http://www.erichynds.com/examples/jquery-ui-multiselect-widget/demos/#single for multiselect, and wishfully for single select also, in the same page.
basically i have 2 selects ...
2
votes
2answers
37 views
SQL INSERT INTO select
Currently using a MySQL database
Wanting to insert a new row into a table (t_2) for every matching entry in my where condition of another table (t_1).
I also want to include a count value from a ...
1
vote
2answers
25 views
MySQL: Sort by group and field
I have a table with the following (simplified) structure:
INT id,
INT type,
INT sort
What I need is a SELECT that sorts my data in a way, so that:
all rows of the same type are in sequency, ...
0
votes
1answer
11 views
Oracle Select Max Date on Multiple records
I've got the following SELECT statement, and based on what I've seen here: SQL Select Max Date with Multiple records I've got my example set up the same way. I'm on Oracle 11g. Instead of returning ...
0
votes
1answer
10 views
DB2 insert if not present and select
I have a DB2 database table
Users
------
userId: BIGINT
I need to return a row from the table for a user. If the row is not present it should be inserted and returned.
Is there a single statement ...
4
votes
4answers
30 views
Most common number in MYSQL SELECT statement
I am trying to get a MYSql statement to spit out the most common number in a field. I believe I am supposed to use COUNT(QUANTITY) but I am confused by which to GROUP BY and ORDER BY, I can't seem to ...
1
vote
1answer
29 views
insert if not exists in sqlite with vb.net
I have records from server that I want to copy, so I used datareader to select all, during selection the insert also process.
This is the pseudo code:
while datareader.read
For f As Integer = ...
0
votes
1answer
25 views
Oracle: select by number name (seven -> 7)
Simple question: is there any way to select rows that contain a number by its number name? By that I mean I type 'seven' in the query, and get rows that contain '7'. I need this to do ordinals too: I ...
1
vote
0answers
21 views
always blocked on reading from pipe opened through php's proc_open when used with stream_select
I'm talking to a process requiring user interaction using the following (PHP 5.3/ Ubuntu 12.04),
$pdes = array(
0 => array('pipe', 'r'), //child's stdin
1 => array('pipe', 'w'), //child's ...
0
votes
4answers
29 views
Retrieve data using between some date range
I have the following table in my database
Membership
ComapanyId
IsMember
JoinedDate
ExpiryDate
RejoinDate
LeavingDate
I am using the following query to return all the members as for 2011-01-31
...
1
vote
1answer
39 views
sqlite select record one by one in vb.net
I have this records in the table:
username, password, rights, allowance
admin, asdf, admin, 20
john, qwer, user, 10
peter, zxcv, user, 10
I want to select one record at a time
I used:
for i as ...
0
votes
1answer
26 views
How to do this query with a complex where statement in Sqlite in Android?
I have a table with 100 or more columns that could have a value "yes" or "no".
I want to do a select according with the user's request (checkbox values form) to extract all the rows that have the ...
0
votes
2answers
30 views
Find the closest class of object - Jquery
Jquery
var courseSelect = $(".courseSelected");
$(".courseSelected").click(function()
{
if($(this).attr('checked'))
{
var selects = ...
2
votes
4answers
64 views
select rows with 2 distinct columns
I have a table with 3 columns: id, val1 and val2.
For each distinct value of val2 I want to select all rows for which distinct values of val1 exist (note that I dont want to select distinct values of ...
5
votes
4answers
52 views
Why do browsers replace the width value assigned via css?
When I assign a basic style to all selects eg.
width: 300px;
padding: 0;
margin: 0;
border-width: 1px;
I get unexpected results when retrieving the width via javascript under different ...