DMXzone Database Connector PHP Support Product Page
Answered
Convert string to value in Query Builder
Asked 8 years ago
1
has this question
8 years ago 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"

Replies
Replied 8 years ago
8 years ago 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
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