sitemule / noxDB

Not only XML. SQL,JSON and XML made easy for IBM i
MIT License
42 stars 20 forks source link

How to set null value in noxdb 2? #62

Closed m1h43l closed 2 years ago

m1h43l commented 2 years ago

I couldn't find a function which sets null as a value. How to generate the following JSON with noxDB 2:

{ "error" : null }
NielsLiisberg commented 2 years ago

look for :

json_setNull(pNode);

On Sun, Jan 9, 2022 at 3:46 PM m1h43l @.***> wrote:

I couldn't find a function which sets null as a value. How to generate the following JSON with noxDB 2:

{ "error" : null }

— Reply to this email directly, view it on GitHub https://github.com/sitemule/noxDB/issues/62, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAVIPHQT7H2ZQGA3S4SEDYDUVGNU5ANCNFSM5LR5YESA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

m1h43l commented 2 years ago

That would have also been my first guess. But there is no prototype for nox_setNull nor json_setNull and there is no exported function nox_setNull (in noxDB2.binder).

NielsLiisberg commented 2 years ago

I think you need to pull:

/// // Set node with null value // // Creates a node at the passed path with the value null. // Any existing node will be replaced by this new node. // // @param Node // @param Node path expression // @return New node /// Dcl-PR jx_setNull pointer extproc(CWIDEN : 'jx_SetNullByName'); node pointer value; nodePath pointer value options(*string); End-PR;

On Mon, Jan 10, 2022 at 2:28 PM m1h43l @.***> wrote:

That would have also be my first guess. But there is no prototype for nox_setNull nor json_setNull and there is no exported function nox_setNull (in noxDB2.binder).

— Reply to this email directly, view it on GitHub https://github.com/sitemule/noxDB/issues/62#issuecomment-1008874154, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAVIPHUIMBVABPYQKZNXMB3UVLNGZANCNFSM5LR5YESA . You are receiving this because you commented.Message ID: @.***>

m1h43l commented 2 years ago

But that is noxDB 1 ... I am searching for a setNull function on the utf8 branch.

NielsLiisberg commented 2 years ago

True; it's missing

On Tue, Jan 11, 2022 at 11:49 AM m1h43l @.***> wrote:

But that is noxDB 1 ... I am searching for a setNull function on the utf8 branch.

— Reply to this email directly, view it on GitHub https://github.com/sitemule/noxDB/issues/62#issuecomment-1009840039, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAVIPHR3DNIMLGDTCUI5PADUVQDJ7ANCNFSM5LR5YESA . You are receiving this because you commented.Message ID: @.***>

NielsLiisberg commented 2 years ago

Done!!