> <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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
