Hi Ben...
I have it working in other setups fine - just this one won't behave.
If I use like '%spp%' pass spp=TAR, then the query that gets run is
like 'TAR', which is basically an un-indexed =
I need a like '%TAR%' in the SQL hence the double % sign. I have this working
elsewhere fine (but
I see what Ben was worried about and what you're trying to do. I haven't done a
lot of variable substitution but I have done a lot of head scratching to when
queries don't work as expected. A couple things that might shed some light you
could try:
like '%spp%' and pass spp=%TAR%
If you're
Use double %%
like '%%spp%%' and pass spp=TAR
Regards,
Robert
Joshua Hevenor jheve...@rogers.com 15/03/2010 1:03 p.m.
I see what Ben was worried about and what you're trying to do. I haven't done a
lot of variable substitution but I have done a lot of head scratching to when
queries