Column named Function throwing error

Column named Function throwing error

mRendermRender 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

Answers

  • allanallan Posts: 61,918Questions: 1Answers: 10,151 Site admin
    Answer ✓

    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

  • mRendermRender Posts: 151Questions: 26Answers: 13

    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.

This discussion has been closed.