|
*hut *he *uck *p 
|
|
|
|
|
It's definitely not a clever code. Somebody smokes joint too often. 
|
|
|
|
|
a collegue of mine, from a village near Rome, uses to say "fresco": it means basically "stuff", and he really abuses the word.
When he explains your code to you, he sounds like this:
"Well, I coded a 'fresco' that takes two other 'frescos' and move them around, while another couple of lists of 'frescos'...."
He also claims being a jQuery expert... so this is a jQuery example of his "frescoes" 
$(".TimeoutInMinutes").change(function() {
UpdateSave($(this).parent().parent().parent().parent().parent().parent().attr("id"));
});
$(".Iteration").change(function() {
UpdateSave($(this).parent().parent().parent().parent().parent().parent().attr("id"));
});
l
|
|
|
|
|
Quite a big family...
(yes|no|maybe)*
|
|
|
|
|
bruno.tagliapietra wrote: "Well, I coded a 'fresco' that takes two other 'frescos' and move them around, while another couple of lists of 'frescos'...."
This is not hard to unerstand. As a kid I watched the Smurfs on TV a lot. Watching that a lot made me familiar with their language. The language your co-worker speaks seems closely related to the Smurfs language. A basic rule for this language family is to replace every noun with another word, in your co-workers language this word is 'fresco'.
Learning a new language is never easy, but with a bit of practice you'll get there! 
bruno.tagliapietra wrote:
$(".TimeoutInMinutes").change(function() {
UpdateSave($(this).parent().parent().parent().parent().parent().parent().attr("id"));
});
$(".Iteration").change(function() {
UpdateSave($(this).parent().parent().parent().parent().parent().parent().attr("id"));
});
l
This language seems harder to decipher...
It's an OO world.
|
|
|
|
|
yup, a language very easy to speak but almost impossible to understand eheh.. it's like a noninvertible function
|
|
|
|
|
smurfs rock!
|
|
|
|
|
I can not see anything to complain about!
He talks about frescos[^] and revers to the 6. generation of parents - this sound fine to me.
The time should kind of fit.
regards
Torsten
I never finish anyth...
|
|
|
|
|
and here's another one... it's ROBUST jquery :p
$(this).parent().parent().parent().children("tr:nth-child(1)").children("td").children().children().children().children(":nth-child(2)")children(".MultilineTextBox").val("!" + Out);
|
|
|
|
|
Yeah, that is a really ugly querry of "frescoes".
Just because the code works, it doesn't mean that it is good code.
|
|
|
|
|
Is fresco Italian for widget? I'm hungry, how do you ever stop eating over there?! I'm 50% Italian, my mother was born there, but I've never visited. I would have to stay though, because I wouldn't fit on the plane back.
Craigslist Troll: litaly@comcast.net
"I have a theory that the truth is never told during the nine-to-five hours. "
— Hunter S. Thompson
|
|
|
|
|
"fresco" means something "fresh". I can't think of an word sounding the same with a useful meaning in software developing.
regards
Torsten
I never finish anyth...
|
|
|
|
|
|
Are you saying he's all fresco?
Maybe he should work on this[^]?
|
|
|
|
|
Hi Bruno,
Clearly this programmer is using "fresco" as a code-word for "obfuscatore al dente."
best, Bill
"Many : not conversant with mathematical studies, imagine that because it [the Analytical Engine] is to give results in numerical notation, its processes must consequently be arithmetical, numerical, rather than algebraical and analytical. This is an error. The engine can arrange and combine numerical quantities as if they were letters or any other general symbols; and it fact it might bring out its results in algebraical notation, were provisions made accordingly." Ada, Countess Lovelace, 1844
|
|
|
|
|
EDIT: This is LOOOONG. Sorry. 
The following code is used to create "WHERE" clause criteria, for all possible cominations of 8 "class" parameters if the "group_a" parameter is passed with a value. I know there's a better way of doing this, but I can't be bothered to unravel this convoluted piece of code!
Function grpStatement(group_a As String, class_aa As String, class_ab As String, class_ac As String, _
class_ad As String, class_ae As String, class_af As String, class_ag As String, _
class_ah As String, classCondition_a As String) As String
Dim groupCondition_a As String
If group_a <> "" Then
If class_aa <> "" Then
classCondition_a = classCondition_a & "'" & class_aa & " %'"
If class_ab <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ab & " %'"
If class_ac <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ac & " %'"
If class_ad <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ad <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ac <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ac & " %'"
If class_ad <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ad <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ab <> "" Then
classCondition_a = classCondition_a & "'" & class_ab & " %'"
If class_ac <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ac & " %'"
If class_ad <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ad <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ac <> "" Then
classCondition_a = classCondition_a & "'" & class_ac & " %'"
If class_ad <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ad <> "" Then
classCondition_a = classCondition_a & "'" & class_ad & " %'"
If class_ae <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ae <> "" Then
classCondition_a = classCondition_a & "'" & class_ae & " %'"
If class_af <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_af <> "" Then
classCondition_a = classCondition_a & "'" & class_af & " %'"
If class_ag <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ag <> "" Then
classCondition_a = classCondition_a & "'" & class_ag & " %'"
If class_ah <> "" Then
classCondition_a = classCondition_a & " OR Level4 LIKE '" & class_ah & " %'"
End If
ElseIf class_ah <> "" Then
classCondition_a = classCondition_a & "'" & class_ah & " %'"
Else
classCondition_a = classCondition_a & "'%'"
End If
groupCondition_a = "Level3 LIKE '" & group_a & " %' AND " & "(" & classCondition_a & ")"
End If
grpStatement = groupCondition_a
End Function
|
|
|
|
|
What the...  
It's an OO world.
|
|
|
|
|
|
This is one clear line of commands. You can't say the programmer wanted to confuse you!
regards
Torsten
I never finish anyth...
|
|
|
|
|
That guy tricked you. He wrote a code generator (which he hides from you, and the boss) to generate such long lines of code, and thus he earns lots of money since he gets paid for lines of code.
|
|
|
|
|
I guess he would be able to retire after this one...
|
|
|
|
|
|
zee googles, zey do nuthing.
|
|
|
|
|
See... This is what happens when a developer writes in VB for too long.. 
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
What's worse is that this is obviously just one part of a very messy inline-SQL generation procedure... Since this would only make one part of a WHERE clause, there are no doubt similar structures elsewhere that you're not showing us...
VB, plus messy inline-SQL generation... ick. 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
