 |
ArjoWiggins offices are situated worldwide - please select the relevant market to locate your nearest ArjoWiggins office contact details
Please note we sell through graphical, print & retail channels and not to the general public, however we are more than happy to advise you on where you can source the products.
Please select your country to locate your nearest ArjoWiggins office.
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_webdata_STRING
Recordset1.Source = "SELECT DISTINCT awc_name 'country', awc_id 'id' FROM dbo.aj_countries ORDER BY awc_name Asc"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
|
<%
If Len(Request.Form("country")) > 0 Then
sqlStr = "SELECT ajo_id, ajo_tel, ajo_add1, ajo_add2, ajo_add3, ajo_add4, ajo_add5, ajo_add6, ajo_add7, ajo_add8, ajo_add9, ajo_add10, ajo_fax, ajo_email FROM dbo.aj_offices, dbo.aj_office_countries, dbo.aj_countries WHERE awc_id = " & trim(Request.Form("country")) & " AND oc_awc_id = awc_id AND oc_ajo_id = ajo_id"
set query = Server.CreateObject("ADODB.Recordset")
query.ActiveConnection = MM_webdata_STRING
query.Source = sqlStr
query.CursorType = 0
query.CursorLocation = 2
query.LockType = 3
query.Open()
query_numRows = 0
Repeat1__numRows = -1
Repeat1__index = 0
query_numRows = query_numRows + Repeat1__numRows
While ((Repeat1__numRows <> 0) AND (NOT query.EOF))
%>
 |
address |
<% if (NOT query.Fields.Item("ajo_add1").Value = "") then %>
<%=(query.Fields.Item("ajo_add1").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add2").Value = "") then %>
<%=(query.Fields.Item("ajo_add2").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add3").Value = "") then %>
<%=(query.Fields.Item("ajo_add3").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add4").Value = "") then %>
<%=(query.Fields.Item("ajo_add4").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add5").Value = "") then %>
<%=(query.Fields.Item("ajo_add5").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add6").Value = "") then %>
<%=(query.Fields.Item("ajo_add6").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add7").Value = "") then %>
<%=(query.Fields.Item("ajo_add7").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add8").Value = "") then %>
<%=(query.Fields.Item("ajo_add8").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add9").Value = "") then %>
<%=(query.Fields.Item("ajo_add9").Value)%>
<% end if %>
<% if (NOT query.Fields.Item("ajo_add10").Value = "") then %>
<%=(query.Fields.Item("ajo_add10").Value)%>
<% end if %>
|
<% if (NOT query.Fields.Item("ajo_tel").Value = "") then %>
 |
telephone |
Tel: <%=(query.Fields.Item("ajo_tel").Value)%> |
<% end if %>
<% if (NOT query.Fields.Item("ajo_fax").Value = "") then %>
 |
fax |
Fax: <%=(query.Fields.Item("ajo_fax").Value)%> |
<% End If %>
<% if (NOT query.Fields.Item("ajo_email").Value = "") then %>
 |
email |
"><%=(query.Fields.Item("ajo_email").Value)%> |
<% End If %>
<% query.MoveNext
Wend
End If %>
|
|
 |