Regarding a previous chat about escaping colons

:

in a queryExecute method: What I thought was working was true, which happened to be when I was escaping column names that had

:

in them, but then when attempting to escape

:

the same way in the VALUES of an INSERT INTO statement, it seemed to escape them, but never converted a

::

back to

:

. Thinking my code was faulty somewhere (still could be, but I don't honestly think it is), I spent quite a bit of time trying to figure out how to make it work, but wound up with an alternative by adding an update statement at the end to replace

::

with

:

. Escaping single quotes work in VALUES properly, however.