38,502 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
2
votes
2
answers
97
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 (...
0
votes
0
answers
122
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 ...
1
vote
2
answers
86
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 ...
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
124
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日
...
0
votes
0
answers
64
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 ...
-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) ...
0
votes
1
answer
94
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() ...
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 ...
deschen's user avatar
- 11.6k
0
votes
0
answers
127
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
80
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 => {}
...
1
vote
1
answer
69
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', (...
0
votes
2
answers
107
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 ...