Skip to main content

Andrew Bauer

Member since Jan 12, 2009

Recent Blog Comments By Andrew Bauer

  • Learning ColdFusion 9: From SQL To ORM - A Conceptual Shift In Relationships

    Posted on Jun 7, 2010 at 9:09 PM

    @Don, I like to do as much data manipulation as possible in the database, and I also find it much easier to think in sets instead of objects. However I agree with Brian Kotek, in that OOP does have it's advantages when dealing with single entities. But in saying that, why does it have to be all or... read more »

  • Learning ColdFusion 9: From SQL To ORM - A Conceptual Shift In Relationships

    Posted on Jun 7, 2010 at 6:50 PM

    @Don, I think you are confusing what the definition of an object is in regards to OOP (Object-Oriented Programming). An object, in OOP, is a bunch of methods (functions) and members (variables) encapsulated in a class to describe the actions and state of a real-world entity. For example, a custome... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Jan 24, 2010 at 10:59 PM

    @Ben Nadel, I can understand about the formatting frustrations, I hope that I have not left snippets unformatted :) How about a hybrid of blog comments and forum? Have it when a blog is posted it automatically creates a forum thread.... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Jan 19, 2010 at 5:29 PM

    @Waheed, happy to help. I was curious about your problem as your code looked very verbose for what you seemed to be doing. Looking at it, it seemed to me that you were attempting to calculate the averages one record at a time via cursors, instead of doing it all at once with a single update stateme... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Jan 18, 2010 at 7:18 PM

    @Waheed, your post doesn't really have a question to it, though it sounds like you are attempting to ask one. I am assuming that you want to find the average age of people in a zip code; is this correct? If so your query can be reduced to a single insert or update query. @Ben, have you thought of ... read more »

  • ColdFusion, jQuery, And "AJAX" File Upload Demo

    Posted on Jan 15, 2010 at 12:21 AM

    I know this is an older post, however why not send the file via sockets to port 80 by getting javascript to initiate a java applet or flash movie like: http://stephengware.com/projects/javasocketbridge/... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Jan 10, 2010 at 5:12 PM

    @Ben, I believe it is required to use aliases in the join section of a join-based update query, however Dennis was attempting to update the alias. When updating via a join-based query in MS SQL (not sure if it is so for other RDBMS) you have to think of it as being referenced twice (like in a self-... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Jan 7, 2010 at 5:24 PM

    @Dennis, Change the query to: UPDATE CompletedRequirement SET CompletedRequirement.CreatedBy = 'jsmith' FROM CompletedRequirement cr INNER JOIN vwRequirementList rl ON cr.RequirementID = rl.RequirementID WHERE cr.CompletedRequirementID = 90271 Think of the from and join tables as separate from th... read more »

  • Ask Ben: Parsing Nested Lists With A Single Delimiter In ColdFusion

    Posted on Oct 21, 2009 at 9:59 PM

    @Ben, Awesome solutions! I would have never thought to look at this as a pattern. I like the first approach, mainly because I think regex is amazing.... read more »

  • Learning ColdFusion 9: ORM Inheritance Mapping

    Posted on Sep 7, 2009 at 1:44 AM

    @Justice, Thanks for the insight.... read more »

  • Learning ColdFusion 9: ORM Inheritance Mapping

    Posted on Sep 6, 2009 at 7:16 PM

    @Ben, I know what you mean by it not feeling right and I am rather against it myself (especially for intermediate to advanced systems, like enterprise level applications). In saying that, I can understand the purpose of ORM to simplify the processes of less data intensive applications.... read more »

  • Learning ColdFusion 9: ORM Inheritance Mapping

    Posted on Sep 6, 2009 at 6:55 PM

    @Ben, I don't think this approach is more optimal on a database level, however it is probably the easiest approach to code up while giving similar results. By this I mean: when coding any type of UNION, you have to make sure the column structure of the multiple select statements are exactly the sa... read more »

  • Understanding The IIS Mod-Rewrite Log File And Work Flow

    Posted on Sep 3, 2009 at 9:02 PM

    @Ben, Just a stab in the dark... Can't you get the RegEx to exclude the index.cfm match? There is probably a more elegant solution, however if it works it could be used until such solution presents itself.... read more »

  • Learning ColdFusion 9: The Ternary Operator

    Posted on Aug 26, 2009 at 8:29 PM

    Bald guy? My photo is in my avatar.... read more »

  • Learning ColdFusion 9: The Ternary Operator

    Posted on Aug 26, 2009 at 8:23 PM

    @Hugh, In the ternary, boolean is a variable, not a data type. So when Coldfusion loops over the list and assigns boolean with a value; it will do an implicit conversion of "true" and "false" giving you "It was True" and "It was False".... read more »

  • Learning ColdFusion 9: ORM Inheritance Mapping

    Posted on Aug 25, 2009 at 7:13 PM

    @Brian, You may be correct in saying that Hibernate handles the modification anomalies, however saying not to worry about it may not be a good idea for every situation. In a single entry point system, letting Coldfusion and Hibernate handle the database setup maybe a valid option. However if that ... read more »

  • Learning ColdFusion 9: ORM Inheritance Mapping

    Posted on Aug 24, 2009 at 10:47 PM

    @Brian, Even though hard drive space is cheap and querying a single table is faster, when using a single table for sub-classes you have to be careful of modification anomalies. Wikipedia has a good explanation of modification anomalies at http://en.wikipedia.org/wiki/Database_normalization#Free_t... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Aug 11, 2009 at 1:24 AM

    @JD, I can understand the pain of not being able to change the schema and I know that a well structured schema saves you from a lot of headaches. Personally, I would flat-out refuse to work with this type of database schema, opting to volunteer rewriting the structure and creating ETL (Extract Tra... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Aug 10, 2009 at 9:25 AM

    @JD, I am glad that I could help with my previous reply. With your question; it is possible to do with stored procedures and functions, but I would not suggest it. It is not a good idea to hold multiple key values in the same column. Having multiple keys in a column leads to data integrity issues... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Aug 6, 2009 at 9:15 AM

    @J.D. Sure can, Ben shows how in the blog: INSERT INTO @girl ( id, name )( SELECT 1, 'Maria Bello' UNION ALL SELECT 2, 'Christina Cox' UNION ALL SELECT 3, 'Winona Ryder' ); If you need the values to come from a table, then substitute the static information for column names and add a from clause; ... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel