While using NestJS with VSCode, Is there a better way to separate the application logs in a new tab or use log filters within same console?

I was able to get this to work but is seems a little clunky and not as elegant as I was hoping for.

df3 = (pl.DataFrame(data)
        .with_columns(
            diff = pl.col('strike') - pl.col('target'))
        .with_columns(
            max_lt_zero = pl.when(pl.col('diff') < 0).then(pl.col('diff')).otherwise(None).max(),
            min_gt_zero = pl.when(pl.col('diff') > 0).then(pl.col('diff')).otherwise(None).min())
        .filter(
            pl.max_horizontal (
                pl.col('diff') == pl.col('max_lt_zero'),
                pl.col('diff') == pl.col('min_gt_zero')))
        .select(['strike', 'target', 'diff'])
)

shape: (2, 3)
┌────────┬────────┬──────┐
│ strike ┆ target ┆ diff │
│ ---    ┆ ---    ┆ ---  │
│ i64    ┆ i64    ┆ i64  │
╞════════╪════════╪══════╡
│ 15     ┆ 16     ┆ -1   │
│ 20     ┆ 16     ┆ 4    │
└────────┴────────┴──────┘

You can use chatgpt, if you ask it he will turn it into raw bytes (i had the same problem).

I like to use the URL API in such cases

const url = new URL('http://myapi.com/orders');

url.searchParams.append('sort', 'date');
url.searchParams.append('order', 'desc');

fetch(url.href);

https://developer.mozilla.org/en-US/docs/Web/API/URL

This code work fine for me:

mysql> update link_productgroepen set groep_id=(select groep_id from link_productgroepen_bck  where link_productgroepen.sku=link_productgroepen_bck.sku); 

link_productgroepen_bck contains a backup of the table link_productgroepen ,so the structure is the same. In order to update the link_productgroepen table I need to drop it and to create a new empty clone of it that gets filled with the new values provided by an other website by an api. This new dataset needs to be complemented by information present in 2 columns in the link_productgroepen_bck table. The code above copies the contents of the groep_id column in the link_productgroepen_bck table to the renewed ink_productgroepen table if the sku value in both tables is the same. The other backupped column is copied by the same mysql command but with the other column name.

You should use GREATEST/LEAST, this function returns NULL if at least one value is NULL.

So this code:

select * from TABLE where LEAST(COLUMN_1, COLUMN_2, COLUMN_3, COLUMN_4) is not null

will only return results if all columns are non-null.

We dont have the example data for tables like cs_facilities, cs_fundingMethods, ci_periodicBillings etc.

I created this example based on the sample data you provided and the expectation that you shared.

Fiddle

WITH RateChanges AS (
    SELECT 
        Client,
        Rate,
        Funding,
        LastUpdated,
        LAG(Rate) OVER (PARTITION BY Client ORDER BY LastUpdated DESC) AS PreviousRate,
        LAG(Funding) OVER (PARTITION BY Client ORDER BY LastUpdated DESC) AS PreviousFunding
    FROM ClientBillingInfo
    WHERE LastUpdated BETWEEN '2024-09-01' AND '2024-09-30'  -- Filtering only September 2024
)
SELECT 
    Client,
    Rate AS LatestRate,
    PreviousRate,
    Funding AS LatestFunding,
    PreviousFunding,
    LastUpdated
FROM RateChanges
WHERE PreviousRate IS NOT NULL  -- Ensures that there's a previous rate (indicating a change)
ORDER BY Client, LastUpdated DESC;

Output :

I think u should start use parallel programming like MPI library

As of torchvision version 0.13, the class labels are accessible from the weights class for each pretrained model (as in the documentation):

from torchvision.models import ResNet50_Weights
weights = ResNet50_Weights.DEFAULT
category_name = weights.meta["categories"][class_id]

My workaround was to go to Resource > Manage added data sources > Edit

I added a new dimension called 'Exclusions'

I used a Case statement in this to set the field value to 'Exclude' for items I wished to exclude, and 'Include' for items I wanted to include.

I then set the Exclusions field in the drop down list, and set the default value to 'Include'

Instructions for the case statement: https://support.google.com/looker-studio/answer/7020724?hl=en#zippy=%2Cin-this-article

I checked the Jira Administration section on a sample account and there isn't a stock Requirements field which makes me think it is a custom field in your cloud installation (unless your are using a server installation).

Can you clarify if you are using cloud or server impleentation? I can't tell from the url you specified if it is a hosted jira server implementation or a custom url for a cloud implementation.

