« first day (713 days earlier)      last day (3295 days later) » 

1:00 AM
MIN() is an aggregate, like SUM(), AVG(), MAX() etc.
 
Yes, I just looked them up.
So, what is up with it?
 
Aggregate means you're combining multiple rows into one.
 
Is there an aggregate IGN function to just tell it to work?
JK.
 
So any column in your select needs to have an aggregation applied to it, or in the group by.
 
But if I put it in the GROUP BY, it doesn't work!
 
1:01 AM
(if any)
 
So, which aggregate should I use?
 
You need a CTE or a subquery.
 
Oh.
OK.
 
Or hmm, let me look at how Phrancis did it in his.
Uh, @sᴉɔuɐɹɥԀ does yours actually work?
 
Yes, except it does something a bit different than yours
 
1:03 AM
Oh, there it goes.
 
It still isn't working...
It is still complaining with the same error message.
 
link?
 
How is that a sanity check?
 
1:06 AM
I think I need a custom version of SQL that just works, JK.
 
Everyone gets that version after they've earned it.
2
 
OK, I think I need to step back and think the problem through again.
 
@nhgrif We're looking for the one first post, yet we are getting multiple results.
 
Wait, @Hosch250 stop for a second, let me explain in plain English what your broken query is doing and see if that helps.
 
@nhgrif do you have that blog you wrote about comments handy?
 
1:08 AM
Because usually in SQL, when you're new to it, you don't understand what's actuallywrong with something.
 
Well there ya go. Why is that not your code? Dp you see what I'm getting at? — RubberDuck 2 mins ago
 
I know what it is doing when I have it in the GROUP BY.
 
OK, fire away.
 
Thnx
 
1:10 AM
well, actually first, let me simplify your query
You don't need the Users table.
SELECT DISTINCT
    OwnerUserId AS [User Link]
  , Id AS [Post Link]
  , MIN(CreationDate) AS [Creation Date]
 FROM Posts
 WHERE PostTypeId = 1
 GROUP BY OwnerUserId, Id
 ORDER BY OwnerUserId
 
0
Q: Apache Fluent Client's transitive dependency on HttpClient causes NoClassDefFoundExceptions

