% if len(request("refno"))>0 then session("refno")=request("refno") end if SQL="../select * from flowerdata where refno='" & session("refno") & "'" Set rs = GetMdbStaticRecordset( "flower.mdb",SQL) 'response.write SQL 'pic1="dummy.jpg" 'if Instr(rs("pic1"),".") then 'pic1=rs("pic1") 'end if %>