<%@ Language=JavaScript %> <% var pathToMDB = Server.MapPath("../../../../../kristiDB/kristi.mdb"); var kristiID = 94; if(kristiID == "undefined") { Response.Write("Error: You must supply a kristiID for display.

\nExample: .../staff.asp?kristiID=12"); Response.End(); } //Holds the Database Connection Object var adoCon = new ActiveXObject("ADODB.Connection"); var resultSet = new ActiveXObject("ADODB.Recordset"); var query = "select * from tblKristiLogBook where internalKristiID=" + kristiID; //Set an active connection to the Connection object using a DSN-less connection try { adoCon.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + pathToMDB); } catch(e) { Response.Write("Error: I could not open a connection to the Access Database.
\nReason:" + e.description); Response.End(); } try { // Make the call: resultSet.open(query, adoCon); var theKristi = new Object(); if(resultSet.EOF) { Response.Write("Sorry, you entered an invalid (out of range) kristiID Number (" + kristiID + "). Please check your typing, or the link that you clicked."); resultSet.Close(); adoCon.Close(); Response.End(); } else { //gather the information for display: theKristi.serialnumber = new String( resultSet("strSerialNumber")); theKristi.model = new String( resultSet("strModel")); theKristi.builddate = new String( resultSet("strBuildDate")); theKristi.engine = new String( resultSet("strEngine")); theKristi.enginenumber = new String( resultSet("strEngineNumber")); theKristi.buyer = new String( resultSet("strBuyer")); theKristi.buyercity = new String( resultSet("strBuyerCity")); theKristi.buyerstate = new String( resultSet("strBuyerState")); theKristi.buyercountry = new String( resultSet("strCountry")); theKristi.salesagent = new String( resultSet("strSalesAgent")); theKristi.remarks = new String( resultSet("memRemarks")); theKristi.currentowner = new String( resultSet("strCurrentOwner")); theKristi.currentcondition = new String( resultSet("strCurrentCondition")); theKristi.currentintendeduse = new String( resultSet("strCurrentIntendedUse")); theKristi.currentcolor = new String( resultSet("strCurrentColor")); theKristi.currentlocation = new String( resultSet("strCurrentLocation")); theKristi.previousowners = new String( resultSet("strPreviousOwners")); theKristi.othernotes = new String( resultSet("memOtherNotes")); } //clean up after ourselves: resultSet.Close(); adoCon.Close(); //clean up our data a bit: for(field in theKristi) { if(theKristi[field] == "null") theKristi[field] = "unknown"; } } catch(e) { Response.Write("I could not query the database.
\nReason:" + e.description); Response.End(); } %> KristiSnowCat.com
Kristi Registry

Serial number - <%=theKristi.serialnumber%>
Model - <%=theKristi.model%>
Date of build - <%=theKristi.builddate%>
Engine - <%=theKristi.engine%>
Engine Serial Number - <%=theKristi.enginenumber%>
Original Buyer - <%=theKristi.buyer%>
Original Location - <%=theKristi.buyercity%>, <%=theKristi.buyerstate%>, <%=theKristi.buyercountry%>

Current owner - <%=theKristi.currentowner%>
Condition of unit - <%=theKristi.currentcondition%>
Intended use - <%=theKristi.currentintendeduse%>
Color - <%=theKristi.currentcolor%>
Location - <%=theKristi.currentlocation%>
Previous owners - <%=theKristi.previousowners%>
Other notes - <%=theKristi.othernotes%>

Soni Honegger was shown on national television in January 2008 when he participated in a search and rescue mission to find six lost snowmobilers in Chama, New Mexico.  Details including video can be found in our In The Press section. Way to go Soni!

If you are the owner of this Kristi or have a Kristi not listed in the registry, please send an email and we will add information to the Kristi registry. Thanks
Error processing SSI file