Recordset filter question for MySQL

[Shane930]

Hi I am looking to filter a query with three conditions and can not find the
correct syntax. I am looking to search on a type of vehicle then a span of
years.

Thanks

Shane

Here is my SQL:

SELECT *
FROM saa.vehicle_ad
WHERE vehicle_type = #FORM.vehicle_type# AND veh_year<= #FORM.veh_yearup# AND
veh_year<= #FORM.veh_yeardown#
ORDER BY vehicle_type ASC

[Shane930]

Forgot to add this is MySQL DB.

[paross1]

I noticed that you were checkingto see if your veh_year parameter was <b>less
than or equal to</b> both values, it this what you intended? Also, you might
try BETWEEN...

Something like this?

SELECT *
FROM saa.vehicle_ad
WHERE vehicle_type = #FORM.vehicle_type#
AND veh_year BETWEEN #FORM.veh_yearup# AND #FORM.veh_yeardown#
ORDER BY vehicle_type ASC

Phil

[Shane930]

Hi Phil, thanks for the reply. I did get it worked out later yesterday. It
seems I needed to put the second condition in the WHERE clause on its own line
like you have above and it processes like it should.

Thank you for your help.

Shane