I am using the following script to pull in 10 UK postcodes into my page:
Expand|Select|Wrap|Line Numbers
- <%
- sqlStrB = "Select TOP 10 * from postcodetable"
- oRsBJ.Open sqlStrB, oDBConn
- If oRsBJ.eof then
- %>
- Sorry there are no postcodes
- <%
- Else
- %>
- ---
- <%
- Do while not oRsBJ.eof
- postcode = oRsBJ("postcode")
- %>
- <%=postcode%>
- <%
- oRsBJ.MoveNext
- loop
- %>
- ---
- <%
- End If
- %>
- <%
- oRsBJ.close
- set oRsBJ = nothing
- %>
Expand|Select|Wrap|Line Numbers
- <script type="text/javascript">
- var locations = [
- 'POSTCODE, UK',
- ];
- </script>
Expand|Select|Wrap|Line Numbers
- <script type="text/javascript">
- var locations = [
- 'LU4 9LT, UK',
- 'HP2 5UY, UK',
- 'WD2 6TF, UK',
- ];
- </script>
Any help would be fully appreciated
Best regards
Rod from the UK