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:
<CFIF IsDefined("hashottub") and hashottub NEQ "0">
AND hashottub = 1
</CFIF>
Needed to be this:
<CFIF IsDefined("hashottub") and hashottub NEQ "0">
AND cabinHottub = 1
</CFIF>
'cabinHottub' is the name of the column in the database. I might not have
been clear about that. In any case, it seems to be WORKING! Thanks very much
to all who replied.
I now need to apply this to the 3 other yes/no search fields, and I'm
praying that it works.. lol.
Many MANY thanks,
P@tty Ayers
Macromedia Evangelist
CF Newbie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
