Loading...
 
Features / Usability

Features / Usability


Tiki doesn't like a 'Union' SQL statement

posts: 228 Ukraine

I seem to have found an 'edge' case.

While 'CodeMirror' (e.g. syntax highlighting) works exceptionally well (SQL, Python, HTML, CSS tested so far) it just doesn't like 'UNION' for some reason as I get a blank white page with a 'FORBIDDEN' message. So I hit the 'back' button and add something before and after the 'UNION' and then it seems to be ok, for example:

Copy to clipboard
SELECT * FROM riders WHERE total_trips < 500 -> UNION <- SELECT * FROM riders2 WHERE total_trips < 500;


I usually have the CODE in a DIV, which can sometimes can be in a FADE.
Oh, and all of this is typically in a FLUIDGRID... rolleyes biggrin

Small workaround, but otherwise, CodeMirror work great!

Mike

There are no comments at this time.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting