Latest Questions

Laravel - foreach on collection

I have a request : $comments = $post->comments()->with('replyComments:id,post_id,user_id,content,created_at,reply_comment_id')->orderBy('created_at', '

How to insert data from CTE to a Temp Table?

I am trying to create a some logic using CTE and then instead of using DML statement after CTE, I am trying to create a temp table using CTE. This is possible i

How to modify & replace the key an object by comparing it with other objects?

I have an array of object which consists some id's as a key. const sampleObj1 = {0011:[{},{}], 0022:[{}, {}], 0033:[{},{}]} const sampleObj2 = [{id:0011, name:'

Alternative to index signature

I have an array of object like this: [ { "bio": "Douglas Gerald Hurley is an American engineer, former Marine Corps pilot and former NASA astronaut. He la

422 Error when using httr for uploading data to batchPrediction API (data robot)

Disclaimer: This error is related to a subscription-based tool and hence the issue is likely not going to be reproducible for any reader. Nevertheless, any sugg

Control the order of adjacent columns when selecting SUM

When you select by a SUM, the returned data is grouped to a single record, which is fine. The query below correctly returns the sum, but the adjacent column val

The type java.util.Optional is not a supported type for a multipart request

I have a facade filter service. Trying to route a REST call in one cluster into another cluster through the filter service. @Filter({"/api/**", "/home/**"}) pub

Encountered a sub-selection on the query, but the store doesn't have an object reference. angular

I'm getting this error when I try to make some gql query: I have tried to change the angular version, but I need to implement gql in this version. without upgr

Vue.js 3: Store videos offline in a Vue PWA

I am using Vue 3 with Typescript. I am trying to show a video in the PWA. It works online great but when i try it offline the video is not loading. I store the

Gatling EL not getting replaced in ElFileBody

I'm very new to gatling performance test and i'm trying to write one simulation for our service. I'm using gatling 3.7.6 version. I have below request json for

Spreadsheet automatically multiple rows

I'm trying to make a sheet that I can easily expand on in the future. I want to calculate B3-BX by C-S2. In row 2 of every column I have a different number. I w

Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why?

I've been wrestling with this for a while and can't quite figure out what's happening. I have a Card entity which contains Sides (usually 2) - and both Cards a

Trying to calculate a 1hr range within the last 12hrs of a range with VBA

So I am trying to calculate a test temp for 1hr from the last 12 hours of data. Sometimes this data can be several days some times it can be only 24hrs. The sta

Bypassing Imperva bot detection with Scrapy. Any way possible?

I'm trying to scrape several links containing information about events. I am rotating my paid proxies and user agents generated by UserAgent library. Imperva, w

What are the practical uses for strings?

I have been following some Fortran tutorials online and have recently come across strings. I was just wondering... what are the practical uses of them? It's pro

Vue dynamically added :ref in v-for are not shown in this.$refs

I'm new to vue.js, and I have a vue.js component that basically shows numbers from a data array when the button "Add elements" is clicked, the code is the follo

FFMpeg Add multiple Gifs/Watermarks to a video

I'm trying to add various Gifs/Watermarks to a video, but I'm having a problem getting it to work properly. We're assuming the video is 60 seconds long and I'm

alpine js, x-model binds to wrong value when switching tabs

running into an issue with alpine js. First of all I have a master component that allows the user to switch between two tabs @props(['pages', 'blogs']) <div

HTML Write side by side

I want to type words side by side.When I type words, they come one after the other. Here's my problem: problem I want to write this words side by side.Thanks fo

Can I apply popEnterAnim when I popUpTo a destination?

I have a NavGraph like below. Why I CANNOT execute the popEnterAnim when popUpTo the graph starting destination? <?xml version="1.0" encoding="utf-8"?>

npm err! code 1 in the vscode during installation for Angular

I'm trying to execute a code I have downloaded from the github in my machine. I have set the ambient for angular in the vscode and the issue npm ERR! code 1 is

Adding new column with first non Nan for each row closest to a chosen column from a dataset Python

Hello I want to create a new column from a given dataset (that I call here "df") with the first non-Nan for each row and closest from a given column For example

Increment index without show its value on xtend

I'm trying to generate some code with a xtend function , that function uses foor loop that with variable that its increemented , the problem is that that the va

Melt a frequency table in order to use ggplot2

I have a "frequency table" similar to this one # Create a matrix df<- matrix(sample(0:10,35,replace=T),nrow=5, ncol=7) # Rename columns and rows colnames

React Native iOS build failed at AppCenter

Our React Native iOS project has been working well with AppCenter build. But when we pushed certain changes, although it still works well locally, the build at

How do I access response information from COINGECKO API for coins with more than one word id?

I have 6 crypto coins I'm getting current price from CoinGecko's API I have spans inside of divs set up on my html page, where the price span html updates after

Random "Error Establishing a Database Connection" occuring once every 1 - 2 weeks

I am running WordPress 5.9.3 on Ubuntu 20.04 using Apache and once every 1 - 2 weeks my website goes into a state of "Error Establishing a Database Connection".

Google Colab: pip install and imports from a custom script

In MyDrive/colab a I have these files: 00-imports.py with content... !pip install boto3 classes.py with content... class Test def __init__(self): print(

GridFS Large File Download Crashes the Node.js Server. MongoServerError: Sort exceeded memory limit of bytes

So I'm running a Node.js server with mongoose and I've been trying to download a large file using the GridFS node package but I've been getting the following er

String Pattern Matching in C

I was trying this pattern matching method in C but whenever I give all the input, the vscode terminal waits for a while and just stops the program without any w