Query builder escaping periods when using TableName.Column |
Hey!
In my query, I'm using the "TableName.ColumnName" syntax to designate a specific column. Unfortunately, when using the query builder, the period in those parts is getting escaped, forming the following: "`TableName`.`ColumnName`" Which obviously throws a SQL Error. Is there a way to solve thisĀ other than turning off QueryBuilder's "automatic SQL Injection prevention" (Which is pretty much my top reason for using Query Builder. Otherwise I could just build the query string on my own.)? (The solution of turning off QueryBuilder's automatic escaping was posted on StackOverflow) Thank you very much! |
Messages In This Thread |
Query builder escaping periods when using TableName.Column - by Call-Me-Captain - 07-31-2016, 12:41 PM
RE: Query builder escaping periods when using TableName.Column - by InsiteFX - 07-31-2016, 05:38 PM
RE: Query builder escaping periods when using TableName.Column - by Narf - 07-31-2016, 11:44 PM
RE: Query builder escaping periods when using TableName.Column - by Call-Me-Captain - 08-03-2016, 10:37 AM
RE: Query builder escaping periods when using TableName.Column - by InsiteFX - 08-03-2016, 05:32 PM
|