%@LANGUAGE="JAVASCRIPT"%>
<%
var RS_Partners__MMColParam = "2";
if (String(Request("MM_EmptyValue")) != "undefined" &&
String(Request("MM_EmptyValue")) != "") {
RS_Partners__MMColParam = String(Request("MM_EmptyValue"));
}
%>
<%
var RS_Partners_cmd = Server.CreateObject ("ADODB.Command");
RS_Partners_cmd.ActiveConnection = MM_Conn_Equistro_international_STRING;
RS_Partners_cmd.CommandText = "SELECT * FROM contacts_main WHERE Type = ? ORDER BY contact_company ASC";
RS_Partners_cmd.Prepared = true;
RS_Partners_cmd.Parameters.Append(RS_Partners_cmd.CreateParameter("param1", 5, 1, -1, RS_Partners__MMColParam)); // adDouble
var RS_Partners = RS_Partners_cmd.Execute();
var RS_Partners_numRows = 0;
%>
<%
var RS_NewsFlash_cmd = Server.CreateObject ("ADODB.Command");
RS_NewsFlash_cmd.ActiveConnection = MM_Conn_Equistro_international_STRING;
RS_NewsFlash_cmd.CommandText = "SELECT * FROM flash_table ORDER BY flash_date DESC";
RS_NewsFlash_cmd.Prepared = true;
var RS_NewsFlash = RS_NewsFlash_cmd.Execute();
var RS_NewsFlash_numRows = 0;
%>
<%
var rs_prNews_cmd = Server.CreateObject ("ADODB.Command");
rs_prNews_cmd.ActiveConnection = MM_Conn_Equistro_international_STRING;
rs_prNews_cmd.CommandText = "SELECT * FROM pr_table ORDER BY pr_date DESC";
rs_prNews_cmd.Prepared = true;
var rs_prNews = rs_prNews_cmd.Execute();
var rs_prNews_numRows = 0;
%>
<%
var Repeat1__numRows = 2;
var Repeat1__index = 0;
rs_prNews_numRows += Repeat1__numRows;
%>
<%
var NewsFlash__numRows = -1;
var NewsFlash__index = 0;
RS_NewsFlash_numRows += NewsFlash__numRows;
%>
<%
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
// set the record count
var rs_prNews_total = rs_prNews.RecordCount;
// set the number of rows displayed on this page
if (rs_prNews_numRows < 0) { // if repeat region set to all records
rs_prNews_numRows = rs_prNews_total;
} else if (rs_prNews_numRows == 0) { // if no repeat regions
rs_prNews_numRows = 1;
}
// set the first and last displayed record
var rs_prNews_first = 1;
var rs_prNews_last = rs_prNews_first + rs_prNews_numRows - 1;
// if we have the correct record count, check the other stats
if (rs_prNews_total != -1) {
rs_prNews_numRows = Math.min(rs_prNews_numRows, rs_prNews_total);
rs_prNews_first = Math.min(rs_prNews_first, rs_prNews_total);
rs_prNews_last = Math.min(rs_prNews_last, rs_prNews_total);
}
%>
<% var MM_paramName = ""; %>
<%
// *** Move To Record and Go To Record: declare variables
var MM_rs = rs_prNews;
var MM_rsCount = rs_prNews_total;
var MM_size = rs_prNews_numRows;
var MM_uniqueCol = "";
MM_paramName = "";
var MM_offset = 0;
var MM_atTotal = false;
var MM_paramIsDefined = (MM_paramName != "" && String(Request(MM_paramName)) != "undefined");
%>
<%
// *** Move To Record: handle 'index' or 'offset' parameter
if (!MM_paramIsDefined && MM_rsCount != 0) {
// use index parameter if defined, otherwise use offset parameter
r = String(Request("index"));
if (r == "undefined") r = String(Request("offset"));
if (r && r != "undefined") MM_offset = parseInt(r);
// if we have a record count, check if we are past the end of the recordset
if (MM_rsCount != -1) {
if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last
if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount % MM_size);
} else {
MM_offset = MM_rsCount - MM_size;
}
}
}
// move the cursor to the selected record
for (var i=0; !MM_rs.EOF && (i < MM_offset || MM_offset == -1); i++) {
MM_rs.MoveNext();
}
if (MM_rs.EOF) MM_offset = i; // set MM_offset to the last possible record
}
%>
<%
// *** Move To Record: if we dont know the record count, check the display range
if (MM_rsCount == -1) {
// walk to the end of the display range for this page
for (var i=MM_offset; !MM_rs.EOF && (MM_size < 0 || i < MM_offset + MM_size); i++) {
MM_rs.MoveNext();
}
// if we walked off the end of the recordset, set MM_rsCount and MM_size
if (MM_rs.EOF) {
MM_rsCount = i;
if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount;
}
// if we walked off the end, set the offset based on page size
if (MM_rs.EOF && !MM_paramIsDefined) {
if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount % MM_size);
} else {
MM_offset = MM_rsCount - MM_size;
}
}
// reset the cursor to the beginning
if (MM_rs.CursorType > 0) {
if (!MM_rs.BOF) MM_rs.MoveFirst();
} else {
MM_rs.Requery();
}
// move the cursor to the selected record
for (var i=0; !MM_rs.EOF && i < MM_offset; i++) {
MM_rs.MoveNext();
}
}
%>
<%
// *** Move To Record: update recordset stats
// set the first and last displayed record
rs_prNews_first = MM_offset + 1;
rs_prNews_last = MM_offset + MM_size;
if (MM_rsCount != -1) {
rs_prNews_first = Math.min(rs_prNews_first, MM_rsCount);
rs_prNews_last = Math.min(rs_prNews_last, MM_rsCount);
}
// set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount);
%>
<%
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
var MM_removeList = "&index=";
if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone="";
// add the URL parameters to the MM_keepURL string
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}
// add the Form variables to the MM_keepForm string
for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
}
}
// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL + MM_keepForm;
if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1);
if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
%>
<%
// *** Move To Record: set the strings for the first, last, next, and previous links
var MM_moveFirst="",MM_moveLast="",MM_moveNext="",MM_movePrev="";
var MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves
var MM_moveParam = "index";
// if the page has a repeated region, remove 'offset' from the maintained parameters
if (MM_size > 1) {
MM_moveParam = "offset";
if (MM_keepMove.length > 0) {
params = MM_keepMove.split("&");
MM_keepMove = "";
for (var i=0; i < params.length; i++) {
var nextItem = params[i].substring(0,params[i].indexOf("="));
if (nextItem.toLowerCase() != MM_moveParam) {
MM_keepMove += "&" + params[i];
}
}
if (MM_keepMove.length > 0) MM_keepMove = MM_keepMove.substring(1);
}
}
// set the strings for the move to links
if (MM_keepMove.length > 0) MM_keepMove = Server.HTMLEncode(MM_keepMove) + "&";
var urlStr = Request.ServerVariables("URL") + "?" + MM_keepMove + MM_moveParam + "=";
MM_moveFirst = urlStr + "0";
MM_moveLast = urlStr + "-1";
MM_moveNext = urlStr + (MM_offset + MM_size);
MM_movePrev = urlStr + Math.max(MM_offset - MM_size,0);
%>
Welcome to Equistro.com
Welcome to Equistro.com
Vétoquinol has a link with animals that
few pharmaceutical companies can match.
Vétoquinol is the 10th largest European veterinary pharmaceutical company. From its creation in 1933 it has been exclusively and passionately dedicated to developing, innovating and manufacturing veterinary medicines and nutritional supplements of the highest quality that each day, all around the world, help to improve the health and welfare of animals.
Nobody understands horses better than Vétoquinol.
This family owned and independent company prides itself on being above all passionate about animals and its desire to push back the veterinary frontiers for the sake of their welfare.
With more than 75 years of experience and acquired expertise in all areas related to horse health and well-being , it was only natural that Vétoquinol reinforced its already incontestable position as a leading nutraceutical expert with the acquisition of the EQUISTRO® range in 2001.
Vétoquinol is unique in its unrelenting strive for innovation, quality and improved nutritional solutions for the horse that only an International Veterinary Pharmaceutical company can provide.
Vétoquinol believes in leading from the front when it comes to helping the veterinary surgeon and horse owner alike to achieve a better understanding of this most noble of animalsthat was yesterday impossible…
And tomorrow…EQUISTRO® along with the wealth of expertise provided by Vétoquinol will continue to be at the forefront of this quest.
For more information concerning Vetoquinol please visit www.vetoquinol.com
<% while ((NewsFlash__numRows-- != 0) && (!RS_NewsFlash.EOF)) { %>