Tag: WebDev

There is probably a simple answer to this question but for the life of me I cannot find it. I have a table of records, each with a start and due date. I need to find all records which will include a certain date between the start and due date. For example, The date I need to find is 17/3/2026 (a bank holiday) Records: Start date: 1/1/2000 - due date 18/3/2026 - this would be returned Start date: 1/1/2000 - due date 18/3/2021 - this would NOT be returned etc any advice on a MSSQL query would be gratefully received. Thanks in advance

I have decided to implement code to generate tangent numbers as a self-imposed programming challenge. I have succeeded in doing so, but not as efficient as I want it to be. What are tangent numbers? Well they are the following series: 1 2 16 272 7936 353792 22368256 1903757312 209865342976 29088885112832 4951498053124096 1015423886506852352 246921480190207983616 70251601603943959887872 23119184187809597841473536 8713962757125169296170811392 3729407703720529571097509625856 1798651693450888780071750349094912 970982810785059112379399707952152576 583203324917310043943191641625494290432 It is A000182 on OEIS. I have implemented an infinite generator of tangent numbers using the following formula: a(n) = Sum_{k = 1..n-1} binomial(2 * n-2, 2 * k-1) * a(k) * a(n-k), with a(1) = 1, but I will not paste it here as it is quite long and not the fo

In Swift, iOS, I have a pdf file with 2 pages. I want to put the 2 side by side, on a new page. For this, I have to scale initial pages half size and rotate .pi/2. I managed to achieve this by converting pdf pages to UIImages and using a UIGraphicsImageRenderer. But with a critical loss of resolution. I've tried improving the resolution by creating images as jpegData(withCompressionQuality: 1.0), to no avail. So I would need to work directly on the pdf pages using CGPDFDocument format. The code structure is as follows, to insert a single scaled page: if let _page = theCGPdfDocument.page(at: 1) { var _pageRect: CGRect = _page.getBoxRect(CGPDFBox.mediaBox) writeContextInDestination!.beginPage(mediaBox: &_pageRect) // translate to compensate for the flip caused displacement writeContextInDestination!.translateBy(x: _pageRect.size.width, y: _pageRect.size.height) Scale (-1, -1) // rotate 180°

I've attached pictures to my worksheet using Office.js. After that's done, I want to place the pictures in the cells. This can be done in the Excel grid by right-clicking the image and then selecting Place in Cell. It can also be done with VBA using code like this: Option Explicit Sub placeWorksheetPictureInCell() Dim ws As Worksheet Set ws = ActiveSheet ws.Shapes.Range("picture_name").Select ws.Shapes("picture_name").PlacePictureInCell End Sub Is a similar API is available for Office.js? I also tried recording a macro to place the picture in the cell with Office Scripts and the macro recorder says that "This action currently can't be recorded."

When I try to start playwright in a docker container using X11 forwarding like this: docker run \ --rm \ -e "DISPLAY=:1.0" \ -e "XAUTHORITY=/tmp/.Xauthority" \ -v "/tmp/.X11-unix:/tmp/.X11-unix" \ -v "$XAUTHORITY:/tmp/.Xauthority" \ --add-host my-test-host=host-gateway \ -v "$(pwd):/work" -w /work \ -p 19323:9323 \ -u $(id -u) \ mcr.microsoft.com/playwright:v1.58.2-noble \ npx playwright test --ui It starts with a blank white window with only a title. Other commands: npx playwright wk - blank back window npx playwright ff - works npx playwright codegen - two blank white windows I think, the behaviour is dependent on the implementation, so the question is not really about playwright but for any UI-based X11 application: If i do the same thing using ssh -X (into the same container

I am experiencing a strange hydration behaviour in Vue 3 (Nuxt/SSR context). In my component, I have a reactive variable that initialises with a timestamp. On the initial client-side render, the standard mustache interpolation {{ processedHtml }} updates to the client-side time correctly, but the content inside v-html stays stuck on the server-side value. Both only "sync up" once a subsequent reactive change occurs (e.g., via a setTimeout). The Problem: Server Renders: Both values show Server Time (e.g., 12:00:00). Client Hydration: {{ processedHtml }} updates to Client Time (12:00:01), but v-html remains 12:00:00. After 2000ms: Both update to the new timestamp and are finally in sync. Minimal repr

During the NextCloud AIO installation process, I first install Docker, which works as verififed by hello_world, but after running step 3, I get the following error: docker: Error response from daemon: failed to set up container networking: driver failed programming external connectivity on endpoint nextcloud-aio-mastercontainer (efb1272996b34c713eae46dfacd28bf1313b7852b46a0eae8991a61f106c6dec): failed to bind host port 0.0.0.0:80/tcp: address already in use [sudo docker ps -a] results in (none for port): CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES e7f52142a028 ghcr.io/nextcloud-releases/all-in-one:latest "/start.sh" 6 minutes ago Created nextcloud-aio-mastercontainer f0f6e8490cb1 hello-world "/hello" 7 minutes ago Exited (0) 7 minutes ago vibrant_m

I am trying to sort the set size from highest to lowest but that seems to not work. I tried custom sets but that doesn't work either. Here is my code: UpSetR::upset( modality_matrix_upset, nsets = 7, sets = c("AB (10000)","ND (9000)", "US (8000)","CA (7500)", "RF (7000)", "XA (6500)","NM (5000)"), #number.angles = 30, order.by = "freq", #decreasing = TRUE, keep.order = TRUE, mainbar.y.label = "Number of school", sets.x.label = "Number of participant schools", ) Example data: set.seed(123) # create example dataset modality_matrix_upset <- data.frame( "AB (10000)" = sample(0:1, 200, replace = TRUE), "ND (9000)" = sample(0:1, 200, replace = TRUE), "US (8000)" = sample(0:1, 200, replace = TRUE),

I am developing a python package for reusable complex task automation against a software's python interface. To develop a clean interface, I want to develop in a distinct environment. I have tried anaconda, venv and virtualenv and all, when a new environment is created, do not copy the DLLs of the base installation into the environment's folder. Moreover, I found no way to force them to do so. The software I am developing against requires these DLLs for the python interface to work. The solution that I currently implement, revolves around a simple command line tool, that instead of creating an environment unzips an embeddable python distribution of a specific version in a certain directory, creates an environment and activates it. This is an issue, I really didn't see coming at all. Has anybody had a similar problem or knows what the best pratice in this case is? Thanks a lot

What I mean is that my website is based in my country. Since my website is related to foreigners, I want to know how to track whether the users of my website are foreigners or local users. I have tried several variables such as IP, browser language, ISP provider, and time zone. I know that these are not enough to determine whether the users of my website in my country are local or foreign. Does anyone know how to do this, or perhaps have suggestions for additional variables to make the accuracy a little closer to perfect?