Jeroen VannevelI have the following gradle file: apply plugin: 'com.android.application' android { compileSdkVersion 21 buildToolsVersion "21.1.2" packagingOptions { exclude 'META-INF/LICENSE' exclude 'META-INF/NOTICE' exclude 'META-INF/DEPENDENCIES' } defaultConf...

 
How old is SEDE's data?
 
REFRESHES EVERY SUNDAY
 
Updated every Sunday, I believe.
 
Whoops
 
1:15 AM
Ah, thanks
 
SUNDAY SUNDAY SUNDAY COME DOWN TO THE ARENA AND SEE MONSTER TRUCKS AND FRESH SEDE DATA
5
 
Now it isn't posting the User Id.
 
^I noticed that too
 
Some User Ids are NULL from migrated answers.
or deleted users, or something.
Click that link. We can agree these queries are returning the same results, right?
 
You said I don't need the Users table.
 
1:17 AM
You don't.
Not for this.
 
User Link                            Post Link                                                                                                                                              Creation Date
------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------ -------------
null                                 Retrieving context menus from the form                                                                                                                 2011-
^^ plain text results
 
But you are using it!
 
No he's not.
 
SELECT DISTINCT
    OwnerUserId AS [User Link]
  , Id AS [Post Link]
  , MIN(CreationDate) AS [Creation Date]
 FROM Posts
 WHERE PostTypeId = 1 AND OwnerUserId IS NOT NULL
 GROUP BY OwnerUserId, Id
 ORDER BY OwnerUserId
 
He's using the reference to it (foreign key)
 
1:18 AM
Then why did you send my this link?
 
So you could see the queries side by side.
 
Ohh, I didn't see the bottom one.
 
Top is yours, bottom is mine.
SELECT DISTINCT
    OwnerUserId AS [User Link]
  , Id AS [Post Link]
  , MIN(CreationDate) AS [Creation Date]
 FROM Posts
 WHERE PostTypeId = 1 AND OwnerUserId IS NOT NULL
 GROUP BY OwnerUserId, Id
 ORDER BY OwnerUserId
Okay, queries, to me, start at the "FROM" (and joins)
 
^Ditto
 
So at first, our data set is everything in the Posts table.
 
1:20 AM
OK.
 
... where PostType is a question and user ID isn't null. (A user exists for the post)
 
Yeah, I have it working now.
 
What columns are we interested in? OwnerUserId (are we, actually?), Id, CreationDate
 
Yes, I need that to debug it.
Well, with you walking me through it I won't need to debug it.
 
When we group by OwnerUserId, we say "I only want one row per owner user Id, and the rest of the columns should use the aggregation logic I provide"
When we group by OwnerUserId and Id, we say "I want one row per OwnerUserId/Id pair, and the rest of the columns should use the aggregation logic I provide."
But is that what we want?
Do we want one and exactly one row for every OwnerUserId/Id pair?
 
1:24 AM
We want the first.
 
We don't want either, really.
 
Don't we?
Well, we want one per OwnerUserId with the first post by the user.
 
Err, yeah, we want exactly one row per user.
 
The Id is really just to support this data.
 
Every user who has asked at least one question should have exactly one row in this dataset.
 
1:26 AM
So, I need to aggregate the Id somehow.
 
Do you?
 
aw, I missed 200 by 5 points yesterday... thanks for the checkmark @Hosch250!
Monking!
 
@Mat'sMug Whoops.
 
The aggregation options are MIN, MAX, SUM, AVG
 
Well, it would seem that way, but I guess I probably don't want to.
COUNT too.
FIRST and LAST.
 
1:27 AM
and yes, COUNT
Is there FIRST and LAST? I've not seen those.
 
So, what I really need is another CTE, you said.
According to W3Schools.
They don't appear to work here though.
 
SEDE is Microsoft SQL Server. You can use MSDN.
 
Yeah. I'm on that page seeing if there's one we can apply here.
When I did this, I didn't use a GROUP BY, remember.
I think it can be done with GROUP BY though.
 
Yeah.
 
1:30 AM
It can, that's how I used it
But I used JOINs for the logic instead of CTEs
 
You can't use a CTE without using a join...
CTE is just a matter of organization.
 
Well, yes of course
Mine would work in MySQL though ;D
 
Mine would pretty easily work in MySQL, it'd just be a mess.
 
What are you trying to report on?
 
Everything and nothing.
I am trying to learn SQL.
 
1:37 AM
OK, I'm OK with that ;-)
 
@rolfl Don't show him.
 
I can get it to do almost anything EXCEPT what I want it to.
@nhgrif What is that DISTINCT doing on yours?
 
Nothing.
It's redundant.
 
OK.
 
What's it doing on yours?
 
1:38 AM
First posts?
 
I don't know, I saw it on the thing you posted for me to look at.
 
OK, that's cool. I'm fighting Java profilers, so you go do battle with the databases ...
 
Are there any specific keywords I should know before I continue, other than the ones I've already used?
Also, what is the zombie count?
It wasn't posted.
 
@Duga died.
 
Oh dear.
 
1:41 AM
@sᴉɔuɐɹɥԀ I... can't be arsed to figure out how you're doing it the way you're doing it with grouping exactly... but you're also returning results differently than I am.
 
I'll turn a requiem on for you, @Duga
So, who is right?
 
@Hosch250 Try joining the posts table to itself on the CreationDate column.
 
Oh, that sounds clever.
 
That's your big hint from me.
 
@Duga didn't die. She's just taking a nap.
 
1:43 AM
Do you mean hibernating?
 
Maybe she went skiing.
 
@Hosch250 And once you figure out first questions, figuring out first answers posted to those questions should be simple and you should be able to do that part without help.
 
@SimonAndréForsberg What is @Duga's favorite vacation hobby?
@nhgrif Right, I'll try.
 
So... There's a Hot Programmer's question that has me thinking..
 
@nhgrif It's just a clever little join, mostly
FROM Posts AS q
INNER JOIN Posts AS a
  ON q.Id = a.ParentId
  AND q.PostTypeId = @QuestionType
  AND a.PostTypeId = @AnswerType
 
1:45 AM
Is "Test First" a dangerous misnomer?
 
Those variables contain 1 and 2 ints, respectively
 
Does saying it lead too many people to skipping the design?
 
Should I understand the different between an INNER JOIN, an OUTER JOIN, and a JOIN before I continue?
 
@sᴉɔuɐɹɥԀ Yes, all that join does is link answers to questions.
@Hosch250 No. You just need INNER joins.
 
OK.
 
1:45 AM
We can talk about the difference later.
 
Half the trouble is I don't know the legal syntax yet :(
 
@Hosch250 JOIN == INNER JOIN
 
OK, so just stick with JOIN.
 
and you don't need OUTER. Just LEFT or RIGHT
 
@sᴉɔuɐɹɥԀ I don't see how you make sure the question is someone's first asked question (and we both know you're not looking only at first answer)
Or FULL
Or CROSS
or whatever.
 
1:47 AM
right
 
Evil ^
 
Nevermind. you don't need those.
You only need INNER and LEFT.
I've never used RIGHT.
I join my tables in the correct order.
 
MIN(q.CreationDate) AS [Q Date]  -- @nhgrif just a simple aggregate
 
same as LEFT really - just the other way around
 
You can get away without Left quite often too.
 
1:48 AM
As a left-handed person, I assure you, righties are not just as good as us.
3
Wait, what?
 
I've found WHERE EXISTS performs better in many situations.
 
And my Group By is basically just a copy/paste of the select, with aliases removed
To be fair, yours is a bit faster (and probably more elegant)
 
I use WHERE EXISTS a lot too... but I don't see how that's a replacement for left joining...
 
So, I should be doing something like this?
> MIN(CreationDate) [Creation Date] JOIN (something)
 
@nhgrif Buying left handed tools are sometimes more expensive
 
1:49 AM
I've used CROSS JOIN several times, to join two tables where I needed every row of table A for each row of table B - how else would I do that?
 
@sᴉɔuɐɹɥԀ You're just displaying the min date then...
 
@Quill left-handed guitars are
 
@Hosch250 That'd be a syntax error
 
6 mins ago, by RubberDuck
@Duga didn't die. She's just taking a nap.
 
That is what I got.
 
1:49 AM
9 mins ago, by rolfl
OK, that's cool. I'm fighting Java profilers, so you go do battle with the databases ...
 
What do you get when you cross two syntax errors?
 
^^^ Duga CPR
 
Would that be a lousy programmer?
 
@Hosch250 You get... one syntax error to fix, and then another to fix later.
 
Okay... @Hosch250... do you want to see my First Question query and see if you can figure out from there how to get to the first answers?
 
1:50 AM
Not yet.
 
Okay.
I told you that you need to join things on creation date, right?
 
what do we call the value of the parameter again guys?
argument ?
 
> FROM Posts JOIN (something with CreationDate)?
 
So what are you going to join?
 
So, you mean like that?
 
1:51 AM
@Mehrad argument
 
@rolfl cheers
had a mind blank
 
If it's not very heated, it's sometimes just called a disagreement though.
 
-1
Q: javascript function on click

Itachi SamaIts not really working without the alert() //page var domain = "http://localhost/new/"; var home = "#home"; var activities = "#activities"; var about = "#about"; var information = "#information"; var ...

 
@nhgrif Isn't the minimum creation date of a post basically guaranteed to indicate the first post? You're doing that in your CTE as well, same idea, just written differently
 
Yes... but you're just aggregating the min...
Displaying it in the select doesn't filter what rows you're showing...
 
1:53 AM
@nhgrif I'm not saying that Where Exists completely replaces a Left Join, just that there's little reason to do this.
 
GROUP BY
    qUser.Id
  , qUser.Reputation
  , q.Id
  --, q.Tags
  , q.CreationDate -- here
It's also grouping by the selected minimum creation date
 
I guess I need to look at your query again.
 
New Duga vvvvv
 
StackMonkey Greets You
 
LEFT OUTER JOIN foo
    ON bar.Id = foo.Id
WHERE foo.Id IS NULL
 
1:54 AM
THREE LITTLE MONKEYS JUMPING ON THE BED
5
 
Hey there @StackMonkey!
 
Little slow today
 
Hmm... I can either go to bed, or stay up half the night writing a rant about how "Test First" might be causing damage. Decisions...
 
> "Trust your instincts, Fox Duck!"
4
(dated videogame reference, sorry...)
 
DO A BARREL ROLL!
 
1:58 AM
0
Q: Basic functions (sum, len, etc.) with recursively-flattened arguments

TigerhawkT3Based on the excellent answers provided for my previous question, I've thoroughly revised my attempt at "deep" versions of all, any, etc. It uses the recommended encapsulated flattening function, and streamlines some unnecessary stuff. def flatten(*sequence, preserve=False): for item in sequ...

 
2581
Q: How do I correctly pass the string "Null" (an employee's proper surname) to a SOAP web service from ActionScript 3?

billWe have an employee whose last name is Null. He kills our employee lookup application when his last name is used as the search term (which happens to be quite often now). The error received (thanks Fiddler!) is <soapenv:Fault> <faultcode>soapenv:Server.userException</faultcode> <faultst...

that's amazing
 
LOL!!!
 
I'm going to change my last name to Null tomorrow. Let's see how SNAP likes that!
 
It'll.... snap?
 
> FROM Posts p1 JOIN Posts p2 On p1.CreationDate = p2.CreationDate
That doesn't work, but am I sort of on the right track?
 
2:02 AM
No
 
Figured as much.
 
StackMonkey Greets You
 
Hi, @StackMonkey.
 
Restart, "live"
 
Even if it were, the performance would likely be horrible, unless CreationDate was indexed, and still... you don't want to join on a non-ID column unless you absolutely have to
 
2:03 AM
@JeroenVannevel where there's a will user, there's a way (to break all the things).
 
@Hosch250 This is the beginnings of the right track. You need 1 more condition in your ON clause. Use the AND keyword.
 
Imagine all the bugs this person must have caused in systems
 
OK.
 
Well, I think anyway.
You might be able to get it to work this way.
 
Check out Programmers.se or Code Review - Boo. — rolfl 45 secs ago
 
2:09 AM
^^ that was a test.... Duga's shadow is here.
 
@Hosch250 This might help. I'm leaving it with you as I head upstairs to bed. data.stackexchange.com/codereview/query/edit/302461#resultSets
 
OK, thanks.
 
Figure out how to turn those two datasets into one.
 
Night @Hosch250 !
 
Good Night
 
2:12 AM
@sᴉɔuɐɹɥԀ Not me.
 
Oh, whoops
Night, @nhgrif !
 
'night!
 
0
Q: ArrayBlockingQueue: concurrent put and take

veritasHi I have implemented an ArrayBlockingQueue (put and take) on the lines of LinkedBlockingQueue i.e using two locks so that my take should not block my put. For more information please see this stackoverflow questions http://stackoverflow.com/questions/11015571/arrayblockingqueue-uses-a-single-lo...

 
2:30 AM
Well, this is what I have so far:
WITH UserPostIds(UserId, PostId, PostCreationDate)
AS
(
  SELECT Q.OwnerUserId [UserId], Q.Id [PostID]
  ,Q.CreationDate [CreationDate]
  FROM Posts Q
  WHERE Q.PostTypeId = 1
)


SELECT
p1.OwnerUserId [User Link]
,PostId [Post Link]
,MIN(p1.CreationDate) [Creation Date]
FROM  Posts p1 JOIN UserPostIds On UserId = p1.OwnerUserId AND PostCreationDate = p1.CreationDate
WHERE (p1.PostTypeId = 1 AND p1.OwnerUserId IS NOT NULL)
GROUP BY p1.OwnerUserId, PostId
ORDER BY p1.OwnerUserId
It still isn't working, and I need to do the dishes now.
 
2:41 AM
nhgrif pointed out a flaw in mine too, working on fixing that. Mine had same problem that I said yours had earlier, but I did not notice it because of the way the data set was ordered
 
lunch time
 
0
Q: Generate URLs for images hosted on Google drive

Dan DonoghueThe brief is to be able to generate links to artwork files and PDFs easily and quickly without having to go to the site and find what you want, right click and copy location. I have added an image box which shows the user the image upon clicking one. The links are taken from a dir listing in Goo...

 
3:17 AM
monking
 
monkin
 
Am I slowly turning into a spammer?
0
A: Excel forms: identify unused code

Mat's MugI'm developing Rubberduck, an open-source COM add-in for the VBE written in C# that has a code inspections feature that, as of version 1.3 (scheduled for 2015/04/18), will include an inspection that does exactly that: This inspection isn't specifically looking for unused click handlers as the ...

 
If it helps him out then no
 
@Mat'sMug you might enjoy this comment and the following one github.com/dotnet/corefx/issues/461#issuecomment-77494862
2
 
3:25 AM
LOL!
 
Sam Harwell (1st commenter) is behind ANTLR BTW
 
ah, i did not know
 
AGH! Enough SEDE for tonight!
The more I try to sanity-check, the more broken my query becomes
 
I'm voting to close this question as off-topic because it is about optimizing working code. It is more suitable for Code Review. — Ken White 16 secs ago
Thank you for all the help. As suggested, I will move the question to Code Review. — user4075830 7 secs ago
 
3:44 AM
@StackMonkey How many zombies are there?
 
0
Q: Speeding up Access query with a calculated field calling a VBA function

AnthonyAt work I have a Microsoft Access database of employees with fields such as employee's manager, employees email, and employee ID. My duties include updating this database and validating entries generated. Biweekly when I run the VBA script to validate records, I am faced with between 25K and 30K ...

 
3:59 AM
@CaptainObvious I'm sure going through 25K records using an if-else statement, one by one, is very slow indeed. Sadly I don't know that much VBA...
 
4:10 AM
0
Q: Inverting an image

user4075830The problem is that I am trying to modify the code to invert the image in C and optimize it to make it run faster than the original by any method I could think of. After tried to use blocking and loop unrolling, it still does not seem to speed up. Maybe I did it in a wrong way as I'm not really f...

0
Q: Coding Animations with css and js and code performance

samI have coded following DEMO HTML <ul id="test"> <li class="a">1</li> <li class="b">2</li> <li class="c">3</li> </ul> <ul id="test2"> <li data-prod="a" class="animated">1</li> <li data-prod="b" class="animated">2</li> <li data-prod="c" class="animated">3</li> </ul> CS...

 
So, I'm not getting why this is returning all the Posts.Id values in Q1 when there is only the subsection of first post CreationDate values in Q.
SELECT Q.OwnerUserId [User]
,Q1.Id [Post Link]
,Min(Q.CreationDate) [Creation Date]
From Posts Q JOIN Posts Q1 On Q1.CreationDate = Q.CreationDate
Where Q.PostTypeId = 1 AND Q.OwnerUserId IS NOT NULL
GROUP BY Q.OwnerUserId, Q1.Id
Order By Q.OwnerUserId
Shouldn't that eliminate all records that don't match the CreationDate in Q?
 
0
Q: Setting sass environment variables in Grunt

DamonBG: I am into building functional prototypes, but also for outputting css and js, which means we have 2 times we build out our code.. once as a demo with HTML files (we are using assemble.io) and another, where we are building out the files to be uploaded to production (an Enterprise CMS). Most ...

 
Well, actually, if two users posted a question at exactly the same datetime, that might have problems.
So, this should solve the problem:
SELECT Q.OwnerUserId [User]
,Q1.Id [Post Link]
,Min(Q.CreationDate) [Creation Date]
From Posts Q JOIN Posts Q1 On (Q1.CreationDate = Q.CreationDate AND Q1.OwnerUserId = Q.OwnerUserId)
Where Q.PostTypeId = 1 AND Q.OwnerUserId IS NOT NULL
GROUP BY Q.OwnerUserId, Q1.Id
Order By Q.OwnerUserId
But, it still doesn't work...
@nhgrif If/when you have time tomorrow, could you explain why this isn't working?
I might not be around most the day, but I'll read it when I have time.
Bed time now.
 
4:26 AM
Look at your Join carefully. What does it actually do?
OK. Good night
 
I don't know.
 
Good Night
 
I might just start from scratch tomorrow, at least mostly. I need to get better with data subsets.
 
Shouldn't it select the rows of Q1 that match the requirements and those rows only?
I really need to go now, I didn't get to bed until 1 AM last night.
 
Yeah, me too. Good work, glad we're all learning things :)
TTGTB
 
4:42 AM
0
Q: Dependency injection thread safety

crseuserpublic class MyCacheProvider : ICacheProvider { private readonly ISerializer _serializer; public MyCacheProvider(ISerializer serializer) { _serializer = serializer; } } Serializer implementation: public class JilSerializer : ISerializer { public string Serialize<T>

 
YES!!!!!!!
I am not 100% sure what changed, but I believe the new way involves having the first dataset return and actually get separated from the underlying table:
WITH QStuff(OwnerId, CDate)
AS
(
  SELECT Q.OwnerUserId [OwnerId], MIN(Q.CreationDate) [CDate]
  FROM Posts Q
  WHERE Q.PostTypeId = 1 AND Q.OwnerUserId IS NOT NULL
  GROUP BY Q.OwnerUserId
)

SELECT OwnerId [User]
,Q.Id [Post Link]
,CDate [Creation Date]
From QStuff JOIN Posts Q On (Q.CreationDate = CDate AND Q.OwnerUserId = OwnerId)
GROUP BY OwnerId, Q.Id, CDate
Order By OwnerId
 
QStuff is an alias for Posts
 
Well, it is working now.
 
then you join posts with posts
 
That wasn't working.
I don't know why, but it wasn't working to directly join them, but this works.
 
4:55 AM
I
*What is this for exactly?
 
It gets the set of first posts by users and the posts' ID.
And the post time.
 
Instead of [User]
write [User Link]
 
I had that originally, but I wanted to check a few people's ID specifically.
 
Ah, okay'
 
I'm off to bed now, midnight.
Nobody really helped me after you gave me that hint :)
 
5:25 AM
Please could you explain us the intention of your code? If you want a code review please post it codereview.stackexchange.comRaistmaj just now
 
0
Q: Search and Pagination - SESSION or GET variable?

Logan WayneI created a page where it has a search field and a dropdown list (for filtering the searched keyword). At the same time, also has a pagination to reduce the overflowing of result data. My first logic that comes into my mind when I created the page is to store into a session variable the searched...

 
 
1 hour later…
0
Q: Javascript/jQuery OOP

Vainglory07Right now I'm studying OOP with js/jquery and so far upon reading tutorials over the internet and with the helping hand of google, I come up with a way to do it based on my understanding. Technically, I'm not pro (just in case you ask me why I'm doing it this way) but this is how I do it: " us...

 
7:08 AM
Maybe Code Review suits this question better. — Raptor 20 secs ago
hi @BenjaminGruenbaum, kindly help me here codereview.stackexchange.com/questions/87155/… i will delete this post. thank you — Vainglory07 55 secs ago
 
 
1 hour later…
8:31 AM
0
Q: Attemp to make the code synchronization free

Shweta AggarwalI have tried to make modification in below specified code by removing synchronized and replacing Integer with AtomicInteger . Is it correct and going to ensure that code does not run into synchronization issue. Please provide your valuable inputs. Thanks, Shweta /** * */ package...

0
Q: Return Class based on Interface and Enum

Obsidian PhoenixI have a number of classes that implement one or more interfaces. I need to be able to retrieve the correct class corresponding to a given Enum value, but as a type of a specific interface. Classes #region Interfaces public interface IOrderSend { void SendOrder(); } public interface ICust...

 
8:56 AM
for working code you should ask on codereview.stackexchange.comvikingosegundo 55 secs ago
 
0
Q: Perform SELECT INTO Statement and add Primary Key afterwards

JoelHow can I improve this TSQL Statement in terms of performance? SELECT Code, Description INTO [DBApps_Pulse_WarehouseAreas].[dbo].[Tbl_Partmaster] FROM SYSDataBridge.dbo.View_Pulse_Partmaster_Synchronized ALTER TABLE [DBApps_Pulse_WarehouseAreas].[dbo].[Tbl_Partmaster] ADD PRIMARY KEY (Code)

 
You are probably looking for the Code Review Stack Exchange site: codereview.stackexchange.comUnderyx 52 secs ago
 
Is this the right place to ask detailed follow-up questions to responses I receive on the CodeReview site?
 
9:13 AM
@StackMonkey - you seem to post links to the main code review site a lot, but you didn't really answer my question. I've posted to that site, then I get an answer, and I have a lot of follow up questions. Do I post them as comments to the right answer or do I post them here? When I post too many comments, it suggests I move to a chat room
 
0
Q: Python script refractoring

Alex VidisGot an internship invite as a Junior Python Developer and have a task to: Write a python script that detects changes in given type of files (*.php or *.js) in that path and reports it in a form like this: checking PATH at TIME_AND_DATE file: "filename with relative to docroot path" has c...

 
Monking
 
9:36 AM
0
Q: MVC4 Unit Of Work with Entity FrameWork

VIVEK P SI am designing a new asp.net MVC4 application.I know that context class generated by EF is Unit of work and Dbset is the repository class.So I am just avoiding the extra abstaction. I want to know whether i am following the correct pattern or not. Sample Code : Context class(Generated By EF) p...

 
Spend an hour on figuring out a bug yesterday evening... Figure out today that there's a method call on som eplace where it totally should not be
 
9:55 AM
As Underyx said, this is more suited to Code Review, but you should fix the indentation errors before submitting this code for review. Also consider encapsulating your code into one or more functions. — PM 2Ring 30 secs ago
 
0
Q: Working with group of checkboxes in MS Excel

GuzzymanI have the following checkbox as depicted by the image below: The checkboxes are in 3 groups. Confidentiality, Integrity ad Availability. When the first in is clicked, the Confidentiality turns Red for High, Orange for Medium and Green for Low. This is a lot of work to be done as you need to ...

 
Good you adding code. You could edit your question to indent the code properly - makes it easier to read and more likely to get help. Asking people to debug an issue is likely to be flagged as off-topic here. Maybe you're better of on StackExchange's CodeReview site. — cfi 54 secs ago
 
Darn this: How many times do I need to keep telling myself that I absolutely hate JavaScript!
I was passing a function into a method as function() instead of function... things blew up.
 
10:10 AM
1
Q: Simple 3…2…1 countdown in iOS app

Léo DerboisI would like to display a 3...2...1 countdown on my iOS app (before to take a picture) but I didn't find an elegant solution. I don't want to make a Countdown app with an NSTimer. For me the important is to keep all code in the same method, use a system like Block. What I've done : self.infoLab...

 
@JasonB If you have a lot of follow-up questions, Chat is indeed a better place for a discussion than in the comments. (StackMonkey is a bot, and won't answer you.)
@skiwi That's your fault, not JavaScript's. Mixing up a function call and a function reference would cause your code to blow up in any language.
 
10:29 AM
0
Q: how do i use addStatusListener( .....) and display method() can be used

SisaI am trying to create an add on for open office. The addon has to count number of words in each paragraph and display them. and take each sentence in a new line the put it in a text box to draw Processs flow diagram

 
@200_success Except that in statically typed languages it'd give an error
Bugs like these are damn hard to trace down and would cost quite some money if it were in a business
 
Greetings, Programs.
 
0
Q: Correct usage of mocking libraries, specifically Mockito

FinalFivewe've been reviewing some legacy code and have found differences in the prefered approach to how to write tests using Mockito. Both the following tests pass but which one is better and why? @Test public void testA() throws PersistQueueException { final UserTokenVo userTokenVo = new UserToke...

 
hey @Donald.McLean
 
10:48 AM
I hate computer upgrades.
 
Just looked at the Flow extension for JavaScript... Does that mean there is still hope?
 
@Hosch250 Now we need to figure out why you and I have different results: data.stackexchange.com/codereview/query/302717 I can't see an obvious problem with either.
 

« first day (713 days earlier)      last day (3295 days later) »