Dynamic search (where 1=1)


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.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!