If it is a cloud implementation, can you make a python rest api GET call to the following JIRA REST V3 API named field

 https://sample_company.atlassian.net/rest/api/3/field

Make sure to update the url with your cloud instance or it will fail as sample_company isn't a real domain.

That will return all the fields whether they are system or custom in json format. You can then parse the json to find the field(s) once you know the field names. Here is the structure of a sample field from a sample jira cloud installation for reference

{
  "id": "customfield_10072",
  "key": "customfield_10072",
  "name": "samplefield",
  "custom": false,
  "orderable": true,
  "navigable": true,
  "searchable": true,
  "clauseNames": [
    "cf[10072]"
  ],
  "schema": {
    "type": "string",
    "system": "samplefield"
  },
  "customId":10072
},

The name will most likely be Requirements for the custom field you are lookiing for since that is what is rendering in the screenshot but id and key for the field will have a name such as customfield_NNNNN where the NNNNN is a custom number depending on how many custom fields you have in your installation. Once you know this id or key, you can make a python rest api call to the JIRA REST V3 API for your issue and get the custom field values from the previous API. This will change from customer install to customer install so I can't give the exact field.

Here is the Jira Rest API for an issue for example:

 https://sample_company.atlassian.net/rest/api/3/issue/jira_ticket

where jira_ticket is the name of the jira_ticket you are trying to get the data from.

So for example if my ticket is XX-13515, I would make a GET Request to

 https://sample_company.atlassian.net/rest/api/3/issue/XX-13515

That would return JSON output. You could then parse the results for the customfield_NNNN for your Requirements field and the other field you are looking for. There could be multiple ways you would find the field in the results for your issue such as:

      {
        "id": "customfield_10027",
        "key": "customfield_10027",
        "name": "Requirements",
        "untranslatedName": "Requirements",
        "custom": true,
        "orderable": true,
        "navigable": true,
        "searchable": true,
        "clauseNames": [
          "cf[10027]",
          "Requirements",
          "Requirements[Paragraph]"
        ],
        "schema": {
          "type": "string",
          "custom": "com.atlassian.jira.plugin.system.customfieldtypes:textarea",
          "customId": 10027
        }
      },

or it could be a simple url such as

 "customfield_10072": null,  

or possibly some other type. So anything would else be speculation at this point without some sample results from you to investigate further.

I haven't tried it yet, but it looks like there is a set of helper classes and extension methods for 2d spans and memory.

Microsoft.Toolkit.Highperformance.ArrayExtensions.AsSpan

This has been fixed in PDFBOX-5908 and will be in PDFBox 3.0.4. A snapshot build is available here, please test it just to be sure. Thank you for reporting this.

You can use Python’s dataclasses module alongside libraries like pydantic or dataclasses-json to map JSON to nested Python classes automatically.

class ValidList(BaseModel): data: List[List[str]]

@validator('data', each_item=True)
def check_sublist_length(cls, sublist):
    if len(sublist) < 2:
        raise ValueError(f"Sublist {sublist} must have at least 2 elements.")
    return sublist

Optional is usually not recommended for ConfigurationProperties. This is a known behaviour which spring-boot marked as 'not a bug, but a feature'.

Source : https://github.com/spring-projects/spring-boot/issues/21868

Checkout these comments specifically :

• https://github.com/spring-projects/spring-boot/issues/21795#issuecomment-642148739
• https://github.com/spring-projects/spring-boot/issues/27141#issuecomment-874990493

f(x,y)=6xy

f'x=6y

f'y=6x

f'x'x=0

f'x'y=6

f'y'x=6

f'y'y=0

I had recently encounter with the same error in my old project after researching i got the Solution and Created blog on this to solve error

For anyone coming here late, slight correction/clarification to @cb-bailey's answer: A file in the index, which is equivalent to "staging area", is considered tracked locally. If a file has been added to the index using git add, i.e. it is marked as tracked, and you do not commit it but use git rm --cached, then it is not a no-op, since it will still remove the file from the index, so that the file ends up being untracked again. The file still exists in your working tree and can be re-added.

On the other hand, git reset is used to, well, reset a file or directory to the current branch's HEAD or a specified commit in your index, while a dedicated mode argument defines what effect will take place on your local working tree.

