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. > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
