<%@ 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

WorldWide Rugby 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.

<% // 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;} %>