Passing two parameters as field name

D

derrenn

Hi, not sure how to phrase this so bear with me.

I am passing three parameters (using drop down lists) to a results page and
trying to use the second two as a column heading, which then displays if the
country matches and the field (which is the second two parameters joined)
contains an X.

Now i know this used to work when i used FP 2000 and a windows 2000 server
but now i have FP03 and Windows Server 2003. It no longer works.

This used to work.

SELECT * FROM IWCCDIR WHERE (Country LIKE '::Country::' AND "::Metal::
::product::" LIKE '%X%')

Any help would be greatly appreciated.

Derren
 
Top