Is there an easy explanation for what this error means? request for member '*******' in something not a structure or union I've encountered it several times in the time that I've been learning C, but I haven't got a clue as to what it means. ...
Hello. I have a query with a long chain of CTEs which ends with SELECT RegionName, AreaName, CityName, SubCityName, StreetName FROM tDictionaryStreets UNION ALL SELECT RegionName, AreaName, CityName, SubCityName, StreetName FROM tDictionaryRegions The execution time of this query is 1450 ms. When I execute these 2 SELECTs separatl...
Let's say I have a class with union members in it: class ClassX { public: union { StructA * A; StructB * B; }; } If I have pointers x1 and x2 to different ClassX objects, does this: x1->A = x2->A; Have the same effect as this: x1->B = x2->B; ? Thanks. ...
I need to union several tables with the different structure in Microsoft Access. For example I have table: table1 (column_a,column_b,column_c), table2 (column_a,column_c), table3 (column_d) SQL looks like follows: SELECT table1 column_a,column_b,column_c, Null as column_d FROM Table1 UNION SELECT table2 column_a,Null as column_b, co...
Some C++ compilers permit unnamed unions and structs as an extension to standard C++. It's a bit of syntactic sugar that's occasionally very helpful. What's the rationale that prevents this from being part of the standard? Is there a technical roadblock? A philosophical one? Or just not enough of a need to justify it? EDIT: Sorry, ...
I have two tables that I want to query and merge based on a category_id. My events table has a column called event_category_id that creates a relationship between the event and it's category. The value is an int. In my categories table I have a column called category_id which is what I want to match on and replace the int value with ...
I have made a structure for ints and pointers etc. as might be used in LISP. A pointer is at least 8-byte aligned so tag=0. An integer is 29 bits and has a tag of 1. Other types have different tag values. struct Atom{ union{ Pair *pair; struct{ unsigned tag :3; union{ int ...
Let's say I have a list of objects: var items = new { new { Order = 0 }, new { Order = 1 }, new { Order = -1 }, new { Order = 3 }, new { Order = 2 }, new { Order = -1 } }; I need to order it so that items with "Order > -1" be on top of the list ordered by Order ascending, and remaining items with "Order == -1" ...
I don't know how I can do several union with a distinct. When I use .Distinct with an IEqualityComparer an exception in threw : LINQ to Entities does not recognize the method 'System.Linq.IQueryable' My code is var union = query.Union(query1).Union(query2); union = union.Distinct(new EqualityComparerTransaction()); ...
I have used unions earlier comfortably; today I was alarmed when I read this post and came to know that this code union ARGB { uint32_t colour; struct componentsTag { uint8_t b; uint8_t g; uint8_t r; uint8_t a; } components; } pixel; pixel.colour = 0xff040201; /* ---- somewhere down the...
Hello, I have a list of 9 user id's and want to select 3 entries per user id. My current query looks like this. SELECT * FROM entries WHERE user_id IN (1,2,3,4,5,6,7,8,9) LIMIT 27 Some users have many more than 3 entries, so I want to limit the results of this query to 3 entries per user. I tried making a UNION of 9 separate querie...
Hello, I want to query a table so that it´s ordered the following way: 1) "entry" 2) "entry#" 3) "entry something" 4) "..entry.." I did this via Union All and 4 different queries. But additionally, I want to include paging, so that I can f.ex. receive the row-numbers 1-100, 101-200 etc. I tried Row_Num() Over (Order By) but did not ge...
I'm trying to construct a select query where it will take all the columns of 4 tables and then order and display the results by the column 'name' (the same in all tables). I'm still learning the ropes of MySQL. I'm finding that because the columns share the name 'name', only the results from the last table are displayed. Is there a wa...
Is this possible? Using SQL Server 2005....... SELECT * FROM Data0304 UNION SELECT * FROM Data0506 UNION SELECT * FROM Data0708 ...
I need to normalise a table which contains cricket players: +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | matchID | int(11) | NO | PRI | 0 | | | innings | int(11) | N...
<?php $sql = mysql_query(" SELECT navn FROM member_film WHERE username = '$pusername' UNION SELECT meetup FROM member_meetups WHERE byusername = '$pusername' UNION SELECT title FROM member_tutorials WHERE username = '$pusername'"); $rowit = mysql_fetch_array($sql); $number = mysql_num_rows($sql); ?> <? echo $number; ?> <? echo $rowit["n...
Hi, I'm now trying to populate my 'testMatch' table (below) with data from my 'summary' table: TESTMATCH TABLE +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | match_id | int...
Hi, How do I combine these two select statements into one query: SELECT SUM( incidents ) AS fires, neighborhoods AS fire_neighborhoods FROM ( SELECT * FROM `fires_2009_incident_location` UNION ALL SELECT * FROM `fires_2008_incident_location` UNION ALL SELECT * FROM `fires_2007_incident_location` UNION ALL SELECT * FROM `fires_20...
Suppose I define a union like this: #include <stdio.h> int main() { union u { int i; float f; }; union u tst; tst.f = 23.45; printf("%d\n", tst.i); return 0; } Can somebody tell me what the memory where tst is stored will look like? I am trying to understand the output 1102813594 that this p...
Am trying to do the union of the results of two queries. But I'm getting the following error: Error at Command Line:9 Column:81 Error report: SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" SELECT application_id, clicks, datee, client_id FROM( (select APPL_CD AS application_id, count...