sql

All things SQL and JDBC...
firstclassfunc 2020-10-30T15:39:15.192500Z

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

seancorfield 2020-10-30T16:10:28.193300Z

That should be a Clojure string @gary001: [:like :name "% %"]

seancorfield 2020-10-30T16:11:51.194400Z

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).

seancorfield 2020-10-30T16:12:37.195400Z

(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)

firstclassfunc 2020-10-30T16:13:42.195800Z

@seancorfield thanks for your help