Some times we need to check if the PVC is full , since pods are not starting for porblme determination :( can not use df

There is an article on this in case someone across it now. medium link

This answer is years late, but you may wish to explore pagedtable.js which is a javascript table library allowing paging of both rows and columns. It's the same implementation that is used for the inline paged dataframe display in rmarkdown.

I do not believe it has the ability to "freeze" the first column like you are asking but it's pretty close.

Take a look at Transactional Outbox pattern from AWS Prescriptive Guidance https://docs.aws.amazon.com/prescriptive-guidance/latest/cloud-design-patterns/transactional-outbox.html

To guarantee that the delivery order of messages to Amazon SQS (or Kinesis) matches the actual order of database modifications, you can implement the Outbox Pattern. We considered this for one of our projects and thought this was an overkill, but this seems to solve the order issue

Response to TikTok Shop API Messaging Inquiry Hello,

As of my last update, the TikTok Shop API does provide some capabilities for messaging, particularly through webhooks that allow sellers to receive and send messages from buyers. However, the explicit support for messaging between sellers and creators is not clearly defined in the API documentation.

Here are some key points to consider:

Buyer to Seller Messaging:

The API supports webhook notifications for new messages from buyers. This allows sellers to automate responses and manage inquiries effectively. Seller to Creator Messaging:

While there is functionality for targeting collaborations and reaching out to creators, direct messaging capabilities specifically for seller-creator interactions may not be explicitly supported. It is advisable to check the latest version of the TikTok Shop API documentation, as features can evolve. Webhooks:

You mentioned webhook support, which is a good start for automating buyer interactions. If there are updates or changes regarding creator messaging, they may be announced through the API changelogs or updates. Recommendations:

I recommend reaching out to TikTok's developer support or checking their community forums for the most current information regarding messaging capabilities. Engaging with other developers who have experience with the TikTok Shop API may also provide insights into any undocumented features. If you have further questions or need assistance with specific API calls, feel free to ask!

Best regards.

These annotations are only limited for connections and transmission rates, to set the size of the shared memory zone it must be configured through ConfigMap by changing the zone size directly zone=name:size make sure to use unit-m(megabyte). Please see sample configmap below:

Additionally, based on this blog the limit_req_zone directive sets the parameters for rate limiting and the shared memory zone, but it does not actually limit the request rate.

Using Xcode (e.g. version 16.1) and Gimp:

• If no (default) asset catalog exists in the iOS project, create one with Xcode: File -> New -> File from Template... -> (Resource) Asset Catalog -> Next -> (Save as: Assets.xcassets) Create

• Create a graphics file, e.g. AppIcon.png of (NB!) 1024 x 1024 pixels. Starting e.g. from an .svg file, open it in Gimp with the required dimensions, then export it as a .png. (A Google Playstore 512 x 512 .png file will not be accepted.)

• In Xcode, select Assets.xassets (maybe the one created in the first step) in the Project Navigator. Then select AppIcon in the tab on the right, and double click on the block labelled 'Any Appearance'. Use the file picker that appears, to find and accept the file AppIcon.png created in the second step.

• Launch the app from Xcode on a simulator or device with the 'Start the active scheme' arrow button. Wait for the debugger to attach to the target (done when the message at the top right says 'Running [app] on [target]'), then stop the app with the block button to the left of the arrow button.

Check on the simulator or device to ensure that the default iOS app icon has been replaced with the one created in the second step.

binding.scrollView.post { 
    binding.scrollView.smoothScrollTo(0, 0) 
}

Browsers make some scss by their "own", so probably Chrome behaves different because it limits the height of your div, I made a quit view on the menu popover, and could change a bit Change1 Change2

you can put a min-width and max-height for the ul or divs that have the items, to make sure they have enough space, also could do some no overlap of the elements Example here

A great way to understand better flexbox is in this Web Flexbox Tricks Be carefull with the lists inside the lists (ul inside li and another ul)

Hope this helps

Can you show your full code? Are you saying you want the bottom navbar to exist with the tab bar to control the pages of the same screen?

I'm facing the same error for two days. Does anyone have a solution??

import pandas as pd

month_list = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"] months = { 'Jan': 0, 'Feb': 1, 'Mar': 2, 'Apr': 3, 'May': 4, 'Jun': 5, 'Jul': 6, 'Aug': 7, 'Sep': 8, 'Oct': 9, 'Nov': 10, 'Dec': 11, } data = [['Sep', '2024', 112], ['Dec', '2022', 79], ['Apr', '2023', 114], ['Aug', '2024', 194], ['May', '2022', 140], ['Jan', '2023', 222]]

sorted_data = sorted(data, key=lambda x: (int(x[1]), months[x[0]]))

print(sorted_data)

The code sorts the data list first by year (ascending) and then by the month's order using the months dictionary.

I did a research and JEvents has a plugin called User Specific events, available as an option to silver members (paid subscription). I'm seriously thinking to use it because free JEvents is such a powerful tool, but I need something individual for each user.

Check it out: https://www.jevents.net/join-club-jevents?view=article&id=304

Could you please try following command and see if it is connecting or not?

mysql -h your_remote_host -u your_user -p

telnet your_remote_host 3306

Above command will help you to verify the connection from your machine.

Could you please paste error as well? that will help with getting more details on issue.

anyway to make permanent even for new created users? tried to use and customize the NTUSER.DAT but without luck

I am attempting to add ATtiny in the boards manager. I've tried adding both:

https://github.com/SpenceKonde/ATTinyCore.git

https://drazzy.com/package_drazzy.com_index.json

to the additional boards manager in settings, but then when I go to search for them in boards manager nothing shows up. Do I need to wait until I have the Atiny phyiscally plugged in? Or are these just out of date? I'm using IDE 2.2.1. Thanks!

EDIT: It worked! I followed this tutorial: https://www.instructables.com/How-to-Program-an-Attiny85-From-an-Arduino-Uno/\

Same Problem. I have a simple function in a module:
NumberOfFoldersInDir($pathToDir, $_isRecursive)

This module is used by a class within another module. I return a value, depending on the optional bool param _isRecursive: if($_isRecursive) { return (1) }; else { return (2) }

1) (Get-ChildItem -Path $pathToDir -Directory -Recurse).Count
2) (Get-ChildItem -Path $path -Directory).Count

