database result and if logic

[Schrimpkutter]

Hello guys im from germany so my english is not that good
I found an thread here for connection c# to mysql. this works fine for me im doing a select and the result will be safed in a variable. my problem, i try to compare the result of mysql with an other variable with the if logic but everytime a bad end.

If looks like this:
"{-Variable.var_url-}"=="{-Variable.var_db_result-}"
First Variable is the url of a site and the second is the result of mysql.
If i make a new variable and put the content from {-Variable.var_db_result-} to it it works.

I hope someone has a tip for me

This is the Code i found in the forum:

 

[Tobbe]

"{-Variable.var_url-}"=="{-Variable.var_db_result-}" should return true/good if the variables are the same.
You sure no of the variables contains some white space? Like a line break, or space. Try to trim them.

 

[lokiys]

Try to use string escape on both your variables before comparing. Data ==> Word processing ==> String escape

 

[rostonix]

Try to use string escape on both your variables before comparing. Data ==> Word processing ==> String escape

Indy is right.

 

[Schrimpkutter]

You guys are right after the String escape it looks like this: 96WTM9ZX9C/\r\n so now i need to use regex to delete the unnecessary character ?

 

[rostonix]

semms like you have invisible line break at the end.
use word processing - trim to variable

 

[Schrimpkutter]

Thanks it works now.