<%@LANGUAGE="VBSCRIPT"%> <% ' *** Edit Operations: declare variables MM_editAction = CStr(Request("URL")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Request.QueryString End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) <> "") Then MM_editConnection = MM_Intellisource_STRING MM_editTable = "FeedbackInfo" MM_editRedirectUrl = "replythanks.htm" MM_fieldsStr = "MailList|value|SalesCall|value|Literature|value|SendPrice|value|KBDemo|value|MinerDemo|value|Fname|value|Lname|value|Title|value|Company|value|Address|value|City|value|State|value|Zip|value|Country|value|Phone|value|Email|value" MM_columnsStr = "MailList|none,1,0|SalesCall|none,1,0|Literature|none,1,0|SendPrice|none,1,0|KBDemo|none,1,0|MinerDemo|none,1,0|Fname|',none,''|Lname|',none,''|Title|',none,''|Company|',none,''|Address|',none,''|City|',none,''|State|',none,''|Zip|',none,''|Country|',none,''|Phone|',none,''|Email|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(i+1) = CStr(Request.Form(MM_fields(i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For i = LBound(MM_fields) To UBound(MM_fields) Step 2 FormVal = MM_fields(i+1) MM_typeArray = Split(MM_columns(i+1),",") Delim = MM_typeArray(0) If (Delim = "none") Then Delim = "" AltVal = MM_typeArray(1) If (AltVal = "none") Then AltVal = "" EmptyVal = MM_typeArray(2) If (EmptyVal = "none") Then EmptyVal = "" If (FormVal = "") Then FormVal = EmptyVal Else If (AltVal <> "") Then FormVal = AltVal ElseIf (Delim = "'") Then ' escape quotes FormVal = "'" & Replace(FormVal,"'","''") & "'" Else FormVal = Delim + FormVal + Delim End If End If If (i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End if MM_tableValues = MM_tableValues & MM_columns(i) MM_dbValues = MM_dbValues & FormVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% set rsConfigReply = Server.CreateObject("ADODB.Recordset") rsConfigReply.ActiveConnection = MM_Intellisource_STRING rsConfigReply.Source = "SELECT * FROM FeedbackInfo" rsConfigReply.CursorType = 0 rsConfigReply.CursorLocation = 2 rsConfigReply.LockType = 3 rsConfigReply.Open() rsConfigReply_numRows = 0 %> Configurator

e-Service

e-Service reduces the cost of customer service by capturing complex problem diagnosis and trouble-shooting knowledge, and delivering intelligent problem resolution to call center agents as well as to web self-service clients.

Help desk and technical support applications typically require two different knowledge-rich activities: diagnosing a user's problem, and translating that knowledge into solutions that can be applied simply and reliably.  e-Service is unique in its ability to accomplish both of these tasks, to use its knowledge to determine your customer's specific problem, and to select the most likely solutions to the problem.  Because of its depth of knowledge, reliability, and ease of use, e-Service help facilities are as suitable for direct use by untrained web clients as they are by trained call center agents.

e-Service is an optional edition of XpertRule Software's  Knowledge Builder knowledge authoring platform, with advanced features critical to help desk and other technical support applications including:

Automating the support process includes capturing structured support knowledge such as diagnostic trees, trouble-shoot flows, and other support procedures. Once this knowledge is captured, delivering it seriously reduces reliance on the skills of agents to interpret the knowledge. In a service situation with an intelligent script, the agent is guided by the system to ask the right sequence of questions to resolve the problem most quickly and effectively. 

e-Service surpasses all other approaches to help desk implementation by assuring you of graphical rapid data capture,  and ease of maintenance of knowledge over the long term.

Need More Information or Passwords?

 

 

 

 

 

 

 

 

 
products
case studiesdemosnewscompany
 


e-Service
provides a unique
knowledge based
facility to help you:

Resolve problems on the first call, and minimize call duration. 

Deliver consistent, high quality customer support through every agent. 

Reduce the cost of agent training and turnover.

Reduce or remove the need for outsourcing to foreign agencies.

Deliver consistent, up-to-date support knowledge immediately and regardless of agent or location.

Increase customer satisfaction as a result of receiving fast, efficient and consistent support.

Representing XpertRule Software in the Americas
© Copyright 2006 Renaissance International Corp.
<% rsConfigReply.Close() %>