In the module, when I save to a variable and write-host, values are:
1) == 2
2) == 1

In my class, in the other module:
1) $returnVal = NumberOfFoldersInDir $path $true == 2 Checks Out.
2) $returnValue = NumberOfFoldersInDir $path $false == 3 WTF?

The code provided here -

const instance = axios.create({
    baseURL: process.env.URL,
    headers : {
        'Authorization': `Bearer ${token}`
    }
})

will run only once You need to use interceptors to retrieve and pass the token for each network request. Reference: https://axios-http.com/docs/interceptors

I’m facing the same issue and currently working on fixing it. If you have any suggestions or solutions, I'd greatly appreciate it if you could share them with me. Thank you!

Strict Mode Docs: https://react.dev/reference/react/StrictMode

import { createRoot } from "react-dom/client";
import App from "./App.tsx";
import "./index.css";

// Remove strict mode
// With strict mode, the 1st time the useEffect is called,
// it will be called a 2nd time

// createRoot(document.getElementById('root')!).render(
//   <StrictMode>
//     <App />
//   </StrictMode>,
// )

createRoot(document.getElementById("root")!).render(<App />);

Open CMD as administrator Run: assoc .js=NodeJSFile ftype NodeJSFile="C:\Program Files\nodejs\node.exe" "%1" %*

and verify file association by assoc.js it should show that .js file is associated to node.js

This worked, although the url in the browser returns a 404.

bazel build //example:hello-world --registry=http://my.gitlab/my_group/bazel-central-registry/raw/dev

Scanner sc=new Scanner(System.in); As,Scanner class-It belong to java.util package where it is used for user input. sc=new Scanner(System.in)-It is an object creation statement.As,it is used to create an new object in the scanner class where the variable named is sc. (System.in)-As, it an standard input stream,means keyborad when the program is executing. Hope it will be helpful for you.

When you attempt to read from the pipe within a PySpark UDF, you encounter the [Errno 9] Bad file descriptor error. This occurs because the file descriptor created using os.pipe() in the main Python process is not accessible within the UDF.

Spark executors are separate processes on worker nodes. When you create a UDF, the Python code is executed within a new Python process spawned by the Spark executor. File descriptors are not inherited by child processes. This means the file descriptor created in the main process does not exist in the UDF's process.

I did it this way: /Command

yarn create expo-app client --template blank

Remembering that I put client because that's the name I always use, but you can call it whatever you want, just change the name.

Is this still an issue? I tried every example from above and nothing works, to set fullscreen to a different size than desktop.

Tried 1280x800, desktop is 1920x1080.

Best result is auto, where everything is in correct ratio but at 1920x1080. In fullscreen True the ratio is weird, seems like 1920x800.

The issue is the bot blocking that they have employed.

• The first clue is the "<!-" which is HTML code.
• I have then printed out the output of the morphine_mol variable, and it indeed indicates that the issue is due to some kind of blocking they have.

See this text:

    <h2 data-translate="blocked_resolve_headline">What can I do to resolve this?</h2>
        <p data-translate="blocked_resolve_detail">You can email the site owner to let them know you were blocked. Please include what you were doing when this page came up and the Cloudflare Ray ID found at the bottom of this page.</p>

