%@ LANGUAGE="VBSCRIPT" %> <% PageStrings = "355, 365, 430, 431, 432, 433, 434, 435, 798" strThisBackPage = "config" %> <% '=============================================== ' CactuShop ASP Shopping Cart ' ©1999-2004 Cactusoft Ltd. www.cactusoft.com '=============================================== ' All rights reserved. ' Use of this code is covered by the terms and ' conditions in the license agreement. No ' unauthorized duplication or distribution is ' permitted. Cactusoft's copyright notices must ' remain in the ASP sections of the code. '=============================================== appvar = request.QueryString("appvar") if instr(appvar,"#") > 0 then aryAppVar = split(appvar,"#") appvar = aryAppVar(0) end if 'If a specific section was passed, add in a WHERE clause strSection = request.QueryString("strSection") strPaymentGateways = "'payflowpro','protx','paypal','authorizenet','cactuspay','UPS','verisign','worldpay','secure trading','secpay','AIM'" Select Case strSection Case "pg" 'Payment gateways only strWhereClause = " WHERE CFG_Group IN (" & strPaymentGateways & ")" case "al" 'Allowable lengths section strWhereClause = " WHERE CFG_Group IN ('allowable lengths')" case "ss" 'Site settings - everything but the above strWhereClause = " WHERE CFG_Group NOT IN (" & strPaymentGateways & ",'allowable lengths')" End Select '----------------------------------------------- 'LIST CONFIG SETTINGS '----------------------------------------------- strQuery = "SELECT * FROM tblCactuShopConfig" & strWhereClause & " ORDER BY CFG_Group, CFG_Name" Call ExecuteSQL(strQuery, numCursorType, objRecordSet) %>