BINGO! Matt....that would do the trick. The bummer is I can't use it given the application structure I'm working with....but for the future...that would work nicely (like the very next project).
Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Matthew Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, November 04, 2005 11:34 AM Subject: RE: CF webservice consumed via .NET >I know next to nothing about Oracle, but here's an interesting thing I >found > via Google: > > http://www.oracle.com/technology/oramag/oracle/03-may/o33xml.html > > > - Matt Small > > -----Original Message----- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Friday, November 04, 2005 2:28 PM > To: CF-Talk > Subject: RE: CF webservice consumed via .NET > >> -----Original Message----- >> From: Bryan Stevenson [mailto:[EMAIL PROTECTED] >> Sent: Friday, November 04, 2005 1:48 PM >> To: CF-Talk >> Subject: Re: CF webservice consumed via .NET >> >> > Which database are you using? >> > >> > Might it not be fastest to construct the XML as part of the query >> itself? >> > >> > You can format your results using string parsing in most DBs, but some >> > modern ones may be able to do the XML conversion themselves (SQL Server >> > 2005 >> > touts this for example). >> > >> > In other words why fetch, convert and send? Just fetch and send. >> > >> > Jim Davis >> >> DOH!....there's a damn fine idea Jim ;-) >> >> It's Oracle 9i...any idea if it will return XML...and example would be >> great? > > Sorry - I've not actually DONE this (and I don't have any experience with > Oracle)... it was just a thought. > > I know that I could do it SQL Server using string concatenation (just > building the XML manually) - I assume the same is true for Oracle. In SQL > Server you can also use COM objects or (in 2005) built SPs using > JavaScript, > perhaps you can do the same (or similar) in Oracle? > > Now that I'm thinking about it maybe I should work on a YODEL serializer > for > SQL Server 2005... > > Jim Davis > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
