- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
And it doesn't appear to work in Firefox.
Man, how lame am I.
Admin
Pretty lame, but not nearly as bad as this forum software.
B
Admin
Amore? That's not amore, this is a moray http://www.netfunny.com/rhf/jokes/91q4/moray.html
Admin
Also, talk to more than one consultant, not just the CEO's son-in-law. Nothing like a litle competition to drop rates.
Admin
In SQL Server at least, you can put almost anything within the () and get the count. I generally use
select Count('Chocula') from users
just to see if I end up on thedailywtf.
Admin
Trying to expose my ignorance of poor forum software [pi]
Admin
dammit!
Admin
So what's the secret pizza boy?
Admin
Testing, testing... 1 2 3... Is this thing on?
[:)][:D][:O][:P][;)][:$][:'(][:|][:S][:(][H][:@][A][6][8-|][|-)][<:o)][:^)][:-*][:#][Y][B][{][8][*][um][au][pi][sn][O][co][st][mo][8o|][^o)][N][C][8-)][*-)][+o(][D][Z][}][^][U][I][&][~][W][G][S][E][ap][ip][li]
Admin
<FONT face=Arial size=2>I really, truely believe this forum is one of the bigger WTF's. There's actually NO thread in this forum that doesn't have some crappy quotes, misfigured smileys or pink elephants running thru it.</FONT>
<FONT face=Arial size=2>C'mon Alex: how about an upgrade? How about you organize a contest amongst your users to develop a new forum (the one with the least (dare I say none?) WTF's will get implemented). Hell, I'm so fed up with this forum I would offer to develop a forum myself for you if I weren't this busy creating WTF's for you guys all over the place [;)]</FONT>
<FONT face=Arial size=2>Should you not want to consider this option, then at least allow us to edit our posts so we can correct our own WTF's.</FONT>
Admin
AAARGH [:@]
At least offer a PREVIEW option ... [:'(]
Admin
----
From:
http://communityserver.org/default.aspx
Development for Community Server 1.2 is underway with a planned release date of December 2005 (review the full roadmap).
Below are some of the new key features in the Community Server platform:
New backend Control Panel - The new Control Panel provides site managers..
----
Or in short, as usual the developers are moving on to fancy snancy stuff like PodCasting and never mind the fact that way back here we can't even do a PREVIEW!! [:'(]
Typical.. And a lesson to anyone doing a technology 'roadmap' for their own companies products. The secret is, bang the rock together guys! (Hmm not sure what that particular quote has to do with anything but I just like it.. so sue me).
Admin
Soooo not true. I write way more complex SQL queries then that... You can't blame the entire community for the newbies mistakes; they ARE newbies.
Admin
Or maybe it's Jed?
Admin
SELECT [ActiveBookings] = COUNT(*) FROM Bookings WHERE bookings_active_indicator = 'Y'
But this isn't the same thing, this counts all bookings with bookings_active_indicator = 'Y', the original code counts only the bookings for existing clients. You don't assume they have proper RI constraints in their database, do you?
Admin
Yes, this is bad SQL, but what surprised me here is the first query. If they insist on getting all the client IDs, then iterating over them, the first query should be:
select client_num from clients;
What they are doing now is getting ALL information for each client. The table clients could contain dozens of columns of information that unnecessarily slows down the database query but is immediately discarded.
Admin
Maybe a JOIN on the Clients table would be in order ... notice the outer loop which iterates through that table so the inner loop only retrieves bookings by clients who are actually in the Clients table?
Yes, I know about referential integrity... but considering a system that uses code like this, I would not surprised to learn the designers never even have heard about that concept...
Admin
This isn't a WTF. It's an OMG!
Admin
Coldfusion is a WTF in itself
Admin
There is. Alex has disabled it, I think because it caused more mangled postings (though I'm not entirely sure whether there really were more of them back then).
I'm pretty sure what's actually causing all these problems is the editor, which nobody really needs anyway. But you probably can't disable it. And switching to a different forum software would mean all the old threads get lost...
Admin
I second that! (or is that "I third that" by now ?)
Either upgrade or change to some other, less bugridden software (phpBB ? vBulletin?) ? Please ?
Admin
Bull. All you need to do is convert the database (or just write a conversion if none exists). We ARE programmers, aren't we? Or are we just big wussy's? And If I may make a suggestion for a WYSIWYG editor, which we don't need anyway, how about Tiny MCE? Works like a charm! But I also think we don't need a WYSIWYG anyway. Just a plain old textbox will do fine with some UBB code support or something like that.
Really. I think it just sucks seeing such a great site (contents-wise) go *poof* everytime some tries to put in $0.02...
Admin
Duhhhh, brillant has 2 L's in it man.
I've always said a bad joke gets funnier the more you say it, and that's too IsTrue to be funny.
Admin
Good at CF = able to breathe
Using * in any SQL Query that isn't a COUNT = polish
Admin
I'm pretty certain there is no such conversion routine, and call me a wussy, but I wouldn't want to be the one to write it. I've seen the DB schema of another forum software with less functionality, and it was already pretty damn complex. Most likely, you'd have to figure out what the fields are for by looking at the code, because commenting is for wussies and if it's done at all, the comments probably lack any semantic information - don't you just love things like this:
/**
* Returns the wigglyDooDad ID.
*
* @return the wigglyDooDad ID
*/
public int getWigglyDooDadID()
Then, after spending days sifting through crappy code, you'll encounter a field that is integral to the inner workings of the new forum software, but which has no equivalent in the old one and cannot be safely set to a default value.
As I said, I wouldn't want to do it, and I can understand if Alex doesn't want to. That being said, you could simply switch to a new software and keep the old threads in the old one around, set to read-only. The problems are serious enough to justify it.
Admin
I second that
Admin
I don't know how tightly the .TEXT editor is integrated with the rest of the forum software, but it might be possible to just swap the editor control without changing much else. TinyMCE is Java, as far as I can tell, but FckEditor (http://www.fckeditor.net) also supports ASP.NET, which is what the forum actually uses. I've not used it, and there appears to be an issue with the demo (first try told me access was denied, second try worked), but it looks quite cool otherwise.
Admin
Sorry, for some reason I thought this was a different piece of forum software. I meant FreeTextBox editor, which I think is the one it uses
Admin
Sorry you're wrong - that's a big misconception about the use of * in the count function.
Admin
It can't be that tightly integrated because if you use Safari you just get an ordinary text box and a load of smilies that do nothing when you click them.
Following the link at the bottom of the page to [href]http://communityserver.org/[/href] I see that the forum was "Selected by readers of asp.netPRO magazine as the #1 forums solutions." [image] I'd like to see the runners up to the prestigious prize.
Admin
Just go to the back issues of this very forum. Pick any 10 WTFs, cobble them together randomly, and you have it.
Simon
Admin
In IE7 Beta, you get a plain (and rather diminutive) text box as well.
So it'd be possible, in theory, to swap the editor? Not sure if the license prevents this, though, but this is a community license, so maybe not.
Admin
<img src="whatever the pizza was">
I'll hang my head in shame, now..
Admin
I think I had this guy on my staff at one time. Well, at least this looks like his style. Email me and I can give you his name.
Admin
WTF? Now my "delete" key won't work in this crappy editor?
Anyways... I would really like to know which software it was, because I have never come across a "complex" forum before. I also see no need for "complex" databases for a forum (even if it is a huge forum). Please tell me which forum it was? I would love to take a look at it's inner workings...
My guess: It's what you define as "complex" [;)]
Admin
boy, boy, I do quite some work with php and I've seen code like this and even worse. Like some statement joining a table with itself without specifying a condition, only some having clause filtering out a single row. While testing the app, all was fine but when the table had something like 100k rows, things became considerably slower.
regards
fg
Admin
Let me make that a little more specific: a preview that works! I almost always preview my posts when I have the choice.
Sincerely,
Gene Wirchenko
Admin
A classic example of where his CF code ran nice and fast in dev when he had 1-10 records, but as the 'bookings' table fills up, this slows down dynamically.
Admin
For a touch of the ironic, look at the ad at the top of the page:
<font style="font-size: 11px; font-family: verdana,arial,sans-serif; line-height: 14px;">$99/yr CFMX7 Hosting</font>
<font style="font-size: 10px; font-family: verdana,arial,sans-serif; color: rgb(0, 0, 0); line-height: 12px;">DataRide - sound hosting at a fair price. We specialize in ColdFusion!
</font>yeehaw!<font style="font-size: 10px; font-family: verdana,arial,sans-serif; color: rgb(0, 0, 0); line-height: 12px;">
</font>
Admin
Since it doesn't look like
bookingsCount
is a 'per client' variable, I don't think all the SQL that usesGROUP BY
is the right idea. I think this would suffice:I'm not sure how to wrap that up in ColdFusion tags. And I'm sure that's less than optimal on some databases.
Since
GROUP BY
is completely unecessary, the code is even worse than a lot of people originally thought. Forcing the database to shove all the data over the network so the client can do the logic is a very dumb idea. I mean the stupid thing doesn't even use most of the columns in the Clients or Bookings tables, but sends them all over anyway.Admin
working myself with CF for a long time i cant understand why ppl say CF is bad. an argument i always hear is "cf = bad code because its so easy to learn". while its true that its easy to get started and make your first dynamic stuff you can push it to the limits and do some really good work. only because its easy to use dosnt mean its a bad thing at all. i wrote lots of jsp but since coldfusion i wouldnt write any jsp/java if its not necessery. for certain parts i'd use jsp/java with coldfusion and its easy to combine it.
and yes ... this query is a real WTF
Admin
Your capitalization & spelling is a real WTF.
Admin
Your capitalization & spelling are a real WTF. :P
Admin
Oh good god, have they never heard of a 'Join'????? That whole block of code should be replaced with 1 SQL statement, hahahhahaa!
Admin
Like Alex said: PHP is for hobbysts.
Real programmers use ASP.NET and VB.NET.
Real programmers use Telligent solutions.
Admin
ASP.NET is actually quite good most of the time. Speed can be a bit of an issue (though once you figure out caching, you can improve this), but stability is generally quite good. The problem is that there aren't that many text editor components that can do the all-singing-all-dancing stuff that FreeTextBox (the editor control that Community Server uses) can do. Unfortunately, FTB's stability seems to be lacking, especially cross-browser.
Admin
You idiot.
I hate you, but not as bad as I hate proprietary browser controls. Do you people honestly want to be chained to IE for another 6 shitty years? so-called "BB code" works fine and is cross-browser. Shit, they use it for the quote function as it is.
[image]Admin
#q2.recordcount# would have solved his problem. he's terrible at cf, and sql
Admin
[3.14159265358979323846264338327950...]