is there a better way to do a dynamic search than using where 1=1?
Ive used where 1=1 in the past with access databases but never with my sql and i dont seem to be able to get it to work with mysql as it just returns all the values from the datbase.
the selct bit im using is
[CODE]MM_rsCars_Source="SELECT * FROM cars WHERE (1=1) AND Active = 1"[/CODE]
Im then filtering the makes table on the makeID passed through but it keeps displaying all the makes.