You can use this cfx tag I wrote. It takes a query and makes it into xml. Its output is like that of MSSQL server, but it works on any db, and It's pretty fast:
http://www.robrohan.com/client/index.cfm?mode=entry&entry=5879E8AD-0F77-67CC-769389AAE62C9544 (cfxtoxml) On 9/20/05, Dharmendar Kumar <[EMAIL PROTECTED]> wrote: > > Hi! > > The method recommended by Macromedia as per their docs is to use CFXML > and looping thro your recordset is definitely not the best one - its > very bad at performance. > > CFWDDX does not generate xml in the format i need - so I will have to > parse the xml generated by wddx and then use xslt to transform it - not > a very efficient way either. > > I am going to try SQL Servers xml functions to see what kind of > performance i get from it. > > Meanwhile, if anyone knows of any other way of doing this, I would > really appreciate it if you can share it... > > Thanks, > > DK > > > <http://www.realmagnet.com/assets/images/magnet-only.jpg> > Dharmendar Kumar | Lead Developer > Real Magnet | Advanced Broadcast E-mail and Fax Solutions > 4853 Cordell Ave., PH 11, Bethesda, MD 20814 > Phone: 301-652-4025 | Fax: 301-652-7153 > E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Website: www.realmagnet.com <http://www.realmagnet.com> < > http://www.realmagnet.com/> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218795 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
