How to convert "" to null?
我想大声告诉你
我想大声告诉你 2017-06-17 09:15:40
0
5
953

For example, a="", how to convert it into a=null, which is used to transfer values ​​​​through the interface. "" cannot be used, only null can be used, but the value of the option object without value obtained by using select is "", please tell me How to solve?

我想大声告诉你
我想大声告诉你

reply all(5)
刘奇
var a='';
//传之前
a=a||null;
阿神
a===""&&(a=null)
淡淡烟草味
var a="";
a=a===""?null:a;
某草草

a===""&&(a=null)

洪涛

Use select(CASE WHEN(a = '') THEN null ELSE a END) AS a from...This way, you can refer to the article http://blog.csdn.net/qq_16990...

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template