Re: Catution when using XML for Logic

[jaimalchohan]

The issue here is that you must always TRIM any values that you perfrom logic on, else you will obviously get an error


e.g you XML might be
<text>
Default
<text>

And when you run your code you find out that

If text = "Default" Then

doesn't work.

Its becuase the value of text might actually be "Default " (see the space)

[RFH Customer: cswd]

Not a problem if you serialize and deserialize objects to xml . Remains very consistent then.

Humans are the problem here!

(yes i have actually done that before!)

[RFH Reseller: Sol]

This also occurs in other areas, one in particular is when reading a CHAR value from an MS SQL database and is something that I have seen cause many problems.

In my opinion, however, this should be caught at the data validation point during entry and corrected before being written. In the case of the CHAR for SQL databases you know the field length and hence can work with that or use an RTRIM().

[RFH Customer: cswd]

Ah yes - dealt with that one today ironically. Some muppet put 2 character ISO country codes in one table with a CHAR(10) and the other with a CHAR(2) and of course did the joins work - nope!