Re: [CFCDev] Returning a Query from Application Scoped CFC

[jason . r . cronk]

If you var scopes the query then you shouldn't have a problem.  I.E.

<cffunction name="myquery" returntype="query">
      <cfset var getSomething = 0 />

      <cfquery name="getSomething">
      select * from table
      </cfquery>

      <cfreturn getSomething />
</cffunction>


Now if the query is variables scoped and it changes then yes you could run
into problems.

Jason Cronk





                                                                                
                                                       
                      "Gurevich, Gerry                                          
                                                       
                      (NIH/NIEHS)"             To:       CFCDev@cfczone.org     
                                                       
                      <[EMAIL PROTECTED]        cc:                             
                                                        
                      nih.gov>                 Subject:  [CFCDev] Returning a 
Query from Application Scoped CFC                        
                      Sent by:                                                  
                                                       
                      [EMAIL PROTECTED]                                         
                                                       
                      one.org                                                   
                                                       
                                                                                
                                                       
                                                                                
                                                       
                      06/23/2005 11:30                                          
                                                       
                      AM                                                        
                                                       
                      Please respond to                                         
                                                       
                      CFCDev                                                    
                                                       
                                                                                
                                                       
                                                                                
                                                       




I’m using an application scoped CFC to return a recordset.  It works fine
in my development environment.  Do I need to worry about the site under
load.  If multiple users are using the same CFC at the same time, will they
each have their own unique query to work with, or will they interfere with
one another.

-----------------------------------
Gerry Gurevich
Application Development
NIEHS ITSS Contractor
Lockheed Martin Information Technology
919-361-5444 ext 311

b����.n�+�����qׯN�����r��zǧu�ޙ����qׯq�3�w��"�a{
+v˧���r��y��u�ڲ�^���y�h~�^zf��!B
�ⲻ�o �  �'{0q�3�w���v˩���y��UǢ�b�
0�����-�x�`�7���.��+��[�װ�Z�֦jG�����热�(�m����  
���ej{Zr������l��ny�ڂ���w^���v�r�z�����7��+-�Ưj)ZnW��0���j�!����o�}�^���Ήޢ