Scarborough Local Food Directory | Farmers' Markets in the area

<%@LANGUAGE="JAVASCRIPT"%> <% var everything_cmd = Server.CreateObject ("ADODB.Command"); everything_cmd.ActiveConnection = MM_localfood_STRING; everything_cmd.CommandText = "SELECT [local food ID], Company, [Address 1], [Address 2], Town, Postcode, [phone number], [email address], [website address], blurb, food1, food2, food3, food4, food5, outlet1, outlet2, [opening hours etc], fairtrade, notes, display FROM [2009_current] WHERE food1 = 'markets' or food2 = 'markets' or food3 = 'markets' or food4 = 'markets' or food5 = 'markets' and (display=true) ORDER BY Company ASC"; everything_cmd.Prepared = true; var everything = everything_cmd.Execute(); var everything_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; everything_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables // set the record count var everything_total = everything.RecordCount; // set the number of rows displayed on this page if (everything_numRows < 0) { // if repeat region set to all records everything_numRows = everything_total; } else if (everything_numRows == 0) { // if no repeat regions everything_numRows = 1; } // set the first and last displayed record var everything_first = 1; var everything_last = everything_first + everything_numRows - 1; // if we have the correct record count, check the other stats if (everything_total != -1) { everything_numRows = Math.min(everything_numRows, everything_total); everything_first = Math.min(everything_first, everything_total); everything_last = Math.min(everything_last, everything_total); } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (everything_total == -1) { // count the total records by iterating through the recordset for (everything_total=0; !everything.EOF; everything.MoveNext()) { everything_total++; } // reset the cursor to the beginning if (everything.CursorType > 0) { if (!everything.BOF) everything.MoveFirst(); } else { everything.Requery(); } // set the number of rows displayed on this page if (everything_numRows < 0 || everything_numRows > everything_total) { everything_numRows = everything_total; } // set the first and last displayed record everything_last = Math.min(everything_first + everything_numRows - 1, everything_total); everything_first = Math.min(everything_first, everything_total); } %> Scarborough Local Food Directory | Farmers' Markets in the area

jump to website contents list
jump to main text

There are <%=(everything_total)%> farmers' markets currently listed in the Scarborough local food directory

A farmers' market is one in which farmers, growers or producers from a defined local area are present in person to sell their own produce direct to the public. All products sold should have been grown, reared, caught, brewed, pickled, baked, smoked or processed by the stallholder.

<% while ((Repeat1__numRows-- != 0) && (!everything.EOF)) { %>

<%=(everything.Fields.Item("Company").Value)%>

<%=(everything.Fields.Item("Address 1").Value)%>, <%=(everything.Fields.Item("Address 2").Value)%>, <%=(everything.Fields.Item("Town").Value)%>, <%=(everything.Fields.Item("Postcode").Value)%>

<%=(everything.Fields.Item("blurb").Value)%>

<%=(everything.Fields.Item("outlet1").Value)%>

<%=(everything.Fields.Item("opening hours etc").Value)%>

Tel: <%=(everything.Fields.Item("phone number").Value)%>
<%=(everything.Fields.Item("email address").Value)%>
" target="_blank"><%=(everything.Fields.Item("website address").Value)%>

<% Repeat1__index++; everything.MoveNext(); } %>

If you know of a local business which you think should be included in the Scarborough Local Food Directory, please email details to localfood@topfield.org.uk.

Buy local – save money

Fruit is on average 30% more expensive in supermarkets than in street markets.
Food Commission, 1999 More >>>

<% everything.Close(); %>