null values

Suite and Optimus Suite 5
#1

Hello,

is it possible to replace the null values of some fields to " "? that is, hide the word “null” in the fields that actually are null in the database?

Regards,
Eduardo.

#2

Hello again,

it isn’t possible to hide the null values in a dhtmlxgrid??

#3

In case of connecto - if cell has NULL value, it must result in empty string during xml generation, the “NULL” value will appear only if you have “NULL” as a text string in the database.

In case of grid - you can use custom excells to format values as you wish

#4

Hi stanislav, thanks for the reply.

mmm I’m sure that i have null values in the database tables, not the word “null”.
The information showed in the grid is the result of joins between tables.

In any case, how can i replace the word null using custom excells in the dhtmlxgrid?

Thanks,
Eduardo.

#5

Are you using php or java connectors ?
Both can be configured to pre-format data before output

docs.dhtmlx.com/doku.php?id=dhtm … re_loading
docs.dhtmlx.com/doku.php?id=dhtm … re_loading

#6

Hello,

i’m using java as following:

GridConnector c = new GridConnector(conn, DBType.Oracle);
c.render_sql(" SELECT A.fields, B.fields FROM tableA A, table B B WHERE A.X = B.X", “ID”, “FIELDS…”);

As i saw in the link provided, i need to implement a new class file “renderbehavior” and change there the null values to “”…

Thanks,
Eduardo.

#7

Yep, in case of java connector the same can be done through behavior class.