> -----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:223252 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
