Hi,
Suppose I have a table PERSONS like this:
ID | FIRST_NAME |
LAST_NAME | SECOND_LAST_NAME
--------------------------------------------------------
1
| Pedro | Martinez | Perez
2 | John | Smith
| NULL
It's an Oracle DB.
The column SECOND_LAST_NAME represents a second column for those people who
have more than one last name as used in many Spanish-speaking countries.
I'm trying to create a d2rq:pattern on a PropertyBridge that "joins" the
LAST_NAME and SECOND_LAST_NAME, i.e.:
"@@PERSONS.LAST_NAME@@ @@PERSONS.SECOND_LAST_NAME@@"
The property will be created correctly for the ID=1, "Martinez Perez", but
for those people who have a NULL value on the second_last_name it will fail
miserably.
I believe this is because the way Oracle handles the empty value as a NULL
value instead of an empty string.
Any workaround?
Regards,
Eduardo
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
