%
Dim PageSize
Dim Pages
Dim i
If IsEmpty(Request("PageNumber")) Then
CurrentPage = 1
Else
CurrentPage = cint(Request("PageNumber"))
End if
'SQL = "SELECT * FROM gallery_module WHERE Category = " & Request.QueryString("cat") & " and status = true"
SQL = "SELECT * FROM gallery_module WHERE Category = 26 and status = true ORDER BY displayorder"
Set rs = Server.CreateObject("ADODB.Recordset")
PageSize = 100 ' Page size
rs.CursorLocation = 3
rs.open SQL,"" & Application("Connection") & ";"
if not rs.eof then
rs.MoveLast
TotalRec = rs.RecordCount
rs.MoveFirst
rs.PageSize = PageSize
rs.AbsolutePage = CurrentPage
Pages = rs.PageCount
end if
%>
DATE
VENUE
LOCATION
JAN 2009
SATURDAY 17TH
ROADHOUSE BIRMINGHAM
SATURDAY 31ST
LEATHERHEAD THEATRE
LEATHERHEAD SURREY
FEBRUARY 2009
SATURDAY 7th
THE CORN EXCHANGE
HERTFORD
FRIDAY 27TH
THE LAMPLIGHT ARTS CENTRE
STANLEY CO.DURHAM
MARCH 2009
FRIDAY 20TH
ARDHOWEN THEATRE
ENNISKILLEN N.IRELAND
SATURDAY 21st
THE BUTTON FACTORY
DUBLIN
FRIDAY 27Th
TRINITY ARTS CENTRE
GAINSBOROUGH LINCS
SATURDAY 28TH
PRIVATE FUNCTION
SALISBURY
APRIL 2009
SATURDAY 4TH
RIGA
WESTCLIFF ON SEA
FRIDAY 10 Th
THE CORN EXCHANGE
HERTFORD
SATURDAY 11TH
HORN REBORN
ST ALBANS
MAY 2009
FRIDAY 8TH
3TUNS
NEWCASTLE
SATURDAY 9TH
THE LIQUID ROOM
EDINBURGH
FRIDAY 22ND
THE WEST MIDLANDS SHOWGROUND
SHREWSBURY
SATURDAY 23RD
TOWN HALL THEATRE
MAESTEG S.WALES
SATURDAY 30TH
THE CHEQUERMEAD THEATRE
EAST GRINSTEAD
JUNE 2009
SATURDAY 6TH .
BLACKFRIERS ARTS CENTRE
BOSTON LINCS
SATURDAY 13TH
THE GUILDHALL
GLOUCESTER
FRIDAY 19TH
HASLEMERE HALL
HASLEMERE SURREY
SATURDAY 20TH
MERRYFIELD THEATRE@THE HUB CENTRE
VERWOOD DORSET
JULY 2009
FRIDAY 3RD
T.B.C.
SATURDAY 4TH
THE BRAID ARTS CENTRE
BALLYMENA N. IRELAND
SUNDAY 5TH
T.B.C.
SATURDAY 11TH
THE SUBSCRIPTION ROOMS
STROUD
FRIDAY 24TH
THE BRINDLEY ARTS CENTRE
RUNCORN, CHESHIRE
SATURDAY 25 TH
THE ROADHOUSE
BIRMINHGAM
AUGUST 2009
FRIDAY 7 TH
THE MALTINGS ARTS CENTRE
BERWICK UPON TWEED
SATURDAY 8 TH
THE PERTH CONCERT HALL
PERTH, SCOTLAND.
SEPTEMBER 2009
SATURDAY 5TH
THE PALACE THEATRE
NEWARK
FRIDAY 11TH
THE CAMBERLEY THEATRE
CAMBERLEY SURREY
SATURDAY 12TH
RIGA
WESTCLIFF ON SEA
FRIDAY 18TH
THE STABLES THEATRE WAVENDON
MILTON KEYNES
SATURDAY 19TH
PONTARDAWE ARTS CENTRE---NEATH
S.WALES
FRIDAY 25 TH
THE VIKINGVOLKS FESTIVAL
NORTHALLERTON, N.YORKS
SATURDAY 26TH
THE ASSEMBLY ROOMS
TAMWORTH
OCTOBER 2009
FRIDAY 2ND
THE ROYAL SPA CENTRE
LEAMINGTON SPA
SATURDAY 3rd
EVESHAM ARTS CENTRE
EVESHAM, WORCS.
FRIDAY 9 TH
HAVANT ARTS CENTRE
HAVANT, PORTSMOUTH
FRIDAY 16 TH
THE KINGS HALL THEATRE
HEARNE BAY, KENT
FRIDAY 23RD
THE MILLFIELD THEATRE
EDMONTON N. LONDON
SATURDAY 24TH
HORN REBORN
ST ALBANS
THURSDAY 29TH
HEARNS HOTEL
CLONMEL, IRELAND
FRIDAY 30TH
THE MARKET PLACE THEATRE
ARMAGH N.IRELAND
SATURDAY 31ST
ELECTRIC AVENUE
WATERFORD, IRELAND
NOVEMBER 2009
FRIDAY 6 TH
THEATR MWLDAN
CARDIGAN, W.WALES
FRIDAY 13TH
THE RHODES ARTS CENTRE
BISHOPS STORTFORD
SATURDAY 14TH
THE M CLUB
CREWE
MORE DATES TO FOLLOW,PLEASE CHECK AGAIN FOR UPDATES