Unless this is in a CF page or a FlashComm app, it simply won't work. Flash doesn't have the capabilities or the integrated drivers to handle making direct DB calls.
The reason your script isn't throwing an error is because Flash assumes that there's a custom class object named CF with a method called Query. I'd strongly suggest looking at remoting for your middleware as this is easily the best way to get dynamic data into flash. Here's some instructions on CF.Query and other SSAS functions for future reference: http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentation&file=00001496.htm Cheers, Kevin -----Original Message----- From: SStewart [mailto:[EMAIL PROTECTED] Sent: July 15, 2005 11:47 AM To: CF-Talk Subject: RE: Data Access in Flash... more I encapsulated it within a function and it doesn't return any errors, now I need to find out if it's actuall passing the data and get it into a data grid. function getConcrete(){ result = CF.query({datasource:"DocWf_SQL_Test", sql:"EXEC GetConcreteStatus"}); return result; } Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 "Many thousands of years ago, a blue faced Pict stepped on a bloated sheep carcass... and thus the Pipes were born" ..... the Scottish Rogues -----Original Message----- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Friday, July 15, 2005 01:22 pm To: CF-Talk Subject: RE: Data Access in Flash... more Importance: Low The function in question is for Server side Actionscript. This form of scripting is normally used with Flash communication server applications. There are no DB drivers included within the plug-in, so direct DB calls aren't there to use. Cheers, Kevin -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:212023 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
