Re: Question on Structuring Product Attributes

On Saturday, 9 February 2013 12:13:12 UTC+11, hugoko..._at_gmail.com wrote:
>
> <snipped entire load of insanity>

Hugo

You have a really disgusting habit of trying to drag me into your insanity.

Everyone Else

Hugo evidently does not understand syntactical differences between platforms, and he is obsessed with syntax that does not work on his platform (in this post as well as in the entire set of his posts in this thread), and he is unable to resolve such minor issues. I trust other readers are not so crippled.

As stated, the original code works on Sybase, using ISNULL. As stated, I converted it to work on MySQL for someone who implemented my Subtype structure there. It does not have ISNULL, but it does have COALESCE. I converted ISNULL to COALESCE (which required syntactical changes and which are not worthy of explanation, except for the insane). Sybase has COALESCE, so I tested the converted code. As stated, since COALESCE is in the standard, and ISNULL is not, I posted the COALESCE version, so that more people, rather than less, could use it. My MySql colleague did not write back re any problem (syntactical or otherwise), he only confirmed that the whole structure was tested and coded and it worked.

There is no suggestion that the example provided will work on every SQL platform, as is, unchanged for syntactical differences between platforms. I will not be posting examples for each platform, because that will only be relevant to babies who cannot resolve minor issues, and because it will elevate minor syntax issues to the relevance of blog posts.

People like Hugo need to be told in excruciating detail, how to write simple code; I have not provided that level of direction. Most developers don't need it; they can read my code and make whatever minor syntactical changes are required without having to write a blog post about it, or wail about syntax on one platform not working on some other platform. The seriously deranged will pose that (their insane mental spinning) as if it were a fault in someone else's example code.

Cheers
Derek Received on Sat Feb 09 2013 - 03:18:56 CET