That might do it - I've never done it but I believe you can tell SQL Server to return an XML file so it might be possible - I'll do some more research but thought someone on the list might know the answer off the top of their head.
Thanks for the tip!!!! ++++++++++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++++++++++ -----Original Message----- From: Larry White [mailto:[EMAIL PROTECTED] Sent: Wednesday, 29 June 2005 4:06 AM To: CF-Talk Subject: CSV and SQL You could do something like Select Firstname + ',' + Lastname + Char(13) as OneLine Then loop thru the query and concantenate the resultset >Is it possible to structure your SQL query (target SQL Server) so that ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:210834 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
