SQLite.swift icon indicating copy to clipboard operation
SQLite.swift copied to clipboard

bind dictionary params will crash

Open MingleChang opened this issue 6 years ago • 1 comments

If I select use try! connect?.prepare("SELECT * FROM words WHERE category=:category AND language=:language ORDER BY RANDOM()", ["category":category, "language":language]) it will crash, like this 76F3D71E-D6A8-4F6F-9C7E-BD9CD5AF8CA7

But use try! connect?.prepare("SELECT * FROM words WHERE category=? AND language=? ORDER BY RANDOM()", [category, language]) it‘s OK

MingleChang avatar Jan 07 '20 05:01 MingleChang

@MingleChang Try to use $category instead of :category and tell me if it works.

nathanfallet avatar Aug 23 '21 17:08 nathanfallet