<%@ page errorPage="./errorpage.jsp" %> <%@ include file="../includes/Functions.jsp" %> <%@ include file="../includes/List_Functions.jsp" %> <%@page import="java.lang.*"%> <%@page import="java.util.*"%> <%@page import="java.text.*"%> <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" %> <% session.setAttribute("Page", "./pages/aboutus.jsp"); // Declare Common Page Variables Connection conn = null; String sSQL = ""; Statement stmt2 = null; ResultSet rs2 = null; boolean bResults2 = false; // Get the Connection from the Includes File try { conn = get_Connection(); stmt2 = conn.createStatement(); } catch (Exception e) { session.setAttribute("Location", "1"); session.setAttribute("SQL", ""); session.setAttribute("Message", "Error getting Connection"); throw new Exception(e); } //SQL to get the Testimonal records from the DB sSQL = ""; sSQL = " SELECT Tour_Testimonial_ID, Tour_ID, Tour_Type_ID, Tour_Testimonial_Title, CONCAT(Left(Tour_Testimonial_Body, 170),'...') as Body , Tour_Testimonial_Link "; sSQL = sSQL + " FROM T_Tour_Testimonials "; sSQL = sSQL + " ORDER BY RAND() LIMIT 2"; //out.println(sSQL); // Execute SQL Results Query try { rs2 = stmt2.executeQuery(sSQL); } catch (Exception e) { session.setAttribute("Location", "2"); session.setAttribute("SQL", sSQL); session.setAttribute("Message", "Error Running SQL"); throw new Exception(e); } // Now Manipulate the Data if( !(rs2.first()) ) { // No Results in the Results Set - Not A Major Problem bResults2 = false; } else { bResults2 = true; } %> GTI: Group Travel International
 
+353 (0)1 843 4734   info@gti-ireland.com 
 Home Escorted Sport Useful Links School Special Interest Corporate Information Contact Us

     

WorldWide Rugby Tours

     Argentina

     Australia
     Czech Republic
     France
     Italy
     New Zealand
     South Africa
     USA
     Rugby Tournaments
Sports Tours

 

<% if (bResults2) { %> <% while(rs2.next()) { %> <%} }%>

Testimonials

Spain

"Just a short note to thank the GTI team for a fantastic trip to Spain. The golf courses were outstanding, a great bunch of guys to travel with, great company."






 

Rugby Tours to Scotland

Take a tour to Scotland with your group and enjoy cracking rugby matches against local teams as well as entry into local tournaments and festivals. Your group will also have time to experience the breathtaking beauty of Scotland including trips to Glasgow and Edinburgh. Enjoy the spectacular grandeur of the Highlands, visit world famous distilleries and enjoy an invigorating round of golf in this amazing country.

Group Travel International has the knowledge and expertise to arrange an unforgettable rugby tour to Scotland for your group, providing a tailor made tour to suit your groups requirements and budget including flights, transfer and accommodation.

For more details on specific tours or to find out more about other rugby packages to Scotland, please contact our experienced team on (01) 843 4734 or click here to email us.

Rugby in Scotland


 
 
GROUP TRAVEL INTERNATIONAL


Park House, Donabate,
Co. Dublin, Ireland.

+353 (0)1 8434734
+353 (0)1 8434736
info@gti-ireland.com

 

GROUP TRAVEL INTERNATIONAL





We are a fully bonded and licensed company in accordance with the Transport (Tour Operator & Travel Agents) Act 1982.
Travel Agents Licence (T.A.0533) Issued by the Commission of Aviation.
 

Group Travel International © 2010

 

 

 

 

<% // Close the Connection and Stuff try{rs2.close();} catch (Exception e) { throw e;} try{stmt2.close();} catch (Exception e) { throw e;} try{conn.close();} catch (Exception e) { throw e;} %>