How to perform left outer join in C# LINQ to objects without using join-on-equals-into clauses? Is there any way to do that with where clause? Correct problem: For inner join is easy and I have a solution like this List< JoinPair> innerFinal = (from l in lefts from r in rights where l.Key == r.Key select new JoinPair { LeftId = l.Id,...
I have query which is going in the SENDING DATA state for very long period of time. Can someone please help me with this : below are details Mysql Query: select a.msgId,a.senderId,a.destination,a.inTime,a.status as InStatus,b.status as SubStatus,c.deliverTime,substr(c.receipt,82,7) as DlvStatus from inserted_history a left join...
I'm trying to join two tables, one is a table of tags, and another is a table that bridges tagID and slotID. I want to create a sproc that returns the list of tags, and a column of slots that use those categories. tagDetails tagID tagDescription 1 red 2 blue 3 green 4 purple tagBridge tagID slo...
Hello! Similar to selecting img[title="test"] can I somehow select images that have a style property of float set to left? I want to set left and bottom margins for them which don't apply to right floating images. Thank you. ...
Trying to figure out removing left recursion in context free grammars. I'm used to certain forms, but this one has me a bit boggled. S --> S {S} S | (A) | a A --> {S} A | epsilon I also have to design a decent parser, which I can do. However, figuring out this left recursion (especially on the first one) has me confused. ...
This is a performance based question, not a "I don't understand" or "best practice" question. I have a varchar field in a SQLServer database that is guaranteed to be longer than 7 chars. I need to extract a char(4) field consisting of the 2nd, 3rd, 4th and 5th chars in the varchar. For example if the varchar had the value 1234567890 I ...
I need to get the TOP and LEFT coordinates of the 5th paragraph on my page, or maybe the 6th paragraph, or the 8th, im just trying to figure out how to get the coordinates for any paragraph on the page I choose. I then need to insert a div 20px to the left of the top left of the paragraph i choose. Can anyone help? ...
===problem=== i'm using a LEFT JOIN, SQL expression, on 3 tables. i'm getting an unexpected error "JOIN expression not supported" from MS ACCESS 2007 when i try to run it. ===details=== these tables are all connected parent: is at the highest level child1: child of parent child2: child of parent grandchild1: child of child1 thi...
Hi, I have a question about the cell truncation (replaced with "..."): How to display the replacement "..." on the left side of a cell when the column is right-aligned? I'm using non-equal-width font, so I cannot just count the characters to do some string manipulation as a workaround, I need a solution. I believe there should be. To...
hi, I have a litte problem with a mysql query. I use 5 tables: user_has_data (uid, dataid); users (uid, uname); user_in_group(uid, groupid, data); groups(groupid, data, packageid); packages(packageid, name) all ids are PK. I want to build a sql query that finds a user, which belongs to a specified dataid, by its uname and checks if t...
I want my page to be centered in the users screen,say with width of 800px. How do I ensure that the div tags left and top attributes adjust correctly based on the users screen resolution? ...
I have many-2-many relation between Property and Feature. I have to extract results from Property table, but only if both or more Features are related. Ie. Property #1 is related to 'Swimming Pool' and 'Garden'. Property #2 is related only to 'Swimming Pool'. So when I ask for properties that has both 'Swimming Pool' and 'Garden', it sh...
Using jQuery or straight Javascript, I'm looking for the best way to find the leftmost div (or in general the DOM element with the minimum or maximum position on either axis). So far I have two solutions: Iterate through the div objects that I want to consider, saving the smallest left position found. Build an array of objects and us...