On 3 Jul 2018, at 4:22pm, Stephen Chrzanowski <pontia...@gmail.com> wrote:

> V1: *datetime(date(current_timestamp,'localtime'),'+'||:StartTime||'
> hours')))/60) MinutesSince9*
> V2: *datetime(date(current_timestamp,'localtime'),'+:StartTime
> hours')))/60) MinutesSince9 *
> I'm getting a failure with V2, and I'm assuming that binding isn't
> understood when the bind is within a string.  If this assumption is
> correct, is V1 the correct and safe way to bind the values?

Yes and yes.

SQLite does not scan strings to look for binding tokens.  But it does consider 
a binding token anywhere it might find a column identifier.

sqlite-users mailing list

Reply via email to