Passing the resultset (~ million rows) from DB to CF may not work (unless you break it up).
You could use the DB to write the file and then pass the file to CF. For eg, in SQL Server, you could create a DTS package. Export stuff out of your database, write to a file, FTP the file to the webserver, pass the file path to the web service caller. If the file is very big, you could zip it up and pass the zipped file around. Also, you may want to use asynchronous Web services for this kind of work - so your web service client does not have to wait till your servers do the work. Dharmendar Kumar (DK) -----Original Message----- From: Joerg Zimmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 7:42 AM To: CF-Talk Subject: Re: sharing huge amount of data per webservice hi, >1) Have one method that says howmany rows there are, then another that returns >N rows starting at offset M. We already applied arguments to the webservice, allowing to control start and end-date and to specify a participant. However, some participants managed to create 80,000 Rows for them alone. >2) Write the file to somewhere the web server can see it, and use the >webservice to indicate the location of the file. To create this file I would have to generate it's content in a variables and write this variable into the file. Would result in an outofmemory error again. something like <cffile action="write" file="C:\test"> here goes the content </cffile> would be great :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:214167 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
