Tag: WebDev

SO professionals, Following query produces 2 rows: SELECT i.type_desc, i.is_padded, i.fill_factor, i.ignore_dup_key, stat.no_recompute FROM sys.schemas s, sys.indexes i, sys.tables t, sys.stats stat WHERE i.object_id = t.object_id AND t.schema_id = s.schema_id AND t.name = 'leagues' AND s.name = 'dbo' AND i.is_primary_key = 1 AND i.object_id = stat.object_id; But I'm interested only in the PK index, and so it should return just 1 row.. Thx.

When downloading dashboard reports as pdf from appache superset it is coming as a screenshot of the current page and misses alll data in table charts. Only few records show up in the report download in comparison with the actual report. Is there a way to download all data as pdf in superset reports??

I like to compose a JSON from some table data, I do it like this: DECLARE res JSON_OBJECT_T; ja JSON_ARRAY_T; ret CLOB; CURSOR cur IS SELECT JSON_OBJECT( KEY 'name' VALUE SERVICE_NAME, KEY 'customer' VALUE CUSTOMER ) AS Service FROM V_SERVICES; BEGIN res := JSON_OBJECT_T(); ja := NEW JSON_ARRAY_T; FOR aService IN cur LOOP ja.append(aService.Service); END LOOP; res.put('services', ja); DBMS_OUTPUT.PUT_LINE(ret.to_clob); END; Problem is, the data is a string, i.e. it prints { "services": [ "{\"name\":\"MIPVPN4321\",\"customer\":\"Bill\"}", "{\"name\":\"IDN1234\",\"customer\":\"Bob\"}" ] } But I want this: { "services": [ { &quo

I am currently trying to switch from TCanvas to TDirect2DCanvas for some drawing routines, as I wanted to speed things up a little bit. I did but stumble upon the missing TPenMode. I do not find a fitting setting to implement for example pmNot with TDirect2DCanvas. Is this really completely missing? Is there a workaround? Or would I have to switch back to TCanvas to use TPenModes? If so: How would this effect the beginDraw/EndDraw feature? Obviously some other function/property which has the same effect as TPenMode with pmNot (and the others) would to the trick too. If something like this exists I would appreciate a hint where to look for it.

I'm trying to update software on my Mac Studio. Here are hardware that I have: Chip: Apple M1 Max Memory: 32GB HDD: 500GB OS: macOS Sonoma 14.7.2 I need to update XCode to version 26.* In software prerequisites I have found info, that I need OS version > 15.6 So I run softwareupdate. In output of softwareupdate -l I have two options: Title: macOS Sonoma 14.8.4, Version: 14.8.4, Size: 1842424KiB, Recommended: YES, Action: restart Title: macOS Tahoe 26.3, Version: 26.3, Size: 10817535KiB, Recommended: YES, Action: restart Then I choose to update my OS to macOS Tahoe 26.3, so I run sudo softwareupdate -iR 'macOS Tahoe 26.3-25D125' --force --agree-to-license and get following exception in output: Software Update Tool Finding available software Downloading macOS Tahoe 26.3 Password: Downloaded: macOS Tahoe 26.3 Restarting... 2026-02-18 09:48:4

We have several existing ADM models in production that we'd like to enhance with Adaptive Gradient Boosting, but we want to minimize disruption and avoid manual reconfiguration work if possible. I have a few questions regarding the implementation of Adaptive Gradient Boosting in Pega ADM models: Model Update Process: Is it possible to update an existing ADM model to use Adaptive Gradient Boosting as the predictor selection method without having to recreate the entire model from scratch? If yes, what is the recommended approach/process to do this? Predictor Migration: When updating an existing model to use Adaptive Gradient Boosting, is there an automated way to migrate/transfer the existing predictors to the new configuration, or do I need to manually add them again through the prediction studio? Impact on Model History: If such an update is possible, what happens to the ex

I'm trying to set up a filter system with Unix timestamps, one for start date and one for end. However there is some overlap between the dates, e.g. if I select dates from February 1 - 28 it includes some data from January 31. Function: function getFuelData ($conn){ $sql = "SELECT * FROM fuel_log INNER JOIN flightlog ON flightlog.id = fuel_log.flight_id WHERE 1=1"; $params = []; $types = ""; if (!empty($_GET['date-start']) && !empty($_GET['date-end'])) { $timeStampFrom = strtotime($_GET['date-start']); $timeStampFrom += 86400; $timeStampTo = strtotime($_GET['date-end']); $timeStampTo += 86400*2; $sql .= " AND flightlog.time_stamp BETWEEN ? AND ?"; $params[] = $timeStampFrom; $params[] = $timeStampTo; $types .= "ss"; } $stmt = mysqli_prepare($conn, $sql); if (!$stmt) { die("SQL error"); } if

I am installing the OpenClaw on my WSL. But it keeps printing the same error messages about npm. I even tried after updating my npm, but it doesn't work. I also asked Gemini this question, her answer could not solve my questoin... I already installed git and other linux packages like g++ and some extras. Please help me.... 1

I am currently learning the basics of python and I am the beginning of my programming journey. I was doing a course and came across the following problem. I initially picked TypeError and ValueError but that was incorrect. From what I understand a SyntaxError occurs when you violate the programming language. For example if the coder forgets the close the parentheses, but how can a users input cause a SyntaxError. It’s not really clear to me because a user can’t change the code can they?

I have successfully implemented extraction for SharePoint content across multiple sources, including document libraries, web pages, and lists. The system is able to fetch list items along with all relevant columns such as ID, Title, metadata fields, custom columns, and associated content. I have also ensured that the data is processed, embedded, and stored correctly for retrieval within the chatbot environment. For most lists, the chatbot is able to answer queries accurately using any column value, including primary keys like Requirement ID or standard SharePoint IDs. However, I am facing a specific issue with one particular list. In this list, the “Dashboard ID” is not stored as a regular text or number column. Instead, it is configured as metadata and appears to be stored as a “Link Title” field. Because of this structure, the value is not being retrieved properly during the extraction process. Although the data is visible in SharePoint, the chatbot is unable to fet