Comments by JChrisCompton

JChrisCompton 2-Jan-18 10:13am View

"... if you fear StackOverflow"
isn't that why we're on CodeProject instead? ;-)

JChrisCompton 27-Aug-12 13:14pm View

Yeah, maybe... I'm too close to my deadline to mess with it much more. I just don't know enough (or I'm not practiced enough) to make much headway - a little knowledge is a dangerous thing :-)

JChrisCompton 27-Aug-12 12:59pm View

Oops. Duh. Corrected in original question.
I meant to say: WHERE Agency=@Agency

I changed the source code to prevent everyone from knowing my schema (because that's the rule) and mispasted that field when I was recreating the SQL.

JChrisCompton 27-Aug-12 12:25pm View

This would probably work if those were the only two fields in the table, but it is returning a division name for each row that matches pAgency==Agency.

I should have specified that there are multiple people in each division.
Is there anyone listening that can tell me how to change the above to SELECT DISTINCT division FROM tEmp ?

JChrisCompton 7-Jun-12 13:12pm View

That's okay, I realized and swapped them - thanks again!

JChrisCompton 7-Jun-12 12:56pm View

Yes + yes
I did NOT think about the db hit - I knew better though :-)
I did have a clean up the code period (Response.Write is left over from before the controls were there).
Thanks!

JChrisCompton 7-Jun-12 12:34pm View

I got an error trying this:
"LINQ to Entities does not recognize the method 'System.String Concat(System.String[])' method, and this method cannot be translated into a store expression."

Did I do it wrong, or is this functionality not available in EF 4.0?

Comments by JChrisCompton (Top 7 by date)