Solved

how to handle empty string like coliumns=" " i want to insert mysqldb incolumn int type empty string means as Null but it shows error .

  • 28 March 2023
  • 1 reply
  • 31 views
deepikamani007
Rank

below is my error 

 I want to write these type columns (columns=””)to NULL IN mysqldb

 

icon

Best answer by Bikram 28 March 2023, 19:17

View original

1 reply

Bikram
Rank
Userlevel 5
Badge +1

@deepikamani007 

 

can you please try to use the below code in expression evaluator and check if it works for you.

 

${str:isNullOrEmpty(record:value("/emailid"))?NULL:record:value("/emailid")}

 

 

 

Thanks & Regards

Bikram_

 

Reply


Terms & Conditions