Welcome Guest, Not a member yet? Register   Sign In
Query builder escaping periods when using TableName.Column
#1

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!
Reply


Messages In This Thread
Query builder escaping periods when using TableName.Column - by Call-Me-Captain - 07-31-2016, 12:41 PM



Theme © iAndrew 2016 - Forum software by © MyBB