Maybe its a db driver issue?
B)
grant wrote:
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/
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.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/
