Home Download Buy Blog Forum Support

Bug Syntax Highlight in SQL

Bug Syntax Highlight in SQL

Postby BrodaNoel on Thu Aug 30, 2012 6:57 pm

Bug in the reserver word: "LIMIT" of MySQL
Image
BrodaNoel
 
Posts: 1
Joined: Thu Aug 30, 2012 6:53 pm

Re: Bug Syntax Highlight in SQL

Postby agibsonsw on Thu Aug 30, 2012 7:08 pm

I don't think it is a problem with the word LIMIT but the fact that you break up the SQL statement (string) on the previous line. It is no longer recognised as part of a SQL statement, and just considered as quoted text.

If you apply (int) to $y before creating the SQL then you can create the statement as one continuous string (with embedded variables). Alternatively, using sprintf() or prepared statements may also get around this niggle.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
agibsonsw
 
Posts: 901
Joined: Fri Jan 27, 2012 9:11 pm


Return to Technical Support

Who is online

Users browsing this forum: Exabot [Bot], Google [Bot] and 22 guests