Serveur with NWNX4 1.04 crash when a select retreive a NULL

[yi]

Papillon,

NWNXServeur crash when I retreive a NULL string with the version 1.04 (with MySQL database)

request : a simple

[amphiprion]

Same bug here (field type independant - VARCHAR - INT- ....)

[yi]

more details

it crashs if the result of the request is NULL
it does not crahs if the result of the resquest is empty

I hope it helps
_________________
http://www.arkalym.com

[Papillon]

Fixed. Redownload the prototype4 archive to get the updated version.

I wonder what would be better: Should NWNX return "NULL" or "" (empty string) for NULL columns ? I think an empty string is more in line with how NWScript works and what users probably expect.
_________________
Papillon

[yi]

I vote "empty string"
_________________
http://www.arkalym.com

[amphiprion]

thanks papillon, and yes, it's better to return empty value for compliance and nwscript logic.

[Grinning Fool]

Agreed, empty string makes the most sense and would be consistent with prior versions (and compatible with existing scripts).