Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square: That
is, two points that would correspond to
Not being very strong at math, I have a little problem that I'm not sure how
to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100 meters)
(think circle), I need to compute an equivalent square: That is, two points
that would correspond to two
At 03:11 PM 6/28/2007, M5 wrote:
Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square: That
is, two points
On 6/28/07, M5 [EMAIL PROTECTED] wrote:
Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square: That
is,
: MYSQL General List mysql@lists.mysql.com
Sent: Thursday, June 22, 2006 10:04 PM
Subject: Re: Math problem
Chris W wrote:
Karl Larsen wrote:
I'm trying to multiply numbers one of which is money. The money looks
like this:
SELECT price FROM titles;
| price |
++
| $20.00 |
| $19.99
* price AS `Turnover $` From titles;
HTH, Cor
- Original Message - From: Karl Larsen [EMAIL PROTECTED]
To: Chris W [EMAIL PROTECTED]
Cc: MYSQL General List mysql@lists.mysql.com
Sent: Thursday, June 22, 2006 10:04 PM
Subject: Re: Math problem
Chris W wrote:
Karl Larsen wrote:
I'm
I'm trying to multiply numbers one of which is money. The money
looks like this:
SELECT price FROM titles;
| price |
++
| $20.00 |
| $19.99 |
| $7.99 |
| $19.99 |
| $11.95 |
| $19.99 |
| $14.99 |
| $11.95 |
| $22.95 |
| $2.99 |
| $10.95 |
| $7.00 |
| $2.99 |
| $20.95 |
| NULL
Karl Larsen wrote:
I'm trying to multiply numbers one of which is money. The money
looks like this:
SELECT price FROM titles;
| price |
++
| $20.00 |
| $19.99 |
| $7.99 |
| $19.99 |
| $11.95 |
| $19.99 |
| $14.99 |
| $11.95 |
| $22.95 |
| $2.99 |
| $10.95 |
| $7.00 |
| $2.99
[snip]
It appears that mysys 4.1 does not know how to multiply a dollar
amount to another number. Has anyone else seen this problem?
[/snip]
Your price column contains a dollar sign, making it a text field that
you cannot multiply with.
--
MySQL General Mailing List
For list archives:
]
To: mysql@lists.mysql.com
Sent: Thursday, June 22, 2006 4:22 PM
Subject: Math problem
I'm trying to multiply numbers one of which is money. The money looks like
this:
SELECT price FROM titles;
| price |
++
| $20.00 |
| $19.99 |
| $7.99 |
| $19.99 |
| $11.95 |
| $19.99 |
| $14.99
Chris W wrote:
Karl Larsen wrote:
I'm trying to multiply numbers one of which is money. The money
looks like this:
SELECT price FROM titles;
| price |
++
| $20.00 |
| $19.99 |
| $7.99 |
| $19.99 |
| $11.95 |
| $19.99 |
| $14.99 |
| $11.95 |
| $22.95 |
| $2.99 |
| $10.95 |
|
It appears that mysys 4.1 does not know how to multiply a dollar
amount to another number. Has anyone else seen this problem?
If price is a string beginning with '$', MySQL will autoconvert
SubString(price,2) to a numeric iif it's in a numeric expression, but
you'd be much better off losing
12 matches
Mail list logo