This isn't my field of expertise, but for other tasks similar to this, I have used the API instead.

This seems to be their API information: https://docs.drugbank.com/v1/

API signup looks like it should be here. https://dev.drugbank.com/clients/sign_in

Alternatively, if you don't need access in that way - you could save down the file to local, and load it from there.

What I think you are looking for is something like this: DefaultValue To set the default value of the ENUM. Hope this helps

For my case, the reason is the sbt.version in project build.properties file is too old; after updated to the latest one, it works.

You can manage the state in React JS by using the React's state management features or integrating with a state management library: React's state management features: Use the useState and useEffect hooks to manage the local state within a page. State management libraries: Integrate with a state management library like: Avoid using a global store. Since App Router can handle multiple requests simultaneously, using a global store could lead to data being handled from two different requests simultaneously.

if (tea < 5 || candy < 5)
    return 0;
  if ((tea >= 2 * candy) || (candy >= 2 * tea))
    return 2;
  else
    return 1;

I'm facing the same issue and as a workaround am adding include_directories(${<lib>_INCLUDE_DIRS}) as each target exports this variable . It does the trick but I do not understand the root cause so would be interested to follow this thread

Why don't you validate the params inside? like:

@ResponseStatus(HttpStatus.OK)
@GetMapping()
public void foo(@RequestParam(value = "someValue1", required = false) String someValue1, 
                @RequestParam(value = "someValue2", required = false) final String someValue2) {
    // Do validation here
    if (someValue1 == null && someValue2 == null) {
        throw new BadRequestException("someValue1 or someValue2 has to be present");
    }
    
    if (someValue1 != null) {
        // use someValue1
    }
    
    if (someValue2 != null) {
        // use someValue2
    }
    
}

Spring doesn't have an build in feature for that case, at least i don't know it

Harvard CS50 Half Program: float half(float bill, float tax, float tip) function cap

I know this is an old topic... IF I want to restrict to accounts only in my B2C directory only (single tenant), how do I configure MSAL to support this?

I don't want to support/allow other directories or social logins.

I came across this post among others 2 years ago, while searching for the same thing.

This is now supported by AWS (UDP over IPv6 on NLBs) and was mentioned in this release - https://aws.amazon.com/about-aws/whats-new/2024/10/aws-udp-privatelink-dual-stack-network-load-balancers/

I was really excited as we've been waiting for this for 2 years but unfortunately, it requires SNAT and alters the client source IP - which might be ok for others, but is useless for us.

I hope that AWS can expand on this and have the ability to preserve the client IP, then it's an option. Shame this wasn't part of the solution since many other LBs have this functionality.

For my concrete problem, I could solve the issue by "just switching" to esbuild:

-      "executor": "@angular-devkit/build-angular:browser",
+      "executor": "@nx/angular:browser-esbuild",

While I don't understand the underlying issue completely, I am fine with "the fix".

Será tarde para opinar? ya pasaron casi 10 años de está pregunta, acabo de tener precisamente esté problema y se resuelve teniendo la conexión abierta, fácil como un bucle, pero hay que precisar que esto sería para ser usado más como un socket que como una petición al servidor:

