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
>
>
> 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'.. does that
> belong in the
> SQL? I apologize again for these beginner questions.
>
> Again, many thanks for your help.
> P@tty
>
>
> --------------------------------------------------------------
> -------------
> ODBC Error Code = 07001 (Wrong number of parameters)
>
>
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
> Expected 1.
>
> Hint: The cause of this error is usually that your query contains a
> reference to a field which does not exist. You should verify
> that the fields
> included in your query exist and that you have specified their names
> correctly.
>
> SQL = "SELECT cabins.cabinID, cabins.cabinName, cabins.cabinCity,
> cabins.cabinBedrooms, cabins.cabinBathrooms, cabins.cabinSleeps,
> cabins.cabinNightly, cabins.cabinWeekly,
> photos.photosThumbPhotoName FROM
> cabins INNER JOIN photos ON cabins.cabinID = photos.cabinID WHERE
> cabinDistance <= 200 AND cabinBedrooms >= 1 AND
> cabinBathrooms >= 1 AND
> cabinSleeps >= 1 ORDER BY cabinName AND hashottub = 1"
>
> --------------------------------------------------------------
> --------------
> ------
>
> > You need to assign a value to the Doesn't Matter such as this
> >
> > > <select name="hashottub">
> > > <option VALUE="0" selected>Doesn't Matter</option>
> > > <option value="1">Yes</option>
> > > </select>
> >
> >
> > Then your query would read:
> >
> > > <cfquery name="rs2" datasource=#MM_connAsheville_DSN#
> > > username=#MM_connAsheville_USERNAME#
> password=#MM_connAsheville_PASSWORD#>
> > > SELECT
> > > cabins.cabinID, cabins.cabinName, cabins.cabinCity,
> > > cabins.cabinBedrooms,
> > > cabins.cabinBathrooms, cabins.cabinSleeps,
> > > cabins.cabinNightly,
> > > cabins.cabinWeekly, photos.photosThumbPhotoName
> > > FROM cabins INNER JOIN photos ON cabins.cabinID =
> > > photos.cabinID
> > > WHERE
> > > cabinDistance <= #rs2__vardistance#
> > > AND
> > > cabinBedrooms >= #rs2__varnumberbedrooms#
> > > AND
> > > cabinBathrooms >= #rs2__varnumberbathrooms#
> > > AND
> > > cabinSleeps >= #rs2__varsleepsatleast# ORDER BY
> > > cabinName
> > > <CFIF IsDefined("hashottub") and hashottub NEQ "0">
> > > AND hashottub = 1
> > > </CFIF>
> > > </cfquery>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
