That looks more like a DAO than a gateway. Notice that the read method takes in an adminUsers object. At the end of the method it initializes it with what the query returned, so you can access it's properties from the calling page.
Also, typically an update method will only need to return true on success or false on error. The object's properties are still available in the bean through the get*X* methods. hth, Francois Levesque http://blog.critical-web.com/ On Sun, Aug 16, 2009 at 1:56 PM, Glyn Jackson <[email protected]>wrote: > > Hi, > > Thank you to everyone on house of fusion who has been very helpful so far > with my stupid questions. I have another ;) > > I was looking at some code I generated for a gateway by Illudium PU36. The > read and update functions do not make any sense in that it does not have any > return for me to get! However I noticed a function called "queryRowToStruct" > I am assuming this has something to do with how I can return the query or > access the query from my service layer, however this is a private function > so my service layer cannot access it if this was true. I am just confused > because without a way to return the query whats the point in these > functions? > > Are they wrong, or should I give them a return? or I am missing the > purpose? > > Thanks Glyn > > ------------------------------------------------------------------------- > > <!---Read---> > <cffunction name="readAdminUsers" access="public" output="false" > returntype="void"> > <cfargument name="adminusers" type="salesMaxx.model.objects.adminusers" > required="true" /> > <cfset var qRead = "" /> > <cfset var strReturn = structNew() /> > <cftry> > <cfquery name="qRead" datasource="#variables.dsnBean.getname()#" > username="#variables.dsnBean.getusername()#" > password="#variables.dsnBean.getpassword()#"> > > SELECT > > adminId, > > firstname, > > surname, > > email, > > username, > > password, > > role, > > lastLogin, > > flag, > > IP, > > userLog, > > createddatetime > > FROM adminusers > > WHERE adminId = <cfqueryparam > value="#arguments.adminusers.getadminId()#" CFSQLType="cf_sql_integer" /> > > </cfquery> > <cfcatch type="database"> > <!--- leave the bean as is and set an empty query for the conditional > logic below ---> > <cfset qRead = queryNew("id") /> > </cfcatch> > </cftry> > <cfif qRead.recordCount> > <cfset strReturn = queryRowToStruct(qRead)> > <cfset arguments.adminusers.init(argumentCollection=strReturn)> > </cfif> > </cffunction> > > > > > <cffunction name="queryRowToStruct" access="private" output="false" > returntype="struct"> > > <cfargument name="qry" type="query" required="true"> > > > > <cfscript> > > /** > > * Makes a row of a query into a structure. > > * > > * @param query The query to work with. > > * @param row Row number to check. Defaults to > row 1. > > * @return Returns a structure. > > * @author Nathan Dintenfass ( > [email protected]) > > * @version 1, December 11, 2001 > > */ > > //by default, do this to the first row of the query > > var row = 1; > > //a var for looping > > var ii = 1; > > //the cols to loop over > > var cols = listToArray(qry.columnList); > > //the struct to return > > var stReturn = structnew(); > > //if there is a second argument, use that for the > row number > > if(arrayLen(arguments) GT 1) > > row = arguments[2]; > > //loop over the cols and build the struct from the > query row > > for(ii = 1; ii lte arraylen(cols); ii = ii + 1){ > > stReturn[cols[ii]] = qry[cols[ii]][row]; > > } > > //return the struct > > return stReturn; > > </cfscript> > > </cffunction> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
