Thanks for the tip :) -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 Email > [EMAIL PROTECTED]
"Hello Stupid, and welcome to your crappy computer." - Strong Bad, HomestarRunner.com > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 11:04 AM > To: CF-Talk > Subject: RE: Flash: load sounds > > > > <cfcomponent> > > <cfparam name="Request.DSN" default="ActorDB"> > > <cffunction name="getActorList" access="remote"> > > <cfquery name="selActorList" datasource="#Request.DSN#"> > > SELECT ActorID, ActorFirstName, > > ActorLastName, ActorMP3 > > FROM Actor > > ORDER BY ActorLastName, ActoFirstName > > </cfquery> > > <cfreturn selActorList> > > </cffunction> > > </cfcomponent> > > > > Just a reminder to not forget to var scope your local variables in CFC > methods. In this case, before the cfquery I would add: > > <cfset var selActorList = ""> > > ============================================================== > ========= > Raymond Camden, ColdFusion Jedi Master for Macromedia > > Email : [EMAIL PROTECTED] > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
