[MI-L] SQL Select

2005-11-28 Thread Andrew Tracey
Dear All This may be a easy one but hear goes, I have two columns of data which I want to multiply the values of each together and give the result in a additional column. I take it this is possible to do, if so could somebody please enlighten me. Thanks Andrew Tracey Information Support Offic

MI-L SQL Select

2002-03-06 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is there a simple way to select the records in the same table that have = the same name and the same second variable? I want to be able to select all s

MI-L SQL Select

2002-03-18 Thread Christian McNierney
I have two tables, one contains points, the other polygons. I want to find out how many points are within each of the polygons and update that count in the polygon table. I'm drawing a blank on this one. Thanks, Christian McNierney Spatial Insights, Inc. A Geographic Information Services

MI-L SQL Select

2001-03-09 Thread Morrier, Steve
Does anybody know the proper syntax for selecting on those records within a field that contain two words or more. I need to select all street names with in a file that are more than one word. Basically I am concerned with any entry that has a space in it. Any help would be greatly appreciated. Tha

[MI-L] sql select

2006-04-13 Thread Robert DeRubeis
List, I'm having a problem with a selection query.  I have 2 tables both editable with a common column named "ID".  Table B is my "deleted" records which I want to find in table A to delete.  When I run the following sql select statement- Select * from Table A, Table B where Table A.ID = Ta

MI-L sql select problem

2004-07-17 Thread Véronique De Laet
Dear list, We have a database with elevation values of contourlines with an aquidistance of 1m. Now we want to select lines with an interval of 5m. So we tried the sql select function: table: the contour table column: the elevation values where condition: And here we stuck. Can someone give u

RE: [MI-L] SQL Select

2005-11-28 Thread Peter Horsbøll Møller
riginal Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Tracey Sent: Monday, November 28, 2005 6:19 PM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] SQL Select Dear All This may be a easy one but hear goes, I have two columns of data which I want to multi

RE: [MI-L] SQL Select

2005-11-28 Thread Jakob Lanstorp
fo-L@lists.directionsmag.com Subject: [MI-L] SQL Select Dear All This may be a easy one but hear goes, I have two columns of data which I want to multiply the values of each together and give the result in a additional column. I take it this is possible to do, if so could somebody please enlighten me. Th

RE: [MI-L] SQL Select

2005-12-03 Thread Lawley, Russell S
ey Sent: 28 November 2005 17:19 To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] SQL Select Dear All This may be a easy one but hear goes, I have two columns of data which I want to multiply the values of each together and give the result in a additional column. I take it this is possibl

MI-L SQL Select Error

2004-03-16 Thread Don Guerra
Hi, I am using SQL Select to sum object lengths. The selection table has one column from the base table and one derived column. The derived column is specified as Sum(ObjectLen(obj,"ft")) I get this error: "Could not fetch object from the current row, argument ObjectLen" The query

MI-L SQL Select Error

2004-03-16 Thread Don Guerra
O.K. I tried using the table name with the expression for the ObjectLen function as Terry McDonnell suggested..got the same result. Then I checked to see if these are in fact polylines as Bill Thoen suggested. All of the lines where selected meaning none are polylines. I even reversed this

MI-L SQL Select Error

2004-03-17 Thread Don Guerra
Thanks Spencer, that helped a lot. I was able to determine that 13 out of 893 objects were in fact not polylines and this is what's hanging up the SQL select. Thanks to Mike Cummings also for his suggestion, however I had already packed the table when I first got the error. Donald Guerra

Re: MI-L SQL Select

2002-03-18 Thread Uffe Kousgaard
ginal Message - From: "Christian McNierney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 18, 2002 9:17 PM Subject: MI-L SQL Select > I have two tables, one contains points, the other polygons. I want to > find out how many points are within each of th

RE: MI-L SQL Select

