You searched for the word(s): userid:841100

More Search Options

RSS Available

• Re: Entity Sql - Count function

  well it's a little bit late but thanks a lot for your help :)

  Posted to ASP.NET Dynamic Data (Forum) by gameover88 on 11/18/2009

• Re: change my username

  what if we want to cancel our membership and sign in again with a different username? if we can(cancel our membership), could someone tell where i can do this?

  Posted to Feedback on this website (Forum) by gameover88 on 11/18/2009

• Re: change my username

  yes i did that already, but thanks anyway. :)

  Posted to Feedback on this website (Forum) by gameover88 on 11/18/2009

• Re: Entity Sql - Count function

  [quote user="andreadottor"] I don't have try, but in your query missed "as c" near Comments, and you must indicate the name of the class of your ObjectContext [/quote] i can't believe how i forgot this.) thanks. now i'm writing this statement: SELECT m.MediaTitle, (Select COUNT(c.MediaID) FROM MediaPortalEntities.Comments AS c WHERE c.MediaID = m.MediaID) AS TotalComments FROM MediaPortalEntities.Medias AS m But during the run time this is what it shows in the datalist

  Posted to ASP.NET Dynamic Data (Forum) by gameover88 on 7/3/2009

• Entity Sql - Count function

  Hi. i'm trying to write an e-sql statement that retrieves all records in a table called 'Medias' and also, number of the comments those belong to each Media, by MediaID (in the Comments table). i've tried several statements like this but i always get error: SELECT m.MediaTitle, m. SuggestedBy, m.Summary, (Select COUNT(c.MediaID) FROM Comments WHERE c.MediaID = m.MediaID) AS TotalComments FROM Medias AS m i know this may sound easy but i'm in trouble with this :(. i would appreciate

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by gameover88 on 7/3/2009