<% strAdmin = Session("SbNuAdmin") strCheckAdmin = Mid(strAdmin, 6, 1) strDate = DateAdd("d", -1, Date) %> <% Set RSFairs = Server.CreateObject("ADODB.Recordset") Fairs = "SELECT tblFair.CountryID, tblCountry.ID AS CoID, tblCountry.EName AS CoName FROM tblFair INNER JOIN tblCountry ON tblFair.CountryID = tblCountry.ID WHERE tblFair.FairDate > " & strDate & " AND tblFair.Deleted = False GROUP BY tblCountry.EName, tblCountry.ID, tblFair.CountryID ORDER BY tblCountry.EName, tblCountry.ID, tblFair.CountryID " RSFairs.Open Fairs, Connect, adOpenStatic, adLockOptimistic Set RSFairsOrg = Server.CreateObject("ADODB.Recordset") FairsOrg = "SELECT tblFair.OrgID, tblFairOrg.ID AS OID, tblFairOrg.Name AS OName FROM tblFair INNER JOIN tblFairOrg ON tblFair.OrgID = tblFairOrg.ID WHERE tblFair.FairDate > " & strDate & " AND tblFair.Deleted = False GROUP BY tblFairOrg.Name, tblFairOrg.ID, tblFair.OrgID ORDER BY tblFairOrg.Name, tblFairOrg.ID, tblFair.OrgID " RSFairsOrg.Open FairsOrg, Connect, adOpenStatic, adLockOptimistic Set RSOrg = Server.CreateObject("ADODB.Recordset") Org = "SELECT tblFairOrg.CountryID, tblCountry.ID AS CoID, tblCountry.EName AS CoName FROM tblFairOrg INNER JOIN tblCountry ON tblFairOrg.CountryID = tblCountry.ID WHERE tblFairOrg.Deleted = False GROUP BY tblCountry.EName, tblCountry.ID, tblFairOrg.CountryID ORDER BY tblCountry.EName, tblCountry.ID, tblFairOrg.CountryID " RSOrg.Open Org, Connect, adOpenStatic, adLockOptimistic %>

Comming Record Fairs!

Here You'll find information about Comming Record Fairs and Organizers all around the world!

Choose which Fairs You want to see:
Show the whole list
Show all Fairs during 2009
Show all Fairs during 2010

Fairs in:
Organized by:


Choose which Organizers You want to see:
Show the whole list

Organizers in:


Do You miss any Fair or Organizer in the lists??

We're trying to keep this list over Coming Record Fairs as up to date as possible...
...but we need help from You with information.

You are welcome to send us a mail with information about Fairs / Organizers that You Miss.
It doesn't matter where in the world they are...

The info that we wish to have about Fairs are:
Date*
Country*
City*
Place*
Time
Entrance Fee
Organizer
Other info...

The info that we wish to have about Organizers are:
Name*
Contactperson
Homepage
E-Mail
Phone
Fax
Postaladdress
Other info...

* = Required information.