howto fixthis if statement

[AliHabib]

I write a code to change variable by this if statement but it not work alwaysgive the else

if request("txtSearch2") = "" then
 
 
                    'select case sens
                    if request("Sense")= "on" then   
                    sqlPRJ = "SELECT TCKT_ID,TCKT_OPN_DATE,TCKT_DESC FROM TCKTs WHERE TCKT_DESC like '%'+'"&request("txtSearch1")&"'+'%'COLLATE SQL_Latin1_General_CP1_CS_AS"                    
                     else
                    sqlPRJ = "SELECT TCKT_ID,TCKT_OPN_DATE,TCKT_DESC FROM TCKTs WHERE TCKT_DESC like '%'+'"&request("txtSearch1")&"'+'%'"
                    end if
                end if

[CroCrew]

Hello AliHabib,

Try adding some debugging code like the one below to see what your getting for your values and where you fall into your ‘If Then’ statements.

response.write("This is the value for 'txtSearch2': [" & request("txtSearch2") & "]</br>")
if request("txtSearch2") = "" then 
    response.write("This is the value for 'Sense': [" & request("Sense") & "]</br>")
 
    if request("Sense")= "on" then    
        response.write("True")
    else 
        response.write("False")
    end if 
end if 
 

Hope this helps,
CroCrew~

[jhardman]

try trimming your request (removes spaces)

if trim(request("txtSearch2")) = "" then                        

let me know if this helps.

Jared

[Nicodemas]

@AliHabib

Remember that the conditional is going to compare this EXACT test. If the value of request("Sense") is being passed along as "on" (note, no leading/trailing spaces, all lowercase) then it should work.

Try this and see:

if trim(request("txtSearch2")) = "" then 
   'select case sens 
   if lcase(trim(request("Sense")))= "on" then    
      sqlPRJ = "SELECT TCKT_ID,TCKT_OPN_DATE,TCKT_DESC FROM TCKTs WHERE TCKT_DESC like '%'+'"&request("txtSearch1")&"'+'%'COLLATE SQL_Latin1_General_CP1_CS_AS"                     
   else 
      sqlPRJ = "SELECT TCKT_ID,TCKT_OPN_DATE,TCKT_DESC FROM TCKTs WHERE TCKT_DESC like '%'+'"&request("txtSearch1")&"'+'%'" 
   end if 
end if
 

If that does not work, your Request parameter is not correct or you are sending the wrong string in request("Sense").