Morning all, does anyone know how to search for a blank space in a honeySql expression {:update :device :set0 {:qualified false} :where [:like :name '% %']}
does not seem to work
That should be a Clojure string @gary001: [:like :name "% %"]
With single quotes it will quote the first %
as (quote %)
producing a literal symbol, but the second one -- %'
-- is a valid Clojure symbol so it will try to look up %'
(and fail).
(by the way, when asking for help, "does not seem to work" is not very helpful/specific -- providing the actual error message or describing the unwanted behavior makes it easier for others to help you)
@seancorfield thanks for your help