>I mentioned something similar to that earlier on this week. Now, this relates also to Microsoft.XMLHTTP. Basically, if you return only one record and that it has an integer of a value 1, that value will be converted to a logical when using that control. The same is true if all your records has 1 for that integer value. As soon as you have another value it will always work. Why is this conversion taking place?

what do you mean with only one record are you returning a cursortoxml of a table if this is the case you need to also return the schema so that the parser knows wht type of data every field is dont forget that in SQLSERVER true is 1 an false is 0 so the parser is thinking that you are returning a logical value.