• (cs) in reply to Ytram
    Ytram:
    Actually all I did was quote the guy that got it working right, and then I just cut and pasted his pizza [:P]

    Of course, from now on, I'll have to return to this thread and cut and paste and see if it works across threads.

    When the moon hits your eye
    Like a big [image][image][image][image][image][image][image][image]
    That's amore...

    (8 slices = one pizza pie)


    And it doesn't appear to work in Firefox.

    Man, how lame am I.
  • suidae (unregistered) in reply to Ytram
    Ytram:

    Man, how lame am I.

    Pretty lame, but not nearly as bad as this forum software.
      B
  • (cs) in reply to Ytram

    Ytram:
    Actually all I did was quote the guy that got it working right, and then I just cut and pasted his pizza [:P]

    Of course, from now on, I'll have to return to this thread and cut and paste and see if it works across threads.

    When the moon hits your eye
    Like a big [image][image][image][image][image][image][image][image]
    That's amore...

    (8 slices = one pizza pie)

    Amore? That's not amore, this is a moray http://www.netfunny.com/rhf/jokes/91q4/moray.html

  • (cs) in reply to Xepol
    Xepol:
    ...Always get references for consultants, and preferably view a system they wrote in action.
    Do they have one-list of previous clients and reference contacts, which is good, or do they have two separate lists, which is not good?  If the latter then try this: cross-reference the client list with the reference list and ask to contact companies on the client list but not on the reference list.  There is probably a reason why they weren't on the reference list.

    Also, talk to more than one consultant, not just the CEO's son-in-law.  Nothing like a litle competition to drop rates.


  • rhett (unregistered) in reply to RevMike
    RevMike:
    Anonymous:


    SELECT Client_Num, Count(1) FROM Bookings group by Client_Num

    Would actually be faster since the * will have to replace each column....




    Whether or not this is faster is sensitive to database product and version.  Many SQL optimizers look for Count(*) specifically and optimize its calculation.

    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.

  • (cs) in reply to whojoedaddy

    Trying to expose my ignorance of poor forum software  [pi]

  • (cs) in reply to Mung Kee

    Mung Kee:
    Trying to expose my ignorance of poor forum software  [pi]

     

    dammit!

  • (cs) in reply to Mike R
    Mike R:
    Manni:

    SheridanCat:

    ColdFusion's big benefit is also it's main problem.  It's easy to get started with, thus a lot of crappy code that more or less works gets written.

    A.K.A. - Visual Basic. I know I know, the VB zealot trouncing his own language. I've seen a lot of VB code like this before, where people don't bother to investigate the data source they're accessing to see if there's a better way.

    And on that note, I'd like to use this icon because I've never seen anyone else use it: [pi]



    Oh! you mean this: [image]?

    So what's the secret pizza boy?

  • (cs) in reply to whojoedaddy

    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]

  • (cs) in reply to RobIII

    <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>

  • (cs) in reply to RobIII

    AAARGH [:@]

    At least offer a PREVIEW option ... [:'(]

  • utunga (unregistered) in reply to RobIII
    RobIII:

    AAARGH [:@]

    At least offer a PREVIEW option ... [:'(]

     

    ----

    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:

    • Inline editing - ...
    • New UI - New user interface which better conforms to HTML standards ..
      New backend Control Panel - The new Control Panel provides site managers..
    • Support for both ASP.NET 1.1 and 2.0 - ..
    • New File Gallery - ..
    • Podcasting (RSS Enclosures) - Easily support both server and remote files for blog attachments.

    ----

    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).

     

  • Ludvig Ericson (unregistered) in reply to Xepol
    Xepol:
    Looks like the developer recently moved from PHP and MySQL. Its the ONLY place where code this stupid is considered industry norm. Always get references for consultants, and preferably view a system they wrote in action.


    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.
  • (cs) in reply to WIldpeaks
    WIldpeaks:

    Ohh, Paula got a new job apparently...



    Or maybe it's Jed?
  • Florian (unregistered) in reply to Maurits

    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?


  • (cs)

    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.

  • Idonthaveaname (unregistered) in reply to Jeff S
    Jeff S:
    The grouping on client_num depends if there is some code in there that was snipped that displays the count per client.  Otherwise, of course, just a single count w/o any grouping would be needed to returned the total.


    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...
  • Bernhard Hofmann (unregistered)

    This isn't a WTF. It's an OMG!

  • Oli (unregistered)

    Coldfusion is a WTF in itself

  • (cs) in reply to RobIII
    RobIII:

    AAARGH [:@]

    At least offer a PREVIEW option ... [:'(]



    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...
  • (cs) in reply to RobIII
    RobIII:

    <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? </FONT>

    I second that! (or is that "I third that" by now ?)

    Either upgrade or change to some other, less bugridden software (phpBB ? vBulletin?) ? Please ?

     

  • (cs) in reply to brazzy

    brazzy:

    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...

    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...

  • Welcome To The Machine (unregistered) in reply to John Bigboote
    John Bigboote:
    Anonymous:

    Anonymous:

    <FONT face=Verdana size=2>One word: Brilliant!</FONT>

    Alright, people... The Brillant and IsTrue jokes are played out. Know when a good thing is no longer good and let it go. Just let it go...



    I agree. I think we can start getting some mileage out of "brilant" though.

    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.

  • asdf (unregistered)

    Good at CF = able to breathe
    Using * in any SQL Query that isn't a COUNT = polish

  • (cs) in reply to RobIII
    RobIII:

    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?



    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.

  • Kevin (unregistered) in reply to Oli
    Anonymous:

    Coldfusion is a WTF in itself



    I second that
  • (cs) in reply to Kevin

    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.

  • (cs) in reply to johnl

    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

  • (cs) in reply to Colin

    Sorry you're wrong - that's a big misconception about the use of * in the count function.

  • (cs) in reply to johnl
    johnl:
    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.

    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.

  • (cs) in reply to stinch

    I'd like to see the runners up to the prestigious prize.

    Just go to the back issues of this very forum. Pick any 10 WTFs, cobble them together randomly, and you have it.

    Simon

  • (cs) in reply to tufty

    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.

  • (cs) in reply to Mung Kee
    Mung Kee:

    So what's the secret pizza boy?



    <img src="whatever the pizza was">

    I'll hang my head in shame, now..
  • zeroWS (unregistered) in reply to Ladislaus
    Anonymous:

    <font face="Verdana" size="2">One word: Brilliant!</font>

    <font face="Verdana" size="2">Who's this genius, and where can I hire him/her?</font>



    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.

  • (cs) in reply to brazzy

    brazzy:
    I've seen the DB schema of another forum software with less functionality, and it was already pretty damn complex.

    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" [;)]

  • Barfusslaeufer (unregistered) in reply to anon
    Anonymous:
    hmm? i don't think i've ever seen any php/mysql code that used a loop to count a record set. mysql does have count(), you know... not to mention php has mysql_num_rows, which you get for "free" with the database result.


    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
  • (cs) in reply to brazzy
    brazzy:
    RobIII:

    AAARGH [:@]

    At least offer a PREVIEW option ... [:'(]


    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...


    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

  • (cs) in reply to Ytram

    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.

  • (cs)

    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>

  • (cs)

    Since it doesn't look like bookingsCount is a 'per client' variable, I don't think all the SQL that uses GROUP BY is the right idea. I think this would suffice:

    SELECT count(*) FROM Bookings
       WHERE Client_Num in (SELECT Client_Num from Clients) AND
             bookings_active_indicator = 'Y'

    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.

  • (cs) in reply to Kevin
    Anonymous:
    Anonymous:

    Coldfusion is a WTF in itself



    I second that
    any good reasons?

    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

  • (cs) in reply to kiriran
    kiriran:
    Anonymous:
    Anonymous:

    Coldfusion is a WTF in itself



    I second that
    any good reasons? 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

    Your capitalization & spelling is a real WTF.
  • Para||ax (unregistered) in reply to John Smallberries
    John Smallberries:
    kiriran:
    Anonymous:
    Anonymous:

    Coldfusion is a WTF in itself



    I second that
    any good reasons? 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

    Your capitalization & spelling is a real WTF.


    Your capitalization & spelling are a real WTF. :P

  • Justice (unregistered)

    Oh good god, have they never heard of a 'Join'?????  That whole block of code should be replaced with 1 SQL statement, hahahhahaa!

  • (cs) in reply to RobIII
    RobIII:

    <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>

    Like Alex said: PHP is for hobbysts.
    Real programmers use ASP.NET and VB.NET.
    Real programmers use Telligent solutions.

  • (cs) in reply to Savior

    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.

  • George Bezel (unregistered) in reply to johnl

    johnl:
    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.

    You idiot.

    johnl:
    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.

    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]
  • Joshua (unregistered)

    #q2.recordcount# would have solved his problem. he's terrible at cf, and sql

  • PiGuy (unregistered)

    [3.14159265358979323846264338327950...]

Leave a comment on “Slowed Fusion”

Log In or post as a guest

Replying to comment #:

« Return to Article