fran7, without digging in to deep something caught my eye. Look at one of the loops you are doing.
-
-
'loop through the total number of fields
-
For i = 0 to recordset.Fields.Count - 1
-
'write out the field value
-
Response.write ("<a href="""" title="" ""><img width=""100%"" class=""bord"" alt="" "" src=""" & recordset (i) & """/></a>")
-
Next
-
It looks like you are looping through each field, but yet in your query you only select one field from the table. I would start there.