Posting sql examples here denied

[Owdy]

I think its a little rediculous that you cant post sql querys in code box in here. Just my opinion. If i wanna show sql commands, i have to post screenshots.

[Square Wheels]

SELECT dbo.Employees.Last_Name, dbo.Employees.First_Name, dbo.Employees.ELocation
FROM          dbo.train_doc_emp LEFT OUTER JOIN
                        dbo.Employees ON dbo.train_doc_emp.train_doc_emp_emp_pk = dbo.Employees.Emp_pk
WHERE      (dbo.train_doc_emp.train_doc_emp_date IS NULL) AND (dbo.train_doc_emp.train_doc_emp_train_doc_pk = 118) AND 
                        (dbo.Employees.Active_Inactive = N'a')
GROUP BY dbo.Employees.ELocation, dbo.Employees.First_Name, dbo.Employees.Last_Name
ORDER BY dbo.Employees.ELocation

Worked for me?

[Nathan Explosion]

SELECT * FROM banana WHERE sausage = 'yum';

 

I think its a little rediculous that you cant post sql querys in code box in here. Just my opinion. If i wanna show sql commands, i have to post screenshots.

Is this an issue whereby you actually can't post them, or you can't see 'SQL' in the drop down code box?

[Owdy]

Weird, i got error message and support staff sayd its denied.

 If you're posting a SQL query or similar, please attach it as a text file or screenshot as the mitigation filter is assuming you're attempting SQL injection.

I try to post this http://pastebin.com/gbWR34mp

Get this error: 

[Nathan Explosion]

Yep, that's fair enough. I'd expect the same response if you used an INSERT query too.

[Square Wheels]

INSERT Happiness INTO Life_Table
WHERE Currnet_Mood = "blah"

UPDATE ipb_forums_posts SET post = REPLACE(post,'http://hoitajat.net/foorumi/public/style_emoticons/default/','http://hoitajat.net/public/style_emoticons/default/');

I must be doing it wrong.

[Owdy]

Yep, try put it to code box @Square Wheels

[Charles]

The firewall blocks some things it thinks might be dangerous.

[Owdy]

The firewall blocks some things it thinks might be dangerous.

Weird thing is, it blocks it if its in code box, not if i just paste it as plain text. Should be other way

[Ralf Herrmann]

Weird thing is, it blocks it if its in code box, not if i just paste it as plain text. 

That doesn’t make a difference in regards to security. 

[Owdy]

That doesn’t make a difference in regards to security. 

Yes, but that is how it behives now.

UPDATE ipb_forums_posts SET post = REPLACE(post,'http://hoitajat.net/foorumi/public/style_emoticons/default/','http://hoitajat.net/public/style_emoticons/default/');

 

 

If i put that in code box, it blocks it

[Nathan Explosion]

Ah now that is a silly behaviour