loading

<% id=CLng(Request("id")) fab = TRIM(Request("fab")) cod = TRIM(Request("cod")) %> <% sqlstring = "SELECT * FROM bfy_fabricante WHERE id=" & id SET RS = Con.execute ( sqlstring ) %>

<%=RS("fab")%>


<% IF RS("fab") = "Hiter" THEN %>

<%END IF%> <% IF RS("nota") <> "" THEN %>

<%=RS("nota")%>

<% END IF %>

<% RS.Close Set RS = nothing sqlstring = "SELECT Count(*) as Count FROM bfy_atuador WHERE fabid=" & id SET RS = Con.execute ( sqlstring ) IF RS("Count") = 0 THEN Linhas = 1 ELSE Linhas = RS("Count") END IF sqlstring = "SELECT * FROM bfy_atuador WHERE fabid=" & id & " ORDER BY cod" SET RS = Con.execute ( sqlstring ) %> <% IF NOT RS.EOF THEN RS.MoveFirst WHILE NOT RS.EOF %> <% RS.MoveNext WEND ELSE %> <% END IF RS.Close Set RS = Nothing sqlstring = "SELECT Count(*) as Count FROM bfy_sup_pos WHERE fabid=" & id SET RS = Con.execute ( sqlstring ) IF RS("Count") = 0 THEN Linhas = 1 ELSE Linhas = RS("Count") END IF sqlstring = "SELECT * FROM bfy_sup_pos WHERE fabid=" & id & " ORDER BY cod" SET RS = Con.Execute( sqlstring ) %> <% IF NOT RS.EOF THEN RS.MoveFirst WHILE NOT RS.EOF %> <% RS.MoveNext WEND ELSE %> <% END IF RS.Close Set RS = Nothing sqlstring = "SELECT Count(*) as Count FROM bfy_sup_ima WHERE fabid=" & id SET RS = Con.execute ( sqlstring ) IF RS("Count") = 0 THEN Linhas = 1 ELSE Linhas = RS("Count") END IF sqlstring = "SELECT * FROM bfy_sup_ima WHERE fabid=" & id & " ORDER BY cod" SET RS = Con.execute ( sqlstring ) %> <% IF NOT RS.EOF THEN RS.MoveFirst WHILE NOT RS.EOF %> <% RS.MoveNext WEND ELSE %> <% END IF Rs.Close %>
BFY to <%=RS("fab")%> Actuator
B F Y - <%=RS("cod")%>
Manufacturer Model
Actuator Model / Size
<%=RS("cod")%>
 
 
<%=RS("pos")%>  
Positioner Bracket
<%=RS("cod")%>
 
<%=RS("sup")%>

Magnet Bracket

<%=RS("cod")%>
<%=RS("sup")%>  

 

<% sqlstring = "SELECT * FROM bfy_atuador WHERE fabid=" & id & " ORDER BY cod" SET RS = Con.Execute ( sqlstring ) RS.MoveFirst WHILE NOT RS.EOF id_atu = RS("id") sqlstring = "SELECT * FROM bfy_imagens WHERE id_atu=" & id_atu & " AND tipo=2" SET RS0 = Con.Execute ( sqlstring ) sqlstring = "SELECT * FROM bfy_imagens WHERE id_atu=" & id_atu & " AND tipo=3" SET RS1 = Con.Execute ( sqlstring ) sqlstring = "SELECT * FROM bfy_imagens WHERE id_atu=" & id_atu & " AND tipo=4" SET RS2 = Con.Execute ( sqlstring ) sqlstring = "SELECT * FROM bfy_imagens WHERE id_atu=" & id_atu & " AND tipo=5" SET RS3 = Con.Execute ( sqlstring ) %> <% If NOT RS0.eof then RS0.MoveFirst WHILE NOT RS0.EOF %> <% RS0.MoveNext WEND ELSE %> <%end if%> <% If NOT RS1.eof then RS1.MoveFirst WHILE NOT RS1.EOF %> <% RS1.MoveNext WEND ELSE %> <% end if %> <% If NOT Rs2.eof then RS2.MoveFirst WHILE NOT RS2.EOF %> <% RS2.MoveNext WEND ELSE %> <% end if %> <% If NOT Rs3.eof then RS3.MoveFirst WHILE NOT RS3.EOF %> <% RS3.MoveNext WEND ELSE %> <% end if %> <% RS.MoveNext WEND %>
Actuator Model /
Size
Positioner Bracket
Magnet
Bracket
Mounting
Dimensions
Linear
Rotary
<%=RS("cod")%> 
<%=RS("pos")%> 
<% if rs0("img") <> "" then%> " target="_blank"> <% else %>   <%end if%>
 
<% if rs1("img") <> "" then%> " target="_blank"> <% else %>   <%end if%>
 
<%if RS2("img") <> "" then%> " target="_blank"> <% else %>   <%end if%>
 <%if RS3("img") <> "" then%> <% else %>   <%end if%>