The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
0
votes
2 answers
nested collision starling as3
I am using starling and tweenMax frameworks in my project.
The trouble I am running into is this:
For the purpose of animating along different paths, I am using tweenmax.
There is one _leaderEnemy that animates along a path and I am pushing several…
sssaini
- 375
- 1
- 2
- 14
0
votes
1 answer
XNA Rectangle Intersection issues
I am fairly new at XNA and I have come across a problem.
I have a button class which I am using for a button on the start screen of the game. I want to make it so that when the mouse clicks on the button, a boolean isClicked is set to true and then…
Nick M
- 3
- 3
0
votes
1 answer
correct way to use set_intersection
struct Cord
{
int x_cord;
int y_cord;
Cord(int x = 0,int y = 0):x_cord(x),y_cord(y) {}
bool operator < (const Cord& cord) const
{
if (x_cord == cord.x_cord)
{
return…
YAKOVM
- 9,805
- 31
- 116
- 217
0
votes
1 answer
Why is Rectangle intersect never true?
I have the following function, which shall tell me when 2 sprites overlap on the x-axis:
public int getSecondObjectX(int secObjWidth)
{
int rndX = random.nextInt(AndroidApplication.getInstance().device_width - secObjWidth);
Rect…
Toni Kanoni
- 2,265
- 4
- 23
- 29
0
votes
3 answers
Turtle line intersection, coordinates
I need to make a small program that draws three circles, a line between the first two, and then determines if the third touches or intersects the line. I have done everything but the last part. I am trying to use the points to determine if the area…
user2185152
- 1
- 1
0
votes
2 answers
two collada object colliding
I am trying to use Ray intersect to find out if 2 collada object collide.
But so far no success :(
my code http://jsfiddle.net/XqQzF/
object.updateMatrix();
// ray
var f_vector = new THREE.Vector3( 0, 0, -1 );
var…
user2156933
- 65
- 6
0
votes
3 answers
How to determine which rectangle is intersecting more C# XNA
Basically I have a grid of rectangles, 75x75 each, side by side. I'm placing an object into these rectangles and when I place the object I need to figure out which rectangle it is intersecting with the MOST.
It would most likely look something like…
user2062092
- 1
- 1
- 1
0
votes
1 answer
subtract two "lists of dictionaries"
How should I subtract two list of dictionaries in a pythonic way?
I want to find the element that are unique in the first listOfDict.
See my example below:
firstDict = [{'A':1 ,'B':1}, {'A':2 ,'B':2}]
secondDict = [{'A':3 ,'B':3}, {'A':2…
theAlse
- 5,577
- 11
- 68
- 110
0
votes
1 answer
How can I check collision between a triangle - circle and triangle rectangle? (including rotation)
I need to check if some shapes are colliding in a 2D world.
To check collision between circle and rectangle I found this:
Collision Detection with Rotated Rectangles
But now I need to add another shape to this code (triangle), and the triangle can…
Ighor Martins
- 11
- 3
0
votes
1 answer
how to know if the curve is intersect with the red line
this curve is consist of these points. i want to know if the red line intersect with the curve. the red line is consist of PointA and PointB. what can i do ?
badboy_tqj
- 300
- 2
- 14
0
votes
2 answers
SQL Using to_char(null), to_number(null), etc in set operators with Oracle
I'm a student entering the world of SQL for the first time and I cannot find any clear and understandable documentation on how to use to_somedatatype(null) to substitute for missing columns in a UNION, INTERSECT, etc. I'm using the HR schema that…
Troy D
- 381
- 2
- 4
- 17
0
votes
1 answer
three.js - principle of camera collision
As I understood the only method to compute collisions with three.js is intersectObjects with a ray ...
I created an object that includes the basic elements of the collision : ground, walls, objects, stairs. with the firstpersoncontrols. I went with…
Laurane Bernard
- 209
- 1
- 2
- 10
0
votes
0 answers
array_intersect always evaluates to false
my code always goes into the "else-part", even if the "if-part" should be returned. When i delete the "else-part" it returns the "if-part".
foreach ($messageRepo as $oMessage) {
$messageTag = $oMessage->getMessageTags(); // get tags from all…
Pascal Cloverfield
- 561
- 1
- 6
- 20
0
votes
0 answers
performing a database search in union or intersection
My code allows a person to enter keyword(s) in a provided space and clicking the search button, searches a database for those keywords and displays url(s) that have that keyword in it's row.
The code preforms a union search automatically.
I have…
Justin Gould
- 23
- 1
- 1
- 5
0
votes
1 answer
combining result of 5 sql queries by running a union and intersection
i have got 5 queries as given below , i need to perform a union on all
if($dv_state_ids!="")//check if no state is entered
$state_sql="SELECT pkg_id FROM package_state where state_id in ($dv_state_ids) ";
if($dv_city_ids!="")//check if no…
prashant kumar
- 9
- 1