<http://www.houseoffusion.com/cf_lists/index.cfm?method=results&optionlist=0 &forumid=4&Search=xml&optionlist=2&Author=Rob+Rohan&After=&Before=&maxrows=6 0#98370>
Thanks. Rob -----Original Message----- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 2:20 PM To: CF-Talk Subject: RE: CF 2 XML Oh, that. That's by design. The issue is that MSSQL is not returning a query but what MS calls a Stream, which is a one field query meant to be appended (which is pretty different from Java Streams, afaik). When accessing this type of SQL with ADO you use MS's ADO Stream object instead of an ADO Recordset. Unfortunately, CF doesn't have any equivalent, so we have to hack our way through. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4