2002-06-26 Thread jal
rence på http://www.kampsax-gis.dk/Default.asp?ID=296 "Jacques Paris" <[EMAIL PROTECTED]> Sendt af: [EMAIL PROTECTED] 09-03-2001 20:58 Besvar venligst til "Jacques Paris" Til:"Morrier, Steve" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]&g

MI-L SQL select bug?

2001-02-06 Thread Richard Maaranen
I think this may be an SQL select bug. When I want to select all the = points from a point layer that fall within a polygon layer using SQL = select, sometimes it selects only polygons and sometimes it selects the = points. I can't seem to figure out exactly how to get it to select only = the po

RE: MI-L SQL Select

2001-03-09 Thread Jacques Paris
uestions see the J.Paris site at http://www.total.net/~jakesp/index.htm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Morrier, Steve Sent: March 9, 2001 2:36 PM To: '[EMAIL PROTECTED]' Subject: MI-L SQL Select Does anybody know the proper synt

Re: MI-L SQL Select

2001-03-09 Thread Mats Elfström
"Morrier, Steve" wrote: > > Does anybody know the proper syntax for selecting on those records within a > field that contain two words or more. I need to select all street names with > in a file that are more than one word. Basically I am concerned with any > entry that has a space in it. Hi St

Re: [MI-L] sql select

2006-04-13 Thread Robert DeRubeis
9:22 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] sql select List, I'm having a problem with a selection query.  I have 2 tables both editable with a common column named "ID".  Table B is my "deleted" records which I want to find in table A to delete.  When I run the following

RE: [MI-L] sql select

2006-04-17 Thread Llewellyn, David
Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Friday, 14 April 2006 1:43 AM To: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] sql select   That's what the problem was.  Table A was not mappable and Table B was mappable.  I made Table A mappable and ran the same quer

SV: [MI-L] sql select

