hi.
i am trying to show images with a property search. i have everything set in terms of image galleries. i would like to display the first image in teh gallery on my search page.

this is my recordset for my properties.

SELECT *
FROM tblProperties
WHERE ID_Location like 'vLocation' AND ID_Type like 'vType' AND Description like '%vDescription%'

for my variables i am using
vLocation % Requestion("locatiosns"
and so on for all three variables.

where i am stuck is displaying my images.
my image gallery is in a separate table with a primary ID and a secondary ID that relates all inserted images as a set belong to specific properties. i can display the thumnail on the details page as i have already passied the property id to that page but the search page thumnail has me stumped.

can someone help me write a recordset query for my images.

help?

thanks


Edited by - kschwenker on 27 Feb 2003 19:20:42