<% category=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace("Printing","(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">",""),"+","")) manufacturer=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("manufacturer"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">",""),"+","")) category2=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("category2"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">",""),"+","")) category3=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("category3"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">",""),"+","")) PRODUCTLINE=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("PRODUCTLINE"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">",""),"+","")) If category = "" and manufacturer = "" and category2 = "" and PRODUCTLINE = "" then Response.Redirect "https://www.posglobal.com/" End If if Request.QueryString("page") <> "" then page=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("page"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">",""),"+",""),"&","")) else page=1 end if Session("Category")=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace("Printing","(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">","")) Session("Manufacturer")=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("manufacturer"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">","")) Session("Category2")=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("category2"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">","")) Session("Category3")=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("category3"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">","")) Session("PRODUCTLINE")=Trim(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Request.QueryString("PRODUCTLINE"),"(",""),")",""),"'",""),";",""),"|",""),"""",""),"<",""),">","")) PN1 = page*30+1 PN2 = PN1-30 %> Printers: Barcode Label Printers, Card Printers, Media & Supplies, Printer Spare Parts, Print Heads, Print Stations, Receipt Printers, Slip Printers, Software and Accessories <% '-------------------------------------------------------------------- ' Microsoft ADO ' ' Copyright (c) 1996-1998 Microsoft Corporation. ' ' ' ' ADO constants include file for VBScript ' '-------------------------------------------------------------------- '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- CursorOptionEnum Values ---- Const adHoldRecords = &H00000100 Const adMovePrevious = &H00000200 Const adAddNew = &H01000400 Const adDelete = &H01000800 Const adUpdate = &H01008000 Const adBookmark = &H00002000 Const adApproxPosition = &H00004000 Const adUpdateBatch = &H00010000 Const adResync = &H00020000 Const adNotify = &H00040000 Const adFind = &H00080000 Const adSeek = &H00400000 Const adIndex = &H00800000 '---- LockTypeEnum Values ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 '---- ExecuteOptionEnum Values ---- Const adAsyncExecute = &H00000010 Const adAsyncFetch = &H00000020 Const adAsyncFetchNonBlocking = &H00000040 Const adExecuteNoRecords = &H00000080 Const adExecuteStream = &H00000400 '---- ConnectOptionEnum Values ---- Const adAsyncConnect = &H00000010 '---- ObjectStateEnum Values ---- Const adStateClosed = &H00000000 Const adStateOpen = &H00000001 Const adStateConnecting = &H00000002 Const adStateExecuting = &H00000004 Const adStateFetching = &H00000008 '---- CursorLocationEnum Values ---- Const adUseServer = 2 Const adUseClient = 3 '---- DataTypeEnum Values ---- Const adEmpty = 0 Const adTinyInt = 16 Const adSmallInt = 2 Const adInteger = 3 Const adBigInt = 20 Const adUnsignedTinyInt = 17 Const adUnsignedSmallInt = 18 Const adUnsignedInt = 19 Const adUnsignedBigInt = 21 Const adSingle = 4 Const adDouble = 5 Const adCurrency = 6 Const adDecimal = 14 Const adNumeric = 131 Const adBoolean = 11 Const adError = 10 Const adUserDefined = 132 Const adVariant = 12 Const adIDispatch = 9 Const adIUnknown = 13 Const adGUID = 72 Const adDate = 7 Const adDBDate = 133 Const adDBTime = 134 Const adDBTimeStamp = 135 Const adBSTR = 8 Const adChar = 129 Const adVarChar = 200 Const adLongVarChar = 201 Const adWChar = 130 Const adVarWChar = 202 Const adLongVarWChar = 203 Const adBinary = 128 Const adVarBinary = 204 Const adLongVarBinary = 205 Const adChapter = 136 Const adFileTime = 64 Const adPropVariant = 138 Const adVarNumeric = 139 Const adArray = &H2000 '---- FieldAttributeEnum Values ---- Const adFldMayDefer = &H00000002 Const adFldUpdatable = &H00000004 Const adFldUnknownUpdatable = &H00000008 Const adFldFixed = &H00000010 Const adFldIsNullable = &H00000020 Const adFldMayBeNull = &H00000040 Const adFldLong = &H00000080 Const adFldRowID = &H00000100 Const adFldRowVersion = &H00000200 Const adFldCacheDeferred = &H00001000 Const adFldIsChapter = &H00002000 Const adFldNegativeScale = &H00004000 Const adFldKeyColumn = &H00008000 Const adFldIsRowURL = &H00010000 Const adFldIsDefaultStream = &H00020000 Const adFldIsCollection = &H00040000 '---- EditModeEnum Values ---- Const adEditNone = &H0000 Const adEditInProgress = &H0001 Const adEditAdd = &H0002 Const adEditDelete = &H0004 '---- RecordStatusEnum Values ---- Const adRecOK = &H0000000 Const adRecNew = &H0000001 Const adRecModified = &H0000002 Const adRecDeleted = &H0000004 Const adRecUnmodified = &H0000008 Const adRecInvalid = &H0000010 Const adRecMultipleChanges = &H0000040 Const adRecPendingChanges = &H0000080 Const adRecCanceled = &H0000100 Const adRecCantRelease = &H0000400 Const adRecConcurrencyViolation = &H0000800 Const adRecIntegrityViolation = &H0001000 Const adRecMaxChangesExceeded = &H0002000 Const adRecObjectOpen = &H0004000 Const adRecOutOfMemory = &H0008000 Const adRecPermissionDenied = &H0010000 Const adRecSchemaViolation = &H0020000 Const adRecDBDeleted = &H0040000 '---- GetRowsOptionEnum Values ---- Const adGetRowsRest = -1 '---- PositionEnum Values ---- Const adPosUnknown = -1 Const adPosBOF = -2 Const adPosEOF = -3 '---- BookmarkEnum Values ---- Const adBookmarkCurrent = 0 Const adBookmarkFirst = 1 Const adBookmarkLast = 2 '---- MarshalOptionsEnum Values ---- Const adMarshalAll = 0 Const adMarshalModifiedOnly = 1 '---- AffectEnum Values ---- Const adAffectCurrent = 1 Const adAffectGroup = 2 Const adAffectAllChapters = 4 '---- ResyncEnum Values ---- Const adResyncUnderlyingValues = 1 Const adResyncAllValues = 2 '---- CompareEnum Values ---- Const adCompareLessThan = 0 Const adCompareEqual = 1 Const adCompareGreaterThan = 2 Const adCompareNotEqual = 3 Const adCompareNotComparable = 4 '---- FilterGroupEnum Values ---- Const adFilterNone = 0 Const adFilterPendingRecords = 1 Const adFilterAffectedRecords = 2 Const adFilterFetchedRecords = 3 Const adFilterConflictingRecords = 5 '---- SearchDirectionEnum Values ---- Const adSearchForward = 1 Const adSearchBackward = -1 '---- PersistFormatEnum Values ---- Const adPersistADTG = 0 Const adPersistXML = 1 '---- StringFormatEnum Values ---- Const adClipString = 2 '---- ConnectPromptEnum Values ---- Const adPromptAlways = 1 Const adPromptComplete = 2 Const adPromptCompleteRequired = 3 Const adPromptNever = 4 '---- ConnectModeEnum Values ---- Const adModeUnknown = 0 Const adModeRead = 1 Const adModeWrite = 2 Const adModeReadWrite = 3 Const adModeShareDenyRead = 4 Const adModeShareDenyWrite = 8 Const adModeShareExclusive = &Hc Const adModeShareDenyNone = &H10 Const adModeRecursive = &H400000 '---- RecordCreateOptionsEnum Values ---- Const adCreateCollection = &H00002000 Const adCreateStructDoc = &H80000000 Const adCreateNonCollection = &H00000000 Const adOpenIfExists = &H02000000 Const adCreateOverwrite = &H04000000 Const adFailIfNotExists = -1 '---- RecordOpenOptionsEnum Values ---- Const adOpenRecordUnspecified = -1 Const adOpenOutput = &H00800000 Const adOpenAsync = &H00001000 Const adDelayFetchStream = &H00004000 Const adDelayFetchFields = &H00008000 Const adOpenExecuteCommand = &H00010000 '---- IsolationLevelEnum Values ---- Const adXactUnspecified = &Hffffffff Const adXactChaos = &H00000010 Const adXactReadUncommitted = &H00000100 Const adXactBrowse = &H00000100 Const adXactCursorStability = &H00001000 Const adXactReadCommitted = &H00001000 Const adXactRepeatableRead = &H00010000 Const adXactSerializable = &H00100000 Const adXactIsolated = &H00100000 '---- XactAttributeEnum Values ---- Const adXactCommitRetaining = &H00020000 Const adXactAbortRetaining = &H00040000 '---- PropertyAttributesEnum Values ---- Const adPropNotSupported = &H0000 Const adPropRequired = &H0001 Const adPropOptional = &H0002 Const adPropRead = &H0200 Const adPropWrite = &H0400 '---- ErrorValueEnum Values ---- Const adErrProviderFailed = &Hbb8 Const adErrInvalidArgument = &Hbb9 Const adErrOpeningFile = &Hbba Const adErrReadFile = &Hbbb Const adErrWriteFile = &Hbbc Const adErrNoCurrentRecord = &Hbcd Const adErrIllegalOperation = &Hc93 Const adErrCantChangeProvider = &Hc94 Const adErrInTransaction = &Hcae Const adErrFeatureNotAvailable = &Hcb3 Const adErrItemNotFound = &Hcc1 Const adErrObjectInCollection = &Hd27 Const adErrObjectNotSet = &Hd5c Const adErrDataConversion = &Hd5d Const adErrObjectClosed = &He78 Const adErrObjectOpen = &He79 Const adErrProviderNotFound = &He7a Const adErrBoundToCommand = &He7b Const adErrInvalidParamInfo = &He7c Const adErrInvalidConnection = &He7d Const adErrNotReentrant = &He7e Const adErrStillExecuting = &He7f Const adErrOperationCancelled = &He80 Const adErrStillConnecting = &He81 Const adErrInvalidTransaction = &He82 Const adErrUnsafeOperation = &He84 Const adwrnSecurityDialog = &He85 Const adwrnSecurityDialogHeader = &He86 Const adErrIntegrityViolation = &He87 Const adErrPermissionDenied = &He88 Const adErrDataOverflow = &He89 Const adErrSchemaViolation = &He8a Const adErrSignMismatch = &He8b Const adErrCantConvertvalue = &He8c Const adErrCantCreate = &He8d Const adErrColumnNotOnThisRow = &He8e Const adErrURLIntegrViolSetColumns = &He8f Const adErrURLDoesNotExist = &He8f Const adErrTreePermissionDenied = &He90 Const adErrInvalidURL = &He91 Const adErrResourceLocked = &He92 Const adErrResourceExists = &He93 Const adErrCannotComplete = &He94 Const adErrVolumeNotFound = &He95 Const adErrOutOfSpace = &He96 Const adErrResourceOutOfScope = &He97 Const adErrUnavailable = &He98 Const adErrURLNamedRowDoesNotExist = &He99 Const adErrDelResOutOfScope = &He9a Const adErrPropInvalidColumn = &He9b Const adErrPropInvalidOption = &He9c Const adErrPropInvalidValue = &He9d Const adErrPropConflicting = &He9e Const adErrPropNotAllSettable = &He9f Const adErrPropNotSet = &Hea0 Const adErrPropNotSettable = &Hea1 Const adErrPropNotSupported = &Hea2 Const adErrCatalogNotSet = &Hea3 Const adErrCantChangeConnection = &Hea4 Const adErrFieldsUpdateFailed = &Hea5 Const adErrDenyNotSupported = &Hea6 Const adErrDenyTypeNotSupported = &Hea7 '---- ParameterAttributesEnum Values ---- Const adParamSigned = &H0010 Const adParamNullable = &H0040 Const adParamLong = &H0080 '---- ParameterDirectionEnum Values ---- Const adParamUnknown = &H0000 Const adParamInput = &H0001 Const adParamOutput = &H0002 Const adParamInputOutput = &H0003 Const adParamReturnValue = &H0004 '---- CommandTypeEnum Values ---- Const adCmdUnknown = &H0008 Const adCmdText = &H0001 Const adCmdTable = &H0002 Const adCmdStoredProc = &H0004 Const adCmdFile = &H0100 Const adCmdTableDirect = &H0200 '---- EventStatusEnum Values ---- Const adStatusOK = &H0000001 Const adStatusErrorsOccurred = &H0000002 Const adStatusCantDeny = &H0000003 Const adStatusCancel = &H0000004 Const adStatusUnwantedEvent = &H0000005 '---- EventReasonEnum Values ---- Const adRsnAddNew = 1 Const adRsnDelete = 2 Const adRsnUpdate = 3 Const adRsnUndoUpdate = 4 Const adRsnUndoAddNew = 5 Const adRsnUndoDelete = 6 Const adRsnRequery = 7 Const adRsnResynch = 8 Const adRsnClose = 9 Const adRsnMove = 10 Const adRsnFirstChange = 11 Const adRsnMoveFirst = 12 Const adRsnMoveNext = 13 Const adRsnMovePrevious = 14 Const adRsnMoveLast = 15 '---- SchemaEnum Values ---- Const adSchemaProviderSpecific = -1 Const adSchemaAsserts = 0 Const adSchemaCatalogs = 1 Const adSchemaCharacterSets = 2 Const adSchemaCollations = 3 Const adSchemaColumns = 4 Const adSchemaCheckConstraints = 5 Const adSchemaConstraintColumnUsage = 6 Const adSchemaConstraintTableUsage = 7 Const adSchemaKeyColumnUsage = 8 Const adSchemaReferentialConstraints = 9 Const adSchemaTableConstraints = 10 Const adSchemaColumnsDomainUsage = 11 Const adSchemaIndexes = 12 Const adSchemaColumnPrivileges = 13 Const adSchemaTablePrivileges = 14 Const adSchemaUsagePrivileges = 15 Const adSchemaProcedures = 16 Const adSchemaSchemata = 17 Const adSchemaSQLLanguages = 18 Const adSchemaStatistics = 19 Const adSchemaTables = 20 Const adSchemaTranslations = 21 Const adSchemaProviderTypes = 22 Const adSchemaViews = 23 Const adSchemaViewColumnUsage = 24 Const adSchemaViewTableUsage = 25 Const adSchemaProcedureParameters = 26 Const adSchemaForeignKeys = 27 Const adSchemaPrimaryKeys = 28 Const adSchemaProcedureColumns = 29 Const adSchemaDBInfoKeywords = 30 Const adSchemaDBInfoLiterals = 31 Const adSchemaCubes = 32 Const adSchemaDimensions = 33 Const adSchemaHierarchies = 34 Const adSchemaLevels = 35 Const adSchemaMeasures = 36 Const adSchemaProperties = 37 Const adSchemaMembers = 38 Const adSchemaTrustees = 39 Const adSchemaFunctions = 40 Const adSchemaActions = 41 Const adSchemaCommands = 42 Const adSchemaSets = 43 '---- FieldStatusEnum Values ---- Const adFieldOK = 0 Const adFieldCantConvertValue = 2 Const adFieldIsNull = 3 Const adFieldTruncated = 4 Const adFieldSignMismatch = 5 Const adFieldDataOverflow = 6 Const adFieldCantCreate = 7 Const adFieldUnavailable = 8 Const adFieldPermissionDenied = 9 Const adFieldIntegrityViolation = 10 Const adFieldSchemaViolation = 11 Const adFieldBadStatus = 12 Const adFieldDefault = 13 Const adFieldIgnore = 15 Const adFieldDoesNotExist = 16 Const adFieldInvalidURL = 17 Const adFieldResourceLocked = 18 Const adFieldResourceExists = 19 Const adFieldCannotComplete = 20 Const adFieldVolumeNotFound = 21 Const adFieldOutOfSpace = 22 Const adFieldCannotDeleteSource = 23 Const adFieldReadOnly = 24 Const adFieldResourceOutOfScope = 25 Const adFieldAlreadyExists = 26 Const adFieldPendingInsert = &H10000 Const adFieldPendingDelete = &H20000 Const adFieldPendingChange = &H40000 Const adFieldPendingUnknown = &H80000 Const adFieldPendingUnknownDelete = &H100000 '---- SeekEnum Values ---- Const adSeekFirstEQ = &H1 Const adSeekLastEQ = &H2 Const adSeekAfterEQ = &H4 Const adSeekAfter = &H8 Const adSeekBeforeEQ = &H10 Const adSeekBefore = &H20 '---- ADCPROP_UPDATECRITERIA_ENUM Values ---- Const adCriteriaKey = 0 Const adCriteriaAllCols = 1 Const adCriteriaUpdCols = 2 Const adCriteriaTimeStamp = 3 '---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ---- Const adPriorityLowest = 1 Const adPriorityBelowNormal = 2 Const adPriorityNormal = 3 Const adPriorityAboveNormal = 4 Const adPriorityHighest = 5 '---- ADCPROP_AUTORECALC_ENUM Values ---- Const adRecalcUpFront = 0 Const adRecalcAlways = 1 '---- ADCPROP_UPDATERESYNC_ENUM Values ---- '---- ADCPROP_UPDATERESYNC_ENUM Values ---- '---- MoveRecordOptionsEnum Values ---- Const adMoveUnspecified = -1 Const adMoveOverWrite = 1 Const adMoveDontUpdateLinks = 2 Const adMoveAllowEmulation = 4 '---- CopyRecordOptionsEnum Values ---- Const adCopyUnspecified = -1 Const adCopyOverWrite = 1 Const adCopyAllowEmulation = 4 Const adCopyNonRecursive = 2 '---- StreamTypeEnum Values ---- Const adTypeBinary = 1 Const adTypeText = 2 '---- LineSeparatorEnum Values ---- Const adLF = 10 Const adCR = 13 Const adCRLF = -1 '---- StreamOpenOptionsEnum Values ---- Const adOpenStreamUnspecified = -1 Const adOpenStreamAsync = 1 Const adOpenStreamFromRecord = 4 '---- StreamWriteEnum Values ---- Const adWriteChar = 0 Const adWriteLine = 1 '---- SaveOptionsEnum Values ---- Const adSaveCreateNotExist = 1 Const adSaveCreateOverWrite = 2 '---- FieldEnum Values ---- Const adDefaultStream = -1 Const adRecordURL = -2 '---- StreamReadEnum Values ---- Const adReadAll = -1 Const adReadLine = -2 '---- RecordTypeEnum Values ---- Const adSimpleRecord = 0 Const adCollectionRecord = 1 Const adStructDoc = 2 %>
   
FREE SHIPPING * On Most Orders
1-877-769-7300 <%Response.Expires = -1 %> <%Response.ExpiresAbsolute = Now() - 1 %> <%Response.AddHeader "pragma", "no-cache" %> <%Response.AddHeader "cache-control", "private" %> <%Response.CacheControl = "no-cache" %> <% Response.Expires = -1000 Response.Buffer = True %> <%Your_UserName = request.cookies("UserName")%> <%Date_In = request.cookies("still")%>
<% Response.Expires = -1000 Response.ExpiresAbsolute = Now() - 1 If request.cookies("UserName") <> "" AND Session("UserName") <> "" then%> Welcome <% =Your_UserName%>!   | MyAccount | Logout <% Else %> Create Account | Login <% End If %>
<%If searchTerm = "Keywords" then%> SKU, UPC or Mfr Part#     Keywords <%Else%> SKU, UPC or Mfr Part#     Keywords <%End If%> <% DIM searchTerm Response.Cookies("searchTerm") = searchTerm %> ">
Shopping Cart
<% Dim CONN_STRING Dim oConn Dim sSQL Set oConn = Server.CreateObject("ADODB.Connection") CONN_STRING = "DRIVER={SQL Server};SERVER=localhost;UID=POSGlobal;PWD=PR0tDYRm3nYosG;DATABASE=POSGlobal" oConn.Open(CONN_STRING) %> <% Dim CONN_USER Dim CONN_PASS If Session("Manufacturer") ="" AND Session("Category") <>"" AND Session("Category2") ="" AND Session("Category3") ="" AND Session("PRODUCTLINE") ="" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") ="" AND Session("Category") <>"" AND Session("Category2") <>"" AND Session("Category3") ="" AND Session("PRODUCTLINE") ="" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Category2='"&Category2&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Category2='"&Category2&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") <>"" AND Session("Category") <>"" AND Session("Category2") ="" AND Session("Category3") ="" AND Session("PRODUCTLINE") ="" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") ="" AND Session("Category") <>"" AND Session("Category2") ="" AND Session("Category3") ="" AND Session("PRODUCTLINE") <>"" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") ="" AND Session("Category") <>"" AND Session("Category2") <>"" AND Session("Category3") <>"" AND Session("PRODUCTLINE") ="" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Category2='"&Category2&"' and Category3='"&Category3&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Category2='"&Category2&"' and Category3='"&Category3&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") ="" AND Session("Category") <>"" AND Session("Category2") <>"" AND Session("Category3") ="" AND Session("PRODUCTLINE") <>"" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Category2='"&Category2&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Category2='"&Category2&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") <>"" AND Session("Category") <>"" AND Session("Category2") ="" AND Session("Category3") ="" AND Session("PRODUCTLINE") <>"" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") <>"" AND Session("Category") <>"" AND Session("Category2") <>"" AND Session("Category3") ="" AND Session("PRODUCTLINE") ="" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"' and Category2='"&Category2&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"' and Category2='"&Category2&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If If Session("Manufacturer") <>"" AND Session("Category") <>"" AND Session("Category2") <>"" AND Session("Category3") ="" AND Session("PRODUCTLINE") <>"" Then sSQL = "SELECT Count(*) AS TotalRecords FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"' and Category2='"&Category2&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"'" Set countRS = oConn.Execute(sSQL) strSQL = "SELECT TOP 30 SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM (SELECT ROW_NUMBER() OVER (ORDER BY Qty DESC, Price, MPN) AS RowNum, SKU, MPN, UPC, Vendor, Description, Productline, Price, Qty, ImageURL, ENHANCEDDESCRIPTION, etDescription FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Vendor='"&Manufacturer&"' and Category2='"&Category2&"' AND Replace(Replace(Replace(PRODUCTLINE,'(',''),')',''),'+','')='"&PRODUCTLINE&"') AS RowConstrainedResult WHERE RowNum >= '"&PN2&"' AND RowNum < '"&PN1&"' ORDER BY RowNum" End If TotalRecords = countRS("TotalRecords").Value if round(TotalRecords/30,2) =< 1 then TotalPages=1 elseif round(TotalRecords/30) = TotalRecords/30 then TotalPages=round(TotalRecords/30) elseif right(FormatNumber(TotalRecords/30),2) < 50 then TotalPages=round(TotalRecords/30)+1 else TotalPages=round(TotalRecords/30) end if CONN_USER = "" CONN_PASS = "" Dim iPageSize 'How big our pages are Dim iPageCount 'The number of pages we get back Dim iPageCurrent 'The page we want to show Dim strOrderBy 'A fake parameter used to illustrate passing them Dim strSQL 'SQL command to execute Dim objPagingConn 'The ADODB connection object Dim objPagingRS 'The ADODB recordset object Dim iRecordsShown 'Loop controller for displaying just iPageSize records Dim I 'Standard looping var Dim J 'Standard looping var Dim nRecCount 'Records count ' Get parameters iPageSize = 30 ' Number to be display on a page ' Retrieve page to show or default to 1 If Request.QueryString("page") = "" Then iPageCurrent = 1 Else iPageCurrent = CInt(Request.QueryString("page")) End If ' Make sure the input is one of our fields. strOrderBy = LCase(Request.QueryString("order")) Select Case strOrderBy Case "AvailabilityFlag", "SKU", "MSRP" ' A little pointless, but... strOrderBy = strOrderBy Case Else strOrderBy = "AvailabilityFlag" End Select ' Build our SQL String using the parameters we just got. Set objPagingConn = Server.CreateObject("ADODB.Connection") objPagingConn.Open CONN_STRING, CONN_USER, CONN_PASS ' Create recordset and set the page size Set objPagingRS = Server.CreateObject("ADODB.Recordset") objPagingRS.PageSize = iPageSize ' You can change other settings as with any RS 'objPagingRS.CursorLocation = adUseClient objPagingRS.CacheSize = iPageSize ' Open RS objPagingRS.Open strSQL, objPagingConn, adOpenStatic, adLockReadOnly, adCmdText ' Get the count of the pages using the given page size iPageCount = objPagingRS.PageCount ' Get records count nRecCount = TotalRecords ' If the request page falls outside the acceptable range, ' give them the closest match (1 or max) If iPageCurrent > iPageCount Then iPageCurrent = iPageCount If iPageCurrent < 1 Then iPageCurrent = 1 ' Check page count to prevent bombing when zero results are returned! If iPageCount = 0 Then Response.Write "" & vbCrLf Response.Write vbTab & "" & vbCrLf Response.Write vbTab & "" & vbCrLf Response.Write vbTab & "" & vbCrLf Response.Write vbTab & "
" & vbCrLf Response.Write "No record found!" Response.Write vbTab & "
" & vbCrLf Response.Write "" & vbCrLf Response.Write vbTab & "" & vbCrLf Response.Write vbTab & "
" & vbCrLf Response.Write "" & vbCrLf Response.Write vbTab & "" & vbCrLf Response.Write vbTab & "" & vbCrLf Response.Write vbTab & "" & vbCrLf Else ' Move to the selected page objPagingRS.AbsolutePage = iPageCurrent ' Start output with a page x of n line If iPageCurrent = 1 then ItemShowStart = 1 Else ItemShowStart = (iPageCurrent - 1) * iPageSize + 1 End If If iPageCurrent = iPageCount then ItemShowEnd = nRecCount Else ItemShowEnd = iPageCurrent * iPageSize End If %>
" & vbCrLf Response.Write "No record found!" Response.Write vbTab & "

  Sub-Categories:
<% IF Manufacturer <> "" then sSQL = "SELECT DISTINCT Category2 FROM POSCON WITH (INDEX(CAT))WHERE Vendor='"&Manufacturer&"' and Category1='"&Category&"' Order by Category2" Set oRS7 = oConn.Execute(sSQL) Else sSQL = "SELECT DISTINCT Category2 FROM POSCON WITH (INDEX(CAT))WHERE Category1='"&Category&"' Order by Category2" Set oRS7 = oConn.Execute(sSQL) End If Do While NOT oRS7.EOF %> <%If Manufacturer<>"" Then%> <%IF oRS7("Category2").Value <>"" then%> • &Manufacturer=<%=Manufacturer%>" class="nounderline"><%=Replace(oRS7("Category2").Value,"-"," ")%> <%Else%> • " class="nounderline"><%=oRS7("Category2").Value%> <%End If%> <%Else%> <%IF oRS7("Category2").Value <>"" then%> • " class="nounderline"><%=Replace(oRS7("Category2").Value,"-"," ")%> <%Else%> • " class="nounderline"><%=oRS7("Category2").Value%> <%End If%> <%End If%>
<% oRS7.MoveNext Loop %>
 
Manufacturers:
<% If Category2 <> "" Then sSQL = "SELECT DISTINCT Vendor From POSCON WITH (INDEX(CAT)) WHERE Category1= '"&Category&"' and Category2='"&Category2&"' ORDER BY Vendor" Set oRS6 = oConn.Execute(sSQL) Else sSQL = "SELECT DISTINCT Vendor From POSCON WITH (INDEX(CAT)) WHERE Category1 = '"&Category&"' ORDER BY Vendor" Set oRS6 = oConn.Execute(sSQL) End If Do While NOT oRS6.EOF IF Not oRS6.EOF Then %> <%If category2 <> "" Then%> • " class="nounderline"><%=Replace(oRS6("Vendor").Value,"-"," ")%> <%Else%> <%IF oRS6("Vendor").Value <>"" then%> • " class="nounderline"><%=Replace(oRS6("Vendor").Value,"-"," ")%> <%Else%> • " class="nounderline"><%=oRS6("Vendor").Value%> <%End If%> <%End If%>
<%End If%> <% oRS6.MoveNext Loop %>
 
Models:
<% IF Manufacturer <> "" and Category2 ="" then sSQL = "SELECT DISTINCT PRODUCTLINE FROM POSCON WITH (INDEX(CAT)) WHERE Vendor='"&Manufacturer&"' and Category1='"&Category&"' Order by PRODUCTLINE" Set oRS8 = oConn.Execute(sSQL) Else IF Manufacturer = "" and Category2 <> "" then sSQL = "SELECT DISTINCT PRODUCTLINE FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' and Category2='"&Category2&"' Order by PRODUCTLINE" Set oRS8 = oConn.Execute(sSQL) Else IF Manufacturer <> "" and Category2 <> "" then sSQL = "SELECT DISTINCT PRODUCTLINE FROM POSCON WITH (INDEX(CAT)) WHERE Vendor='"&Manufacturer&"' and Category1='"&Category&"' and Category2='"&Category2&"' Order by PRODUCTLINE" Set oRS8 = oConn.Execute(sSQL) Else sSQL = "SELECT DISTINCT PRODUCTLINE FROM POSCON WITH (INDEX(CAT)) WHERE Category1='"&Category&"' Order by PRODUCTLINE" Set oRS8 = oConn.Execute(sSQL) End If End If End If Do While NOT oRS8.EOF %>
<%IF oRS8("PRODUCTLINE").Value <> "" then%> <%If category2 <> "" and Manufacturer <> "" Then%> " class="nounderline"><%=replace(oRS8("PRODUCTLINE").Value,"-"," ")%> <%Else If category2 <> "" and Manufacturer = "" Then%> " class="nounderline"><%=replace(oRS8("PRODUCTLINE").Value,"-"," ")%> <%Else If category2 = "" and Manufacturer <> "" Then%> " class="nounderline"><%=replace(oRS8("PRODUCTLINE").Value,"-"," ")%> <%Else%> " class="nounderline"><%=replace(oRS8("PRODUCTLINE").Value,"-"," ")%> <% End IF End IF End IF %> <%Else%> <%End IF%>
<% oRS8.MoveNext Loop %>
<% objPagingRS.Close Set objPagingRS = Nothing objPagingConn.Close Set objPagingConn = Nothing %>

Home > <%if Session("Category") <> "" AND Session("Manufacturer") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") = "" then%> <%=Replace(Session("Category"), "-", " ")%> <%Else if Session("Category") <> "" AND Session("Manufacturer") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") <> "" then%> <%=Replace(Session("Category"), "-", " ")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Manufacturer") <> "" AND Session("Category") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Manufacturer"), "-", " ")%> <%Else If Session("Manufacturer") <> "" AND Session("Category") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") <> "" Then%> "><%=Replace(Session("Manufacturer"), "-", " ")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Manufacturer") = "" AND Session("Category") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Category"), "-", " ")%> > <%=Replace(Session("Category2"), "-", " ")%> <%Else If Session("Manufacturer") = "" AND Session("Category") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") <> "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Category2=<%=Session("Category2")%>"><%=Session("Category2")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") = "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Category"), "-", " ")%> > <%=Replace(Session("Manufacturer"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") = "" AND Session("PRODUCTLINE") <> "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Manufacturer=<%=Session("Manufacturer")%>"><%=Session("Manufacturer")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Category2=<%=Session("Category2")%>"><%=Session("Category2")%> > <%=Replace(Session("Manufacturer"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") <> "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Category2=<%=Session("Category2")%>"><%=Session("Category2")%> > &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>"><%=Session("Manufacturer")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%>

Barcode Label Printers, Card Printers, Media & Supplies, Print Heads, Print Stations, Receipt Printers, Slip Printers, Software and Accessories

Looking for Printers? POS Global has: Barcode Label Printers, Card Printers, Media & Supplies, Printer Spare Parts, Print Heads, Print Stations, Receipt Printers, Slip Printers, Software and Accessories. You can browse online today and feel free to contact us for more information or to better understand how our products can benefit you. Plan on buying something else? Don't forget to purchase Power UPS.

<%if TotalRecords < PN1-1 then%> Showing: <%=PN2%> - <%=TotalRecords%> of <%=TotalRecords%> Items <%else%> Showing: <%=PN2%> - <%=PN1-1%> of <%=TotalRecords%> Items <%end if%> Total Page(s): <%=TotalPages%> 

<% iPageCount = TotalPages If Request.QueryString("page") = "" Then iPageCurrent = 1 Else iPageCurrent = CInt(Request.QueryString("page")) End If If iPageCurrent > 9 Then %> <%If Session("Category2") = "" and Session("Manufacturer") = "" and Session("PRODUCTLINE") = "" Then%> &page=1">[First]   &page=<%= iPageCurrent - 10 %>">[Prev 10]   <%Else%> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=1">[First]   &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= iPageCurrent - 10 %>">[Prev 10]   <% End IF %> <% End If ' You can also show page numbers: If iPageCurrent + 4 < iPageCount then J = iPageCurrent + 4 Else J = iPageCount End If If iPageCurrent =< 10 and iPageCount =< 10 then For I =1 To iPageCount If I = iPageCurrent Then %> <%= I %>  <% Else %> <%If Session("Category2") = "" and Session("Manufacturer") = "" and Session("PRODUCTLINE") = "" Then%> &page=<%= I %>"><%= I %>  <%Else%> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= I %>"><%= I %>  <%End IF%> <% End If Next 'I Else If iPageCurrent < 10 and iPageCount > 10 then For I =1 To 10 If I = iPageCurrent Then %> <%= I %>  <% Else %> <%If Session("Category2") = "" and Session("Manufacturer") = "" and Session("PRODUCTLINE") = "" Then%> &page=<%= I %>"><%= I %>  <%Else%> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= I %>"><%= I %>  <%End IF%> <% End If Next 'I Else For I = iPageCurrent - 5 To J If I = iPageCurrent Then %> <%= I %>  <% Else %> <%If Session("Category2") = "" and Session("Manufacturer") = "" and Session("PRODUCTLINE") = "" Then%> &page=<%= I %>"><%= I %>  <%Else%> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= I %>"><%= I %>  <%End IF%> <% End If Next 'I End If End If If iPageCount > 10 and iPageCurrent < iPageCount and (iPageCount - iPageCurrent) > 4 Then %> <%If Session("Category2") = "" and Session("Manufacturer") = "" and Session("PRODUCTLINE") = "" Then%>   &page=<%= iPageCurrent + 10 %>">[Next 10]    &page=<%= iPageCount %>">[Last]  <%Else%>   &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= iPageCurrent + 10 %>">[Next 10]    &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= iPageCount %>">[Last]  <%End IF%> <% End If %>
<% ' Spacing Response.Write vbCrLf ' Continue with a title row in our table Response.Write "" & vbCrLf %> <% ' Loop through our records and ouput 1 row per record iRecordsShown = 0 numCol = 1 Do While iRecordsShown < iPageSize And Not objPagingRS.EOF remainder = numCol Mod 2 If remainder=1 Then Response.Write("") Else Response.Write("") End If ItemID = objPagingRS.Fields(0).Value ItemID = Replace(Replace(Replace(Replace(Replace(trim(ItemID), "+", "^"), "#", "|"), "&", "}"), "/", "!"), "\", ":") %> <% ' Increment the number of records we've shown iRecordsShown = iRecordsShown + 1 ' Can't forget to move to the next record! numCol = numCol+1 objPagingRS.MoveNext Loop Response.Write "
Description

Price
(USD)

Availability

<%if objPagingRS.Fields(8).Value <> "" then%> <%=objPagingRS.Fields(4).Value%> <%end if%>
<%=objPagingRS.Fields(3).Value%>
<%=objPagingRS.Fields(4).Value%>
<%if objPagingRS.Fields(10).Value <> "" then%> <%=objPagingRS.Fields(10).Value%>
<%elseif objPagingRS.Fields(9).Value <> "" then%> <%=objPagingRS.Fields(9).Value%>
<%end if%>
<%if objPagingRS.Fields(2).Value <> "" then%> UPC: <%=objPagingRS.Fields(2).Value%>
<%end if%>
SKU: <%=objPagingRS.Fields(0).Value%>      Mfgr Part#: <%=objPagingRS.Fields(1).Value%>


<% If objPagingRS.Fields(6).Value =< 0 Then %> Price
$Call
<% Else %>

Price
<%=FormatCurrency(objPagingRS.Fields(6).Value)%> <% End If %>

<% If objPagingRS.Fields(7).Value > 0 Then %>

In Stock <% Else %>

Dropship <% End If %>

<% If objPagingRS.Fields(6).Value =< 0 Then %> <% Else %>

 

<% End If %>
" & vbCrLf End If %>
 
<% If iPageCurrent > 9 Then %> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=1">[First]   &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= iPageCurrent - 10 %>">[Prev 10]   <% End If ' You can also show page numbers: If iPageCurrent + 4 < iPageCount then J = iPageCurrent + 4 Else J = iPageCount End If If iPageCurrent =< 10 and iPageCount =< 10 then For I =1 To iPageCount If I = iPageCurrent Then %> <%= I %>  <% Else %> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= I %>"><%= I %>  <% End If Next 'I Else If iPageCurrent < 10 and iPageCount > 10 then For I =1 To 10 If I = iPageCurrent Then %> <%= I %>  <% Else %> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= I %>"><%= I %>  <% End If Next 'I Else For I = iPageCurrent - 5 To J If I = iPageCurrent Then %> <%= I %>  <% Else %> &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= I %>"><%= I %>  <% End If Next 'I End If End If If iPageCount > 10 and iPageCurrent < iPageCount and (iPageCount - iPageCurrent) > 4 Then %>   &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= iPageCurrent + 10 %>">[Next 10]    &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>&PRODUCTLINE=<%=Session("PRODUCTLINE")%>&page=<%= iPageCount %>">[Last]  <% End If %>
<%if TotalRecords < PN1-1 then%> Showing: <%=PN2%> - <%=TotalRecords%> of <%=TotalRecords%> Items <%else%> Showing: <%=PN2%> - <%=PN1-1%> of <%=TotalRecords%> Items <%end if%>

Total Page(s): <%=iPageCount%> 

Home > <%if Session("Category") <> "" AND Session("Manufacturer") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") = "" then%> <%=Replace(Session("Category"), "-", " ")%> <%Else if Session("Category") <> "" AND Session("Manufacturer") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") <> "" then%> <%=Replace(Session("Category"), "-", " ")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Manufacturer") <> "" AND Session("Category") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Manufacturer"), "-", " ")%> <%Else If Session("Manufacturer") <> "" AND Session("Category") = "" AND Session("Category2") = "" AND Session("PRODUCTLINE") <> "" Then%> "><%=Replace(Session("Manufacturer"), "-", " ")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Manufacturer") = "" AND Session("Category") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Category"), "-", " ")%> > <%=Replace(Session("Category2"), "-", " ")%> <%Else If Session("Manufacturer") = "" AND Session("Category") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") <> "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Category2=<%=Session("Category2")%>"><%=Session("Category2")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") = "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Category"), "-", " ")%> > <%=Replace(Session("Manufacturer"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") = "" AND Session("PRODUCTLINE") <> "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Manufacturer=<%=Session("Manufacturer")%>"><%=Session("Manufacturer")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") = "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Category2=<%=Session("Category2")%>"><%=Session("Category2")%> > <%=Replace(Session("Manufacturer"), "-", " ")%> <%Else If Session("Category") <> "" AND Session("Manufacturer") <> "" AND Session("Category2") <> "" AND Session("PRODUCTLINE") <> "" Then%> <%=Replace(Session("Category"), "-", " ")%> > &Category2=<%=Session("Category2")%>"><%=Session("Category2")%> > &Category2=<%=Session("Category2")%>&Category3=<%=Session("Category3")%>&Manufacturer=<%=Session("Manufacturer")%>"><%=Session("Manufacturer")%> > <%=Replace(Session("PRODUCTLINE"), "-", " ")%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%> <%End If%>







Printers: Barcode Label Printers, Card Printers, Media & Supplies, Printer Spare Parts, Print Heads, Print Stations, Receipt Printers, Slip Printers, Software and Accessories










Printers: Barcode Label Printers, Card Printers, Media & Supplies, Printer Spare Parts, Print Heads, Print Stations, Receipt Printers, Slip Printers, Software and Accessories



IBM Business Partner   Microsoft Certified Partner   Motorola Partner Select Authorized Reseller Partner   HP Business Partner   Avaya Business Partner Authorized Reseller   Intuit Solution Provider

    
    
POSGobal Reviews | About Us | Contact Us | Global Shipping | Terms & Return Policy

The POS Guru Blog | Privacy | Sitemap



© 2022 POSGlobal.com All Right Reserved
Current IP address = <%=Request.ServerVariables("REMOTE_ADDR")%>
<% oRS6.Close oRS7.Close oRS8.Close countRS.Close oConn.Close Set oConn = Nothing Set oRS6 = Nothing Set oRS7 = Nothing Set oRS8 = Nothing Set countRS = Nothing %>