MySQL Query + ASP IF Else End IF

Question

Example:

Sql = "Select * From tablo Where Baslik = "&strBaslik&" And Ozellik IN ("&strOzellik&") Order By Id Desc"

I want :

Sql = "Select * From tablo Where Baslik = "&strBaslik&" **IF Not "&strOzellik&" = Then** And Ozellik IN ("&strOzellik&") **End IF** Order By Id Desc"

How do I do this?

Thanks.

Community · Accepted Answer · 2017-05-23 12:20:27Z

0

There are several ways to solve this, one of them is to concatenate the sSql query:

<%
sSql = "Select * From tablo Where Baslik = '"& strBaslik & "' "
If Not strOzellik = "???" Then
     sSql = sSql & " And Ozellik IN ('" & strOzellik & "')"
End If
sSql = sSql & " Order By Id Desc"
%>

Notice that I also added single quotes around your SQL parameters in case the inputs are actually strings. Although, this way is not safe because of SQL injection and you might want to look into parameterized queries.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Feb 24, 2015 at 0:48

Luke Ford

1443 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Luke Ford Over a year ago

@Alp Happy to help, and welcome to Stack Overflow. If this answer or any other one solved your issue, please mark it as accepted.

Collectives™ on Stack Overflow

MySQL Query + ASP IF Else End IF

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related