Posted by fritz on
URL: https://discuss.orbeon.com/need-help-with-query-sql-param-null-tp4658948.html

Hi all,
I'm trying to implement through database service a query were inside parameter is present the null  boolean switch.

insert into rooms-res
(id-res,date-res)
 values
(<sql:param type="xs:string" select="" null="normalize-space(.......) = ''"/>,
 <sql:param type="xs:dateTime" select="" null="normalize-space(.......) = ''"/>);

Instead of dots I've used @select, ./select, ../select, /id-res, /query/id-res and others
but I'm not able to get it working and there is no error in log.
Can someone help me with this?

I need null values for first field because of  key constraint and second for optional field ( there are other fields i've removed).


Fritz