Andy Sandefer

Recent Blog Comments By Andy Sandefer

• Advanced ColdFusion Custom Tags With Ben Nadel (Video Presentation)

  Posted on Aug 24, 2009 at 8:38 AM

  Thanks for putting this out there. I haven't done much with custom tags for the last few years but they are still useful and pretty great for portability reasons!... read more »

• ColdFusion vs. XYZ - It Finally Got Physical

  Posted on Aug 17, 2009 at 1:39 PM

  @Ben - get back to work! Jeez - you had me totally fooled until the end of the story. If I had arms like yours I would've pounded a would be pool hall attacker into next week.... read more »

• SQL Pivot Tables Are Rockin' Awesome (Thanks Rick Osborne)

  Posted on Jul 28, 2009 at 10:28 AM

  There are numerous ways that this problem could've been solved but here's my take on it. Why not create a table that holds the brackets? This table's data could be updated by users when they want to change the behavior (the nubmer of buckets and from/to values of the report buckets) of the report ... read more »

• SQL Pivot Tables Are Rockin' Awesome (Thanks Rick Osborne)

  Posted on Jul 28, 2009 at 9:20 AM

  @Ben, I used to be more focused on data architecture and it has really paved the way for how I approach problems and data access in general. Any time that you spend learning about RDBMS Theory, OLAP Cubes, etc. is time well spent. Consider that Structure Query Language and the Relational Model has... read more »

• Ask Ben: Dynamic Table Names In ColdFusion Queries

  Posted on Nov 13, 2008 at 4:46 PM

  This is a stupid argument. My code checks the value against my table in the database - see what I mean? It is not like I'm saying that you don't have to perform any validation on the back end.... read more »

• Ask Ben: Dynamic Table Names In ColdFusion Queries

  Posted on Nov 13, 2008 at 3:46 PM

  I'm populating a cfselect list using a query returned from a cfc (querying a database table full of acceptable table names that can be used for query). I fail to see how this is some giant security hole. It seems as though you're implying that someone is going to save a copy of my page, edit it an... read more »

• Ask Ben: Dynamic Table Names In ColdFusion Queries

  Posted on Nov 13, 2008 at 3:25 PM

  I do this sort of thing quite often and I don't feel like I'm opening myself up to a can of worms because I always use forms and I always explicitly control what get's passed to the CFC responsible for making the dynamic SQL. Basically if you allow the user to form the queries using only cfselect l... read more »