vote_type seems like the kind of thing that should be numeric if you want to do these kinds of comparisons efficiently, especially if you know the number of possible values is constrained and you don't need it to be changed by the user. Even if you do, it's better to have a vote_types table with a numeric ID

what do you return when the two highest vote_type's are not within 1?

You can do something like

SELECT vent_id, count(vent_id) FROM votes GROUP BY vent_id, vote_type ORDER BY count(vent_id) and it will give you an ordered list of the vent_id/count(vote_type) combos, where the combo with the highest count(vote_type) for any vent_id will be first.

If you want to restrict it to a particular vent_id just add a WHERE vent_id=N

Then you can just have the code compare the first couple rows (edit: and even use a LIMIT 2 if you want), which I think will turn out to be easier than doing all the logic in one query, although I think it's doable with a self-join and a CASE WHEN, or subqueries

Cheers. I agree with the vote types being numeric, but I didn't set them up that way at the time and I'm getting a bit too close to launching to bother right now.

I want to return all the vents that meet the equal or less than 1 criteria. So if there are none, return nothing. It just serves as one of 4-5 filters a user can apply.

you shut your whore mouth!

I meant to write count(vote_type) I'm pretty sure. in both the select list and the order by. I mean I'm not double checking right now but reading it back I'm fairly sure that's what I meant :P

oh yeah I even used count(vote_type) later on. Herp de derp

Gimp is great for many things. The most obvious is if you are looking to learn how to use a photo-editing program. It is also great if you are a poor schmuck like me who can't afford anything better. If you are a professional or are working in an environment where you are making money from photos and images, the price of PS will pay for itself in less than a month. Yes, I am asserting that Gimp is so bad for real world work that it slows you down by hours. Hell, I've experienced it multiple times myself, where a 20 minute job in PS would take several hours in Gimp (and still not up to professional quality), mostly because the fuzzy select is broken beyond practical use and pixel-zooming is less than satisfactory.

Of course, there is the plug-in ecosystem that is Adobe-only, in particular Pantone, and I agree that it is a terrible thing for openess. However, I don't think that Gimp has ever stated that it was meant to be a PS replacement, and no one has ever stepped up to the plate to take down that behemoth.

Other short-comings with Gimp include the paltry text-manipulation, no CMYK, no "smart objects" (no usable vector-conversions), etc.

With all that said, I still use Gimp because I'm cheap and I really don't enjoy working with image-manipulation software, so I have no desire to get much better than I am. I've learned that it is very good to make sure that, if you are creating images for a website, to opt strictly for pages that have a white background color.

Admittedly, you are a very good troll. I was about 80% convinced.

Yes, this is sort of what I told my bosses, and I of course, played the idiot and said I had no idea how to do anything of this sort. For the official record, I believe I could do it, but not getting paid enough.

I don't fault you for liking it. Certainly, "flexibility" is a great thing. I've talked to more than one CRM/ ERP/ [Solution] sales person in my life who trumped up the the customization angle. I asked one, who was irritating me to no end, to clarify, because I have poor comprehension skills, and I thought he said something about this costing more money than my company earns in a year.


Marketing people? No, it is the CEO giving the OK to present themselves this way. It is the entire company operating on this assumption, and the entire sales and CSR operating as if this is true. Basically, you have a group of people from the top to the bottom telling lies who know damn well they are telling lies to the customer to get them to call their silly 800 number, only to bait-and-switch them after SF swallows up all the license fees and the customer says, "but I want..."

That is why they are playing coy with us. We haven't got the consistency ball rolling in their favor yet, so of course they are going to act the mum and wait it out.

Careful Dave, SF is turning you into Lirva...

Yeah, I'll lay off that sauce for a while then.

I wanted to share a Rich Hickey talk. I think he encapsulates everything I felt was wrong about the music - programming worry-dream article that I debated with gaming_mouse.

http://www.infoq.com/presentations/D...on-Performance

Hope you enjoy it (and hate it, too. I don't care).

i agree that if you are even a little bit srs bzns, you should go directly to photoshop without passing go. i just need the occasional layer+mask for an hilarious meme image; gimp gets me from point a to point lol.

My #1 complaint about Gimp is that half the people that use it mispronounce the name.

GIMP is awesome.

Always add a dot.

I wonder how gimp compares to: http://pixlr.com

I've always used pixlr for light weight editing that's a bit beyond what irfanview can do.

dave don't argue. Everyone knows SF is crap, our ERP will be better.

As is Inkscape

Looking forward to the demo on Monday...

Work on this on my side won't start before April next year (possibly later depending on PhD).

Pulling in data to a website from a public google doc csv cannot be good...

Moar storie pleeze!

Not much to say, the data for this client's wordpress site tabular data comes from a direct php link to the google drive csv that anyone can edit. I guess its secure if you don't know the link? Maybe?

If you go to google's web search and add a site:docs.google.com/spreadsheet to your search it seems to find public files. I think you could modify that for various file types that google drive handles

so it's probably not impossible for someone to figure out the URL if they wanted

Michael, if you read this, its probably not worth commenting on threads that haven't been updated in 5 months.

bump