compare strings 1

[taree]

I am trying to do a comparison like below and somehow it is not working. Is it because I am trying to compare a value assigned to a variable with the string. How can I fix that?
please help. thank you

  If String.Compare(strStates1, "ALL", True) = -1 Then
                .Append(" AND R.STATE IN    (SELECT * FROM TABLE (CAST (func_select_state (:BindStates) AS B_state)))")
                cmdDBEVendors.Parameters.Add(New OracleParameter(":BindStates", OracleDbType.Varchar2)).Value = strStates1

            End If

 

[Turkbear]

Hi,
as a debug step,try displaying the value of strStates1 to see if it may need to be trimmed of trailing spaces before comparing it.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jmeckley]

how about

if(strStates1 == "ALL")...

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[taree]

thank you all for the response. there is no trailing space.I already trim the trailing space.

what I am trying to do is that if the user select include "ALL" from the dropdown selection then I want to return all the rows for regardless of the selected states.otherwise, I would like the rows for selected states only.

if(strStates1 == "ALL")...

 

[jmeckley]

...
where
   [other critiera]
and (customer.State = :state or :state is null)

var p = new parameter("state", varchar);
p.Value = if(string.IsNullOrEmpty(state) == false) ? DbNull.Value : state;
command.Parameters.Add(p);

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[taree]

Jason thank you. I will try to apply your sample code. I am not sure how i can use in sql query that use "IN" clause.