Click here to Skip to main content
15,899,124 members
Home / Discussions / Article Writing
   

Article Writing

 
AnswerRe: Article closed Pin
OriginalGriff14-Aug-19 1:54
mveOriginalGriff14-Aug-19 1:54 
AnswerRe: Article closed Pin
Nelek14-Aug-19 3:16
protectorNelek14-Aug-19 3:16 
GeneralRe: Article closed Pin
OriginalGriff14-Aug-19 4:44
mveOriginalGriff14-Aug-19 4:44 
GeneralRe: Article closed Pin
SimbirSoft14-Aug-19 11:26
SimbirSoft14-Aug-19 11:26 
GeneralRe: Article closed Pin
Nelek14-Aug-19 3:21
protectorNelek14-Aug-19 3:21 
GeneralRe: Article closed Pin
OriginalGriff14-Aug-19 4:10
mveOriginalGriff14-Aug-19 4:10 
GeneralRe: Article closed Pin
Nelek14-Aug-19 13:24
protectorNelek14-Aug-19 13:24 
GeneralRe: Article closed Pin
SimbirSoft14-Aug-19 11:27
SimbirSoft14-Aug-19 11:27 
AnswerRe: Article closed Pin
Nelek14-Aug-19 3:23
protectorNelek14-Aug-19 3:23 
GeneralRe: Article closed Pin
SimbirSoft14-Aug-19 11:29
SimbirSoft14-Aug-19 11:29 
QuestionBlog (changed to article) needing help Pin
Nelek6-Aug-19 0:25
protectorNelek6-Aug-19 0:25 
QuestionHelp to decoding Pin
Ktp. Zbig28-Jul-19 11:00
Ktp. Zbig28-Jul-19 11:00 
AnswerRe: Help to decoding Pin
Richard MacCutchan28-Jul-19 21:20
mveRichard MacCutchan28-Jul-19 21:20 
QuestionWeird Pin
Nelek28-Jul-19 6:32
protectorNelek28-Jul-19 6:32 
AnswerRe: Weird Pin
Wendelius28-Jul-19 20:29
mentorWendelius28-Jul-19 20:29 
AnswerRe: Weird Pin
Sean Ewington29-Jul-19 3:31
staffSean Ewington29-Jul-19 3:31 
GeneralRe: Weird Pin
Nelek29-Jul-19 4:10
protectorNelek29-Jul-19 4:10 
QuestionCan't edit my article Pin
aelassas27-Jul-19 4:40
aelassas27-Jul-19 4:40 
QuestionFormatting Pin
Dr.Walt Fair, PE15-Jul-19 10:30
professionalDr.Walt Fair, PE15-Jul-19 10:30 
QuestionWhy?, My Article deleted Pin
hussam.it14-Jul-19 23:28
professionalhussam.it14-Jul-19 23:28 
AnswerRe: Why?, My Article deleted Pin
Richard Deeming15-Jul-19 7:46
mveRichard Deeming15-Jul-19 7:46 
I can't tell you why it was flagged for deletion, but I can have a pretty good guess: your code is vulnerable to SQL Injection[^].
Quote:
The Value property will be rendered to a pattern by adding the % character at the beginning and the end of it:
VB.NET
Database.Table.Name = "Customers"
Database.Table.AliasName = "cust"
With Database.Table.Query.Items
   .Add("cust.CustomerId")
   .Add("cust.ContactName")
   .Add("cust.City", "Lon", QItem.Types.WHERE_LIKE)
End With

The generated SQL Statement will be:
SQL
SELECT cust.CustomerId,cust.CompanyName,cust.ContactName,cust.City _
FROM dbo.Customers cust WHERE cust.City LIKE N'%Lon%';


NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

I would be very surprised if Sean and others hadn't left you a message explaining this critical security vulnerability in your code before closing your article.

There's nothing stopping you from re-submitting the article once you've fixed the vulnerability.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


modified 15-Jul-19 15:20pm.

GeneralRe: Why?, My Article deleted Pin
Nelek15-Jul-19 8:22
protectorNelek15-Jul-19 8:22 
GeneralRe: Why?, My Article deleted Pin
Richard Deeming15-Jul-19 9:20
mveRichard Deeming15-Jul-19 9:20 
GeneralRe: Why?, My Article deleted Pin
hussam.it16-Jul-19 6:40
professionalhussam.it16-Jul-19 6:40 
QuestionCodeProject URL Shortener Pin
Daniel Vaughan3-Jul-19 23:08
Daniel Vaughan3-Jul-19 23:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.