Selecting XML into an ADO Stream using multiple select statements 
Author Message
 Selecting XML into an ADO Stream using multiple select statements
If the Stream consist of multiple select statements for instance:

select '<OrderID>'
select 49
select '</OrderID>'

Then the 49 is interpreted as the character value 49, and prodeuces "- "
So this makes it into a char function more or less.

Is this my design or a bug?



Fri, 24 Oct 2003 20:15:55 GMT
 Selecting XML into an ADO Stream using multiple select statements

Are you using adExecuteStream?

If so, with for xml mode the stream contents are returned in its native
type. Use convert to select integer values as text or use explicit mode
query(select 1 as tag, 0 as parent, orderid as [OrderID!1!] from orders for
XML Explicit)


Quote:
> If the Stream consist of multiple select statements for instance:

> select '<OrderID>'
> select 49
> select '</OrderID>'

> Then the 49 is interpreted as the character value 49, and prodeuces "- "
> So this makes it into a char function more or less.

> Is this my design or a bug?



Sun, 26 Oct 2003 06:55:07 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Select statement on an XML file using ADO ?

2. Multiple SELECT statements using ODBC & ADO

3. USING A FIELD FROM MAIN SELECT STATEMENT IN SUB SELECT STATEMENT

4. Help: multiple select statements in SQL stored proc called by ADO

5. select statement using :variable as selected item

6. How can I using the Select statement to not selecting the Chinese Characters

7. Using multiple select statements in a SQL stored procedure

8. Executing Stored procedure with multiple select statement using RDO

9. inserting multiple rows using select statements?

10. Sql 2000 - Select for xml vs ADO xml persistance

11. Using a Select Case Statement to Open ado recordset

12. SQL select statement from ADO using ODBC


 
Powered by phpBB® Forum Software