on further inspection i don't think cf can deal with the returned data. i'm getting well-formed xml as a string in query analyser, but dumping it in cf returns a query object with two rows; the xml being split across the two.
xmlParse also chokes on the re-constructed string. it's a shame. i'm using flash remoting and the tree component which can take xml as it's datasource. at the moment i have to query sql, which returns a flattened recordset, and then reconstruct it into the nested xml structure. it would be nice to just get xml straight off the bat and avoid the data massage. G On 4/22/05, grant <[EMAIL PROTECTED]> wrote: > Yeah Jon, it's definately do-able. check out > http://www.15seconds.com/issue/001102.htm > I'm doing these methods but getting weirdness back. > G > > On 4/22/05, Jon Austin <[EMAIL PROTECTED]> wrote: > > I have NFI, but fundamentally, I think this is not what SQL Server is > > designed to do. There needs to be a publishing layer, like a CFMX Web > > Service. > > > > I'd be interested to hear if it's possible though! Could offload some > > more processing onto the DB. > > > > Thinking about it, I'm sure it could be done either with TSQL or a > > built DTS package. > > > > Regards, > > > > Jon > > > > On 4/22/05, grant <[EMAIL PROTECTED]> wrote: > > > Hi > > > > > > Anybody got experience in returning XML directly from SQLserver? I'm > > > looking at the keywords FOR XML RAW that you can append to a query - > > > however i'm getting a recordset back that has mashed up XML in it. Any > > > tips? > > > > > > thanks, G > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
