Questions tagged as 'null'

2
answers

Result of a NULL query

Sorry I have been trying to make umeo next select: $sql =mysqli_query ($mysqli, "SELECT hour_out FROM registro_lista WHERE num_c="316115377"); I know from phpMyAdmin that the field I'm looking at is NULL But I want to finalize it in an I...
asked by 17.07.2018 / 05:10
1
answer

Change null values to '0' in a SQL pivot

I have something more or less like that select * from( selcect ...)as pt pivot( asc(valor) for desc in ( [Deporte y cultura],[Despensa],[Destajo - sueldo], [Destajos], etc ...) ) as pvt So far so good, but I get many results as null from...
asked by 19.09.2018 / 18:59
2
answers

Problems referencing an Object

I am calling a class that I have already used, I have instantiated it and in my Login fragment if it runs normally but in my Client_Visit fragment I get an error: E/AndroidRuntime: FATAL EXCEPTION: main Process: sie.progrsist...
asked by 04.08.2018 / 00:41
2
answers

Method that receives datetime nulleable, change format to MM / dd / yyyy

I have a question .. I have a method that receives several dates in datetime format (dd / mm / yyyy) Something like that public ActionResult Reports(DateTime? FechaInicio, DateTime? FechaFin, DateTime? IptSemana, DateTime? IptDia) At the...
asked by 10.08.2018 / 00:10
1
answer

Call to a member function random on null in Laravel 5.7

I am doing a test project for my learning of Laravel in its version 5.7 I am in the part of launching a seeder for, with everything configured in the factories, the models and the DatabaseSeeder, random data are created in the database to be...
asked by 25.09.2018 / 00:18
0
answers

SQLite with SQL View and IS NULL

I have two tables: **Tabla 1** Mensajes con los campos cod_mensaje, cod_usuario, texto **Tabla2** Accesos cod_mensaje, cod_usuario In the access table, I record every time a user reads a record from the messages table. I have created a...
asked by 18.11.2018 / 10:37
0
answers

rewriting Mysql fields or fields to null

I have a hosting in Godaddy of unlimited space with a MySQL database in MyISAM for my application. The bbdd has a weight of 280.4Mb and one of the tables contains 120713 records. For some time now some of these fields in this table are being...
asked by 14.09.2018 / 19:41