Craig-
are you sure you want to test
ranking_id < '10' ???
-martin
- Original Message -
From: "Craig Hoffman" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, July 09, 2004 3:51 PM
Subject: Re: Between Operator
> Than
At 05:51 PM 7/9/2004, you wrote:
Thanks everyone for helping out.I took Michael's advice and made a
new table called ranking and two columns. It defiantly cleared some
things up but I am still having issues using the BETWEEN operator. I
just need to pull up everything BETWEEEN 10 a
Thanks everyone for helping out.I took Michael's advice and made a
new table called ranking and two columns. It defiantly cleared some
things up but I am still having issues using the BETWEEN operator. I
just need to pull up everything BETWEEEN 10 and 18 and it keeps adding
addit
On Fri, Jul 09, 2004 at 09:39:02AM -0500, Craig Hoffman wrote:
> Style: Traditional
> Area: Yosemite
> Rating: From: 5.5 To: 5.10c
...
> "SELECT * FROM routes, users WHERE area='$area' AND style='$style'
> BETWEEN rating='[$rating1]' AND rating='[$rating2]' GROUP BY route
> ORDER BY rating ASC
On Fri, 09 Jul 2004 11:38:05 -0400, Keith Ivey <[EMAIL PROTECTED]>
wrote:
Craig Hoffman wrote:
This should pull up all the rock climbs that are in Yosemite, that are
traditional style and are between the rating 5.5 to 5.10c. Here is my
query:
"SELECT * FROM routes, users WHERE area='$area'
Craig Hoffman wrote:
This should pull up all the rock climbs that are in Yosemite, that are
traditional style and are between the rating 5.5 to 5.10c. Here is my
query:
"SELECT * FROM routes, users WHERE area='$area' AND style='$style'
BETWEEN rating='[$rating1]' AND rating='[$rating2]' GROUP
Hey Everyone,
I have query where one selects an "style" then a "area" and finally
"rating". When some selects a rating they select a range of ratings.
For example:
Style: Traditional
Area: Yosemite
Rating: From: 5.5 To: 5.10c
This should pull up all the rock climbs that are in Yosemite, that
Hi!
Thank you for your bug report.
It helped us fix a bug . A fix will come in version 4.0.5. This is a
patch that fixes a problem:
= sql/field.h 1.41 vs edited =
*** /tmp/field.h-1.41-18621 Wed Oct 16 12:32:31 2002
--- edited/sql/field.h Wed Oct 30 17:24:58 2002
***
**
>Description:
This is a simple bug with dates and 'between' operator. Full data is
supported below, but for the start I show the very essence of the problem. I
use the latest stable version of MySQL - 3.23.52.
SELECT weeks.ix FROM team, weeks WHERE
team.ix=6 AND
weeks.start
