DMXzone Database Connector PHP Support Product Page

Answered

Convert string to value in Query Builder

Asked 22 Aug 2016 13:36:08
1
has this question
22 Aug 2016 13:36:08 David Woolley posted:
How would I convert a string to a value in Query Builder?
Form field inputs a string of digits with leading zeros e.g. 0135
So my query is filtered by this input field $_GET.searchCode
Value should be: Number({{$_GET.searchCode}}); or {{Number($_GET.searchCode);}}
Neither of these work though. I've tried without the semi-colons as well.
What javascript expression should be used for the Value ?

JS: Number("0135" ---> 135

Replies

Replied 28 Sep 2016 15:33:35
28 Sep 2016 15:33:35 Teodor Kuduschiev replied:
Hello David,
With the release of server data formatter you can use convert strings to numbers and vice versa inside the server connect: www.dmxzone.com/go/32653/meet-server-data-formatter-and-crypto

Reply to this topic