CoreBOSBB › Support › Administrator Support v
Pasting a Query in SQL report HTML encodes characters

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode
Pasting a Query in SQL report HTML encodes characters
Guido1982 Offline
Posting Freak
*****
Posts: 855
Threads: 238
Joined: Nov 2015
Reputation: 96
#1
02-01-2019, 09:00 AM (This post was last modified: 02-01-2019, 09:03 AM by Guido1982.)
When I create an SQL report and include a condition like:
PHP Code:
crment_so.createdtime > '2016-01-01 00:00:00' 
It gets saved to the database as
PHP Code:
crment_so.createdtime > '2016-01-01 00:00:00' 
Is this a bug or do I need to change a setting?


EDIT
Ironically, the character of course get decoded here so you will see a right arrow in both code examples and I don't know how to correct that, but trust me, it gets HTML encoded in the database.
Find
Reply
joebordes Offline
Administrator
*******
Posts: 3,565
Threads: 36
Joined: Apr 2014
Reputation: 49
#2
02-01-2019, 10:20 PM
see if this helps: https://github.com/tsolucio/corebos/comm...5d121c383f
Joe
TSolucio
Find
Reply
Guido1982 Offline
Posting Freak
*****
Posts: 855
Threads: 238
Joined: Nov 2015
Reputation: 96
#3
02-05-2019, 08:40 AM
(02-01-2019, 10:20 PM)joebordes Wrote: see if this helps: https://github.com/tsolucio/corebos/comm...5d121c383f

Did the trick, thanks!
Find
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)