Howdy, Stranger!

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

Categories

Dynamic search (where 1=1)

thinker08thinker08 Member Posts: 1
HI

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.

Thanks
Thinker08
Sign In or Register to comment.