> ORDER BY cabinName AND hashottub = 1
What SQL will do with this (theoretically) is turn this into a logical
statement
So, it would be "cabinName and HasHotTub" (logical AND) = 1
If CabinName isn't numeric, then it'll fail
It should be;
ORDER BY CabinName, HasHotTub
Philip Arnold
Director
Ce
Message-
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:21 AM
To: CF-Talk
Subject: Newbie problem: Search on Yes/No Column
Friends:
I thought that I had this solved, but not quite. Can anyone help?
The problem: I need to search on a "yes/no" column
Okay - success! As several of you kindly pointed out:
> You can't have filters after the Order By Clause
>
> ORDER BY cabinName AND hashottub = 1
I did that, and then stumbled upon what I think was giving me the error
messages. This:
AND hashottub = 1
Needed to be this:
AND cabinHottub
y will cause you an error eventually.
|-Original Message-
|From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, April 05, 2001 9:58 AM
|To: CF-Talk
|Subject: Re: Newbie problem: Search on Yes/No Column
|
|
|Randy (and/or anyone else willing to help!) -
|
|Thanks very much. But I'
P@tty,
I think the problem is with your Order By clause:
ORDER BY cabinName AND hashottub = 1
Specifically with "AND hashottub = 1". You can Order By hashottubs but I
don't think order by hashottub = 1 is going to give the result you are
looking for.
Try removing the "=1" and if you need the
P@tty,
Move the ORDER BY clause to the end of everything else and give it a try.
Alec
> -Original Message-
> From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 9:58 AM
> To: CF-Talk
> Subject: Re: Newbie problem: Search on Yes/No Column
>
Your Order by Line should not contain:
AND hashottub = 1
Did you assign a value to the checkbox for "Doesn't Matter"?
-Original Message-
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:58 AM
To: CF-Talk
Subject: Re: Newbie problem: Search o
Randy (and/or anyone else willing to help!) -
Thanks very much. But I've trying this exactly the way you've shown (code is
quoted at the very bottom of this message), and I get an error message,
which I've pasted directly below. Any idea why??
The column name in the database is 'cabinHottub'.. d
Try this...give doesn't matter a unique value in the select list such as 5.
In your SQL then do...
select stuff
fromtable
where conditions that will always be present
and hashottub = #hashottub#
*** REPLY SEPARATOR ***
On 4/5/2001 at 9:21 AM P@tty Ayers wrote:
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:21 AM
To: CF-Talk
Subject: Newbie problem: Search on Yes/No Column
Friends:
I thought that I had this solved, but not quite. Can anyone help?
The problem: I need to search on a "yes/no" column - several
Friends:
I thought that I had this solved, but not quite. Can anyone help?
The problem: I need to search on a "yes/no" column - several of them -
allowing the user to choose that this field "Doesn't Matter" or else "Yes".
There's a search page and a results page. The database has a column
"cabin
11 matches
Mail list logo
