Questions tagged [intersect]

The SQL intersect operator returns rows that are common between two tables without returning duplicate records.

643 questions
0
votes
4 answers

Making a global variable

I'm making a game and I'm having trouble getting variables from another class. I have a Sprite class and a JPanel class. In my game, I want my score to go up once I hit a coin. My intersect coin code is in my Sprite class. How would I make it so…
0
votes
1 answer

BackGround in my JPanel, how can I resolve this?

Well my problem is that I'm making the stars move with a thread, they move verticaly and it works good but i do a random X for the star and sometimes it intersecs other stars like this : This is my code for the JPanel: class Backgroundmoving…
Steven_95
  • 75
  • 8
0
votes
1 answer

MySQL Intersect on same table

My original query is: SELECT * from test where ID BETWEEN 10 AND 100 INTERSECT SELECT * from test where MARKS=10 But, INTERSECT is not working in MySQL I am querying from the same table and INNER JOIN is not working.
0
votes
1 answer

How to make my collision check with Intersect between rectangles to work?

EDIT:here is the full code: https://dl.dropboxusercontent.com/u/65678182/assignment1.rar Any possible help is highly appreciated! I am trying to make a copy of the breakout game, but I have problems with checking if two objects (the ball and…
user3483682
  • 51
  • 1
  • 7
0
votes
0 answers

MySQL ST_intersect doesn't work correctly

I have specific problem with MySQL ST_intersect function. MySQL ST_intersect doesn't work correctly in our case. I'm asking for intersects between polygon and line like in example bellow: SELECT ST_intersects( GeomFromText( 'POLYGON((0 10,10 10,10…
0
votes
1 answer

how to find the area of intersect of Recangle2D in java

I have shapes beside each other, some of them are pasted twice on itself, i want to figure out which object is pasted through getting the percentage of intersection of 2 objects, i coded for comparing single object with all other objects, where i'll…
a14
  • 31
  • 15
0
votes
1 answer

Snake collision detection with itself

I am currently writing some simple snake game in java. The snake objects has an array full of bodyparts. these bodyparts all contain a rectangle. the snake's update method is like that: public void update() { if(isMoving) { …
user2410644
  • 3,861
  • 6
  • 39
  • 59
0
votes
1 answer

android sqlite help to fire my own query?

hello guys i have a simple intersect query works fine for sqlite3 console on windows But how can i fire it and retrieve results in android sqlite database. eg. SELECT b_name FROM bus,route,station WHERE s_name='STAITON_NAME' AND…
0
votes
1 answer

Detect if polylines intersect polygon

I have some polylines (an array of coordinates, representing a route) I also have a polygon (a rectanble made from 4 coordinates) They are used in Google Maps (API v3). -- I need to know if any of theese polylines intersect the polygon, and if so,…
Gertsen
  • 1,078
  • 20
  • 36
0
votes
1 answer

Faster or smarter way to sort and intersect large amount of data?

I was using "intersect" in my Matlab code to do the sorting where I want the following: [ch] = sort(s, 'ascend'); [same, a] = intersect(s, ch); For example: input: s = [55 21 78 7] output: ch = [7 21 55 78] a = [4 2 1 3] I need to access a…
user2563812
  • 219
  • 1
  • 2
  • 12
0
votes
3 answers

VTK: Intersection between a plane and a polydata

Is there a simple way to compute whether a plane and a polydata-object intersect? I want to know on which sides my polydata-object protude my bounding box. I want to use VTK for this task.
liquid.pizza
  • 505
  • 1
  • 10
  • 26
0
votes
1 answer

Javafx - Cursor intersect shape

I have a few objects on a board and I'd like to get those objects's indexes by the coordinates. I've tried making a MouseEvent handler and using the getBoundInParent() combined with MouseInfo.getPointerInfo().getLocation(), but unsuccessful. These…
Adorjan
  • 39
  • 9
0
votes
1 answer

How to intersect and differ multidimensional array

I have two arrays. $paternalSiblings = fname => John lname => Doe gender => M birth_year => 1988 fname => Sophie lname => Ellison gender => F birth_year => 1990 $maternalSiblings = fname => John lname => Smith gender => M…
user2369628
0
votes
2 answers

Rectangle overloaded method issue

So I have a rectangle I am using for a bouncing box.. I'm bouncing balls of this rectangle so need to be able to check if it is bouncing off either the x or y axis of my rectangle. Originally I had the code following code which was fine for…
Rich
  • 15
  • 1
  • 9
0
votes
1 answer

Union? Intersect? Or inversed intersect?

I'm working on a select statement that should return the class for each of the school days. There are 4 school days before the cycle starts over again. (e.g. Monday = Day1, Tuesday = Day2...Thursday = Day4, Friday = Day1..etc ) Some students may…
MPaul
  • 2,553
  • 3
  • 20
  • 34