@WebServlet("/events")
public class SSEServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        System.out.println("1");
        resp.setContentType("text/event-stream");
        resp.setCharacterEncoding("UTF-8");
        resp.setHeader("Cache-Control", "no-store");
        resp.setHeader("Connection", "keep-alive");
        resp.setStatus(HttpServletResponse.SC_OK);
    
        while(true) {
            PrintWriter writer = resp.getWriter();
            writer.write("data: Evento disparado desde SSE\n\n");
            writer.checkError();
            writer.flush();
            try {
                Thread.sleep(2000);
            } catch (InterruptedException ex) {
                Logger.getLogger(SSEServlet.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }
}

There's a Chrome extension on Github called "Liquify". It modifies the search at the top of the liquid file list to search inside the files. Unfortunately, it now has a bug whereby, although the search box still works fine, you can't see what you typed in! So I copy and paste into it now.

I have the same same question here, and there doesn't seem to be an answer online.

Note that in 2024 this methodology changed. The new format, currently very poorly documented, is as follows:

https://github.com/{org}/{repo}/graphs/contributors?from=1%2F1%2F2024&to=7%2F31%2F2024

Example:

https://github.com/apache/pinot/graphs/contributors?from=1%2F1%2F2024&to=7%2F31%2F2024

You can enable type checking in Colab in the menu Tools > Setting > Editor > (at the bottom) "Syntax and type checking". It then underlines errors in red and hovering them (or Alt+F8) displays the message.

As @jakevdp answered, this is an external tool: types are just annotation with usually no effect at runtime (except for code that actually inspects them).

The type checker in Colab seems not to be documented anywhere, but it's Pyright. In case anyone needs to change its configuration from a Colab notebook, that's possible with e.g.:

%%writefile pyproject.toml
[tool.pyright]
typeCheckingMode = "strict"

(run the cell to overwrite pyproject.toml and wait a bit or save the notebook for Pyright to be re-executed).

In my case I had the code compiled with scala 2.13, but my tests are based on maven-surefire-plugin which was still an older version using scala 2.12. Updating surefire plugin version to latest (in my case 4.9.2) worked as it seems to be built on scala 2.13.

CLOB doesn't support "collate binary_ci/_ai", so the most common solutions are the LOWER/UPPER technique or regexp family of functions, if you don't want/can't use Oracle TEXT functionalities.

Electron will be the answer. It is one of the imortant topic which is used here.

To anyone else suffering with this, this is a PDF containing all commands available for different ISO:

https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://e2e.ti.com/cfs-file/__key/communityserver-discussions-components-files/234/COMPROTCOL_2D00_ISO14443A_2B00_15693_2D00_V15.pdf&ved=2ahUKEwiGjry2_fyJAxXkSjABHUttFa8QFnoECBsQAQ&usg=AOvVaw35RktCbTzDJn_wCTE1v3OU

Previous response (@Isaac and @Slaweek) have some case of failure:

1. If tag/column value is null (in json) return a string value "null" (and not the SQL NULL value) it's not an error, but we are working in sql...
2. If json is an element of an array and is betwwen {...} last tag/column return value + "...}"
3. Same of previous point if json is in "[...]"
4. Tag with "partial name" corresponding are misunderstanding (for example if in your json have "fiscal_address": ... and below "address": ... and you are searching for "address" return the value of "fiscal_address" because contain "address")
5. Commas in value are interpreted as a separated tag (example "price": "1,456.00")

Point nr 5 is not easy to solve: if the tag value is a text where comma/quote are important part of it ? (off course we can count quotes "... but we need to look at escape chars too)

For fix other points i modify in this way:

create or alter FUNCTION [dbo].[JSON_VALUE]
(
    @JSON NVARCHAR(3000),           -- contain json data
    @tag NVARCHAR(3000)             -- contain tag/column that you want the value
)
RETURNS NVARCHAR(3000)

AS
BEGIN

DECLARE @value NVARCHAR(3000);
DECLARE @trimmedJSON NVARCHAR(3000);

DECLARE @start INT
        , @end INT
        , @endQuoted int;

set @start = PATINDEX('%"' + @tag + '":%',@JSON) + LEN(@tag) + 3;
SET @trimmedJSON = SUBSTRING(@JSON, @start, LEN(@JSON));
Set @end = CHARINDEX(',',@trimmedJSON);
if (@end = 0)
    set @end = LEN(@trimmedJSON);
set @value = SUBSTRING(@trimmedJSON, 0, @end);

-- if is present a double-quote then the comma is not the tag-separator
if (len(@value) - len(replace(@value,'"','')) = 1)
begin
    set @endQuoted = CHARINDEX(',',  substring(@trimmedJSON, @end +1, LEN(@trimmedJSON) - @end +1))
    set @value = SUBSTRING(@trimmedJSON, 0, @endQuoted+@end);
end

SET @value = replace(@value,'"','');
-- remove last char if is a ]
IF (RIGHT(RTRIM(@VALUE), 1) = ']')
    SET @value = LEFT(RTRIM(@VALUE), LEN(RTRIM(@VALUE)) -1);
-- remove last char if is a }
IF (RIGHT(RTRIM(@VALUE), 1) = '}')
    SET @value = LEFT(RTRIM(@VALUE), LEN(RTRIM(@VALUE)) -1);

-- if tag value = "null" then return sql NULL value
IF UPPER(TRIM(@value)) = 'NULL'
    SET @value = NULL;

RETURN @value
END

In Kotlin you can cast activity to AppCompatActivity using as

For example:

`activity as AppCompatActivity`

Do you have IdeaVim installed? Most likely yo just need to disable it.

