38,505 questions
2
votes
2
answers
94
views
SQLite query to find a result using two tables which needs a match in two rows of one table
I have an SQLite database - and to simplify, it has two tables:-
recipe and ingredients.
The recipe database is comprised of
recipeId (autoincrement, primary index)
title
and the ingredients:-
id (...
- 21
0
votes
0
answers
112
views
How to Customize the Dropdown Icon in JetSmartFilters
I am trying to customize some of the JetSmartFilters: the search filter and checkboxes filter (with the dropdown enabled), but I cannot find any option to customize the dropdown icon element (the ...
- 21
1
vote
2
answers
84
views
SELECT statement on Join example
I'm working through an inner join example on Geeks For Geeks I came across a SELECT statement I don't understand.
We have two tables, Student and StudentCourse we are joining on a common column ...
- 139
0
votes
1
answer
47
views
JQuery show "default" select value on change of first select from mysql values
I've three selects
The first shows product name. The list is generated by a mysqli_query
<select id="product">
<option value="abc">ABC</option>
<option ...
1
vote
3
answers
123
views
Counting number of rows up to a specified value by type and id
I have a dataset with id, test_date, test_type, test_result - like this:
ID
Test_Date
Test_Type
Test_Result
1
2024-03-21
A
Fail
1
2024-04-21
A
Fail
1
2024-04-30
A
Pass
1
2025-05-15
B
Fail
1
2025-05-31
...
- 21
0
votes
0
answers
59
views
Filament Forms Select createOption relations
I get an error if my createOptionForm (in a Filament Form Select) has a Select with a 'relationship' definition instead of an options definition.
I get the same issue using a Fieldset (in the ...
- 125
-6
votes
2
answers
119
views
Reverse order of split string parts [closed]
My simple Oracle SQL select statement:
select id, my_column
from my_table;
returns the following output with over 1.000.000 rows in the result set:
| id | my_column |
| 1 | abc.mno.xyz |
| 2 | ...
3
votes
3
answers
124
views
Check dates within same table
This is my table from SQL and the output that should be. What I need is to merge both dates and their entries.
I tried both queries, IN and OUT, but unable to merge.
IN:
SELECT
MAX(one.TOTAL_IN) ...
- 33
0
votes
1
answer
93
views
PostgreSQL Force Index Scan
I have a table with below columns in PostgreSQL.
id,
location,
store,
flag1,
flag2
Here id, location, store are contributing to Primary Key. So by default postgreSQL creates an index on it.
I have ...
0
votes
0
answers
91
views
recv() or select() doesn't return immediately after shutdown() and abortFlag in multithreaded socket listener
I'm working on a Windows TCP socket-based listener in C++ where the Listener() function runs in a separate thread. It waits for image frames from a detector device. I have implemented an Abort() ...
- 1
2
votes
1
answer
110
views
dplyr::select rename columns and negative selection at the same time doesn't work
I'm confused about the dplyr::select behaviour. Maybe I've missed a recent update to the function or am completely remembering it wrong, but I can't - at the same time - rename a set of columns while ...
- 11.6k
0
votes
0
answers
118
views
Select in MudBlazor
I'm quite new to Blazor and thereby also quite new to MudBlazor and now I get an error that I cannot figure out.
My app.razor:
<!DOCTYPE html>
<html lang="en">
<head>
&...
3
votes
1
answer
79
views
How to cancel a task which includes a file operation?
Reproducible code snippet:
#[tokio::main]
async fn main() {
let (tx, rx) = oneshot::channel();
let a = tokio::spawn(async move {
tokio::select! {
_ = rx => {}
...
- 41
1
vote
1
answer
68
views
Search for multiple different strings in the same set of multiple columns [duplicate]
I need to search for multiple different strings in the same set of multiple columns in a MySQL table.
Here's one way that works (CONCAT / CONCAT_WS):
SELECT * from some_table WHERE
LOCATE('word1', (...
- 21
0
votes
2
answers
103
views
How to make a custom dropdown inside a scrollable popup behave like a native <select> (i.e., render above content without expanding the container)?
I'm building a custom searchable dropdown component in React that works fine in general — but I'm facing a layout issue when it's used inside a popup modal/form.
Here’s the problem:
The popup form has ...
0
votes
1
answer
95
views
SAP Crystal Report 2020- Select Expert is not working as expected
I'm trying to implement a filter in a column to suppress some values based on several conditions, but the displayed results in the report are not totally correct.
This is my formula:
if {DailyReport....
0
votes
1
answer
72
views
VBA in Word - selecting ranges and making comments
I've been trying to figure this out, but no such luck.
Ultimately, I'm trying to create a macro that searches the Word document for each instance of String1, selects a range of text starting with that ...
- 13
0
votes
1
answer
72
views
Postgres SELECT query randomness
The following statement uses random() to produce two distinct values:
select random(), random();
But the next statement outputs two equal values:
select random(), random() order by random();
...
- 3,156
0
votes
1
answer
136
views
Is polars bracket indexing to select a column discouraged?
Some stuff online like Selecting with Indexing is an anti-pattern in Polars: How to parse and transform (select/filter?) a CSV that seems to require so? suggests using indexing like df["a"] ...
- 11.6k
0
votes
1
answer
45
views
how to get only the id, when using vue select
So I have a select from Vue Select, but what comes out is all object data, what I want is only the ID of the data, how can I get just the ID?
here is my code
const form = useForm({
name: '',
...
1
vote
1
answer
55
views
The table has no ID, the date is contained in two columns
I have a table in which a new record is added about once a second. The ID is missing from the table. The "Time" column shows the time in milliseconds, which is reset at the end of the day.
...
- 41
0
votes
2
answers
102
views
From many RData within different subfolders, list only data.frames, select some columns, then rbind them all and unlist
I've searched extensively, but I can't find a solution that meets all these objectives at once:
I have hundreds of RData files located in different subfolders.
In each of these RData files, I have a ...
- 972
0
votes
1
answer
43
views
Selenium on a jQuery select
I'm trying to get a select to work for the following div:
<div class="control-group generic-style clearfix">
<label for="Category">Category</label>
<...
- 51
-1
votes
1
answer
79
views
Get all non-empty rows from one column and then get all matching rows for those values
I've built a program that converts an Excel sheet containing my departments schedule to a SQL table. We always work in pairs so I want to be able to check all my shifts and what person I'll be working ...
- 159
0
votes
1
answer
162
views
I want nested Multi select dropdown in Mudblazor
☐ SaaS
☐ OnPrem Options
☐ Cloud
☐ Hybrid
☐ Other
My select dropdown contains parent options - SaaS ,On Prem and Other and My OnPrem contains 2 child options Cloud and Hybrid. On ...
- 113
0
votes
0
answers
115
views
Way to do a "batch select" (with multiple where... in...) using JDBC in SQL Server?
I am working with SQL Server in Java code.
I have a semi-large (16,000 items) ArrayList of objects, and I would like to do a SELECT on the table for all these objects. (The goal is to get surplus ...
- 29
-1
votes
3
answers
76
views
How to find same column from two tables in SQL [closed]
I have two tables with lots of columns, so I want to write dynamic query to find the same column names from both tables in single query in SQL.
I have tried using intersect - but it cannot work. Is ...
1
vote
0
answers
19
views
What is an elegant way to select a database cell and then increment it? [duplicate]
I have a stored reference number, let's call the variable "my_index," in a table of variables.
id
var_name
var_value
1
black
#000005
2
domain
example.com
3
my_index
3
I need to collect that ...
- 1,966
-1
votes
1
answer
69
views
mysql select and set variable in one query
I have 2 tables:
comments_table
id int(11) unsigned NOT NULL AUTO_INCREMENT,
media_id int(11) unsigned DEFAULT NULL,
user_id int(11) unsigned DEFAULT NULL,//user who commented
title varchar(300) ...
- 5,146
0
votes
0
answers
31
views
SelectInput text is outside the select?
This is basically what is in the examples and my code:
<ScrollView>
<VStack className="px-8">
<Select isRequired>
<SelectTrigger variant="outline&...
- 185
0
votes
0
answers
27
views
using checkbutton, var.get==1 doesn't work why? [duplicate]
update: My application is big, there is many user interfaces,I need help in "Select" button where if select one of the chechbutton, it will display on previous Gui "window" the ...
2
votes
6
answers
258
views
Handling bad date time value transparently as null in select?
I have an Oracle database table I cannot edit where - due to miscommunication - datetime values are ‘01-01-01 00:00:00,000000’ instead of null. I cannot change the data and it is too huge to make a ...
- 75.4k
-1
votes
1
answer
61
views
MySQL Sorting 1 column by word length then alphabetically [duplicate]
I am working on a site that displays all possible words from letters entered. There are words in the database up to 15 in length. Approximately 170,000 words. When I enter up to 8 letters, everything ...
0
votes
3
answers
139
views
Show different text in a separate div by select options
I'm trying to show different text when selecting an option from a select, but it doesn't work.
I'm trying to get the open button to display text 1, then depending on the option chosen the text changes,...
- 37
0
votes
0
answers
36
views
How to implement MUI <Select> with collapsible feature. [Image is given]
is there any way to create a select component like this? I have tried from MUI but the collapsible list is not taking the value.Mui select collapsible
const getOperatorComponent = (value: ...
0
votes
2
answers
136
views
How to edit both Contact and related User records in Filament's editOptionForm?
I am using Filament for my application, and I have a form with a Select field. This Select field lists Contact records, each related to a User.
We are allowing users to add new contacts using the ...
2
votes
2
answers
82
views
Generate a script out of nullable column in SQL table [duplicate]
Following is my query:
SELECT 'INSERT INTO MyTable (
CancellationReason
)
VALUES (
''' + rc.CancelReason + '''
)'
FROM AnotherTable a
I get below result:
Since the column a.CancelReason is ...
1
vote
3
answers
96
views
MySQL select collections matching multiple subgenres
Assuming these two (simplified) tables:
CREATE TABLE books (
book_id VARCHAR(25) NOT NULL,
subgenre_1 VARCHAR(6) NOT NULL,
subgenre_2 VARCHAR(6),
subgenre_3 VARCHAR(6),
mood_1 ...
- 81
1
vote
1
answer
56
views
Selecting columns based on specific values in the field
I'm creating a table based on survey data that asks respondents to rank their satisfaction with elements of an event. If a respondent indicated dissatisfaction with an element of the event, they ...
- 387
0
votes
1
answer
55
views
How to change the outline and label color of Mui Autocomplete Select, when it's selected
I've tried changing many of the styles through sx property, but nothing seems to work. I just want to set all colors to black, as you can see.
screenshot
<Autocomplete
...
1
vote
1
answer
71
views
SQLAlchemy use "IN" to select pairwise correspondence
Consider the following DB:
from sqlalchemy import String, select, create_engine
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, Session
class Base(DeclarativeBase):
pass
class ...
- 5,418
0
votes
1
answer
45
views
SQLite: NOT GLOB returns the string I specifically want to exclude
I am attempting to do a column update in SQLite where if a certain string exists, update the column EXCEPT if it matches a particular string. Note, I can't use an EXCEPT statement in the select query ...
- 681
0
votes
0
answers
87
views
Copying initial table data into a file using Primary key or ctid in postgresql
Im trying to copy initial table data around 100 to 200 GB to a file in text format.I created a connection-1 and started a transaction with isolation level REPEATABLE READ and exported a snapshot to ...
- 336
0
votes
1
answer
75
views
Applescript - targeting a menu with numeric ID
I'm a noob at Applescript, but managed to get the first half of this script to just display the menu. The image is a mouse hover to display the UI Browser result. The syntax for clicking on a menu ...
- 171
2
votes
3
answers
74
views
How can I query each day of a SQL table and check if a particular field value appears in two distinct rows?
I have a Postgres SQL table that looks like the following:
The index_constituents table:
id date opening_closing ISIN
1 2016-05-03 O AAAAAA
2 2018-04-...
1
vote
2
answers
85
views
Paginate SQL results by certain column
I would like to paginate complex table by certain column. Lets say we have table as follows:
ID | Name | Genre
1 | A | fantasy
2 | A | medieval
3 | B | sci-fi
4 | C | comedy
5 | C | sci-fi
6 | C ...
- 563
0
votes
1
answer
59
views
SQL Merge Tables Based on Present Values [duplicate]
I am trying to populate a table with the consent values for two different places based on the same ID.
So I have table A:
id consent_value
111 Y
222 Y
333 N
and table B:
id ...
- 15
1
vote
1
answer
108
views
can starvation happen due to select serving few fd while other fd starve?
Here is the scenario,
one server handling multiple clients using select()
few of the fds are very active(there are very much data coming on few) while other are normal active.
Then will other fds ...
- 287
1
vote
0
answers
36
views
How to disable the options in select with Django
I created a calendar with dates where appointments can be made.
I then created a form to select appointments.
I want each time an appointment is made, it to be grayed out for the exact day and time it ...
- 21
0
votes
0
answers
32
views
Select Media Dialog Tree View Not Working in Sitecore 10.3
I've seen issues like this posted for older Sitecore versions, but none as recent as 10.3.
When invoking the Browse trigger on an Image field in Sitecore CMS, the user gets the Select Media dialog. ...
- 99