Questions tagged as 'null'

Tagged questions
1
answer

Compare NULL using CASE SQL

I have to retrieve 2 fields in this query (number of projects and the management that performs such a project). This query is going to be used to generate a report in JASPER and it does not display field with NULL value, so I want to for...
asked by 08.05.2017 / 16:14
2
answers

"Object reference not set to an instance of an object." error when displaying a null value in view

Within C # MVC5, I'm creating a user registration form with multiple fields. One of them is the (Gratified) Role field, which the user may or may not have. The following is the class User: public class Usuarios { public int Id { get; s...
asked by 19.02.2016 / 19:37
2
answers

Which is faster: NULL or NOT NULL (with an empty string)?

I have a table with NOT NULL fields and they end up empty. What is the difference between a NULL (allows null values) and NOT NULL with an empty string ( '' ) inside?     
asked by 28.06.2018 / 17:28
3
answers

How to convert 0 to null (Error inserting NULL into an INT field from a variable)

I'm editing this question to make it more didactic for other members, since there are only publications addressing this situation outside the community. I have a INT field with UNIQUE property that can have NULL value. The value th...
asked by 12.09.2017 / 19:14
1
answer

Doubt on Null Byte in Bcrypt PHP

Well, I learned that PHP's Bcrypt is vulnerable to Null Byte. What tests do I have to do to see this vulnerability, and what are the constipations of this?     
asked by 04.03.2018 / 06:29
2
answers

SQL - How to select or delete a column with a value of null in a query select

I have a table in a MySQL bd that has 5 fields. This would be a template query: select * from myTable where campo1= 4 and campo2=1 and campo3 =7. However, field3 may have null value and I would need to select or exclude combinations that in...
asked by 24.05.2016 / 21:52
2
answers

JavaScript Injection in Internet Explorer, returns null

I'm developing an application that performs automation in internet explorer, I'm using SHDocVw to do this. My problem is that I can not get the feedback from a JavaScript injection    public static void wJScript(string script) { try {...
asked by 10.07.2014 / 16:46
1
answer

Is the null character \ 0 automatically placed at the end of the string or does it not put because I set the scanf limit?

#include <stdio.h> #include <stdlib.h> int main(void) { char nome[20]; char sobrenome[20]; char nomeSobrenome[40]; printf("Insira seu nome e seu sobrenome:\n"); //scanf("%s%s", nome, sobrenome); scanf("%[A-Z...
asked by 03.09.2018 / 22:43
1
answer

How to handle Null fields in PostgreSQL [duplicate]

Hello, I need to know how best to use COALESCE to handle the null fields in my table. My problem is the following, I'm simulating 6 Stores and their respective cards, let's suppose that one or more stores did not sell product in the Amex card,...
asked by 07.02.2018 / 21:42
1
answer

getElementsByTagName returning zero [closed]

I'm using the following code to read a file .xml try { File fXmlFile = new File("C:\res\teste.xml"); // C:/.../teste.xml DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance(); DocumentBuil...
asked by 22.12.2016 / 18:50