I am a student, and I am doing a project for school. While I was working on it, I encountered a problem and discovered something weird. I needed to check if a something is null or a empty string, but…
I use a global variable: String? globalDeviceVersion; And I set the variable when I connect via bluetooth device and it works good. The issue is when I want to 'reset' the global value and I have tried: setState(() { globals.globalDeviceVersion…
I have a very big table with a column that has mostly null values. I query this table a lot with x_column is not null condition. I wonder how I should index it and what is the best way to…
I'm starting to learn sql in porstgresql. I have create a table with numeric(6,2) structure and trying to import data. But data has some row that has NULL value. Now I'm getting "ERROR: invalid input syntax for type numeric: NULL"…
I have this array of pairs in JS : var my_array = [['line_1','2'],['line_2','0'],['line_3','5'],['line_4',''],['line_5','4'],] var my_sorted_array =my_array.sort((a, b) => a[1] - b[1]) console.log(my_sorted_array) For now to sort it by second item I am using th code below But I would like…
I have an html form used to edit a record in a mysql table. In the case of editing, I prefill the form with the current values for the record as returned by the query, as below: <INPUT TYPE="text" NAME="SITENAME"…
Consider the following C# Code Fragment: public class Person { public int Id { get; set;} public string? Name { get; set;} public string? Description {get; set;} } List<Person>? _persons = new List<Person>(); // Something populates the _persons list; //Use…
I've been working on a hard-coded language switcher for my app, where I have a xib file, where when I tap on a cell, it changes the language of the app, however I have a label that has the text…
I know there are many variants of this question, but none seem to address my issue. I have a page reporting website order stats. One of the variables it considers is which 'website' a customer used. The website ids are…
I'm trying to create tables to store very large volume of data, and I wonder if I can use null TIMESTAMP to save storage? I have a variable update_at, which will be updated to NOW() whenever I modify the associated…