From 22d166fd4e98b67cac7103b48801fb95a0179f01 Mon Sep 17 00:00:00 2001 From: Adam Date: Mon, 17 Oct 2016 18:33:55 -0400 Subject: Address casemapping issues in sqlite/mysql --- modules/database/sql.cpp | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'modules/database') diff --git a/modules/database/sql.cpp b/modules/database/sql.cpp index aa1c94bc0..f88fc35d7 100644 --- a/modules/database/sql.cpp +++ b/modules/database/sql.cpp @@ -136,7 +136,8 @@ class DBSQL : public Module, public Pipe for (const Query &q : SQL->CreateIndex(prefix + type->GetName(), field->serialize_name)) Run(q); - Query query("SELECT `id` FROM `" + prefix + type->GetName() + "` WHERE `" + field->serialize_name + "` = @value@"); + Query query = SQL->SelectFind(prefix + type->GetName(), field->serialize_name); + query.SetValue("value", value); Result res = Run(query); if (res.Rows()) -- cgit