Sorry to hijack here, but I have a very similar problem, in that I had a bunch of installations in my Mamp 5.2 and upgraded to Mamp 7.1. I didn't know that I had to export dbases like you describe and thought by just copying my htdocs file to the new Mamp App folder, it would be ok, (call me ignorant). So now, I have the new phpmyAdmin, sitting there empty, and I can't access my old installations.
Is there a 'safe' way of doing this? I'm a bit clueless when it comes to db handling, other than just creating a db and a new user.
Thanks in advance!!!

What you are explaining is the actual Screen Reader behavior. When an image has an alt value, the screen reader will read it. If you want the image to not be accesible by the screen reader here are your options:

1. Remove the value in the alt text.

<img src="..." alt="">

2. Add the property role with the value presentation.

<img src="..." role="presentation">

Notes to consider:

• if you require an alt value, go with the second option.
• use the second option for decorative images. Images without meaning to the user.
• if your image has a meaning or relation to the content around it, you require the alt value and by default the Screen Reader will access it.

As I wrote on https://github.com/pdfminer/pdfminer.six/issues/1056#issuecomment-2504352023

The handling of unmapped glyphs is a method on PDFLayoutAnalyzer which can be overriden in a subclass or patched at runtime. So you can do this in your code for instance:

from pdfminer.converter import PDFLayoutAnalyzer
PDFLayoutAnalyzer.handle_undefined_char = lambda *args: ""

How are we supposed to override the classes with custom styles if random numbers keep being added to every class? Am I missing something?

I'm working on a project running MUI 4 and I'm struggling to override the styles of some of the components.

Attached here is one component that I wish to override. In error state, the outline/border of the text field and the legend (the label that shrinks to the top left of the notched outline) is in default red color and I wish to override and change them to a different color.

https://i.sstatic.net/jyMcAIBF.png

Some guidance would be very much appreciated.

Did you figure out a solution at the end? I really need this.

• worked for me as well! at least the empty Entitlements.plist
• but a rerun with the reverted Entitlements.plist does not (give me the same error as before)
• may be because I do not know howto set provisioning to manual (using vscode build)

So, I found a workaround for this.

Please see: GitHub issue #26114 for the solution.

Found it and sharing for future like-minded:

label_replace(aws_certificatemanager_days_to_expiry_average, "name", "$1", "dimension_CertificateArn", "(.*)") + on(name) group_left(tag_Name) aws_certificatemanager_info

In my case, the origin of the problem was quite simple: I was running the command flutter gen-l10n outside the root folder of my Flutter project.

Nico mentioned this in the comment but let me add. Your curl command does not have the additional header X-Requested-With which is set to XMLHttpRequest.

curl --header "x-requested-with: XMLHttpRequest" "https://www.starbucks.com/bff/locations?lat=46.6540153&lng=-120.5300666&place=Selah%2C%20WA%2C%20USA"

This article elborates why this is required, but here is a nutshell. The X-Requested-With header is a custom HTTP header used to indicate that the request was made via JavaScript, typically through an AJAX call rather than a traditional browser request and its value is usually set to XMLHttpRequest. This is done for a multitude of reasons for ex., to detect legitimate AJAX calls and/or add an extra layer of security against certain types of attacks etc.

first of all many thanks for your answer. I followed all steps and changed all tables with a little script to the values you indicated. Anyway even if I change it manually in MySQL Workbench it shows utf8mb4_0900_ai_ci as Collation. is this correct?

But finally the result is still the same. It produces these strange binary blobs and running the restore script in order to import it in my local mysql server it gives this result:

ERROR at line 48: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected.

Do you have any other tipp to solve this?

Greetings

It is much easier to use a vagrant box, for example https://portal.cloud.hashicorp.com/vagrant/discover/gbailey/al2023 It is working fine.

Reposted to dba.stackexchange.com

Please close or delete.

Currently, Rasa officially supports Python 3.7 to 3.10. Python 3.11 is not yet fully supported.

First install python version between 3.7 and 3.10 , and then retry pip install rasa command

For additional details, please refer to this. RASA docs

Same problem here, I haven't found any solution either and looks like a very rare problem

I think it’s worth restating what LCP is: this Web Vital measures the largest element rendered on the screen before user interaction. Given that you are running the Lighthouse test, it reports the largest component of the viewport—which happens to be the H1 tag. However, it may not be a problem with the element itself but rather with the preceding application loading steps.

To better understand the flow, I would suggest measuring (and sharing here) TTFB and Element Render Delay. Resource load delay and duration should be zero since it’s a text element.

I would expect that Element Render Delay will be bigger than TTFB; thus, to optimize LCP, you would need to focus on that.

