LinkBack URL
About LinkBacks
See http://www.excelforum.com/showthread...=1#post4502117
I'm trying to post an updated VBA function - but Succuri prevents me from posting the VBA code inline (in CODE tags), saying that a SQL injection was detected...
See http://www.excelforum.com/showthread...=1#post4502117
I'm trying to post an updated VBA function - but Succuri prevents me from posting the VBA code inline (in CODE tags), saying that a SQL injection was detected...
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
It may be caused by the term "Replace". Securi sees this as a SQL term as it is in your code. TT really needs to figure out how to work around the SQL terms that appear in normal discourse.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
That seems weird, as it let me post code containing REPLACE earlier in the thread...
Block reason: SQL injection was detected and blocked.
@Olly
Hi Olly,
As Alan said it is the Replace, - it is one of three character strings I know about that sucuri does not like , - the third of which I only found last night after 2 hours of trying to paste a code in a Thread.
_...The actual string it does not like in your case isOriginally Posted by Olly
Replace(Replace
That is a problem both for normal text or in Code Tags.
Outside Code Tags I use the “Black space” Trick , as I just did here two lines up. In Code tags I just add a space – Then when an OP copies the code to a Code Window in the VB Editor, then the VB editor automatically adjust it and takes out the space
Alan
Please Login or Register to view this content.
_...
Edit P.s. – a few threads discussing the problem are listed in this Post
http://www.excelforum.com/showthread...41#post4412541
And fresh from last night: !
http://www.excelforum.com/showthread...t=#post4502342
__._______________________
@ Alan
Hi Alan
_... ?? TT Team ? I thought it was decided here we do not have one?..... TT really needs to figure out how to work around the SQL terms that appear in normal discourse.
http://www.excelforum.com/the-water-...-outage-2.html
_ - I thought we decided the Forum Software has been forgotten about , - lost somewhere deep down in server somewhere in a room in India... The ExcelForum is lost in a Management less Void
_.... Lol...
Alan
Last edited by Doc.AElstein; 10-15-2016 at 04:33 AM. Reason: Added links to other post of relavance
Thanks Alan.
yous welcome
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks