Column named Function throwing error
Column named Function throwing error
mRender
Posts: 151Questions: 26Answers: 13
Field::inst( 'TestResults.Una' ),
Field::inst( 'TestResults.Function' ),
Field::inst( 'TestResults.Leak' ),
Field::inst( 'TestResults.d1' ),
So I have a column named Function, and it's throwing an error for datatables.
error : "SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'Function'."
Is there a way to cast this column as some other name or anything else? something like...
TestResults.Function AS TestResults.Funct or something that won't break anything?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
It sounds like there is a number whereby the text isn't being correctly escaped. Does this occur on data load, or create / edit? Either way, this will need an update to the libraries to address which I'll look at doing for 1.5.6.
Regards,
Allan
On data load. I've also noticed it does this one other word but I can't remember what word it is at the moment.