RE: Spatial Extension in MySQL 4.1.1-alpha

2003-12-17 Thread Matt Lynch 
Hi Steve and Paul,

Thanks - the comma did get me!
Paul, no the mistake isn't in the manual - I managed it all on my own.

For anyone following, the correct sequence was:



mysql CREATE TABLE geom ( g GEOMETRY );
Query OK, 0 rows affected (0.05 sec)

mysql INSERT INTO geom VALUES ( GeomFromText('POINT(1 1)') );
Query OK, 1 row affected (0.00 sec)

mysql SELECT AsText(g) FROM geom;
++
| AsText(g)  |
++
| POINT(1 1) |
++
1 row in set (0.00 sec)

mysql



Thanks again,

Matt

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 16, 2003 5:48 PM
To: Steven Roussey; [EMAIL PROTECTED]
Cc: 'Matt Lynch'
Subject: Re: Spatial Extension in MySQL 4.1.1-alpha


At 16:03 -0800 12/16/03, Steven Roussey wrote:
You did an insert this way:

   mysql insert into geom values(GeomFromText('POINT(1,1)'));

and expected results this way:

   mysql select AsText(g) from geom;
   +---+
   | AsText(g) |
   +---+
   | Point(1 1)|
   +---+
   1 row in set (0.00 sec)

The formatting of the POINT coordinates are different. I think you 
should be inserting POINT (1 1) not POINT(1,1). It is the comma.

-steve-

That's exactly right.

Was there an example like this in the manual that incorrectly included
the comma?

-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Spatial Extension in MySQL 4.1.1-alpha

2003-12-16 Thread Steven Roussey 
You did an insert this way:

  mysql insert into geom values(GeomFromText('POINT(1,1)'));

and expected results this way:

  mysql select AsText(g) from geom;
  +---+
  | AsText(g) |
  +---+
  | Point(1 1)|
  +---+
  1 row in set (0.00 sec)

The formatting of the POINT coordinates are different. I think you should be
inserting POINT (1 1) not POINT(1,1). It is the comma.

-steve-




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Spatial Extension in MySQL 4.1.1-alpha

2003-12-16 Thread Paul DuBois 
At 16:03 -0800 12/16/03, Steven Roussey wrote:
You did an insert this way:

  mysql insert into geom values(GeomFromText('POINT(1,1)'));

and expected results this way:

  mysql select AsText(g) from geom;
  +---+
  | AsText(g) |
  +---+
  | Point(1 1)|
  +---+
  1 row in set (0.00 sec)
The formatting of the POINT coordinates are different. I think you should be
inserting POINT (1 1) not POINT(1,1). It is the comma.
-steve-
That's exactly right.

Was there an example like this in the manual that incorrectly
included the comma?
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]