The best way to improve it would be to debug which steps are happening before the H1 element shows up. Those might include:

•   Loading application code
•   Fetching data through API

If that’s the case, consider:

•   Splitting application code into chunks, loading the part that’s needed to render the initial UI first
•   Using pagination or decreasing server latency to speed up data load

Please share the performance report from the developer tools; we might be able to provide more specific recommendations.

Also, I would recommend reading this article: https://web.dev/blog/common-misconceptions-lcp

After a lot of struggle I found that in my case I was not swapping the drawing and rendering buffers at the end of rendering loop leading to GL_OUT_OF_MEMORY. So I think what might be happening is that renderer was continuously drawing to FrameBuffer which might be requesting memory every time we draw to it. Since, I was not swapping it so memory was not deleted and instead more memory was continuously accumulated...leading to GL_OUT_OF_MEMORY

Regression algorithms perform as a full-fledged model over well-defined relational data entities, but not much efficient for pulsating datasets. However, handling data with high irregularity is more complex, as its requirements are predominantly unavoidable. In this paper, a novel algorithm is proposed to estimate continuous outcomes for non-uniform or pulsating data using fluctuation-based calculations. The proposed unique approach for dealing with irregular data will address a key application of regression techniques.

TLDR: Please install VS Code extension Even Betterer TOML (Release Fork) and deactivate the "Even Better TOML" extension.

Longer Answer:

"Even Better TOML" isn't updated since 2023-07-15, because an CI token is expired and the only maintainer with access is not available anymore: see discussion on GitHub.

Therefore, a release fork was created and published as Even Betterer TOML (Release Fork).

In each release of the extension, all schemas from the JSON schema store are included. The schema store has support now for PEP 621 compliant pyproject.toml files for a while now. In the lastest update of the VS Code extension, the newest schema is included and the error message will disappear.

@noassl was correct with their comment. The real issue I was running into was with my incorrect assignment of the token. The authorization token was initially assigned undefined but I am not sure why I was unable to change it. I am assuming this has something to do with the way Axios instances function. To correct this issue, I moved the assignment of the instance inside the login function.

const fastify = require('fastify')({ logger: true });
const axios = require('axios');
const fs = require('fs');
require('dotenv').config();

const username = process.env.USERNAME
const password = process.env.PASSWORD
let token
let instance

async function login() {
    const response = await axios.post('/login', {username, password})
    token = response.data['token'];
    instance = axios.create({
        baseURL: process.env.URL,
        headers : {
            'Authorization': `Bearer ${token}`
        }
    })
    console.log(token);
}

async function me() {
    const response = await instance.get('/me')
    console.log(response.data);
}

login().then(me())

I have migrated to coil3 and it has stopped working, does anyone know?

Same here. Llama 3.1 8b modelfile not works.

Latest Updated command for main, not master:

1. Create a repo on GitHub
2. git init
3. git add .
4. git commit -m "Initial commit"
5. git branch -M main
6. git push -u origin main

These commands work properly for me on Windows to add existing projects on GitHub.

It looks like consistently moving the include of Pybind11 headers before QT Headers has fixed it.

However, this also goes for the full include tree. So if A includes B, and B includes Pybind, A should include B before including any QT Headers (QObject, QProcess, QVector, etc)

I just ran into this issue today.

One existing answer from Himanshu says his file name was not matching the expected value.

For me - the expected tab name within the Excel spreadsheet didn't match the expected tab name. A user accidentally fat-fingered in a space at the end of the tab name so the original error was thrown (Opening a rowset for "Sheet1$" failed. Check that the object exists in the database)

TL;DR - Check to make sure your tab names don't have typos or leading/trailing spaces!

Clear Cache works for me

Clear at the search area on ADS.

I've managed to sort this out.

Fortunately this occurred on a branch so I was able to create a new branch from the affected one at the point just before the mistake occurred. I could then inform people to switch to this one.

(The affected branch I've renamed with '_DoNotUse' suffix too.)

Doing this means that the file history of the affected files is no longer broken simply because this wasn't the case at the point that this new branch was made.

I've discovered that this is the default pose for a humanoid Rig in Unity. In other words, this does not appear to be a result of my setup.

I changed everything over to Generic in the model settings for the Rig and it retained the T-Pose.

you should give the value within the double quotes after the equal to. terraform plan -var-file="env-vars/dev.tfvars"

I have this problem. And it actually, didn't start until I updated to the most recent version of Slider Revolution 6.

Hey what was the final solve here. I have the same use case as yours

`const res = words.find((alpha) => alpha == words)`

// how i solve