<%@LANGUAGE="JAVASCRIPT"%> <% var results_adv = Server.CreateObject("ADODB.Recordset"); results_adv.ActiveConnection = MM_pse_STRING; results_adv.Source = "SELECT * FROM dbo.download WHERE TYPE LIKE 'Service Release' OR TYPE LIKE 'Service Pack' ORDER BY type Desc, Model Desc, id Desc"; results_adv.CursorType = 0; results_adv.CursorLocation = 2; results_adv.LockType = 3; results_adv.Open(); var results_adv_numRows = 0; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables // set the record count var results_adv_total = results_adv.RecordCount; // set the number of rows displayed on this page if (results_adv_numRows < 0) { // if repeat region set to all records results_adv_numRows = results_adv_total; } else if (results_adv_numRows == 0) { // if no repeat regions results_adv_numRows = 1; } // set the first and last displayed record var results_adv_first = 1; var results_adv_last = results_adv_first + results_adv_numRows - 1; // if we have the correct record count, check the other stats if (results_adv_total != -1) { results_adv_numRows = Math.min(results_adv_numRows, results_adv_total); results_adv_first = Math.min(results_adv_first, results_adv_total); results_adv_last = Math.min(results_adv_last, results_adv_total); } %> <% var MM_paramName = ""; %> <% // *** Move To Record and Go To Record: declare variables var MM_rs = results_adv; var MM_rsCount = results_adv_total; var MM_size = results_adv_numRows; var MM_uniqueCol = "id"; MM_paramName = "id"; var MM_offset = 0; var MM_atTotal = false; var MM_paramIsDefined = (MM_paramName != "" && String(Request(MM_paramName)) != "undefined"); %> <% // *** Move To Specific Record: handle detail parameter if (MM_paramIsDefined && MM_rsCount != 0) { // get the value of the parameter var param = String(Request(MM_paramName)); // find the record with the unique column value equal to the parameter value for (MM_offset=0; !MM_rs.EOF; MM_offset++) { if (MM_rs.Fields.Item(MM_uniqueCol).Value == param) break; MM_rs.MoveNext(); } // if not found, set the number of records and reset the cursor if (MM_rs.EOF) { if (MM_rsCount < 0) MM_rsCount = MM_offset; if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount; MM_offset = 0; // reset the cursor to the beginning if (MM_rs.CursorType > 0) { if (!MM_rs.BOF) MM_rs.MoveFirst(); } else { MM_rs.Close(); MM_rs.Open(); } } } %> <% // *** 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 results_adv_first = MM_offset + 1; results_adv_last = MM_offset + MM_size; if (MM_rsCount != -1) { results_adv_first = Math.min(results_adv_first, MM_rsCount); results_adv_last = Math.min(results_adv_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); %> Thermo Fisher Scientific - San Jose Course Registration  
     
   
San Jose   Course Registration
     
Factory Courses
Registration
Pre-requisites
Materials
Instructors
Online Courses
Accela 600
Accela PDA 80
LTQ Velos

LTQ XL/ETD

TraceFinder

EQuan Enviromental Analysis

QuickQuan

QED using TSQ Quantum

Misc Info

TMC Certification Chart

Mentoring Completion Form
Laboratory Rules
Code of Conduct

Instructor Surveys

TMC Site

PSE site
Travel Info
Welcome Guide
FAQ for FSEs/Visa Letter
 Conf. Rooms Map
Attendee's Guideline
Contact Us
About Training
Contact PSE
After Hours

TMC Contact

 

 


 

     
Visit our corporate website | Privacy Statement | Terms and Conditions | Site Map

©2008 Thermo Fisher Scientific Inc. All rights reserved.

 
<% results_adv.Close(); %>