left (2,613)


c# - How do I most elegantly express left join with aggregate SQL as LINQ query

c# - How do I most elegantly express left join with aggregate SQL as LINQ query

SQL: SELECT u.id, u.name, isnull(MAX(h.dateCol), '1900-01-01') dateColWithDefault FROM universe u LEFT JOIN history h ON u.id=h.id AND h.dateCol<GETDATE()-1 GROUP BY u.Id, u.name…


How to create a tree-view preferences dialog type of interface in C#?

I'm writing an application that is basically just a preferences dialog, much like the tree-view preferences dialog that Visual Studio itself uses. The function of the application is simply a pass-thr…


html - How can you customize the numbers in an ordered list?

How can I left-align the numbers in an ordered list? 1. an item// skip some items for brevity 9. another item 10. notice the 1 is under the 9, and the item contents also line up Change the character a…


javascript - How do I get the(x, y) pixel coordinates of the caret in text boxes?

I am using jQuery and trying to find a cross browser way to get the pixel coordinates of the caret in<textarea>s and input boxes such that I can place an absolutely positioned div around this locatio…


.net - What is the best way to share MasterPages across projects

Suppose you have two seperate ASP.NET Web Application projects that both need to use a common MasterPage. What's the best way to share the MasterPage across projects without having to duplicate code?…


c# - Creating a LINQ select from multiple tables

This query works great: var pageObject=(from op in db.ObjectPermissions join pg in db.Pages on op.ObjectPermissionName equals page.PageName where pg.PageID== pag…


javascript - How can I resize a swf during runtime to have the browser create html scrollbars?

I have a swf with loads text into a Sprite that resizes based on the content put into-I'd like though for the ones that are longer than the page to have the browser use its native scroll bars rathe…


Is there a way to perform a circular bit shift in C#?

I know that the following is true int i=17;//binary 10001 int j=i<< 1;//decimal 34, binary 100010 But, if you shift too far, the bits fall off the end. Where this happens is a matter of the s…


ruby on rails - How can I count the number of records that have a unique value in a particular field in ROR?

I have a record set that includes a date field, and want to determine how many unique dates are represented in the record set. Something like: Record.find(:all).date.unique.count but of course, that…


SQL Query, Count with 0 count

I have three tables: page, attachment, page-attachment I have data like this: page ID NAME 1 first page 2 second page 3 third page 4 fourth page attachment ID NAME 1 foo.wo…





right join how with and sql from example multiple not