2006-04-18 Thread Watertech - Jacob K . Jørgensen
dSendt: 18. april 2006 02:58Til: Robert DeRubeis; mapinfo-l@lists.directionsmag.comEmne: RE: [MI-L] sql select Robert,   Another way, that works regardless of whether or not either table is mappable is a query of this form:   Tables {TableA} Where {ID in (select ID f

Re: MI-L sql select problem

2004-07-17 Thread Bill Thoen
On Sat, 17 Jul 2004, Véronique De Laet wrote: > We have a database with elevation values of contourlines with an > aquidistance of 1m. Now we want to select lines with an interval of > 5m. If you want to select contour lines with elevation values that are even multiples of 5m, you can do so

RE: MI-L sql select problem

2004-07-19 Thread Dominic Lowe
CTED] Sent: 17 July 2004 20:30 To: [EMAIL PROTECTED] Subject: MI-L sql select problem Dear list, We have a database with elevation values of contourlines with an aquidistance of 1m. Now we want to select lines with an interval of 5m. So we tried the sql select function: table: the contour table c

RE: MI-L sql select problem

2004-07-19 Thread Dominic Lowe
Sorry, missed Bill's answer! -Original Message- From: Bill Thoen [mailto:[EMAIL PROTECTED] Sent: 17 July 2004 22:18 To: Véronique De Laet Cc: [EMAIL PROTECTED] Subject: Re: MI-L sql select problem On Sat, 17 Jul 2004, Véronique De Laet wrote: > We have a database with e

RV: MI-L sql select problem

2004-07-19 Thread Gamiz Ribelles, Sergi (Regsa)
If you cannot use the MOD function, use the statement WHERE: INT(ELEVATION/5) = (ELEVATION/5) This works well Have luck SERGI -Mensaje original- De: Véronique De Laet [mailto:[EMAIL PROTECTED] Enviado el: sábado, 17 de julio de 2004 21:30 Para: [EMAIL PROTECTED] Asunto: MI-L sql select

MI-L SQL Select Join Problem

2003-07-27 Thread Peter Brown
I am attempting to join two tables together (one mapinfo table and one database table) based on a primary key of postcode. On one table it is a number, in the other table it is a string. When trying to join the two through SQL Select, the obvious error message appears "Datatype mismatch". If

RE: MI-L SQL Select Error

2004-03-16 Thread Spencer Simpson
"str$(obj)" for a polyline returns "Polyline", not "Pline". In addition, there is a "line" object type for which str$(obj) returns "line". You can use either of the two expressions below to search for rows that are neither lines nor polylines: not (str$(obj)=any ("line", "polyline")) instr(1,str

RE: MI-L SQL Select Error

2004-03-19 Thread Woody Woodruff
ning/index.htm -Original Message- From: Don Guerra [mailto:[EMAIL PROTECTED] Sent: March 17, 2004 10:27 To: MapINFO (MapINFO) Subject: MI-L SQL Select Error Thanks Spencer, that helped a lot. I was able to determine that 13 out of 893 objects were in fact not polylines and this is what'

RE: MI-L SQL select bug?

2001-02-07 Thread David Booth
vid Booth Senior GIS Officer Merseyside Information Service > -Original Message- > From: Richard Maaranen [SMTP:[EMAIL PROTECTED]] > Sent: 07 February 2001 00:05 > To: [EMAIL PROTECTED] > Subject: MI-L SQL select bug? > > > > I think this may be a

RE: MI-L SQL select bug?

2001-02-07 Thread Stokes Jonathan
hope this helps Jon -Original Message- From: David Booth [mailto:[EMAIL PROTECTED]] Sent: 07 February 2001 09:16 To: 'Richard Maaranen'; [EMAIL PROTECTED] Subject: RE: MI-L SQL select bug? Hi Richard, I'm pretty sure this will be down to the order you list the tables in

Re: MI-L SQL select bug?

2001-02-07 Thread Richard Maaranen
tement. I think (though I'm not entirely sure) that > you get the objects from the first table in the list. Possibly. > > - > David Booth > Senior GIS Officer > Merseyside Information Service > > > -Original Message- > > From: Richard Maaranen [SMTP:

MI-L SQL Select within Radius

2001-06-01 Thread Steve Wallace
Help! Why won't this work? It used to! Select Location, sum(price), sum(cost) from anytable where anytable.obj within CreateCircle(CentroidX(obj),CentroidY(obj),"50") group by Location order by Location into Selection Steve Wallace Florida Farm Bur

RE: MI-L SQL Select Join Problem

2003-07-28 Thread Simmonds, Ashley (PTB)
d capacity for learning from mistakes, so they may be completely false. -Original Message- From: Peter Brown [mailto:[EMAIL PROTECTED] Sent: Monday, 28 July 2003 2:43 PM To: [EMAIL PROTECTED] Subject: MI-L SQL Select Join Problem I am attempting to join two tables together (one mapinfo tab

RE: MI-L SQL Select within Radius

2001-06-04 Thread Campbell, Keith A
: 01 June 2001 18:21 To: [EMAIL PROTECTED] Subject: MI-L SQL Select within Radius Help! Why won't this work? It used to! Select Location, sum(price), sum(cost) from anytable where anytable.obj within CreateCircle(CentroidX(obj),CentroidY(obj),"50")

Re: MI-L SQL Select within Radius

2001-06-09 Thread Chris DuBuc
nt to change this back is: set map distance units "mi" Cheers, Chris Chris DuBuc [EMAIL PROTECTED] >From: "Steve Wallace" <[EMAIL PROTECTED]> >Reply-To: "Steve Wallace" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: MI-L SQL Select

[MI-L] SQL select not performing as expected

2006-01-31 Thread Terry McDonnell
Hi List I have 2 tables: Route and Journey Journey is a superset of Route in that 1 route (bus) may feature several journeys (e.g. the same route but individual details of each journey, such as its times, whether it operates on public holidays, et al) Now Journeys can have service categories