The branch, master has been updated via 74a61f61da8de73853c17a5f198d63c3d675d046 (commit) from b9a6342a17c73db5842978d79f65f4ebaa3ec77f (commit)
- Log ----------------------------------------------------------------- commit 74a61f61da8de73853c17a5f198d63c3d675d046 Author: Madhura Jayaratne madhura.cj@gmail.com Date: Sun Mar 6 02:30:34 2011 +0530
Surround DB name and field names with quotes to distinguish them from SQL key words.
-----------------------------------------------------------------------
Summary of changes: js/sql.js | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/js/sql.js b/js/sql.js index 32a9faa..49380b0 100644 --- a/js/sql.js +++ b/js/sql.js @@ -772,7 +772,7 @@ $(document).ready(function() { /** * @var sql_query String containing the SQL query to update this row */ - var sql_query = 'UPDATE ' + window.parent.table + ' SET '; + var sql_query = 'UPDATE `' + window.parent.table + '` SET ';
$input_siblings.each(function() { /** @lends jQuery */ @@ -801,7 +801,7 @@ $(document).ready(function() { var value;
if (is_null) { - sql_query += ' ' + field_name + "=NULL , "; + sql_query += ' `' + field_name + "`=NULL , "; } else { if($this_field.is(":not(.relation, .enum, .set)")) { this_field_params[field_name] = $this_field.find('textarea').val(); @@ -830,7 +830,7 @@ $(document).ready(function() { $.extend(relation_fields, this_field_params); } } - sql_query += ' ' + field_name + "='" + this_field_params[field_name].replace(/'/g, "''") + "' , "; + sql_query += ' `' + field_name + "`='" + this_field_params[field_name].replace(/'/g, "''") + "' , "; } })
hooks/post-receive