38,491 questions
Advice
0
votes
2
replies
142
views
Using <input type=datetime-local> with <step> attribute to get intervals of 15 minutes
I am working on a prototype of a photography website HTML and I in the Booking page of my website I want to use a date and time selector. But with the step attribute the browser shows all options ...
- reputation score 1
Advice
0
votes
3
replies
134
views
postEfficient mapping between index and permutation for very large n
I am exploring methods to compute a specific permutation from its index (ranking/unranking) without generating all permutations.
My focus is on very large values of n (e.g., up to 1000), where full ...
- reputation score 1
Score of 0
0 answers
67 views
Selecting a single value from a datatable populated by SQL
I am new to Power Automate as of this week. My current attempt, is to have an automation that checks a SQL table on a scheduled basis. The results of the SQL query will include an email address, and a ...
- reputation score 60
Score of 1
1 answer
112 views
Is there an equivalent to SELECT t1.* when there is a USING() clause?
Consider that there are 2 tables -- t1 and t2.
I want to write a query where I do t1 left join t2, and display all the columns of t1 if some attribute of t2 is true.
Out of convenience, I used a USING(...
- reputation score 644
Score of -1
2 answers
149 views
Select Case malfunction with V W X Y and Z? [closed]
I'm using select case to select only numbers and letters (no symbols). It is not working just for a few letters.
This code works with every number and letter except the last five of the alphabet, ...
- reputation score 1
Score of 2
1 answer
119 views
Query to show records with 3 date criterias
I need to pull 3 records at a time from a table to display on a form where people can sign up to one or any of the three matches displayed on the form
I have the mysql table set up with dates and ...
- reputation score 81
Score of 2
2 answers
143 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 (...
- reputation score 29
Score of 0
0 answers
241 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 ...
- reputation score 45
Score of 1
2 answers
98 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 ...
- reputation score 139
Score of 0
1 answer
61 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 ...
- reputation score 3
Score of 1
3 answers
155 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
...
- reputation score 21
Score of -6
2 answers
146 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 | ...
- reputation score 71
Score of 3
3 answers
133 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) ...
- reputation score 33
Score of 0
1 answer
113 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 ...
- reputation score 75
Score of 0
0 answers
106 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() ...
- reputation score 1
