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" ).