UKPSF Trade Members
The following pages contain details of the UKPSF trade members. Some suppliers may appear on more than one page.
When purchasing goods or enquiring for prices or quotations please mention the UKPSF website.
<%
dim strdesc
dbconnect(1)
sql = "select * from ukpsf_tradetypes T left join ukpsf_trademembers M on M.tradetypeid = T.tradetypeid order by T.tradetypeid, M.tradeorderby;"
set rs=db.execute(sql)
if not rs.eof then
do while not rs.eof
if strdesc = "" or strdesc <> rs("tradetypdesc") then
response.write "" & rs("tradetypdesc") & "
"
strdesc = rs("tradetypdesc")
end if
%>
" onClick="openwin('showtrade.asp?tradeid=<%= rs("tradeid") %>','popup',500,400,'yes')"><%= rs("tradename") %>
<%
rs.movenext
loop
else
response.write "There are no trade types configured!
"
end if
dbconnect(0)
%>