You can also pass a list of fields to fetch as argument to your gateway, I think. salvatore Da: [email protected] [mailto:[email protected]] Per conto di Oscar Arevalo Inviato: giovedì 14 maggio 2009 23.08 A: [email protected] Oggetto: [CFCDEV] Re: Gateways dealing with A LOT of columns and maybe some for secure data. The ideal option (in my opinion) would be to create a view of only the subset of columns you are more likely to use; however if that is not an option you could also create 2 or more gateway objects that refer to the same table, kinda mimicking the concept of a view, but at code level. Gateway A will deal only with the subset of columns on your most frequent use cases, Gateway B could deal with the secure columns (or whatever combination) and then a gateway C to deal with the entire table (if you actually need to get everything). Oscar On Thu, May 14, 2009 at 1:26 PM, Baz <[email protected]> wrote: I had a similar situation but not with secure columns (I'd love to actually know what that means?) but where a column was a huge, slow blob of text that I didn't need 99% of the time and would add lots of load if it were there. You can have an optional argument to include those columns or not: <cfargument name="IncludeSecureColumns" default="false" /> and then just CFIF inside the SELECT statement.
Baz On Thu, May 14, 2009 at 12:46 PM, Steve Bryant <[email protected]> wrote: You might look into creating a View of the table. Most databases support this and it would allow you to create a view of the table that doesn't have the secure columns. Then you could just code against that view instead of against the table directly. Steve At 02:34 PM 5/14/2009, garrettjohnson wrote: >I am wondering how others deal with when it comes to designing a >Gateway, but the table it models has A LOT of columns and maybe some >secure columns. -- Oscar Arevalo http://www.oscararevalo.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
