Questions tagged as 'datatable'

Tagged questions
1
answer

When using CONCAT, I get an error saying "The input string does not have the correct format"

It turns out that data charges to DataTable in the following way: private void cargarempresas() { dt_hogar = new DataTable(); String sql = "SELECT CAST(CONCAT(nombre,'-',apellido)AS CHAR) AS nombre,fechacreacion FROM hogar";...
asked by 24.07.2017 / 07:34
1
answer

Order of columns in JQuery DataTable

I have a doubt (maybe basic, I do not know) with the order of the columns of DataTable . The thing is that I need to disable the option " ordering " in the last 4 columns of my DataTable Is that possible? Beforehand, Greetings an...
asked by 10.10.2018 / 20:44
0
answers

DataTable filters by date

I'm trying to use filters by date. I have found several examples, but in one of them I am blocked because it puts the date and takes an example if I select 5 de mayo de 2018 begins to show me the data from 6. The other thing is that...
asked by 18.09.2018 / 17:02
1
answer

How to put an id to a tr from array?

How can I put the ids that come from the database to the tr from the controller since it is printed from there? //CONTROLADOR public function ajax_list() { $list = $this->Prorrateo_model->get_datatables();...
asked by 29.05.2018 / 17:13
0
answers

I need to export an NVARCHAR from JAVA in excel

I am using the sql server database in which I am using a cursor. I need to read this NVARCHAR from java so I can export it in excel from java. Take into consideration: that these columns of my Excel will be added more in the future. e...
asked by 09.03.2018 / 20:43
1
answer

Problem Anomaly Detection Twitter package, data frame with 0 columns and 0 rows

Good morning, everyone. I've been trying to use Twitter's anomaly detection package for the available R language here . My problem is that trying to emulate the examples of Twitter with a database in which I find myself working available here...
asked by 18.01.2018 / 22:47
0
answers

Custom Roweditor

Greetings. I have the following problem Given the following view: client.xhtml <p:fieldset> <p:fieldset legend="Informacion Personal del Cliente"> <h:panelGrid id="panelCliente"...
asked by 08.09.2017 / 07:00
2
answers

Interpret br / in a gridView cell

I have to separate by marks of \n the content of a cell of GridView to get different lines to appear in a cell. The code in which I find myself is the following: Modifying the DataTable : cmd = new OracleCommand();...
asked by 19.04.2017 / 17:13
1
answer

would like to filter a datatable but in reverse

I found these examples: link dt is a DataTable and it has data, but there are some data that are null, I would like to filter the rows that contain such null data. number is one of the columns. I would like to filter and keep all t...
asked by 22.06.2016 / 23:44
2
answers

export to excel with data table

Good, I have these links. <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css"/> <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.2.5/css/selec...
asked by 10.12.2018 / 21:16