Article Writing

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%';

Richard Deeming wrote:

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.

M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

Nelek wrote:

BTW... the thirs link... not valid anymore. They moved it to GitHub

The structure looks correct.