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 reserves order of hashottub ...
try asending or desending.
Also, the fields cabinBathrooms, cabinDistance, cabinBedrooms, cabinSleeps
are all numeric ... correct?
Cheers,
Bill
cabinBathrooms, cabinDistance, cabinBedrooms, cabinSleeps
In a message dated 4/5/01 10:06:19 AM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> 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"
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
