Query SQL and Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Currently I can enter data and submit the data into SQL. I was using
infopath, now would like to use frontpage however I cannot query the database
to update records only display a query that is not editable. In addtion I
cannot add the same field more than once. Some of the forms in infopath I
made rather lengthy and had summaries built in with the second or third time
using the same filed be readonly. Any help would be great. thanks
 
Multiple form fields in the same form w/ the same field name will not work in html (and in any DB update)
- rename your summary field names to be unique

For tips on using the DBRW see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp
For tips on using the DBIW see http://spiderwebwoman.com/resources/diwtipsandtricks.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Currently I can enter data and submit the data into SQL. I was using
| infopath, now would like to use frontpage however I cannot query the database
| to update records only display a query that is not editable. In addtion I
| cannot add the same field more than once. Some of the forms in infopath I
| made rather lengthy and had summaries built in with the second or third time
| using the same filed be readonly. Any help would be great. thanks
|
 
With infopath it allows you to add a text box and make read only. It states
duplicate info but will pull the info and copy the info typed above.

I looked at the spiderwoman site and articles they do not state how to query
the information and update. The default report is not editable.

The code for the first form of many ( there is no duplication in this one I
want to make certain I can do what is needed then continue with the other
forms. this is the smallest I had )

New ticket no problem but need info to populate form a query
<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Session.LCID = 1033
Err.Clear

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear

Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"

Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"

fp_conn.Open Application("Ittracking_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open "ITTRACKING", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic,
adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"

fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(19)
Dim arFormDBFields0(19)
Dim arFormValues0(19)

arFormFields0(0) = "status"
arFormDBFields0(0) = "IT1status"
arFormValues0(0) = Request("status")
arFormFields0(1) = "CScasenumber"
arFormDBFields0(1) = "CScasenumber"
arFormValues0(1) = Request("CScasenumber")
arFormFields0(2) = "partnumber"
arFormDBFields0(2) = "cspartnumber"
arFormValues0(2) = Request("partnumber")
arFormFields0(3) = "invoiceorder"
arFormDBFields0(3) = "CSinvoice"
arFormValues0(3) = Request("invoiceorder")
arFormFields0(4) = "Datecomp"
arFormDBFields0(4) = "DATECOMP"
arFormValues0(4) = Request("Datecomp")
arFormFields0(5) = "cscharge"
arFormDBFields0(5) = "CScharge"
arFormValues0(5) = Request("cscharge")
arFormFields0(6) = "operatingsystem"
arFormDBFields0(6) = "OPERATINGSYSTEM"
arFormValues0(6) = Request("operatingsystem")
arFormFields0(7) = "resolution"
arFormDBFields0(7) = "ITresolution"
arFormValues0(7) = Request("resolution")
arFormFields0(8) = "product"
arFormDBFields0(8) = "PRODUCT"
arFormValues0(8) = Request("product")
arFormFields0(9) = "totalhoursspent"
arFormDBFields0(9) = "totalhoursspent"
arFormValues0(9) = Request("totalhoursspent")
arFormFields0(10) = "customerid"
arFormDBFields0(10) = "CScusomerid"
arFormValues0(10) = Request("customerid")
arFormFields0(11) = "itdescription"
arFormDBFields0(11) = "ITdescription"
arFormValues0(11) = Request("itdescription")
arFormFields0(12) = "relationaldb"
arFormDBFields0(12) = "BACKENDDATABASE"
arFormValues0(12) = Request("relationaldb")
arFormFields0(13) = "csemail"
arFormDBFields0(13) = "CSemail"
arFormValues0(13) = Request("csemail")
arFormFields0(14) = "csphone"
arFormDBFields0(14) = "CSphone"
arFormValues0(14) = Request("csphone")
arFormFields0(15) = "priority"
arFormDBFields0(15) = "ITpriority"
arFormValues0(15) = Request("priority")
arFormFields0(16) = "cscontact"
arFormDBFields0(16) = "CScontact"
arFormValues0(16) = Request("cscontact")
arFormFields0(17) = "version"
arFormDBFields0(17) = "PRODUCTVERSION"
arFormValues0(17) = Request("version")
arFormFields0(18) = "qty"
arFormDBFields0(18) = "csqty"
arFormValues0(18) = Request("qty")

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

FP_SaveFieldToDB fp_rs, Now, "DATESUB"
If Request.ServerVariables("REMOTE_USER") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"),
"SUBMITTEDBY"
End If

fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"

fp_rs.Close
fp_conn.Close

Session("FP_SavedFields")=arFormFields0
Session("FP_SavedValues")=arFormValues0
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
Response.Redirect "itsuccesfulsubmittal.asp"

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<HTML>
<HEAD>
<title>New Page 1</title><meta http-equiv="Content-Language"
content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<style> <!-- .xdXButton { BEHAVIOR: url(#default#DataBindingUI);
FONT-FAMILY: Verdana }
.xdTextBox { BORDER-RIGHT: #dcdcdc 1pt solid; PADDING-RIGHT: 1px;
BORDER-TOP: #dcdcdc 1pt solid; DISPLAY: inline-block; PADDING-LEFT: 1px;
PADDING-BOTTOM: 1px; MARGIN: 1px; BEHAVIOR: url(#default#DataBindingUI);
OVERFLOW: hidden; BORDER-LEFT: #dcdcdc 1pt solid; COLOR: windowtext;
PADDING-TOP: 1px; BORDER-BOTTOM: #dcdcdc 1pt solid; WHITE-SPACE: nowrap;
TEXT-OVERFLOW: ellipsis; BACKGROUND-COLOR: window; TEXT-ALIGN: left }
.xdDTPicker { BORDER-RIGHT: #dcdcdc 1pt solid; BORDER-TOP: #dcdcdc 1pt
solid; DISPLAY: inline; MARGIN: 1px 1px 2px; BEHAVIOR:
url(#default#DataBindingUI); OVERFLOW: hidden; BORDER-LEFT: #dcdcdc 1pt
solid; COLOR: windowtext; BORDER-BOTTOM: #dcdcdc 1pt solid; BACKGROUND-COLOR:
window }
.xdBehavior_FormattingNoBUI { BEHAVIOR: url(#default#Formatting) }
.xdDTText { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px;
OVERFLOW: hidden; WIDTH: 100%; MARGIN-RIGHT: 22px; PADDING-TOP: 0px;
WHITE-SPACE: nowrap; HEIGHT: 100% }
.xdDTButton { BEHAVIOR: url(#default#DTPicker); MARGIN-LEFT: -21px; WIDTH:
20px; HEIGHT: 18px }
SELECT { FONT-SIZE: 10pt; FONT-FAMILY: Verdana }
.xdComboBox { MARGIN: 1px }
.xdBehavior_Select { BEHAVIOR: url(#default#SelectHelper)
url(#default#DataBindingUI/Select) }
.xdBehavior_Formatting { BEHAVIOR: url(#default#Formatting)
url(#default#DataBindingUI) }
--></style>
<script id="jspcal001.js" src="scripts/jspcal001.js">
</script> <script id="EFXFuncs.js" src="scripts/efxfuncs.js"></script>
</HEAD>
<body background="kml_sca_pc-back.jpg">
<form method="POST"
action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)"
language="JavaScript" name="FrontPage_Form1">
<!--webbot bot="SaveDatabase" SuggestedExt="asp"
S-DataConnection="Ittracking" S-RecordSource="ITTRACKING"
S-Builtin-Fields="Timestamp REMOTE_USER" S-Builtin-DBFields="DATESUB
SUBMITTEDBY" S-Form-Fields="status CScasenumber partnumber invoiceorder
Datecomp cscharge operatingsystem resolution product totalhoursspent
customerid itdescription relationaldb csemail csphone priority cscontact
version qty" S-Form-DBFields="IT1status CScasenumber cspartnumber CSinvoice
DATECOMP CScharge OPERATINGSYSTEM ITresolution PRODUCT totalhoursspent
CScusomerid ITdescription BACKENDDATABASE CSemail CSphone ITpriority
CScontact PRODUCTVERSION csqty" U-ASP-Include-Url="_fpclass/fpdbform.inc"
startspan U-Confirmation-Url="itsuccesfulsubmittal.asp" --><input
TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include
file="_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan
i-checksum="40548" -->
<p><img border="0" src="kmllogo.jpg" width="154"
height="87">
<font size="5"><b>Customer Service</b></font><b><font size="5">
Submittal</font></b></p> <div align="left"> <font
size="4">
</font></div> <div align="justify"> <hr
style="BORDER-RIGHT: #ff0000 6pt solid; BORDER-TOP: #ff0000 6pt solid;
BORDER-LEFT: #ff0000 6pt solid; WIDTH: 1117px; BORDER-BOTTOM: #ff0000 6pt
solid; HEIGHT: 8px; BACKGROUND-COLOR: #ff0000" align="left"> </div> <div>
</div> <div> Case Number: <input type="text" name="CScasenumber"
size="20" value="Email or not recieved" id="CScasenumber"> </div>
<div> </div> <div> Customer ID: <input type="text" name="customerid"
size="20"> </div> <div> </div> <div> Customer Contact: <input
type="text" name="cscontact" size="20"> Phone Number: <input
type="text" name="csphone" size="20"> </div> <div> </div> <div>
Email Address: <input type="text" name="csemail" size="61"> </div> <div>
</div> <div> Product: <select class="xdComboBox xdBehavior_Select" title
style="WIDTH: 205px" size=1 name=product value> <option selected></option>
<option value="Auditcon 2100">Auditcon 2100</option> <option value="Auditcon
2
Series">Auditcon 2 Series</option> <option value="Cencon">Cencon</option>
<option value="Centran">Centran</option> <option
value="Gitcon">Gitcon</option>
<option value="LaGard">LaGard</option> <option
value="Vindicator">Vindicator</option>
</select>
Version: <input type="text" name="version" size="20"> </div> <div>
</div> <div> Operating System: <select class="xdComboBox
xdBehavior_Select" title style="WIDTH: 295px" size=1 name=operatingsystem
value> <option selected>Select...</option> <option value="Not Applicable">Not
Applicable</option> <option value="Client OS's only">Client OS's
only</option>
<option value="Server OS's Only">Server OS's Only</option> <option
value="Server/ Advanced Server 2000">Server/ Advanced Server 2000</option>
<option value="Server/ Advanced Server 2003">Server/ Advanced Server
2003</option> <option value="XP">XP</option> <option value="2000
Professional">2000 Professional</option> <option value="XP Home">XP
Home</option> <option value="98 SE">98 SE</option> </select> </div> <div>
Relational DB: <select
class="xdComboBox xdBehavior_Select" title style="WIDTH: 293px" size=1
name=relationaldb value> <option selected>Select...</option> <option
value="Not
Applicable">Not Applicable</option> <option value="All Relational
Databases">All Relational Databases </option> <option value="All SQL
Relational
Databases">All SQL Relational Databases</option> <option value="SQL 2000">SQL
2000</option> <option value="SQL 2005">SQL 2005</option> <option
value="Oracle
10G">Oracle 10G</option> <option value="MSDE">MSDE</option> <option
value="SQL
2005 Exspress">SQL 2005 Exspress</option> </select></div> <div> </div>
<div> Part Number: <input type="text" name="partnumber" size="20"
value="CSRBSBH0015"> Qty: <input type="text"
name="qty" size="20"></div> <div> Invoice Order: <input type="text"
name="invoiceorder" size="20"> Charge amount:
<input type="text" name="cscharge" size="20"></div> <div> </div> <div>
Brief Description :<p>
<!--webbot bot="Validation" s-display-name="itdescription"
s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE"
b-value-required="TRUE" i-minimum-length="1" i-maximum-length="500" -->
<textarea rows="5" name="itdescription" cols="66"></textarea></p></div> <div>
</div> <div> <div> Assigned IT: <select
class="xdComboBox xdBehavior_Select" title style="WIDTH: 211px" size=1
name=assignedit value> <option selected>Select...</option> <option
value="Bill
Meeks">Bill Meeks</option> <option value="Jayson Johnson">Jayson
Johnson</option> <option value="Kane Holmes">Kane Holmes</option> <option
value="Mike Stinson">Mike Stinson</option> <option value="Rick Brandt">Rick
Brandt</option> <option value="Robert Ziegler">Robert Ziegler</option>
</select> Priority Status: <select
class="xdComboBox xdBehavior_Select" title style="WIDTH: 181px" size=1
name=priority value> <option selected>Select...</option> <option
value="Low">Low</option> <option value="High">High</option> <option
value="Emergency">Emergency</option> </select></div> <div> Current status:
<select class="xdComboBox xdBehavior_Select" title id=status
style="WIDTH: 212px" size=1 name=status value> <option
selected>Select...</option> <option value="Active">Active</option> <option
value="Closed">Closed</option> <option value="On Hold">On Hold</option>
<option
value="Wait / Response Required">Wait / Response Required </option>
</select> Date Completed:<input type=text id="txtDate001"
name='txtDate001' size=20 maxlength=20 value=''>
<img src="images/pcalico.jpg" onclick="showCalendar(this, 'txtDate001',
'mm/dd/yyyy',null,-1,-1,-1)">
<p>
date complete test:</p></div> <div> </div> <div> IT Resolution:<p>
<!--webbot bot="Validation" s-display-name="Resolution"
s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE"
b-allow-whitespace="TRUE" i-maximum-length="500" -->
<textarea rows="5" name="resolution" cols="66"></textarea></p></div> <div>
</div> <div> Total time: <input type="text" name="totalhoursspent"
size="20"></div> </div> <div> </div> <div> </div> <div> <input
class="xdXButton" title style="BEHAVIOR: url(#default#ActionButton)"
tabIndex=0
type=submit value=Submit
name=Submit> <p> </p></div>
<div> -------DOES NOT FUNCTION -------------------- <p> </p></div>
<div> IT Tracking Number: Number will automatically
generate
</div> <div> <p> </p> <p> </p></div> <div> <input class="xdXButton"
title style="BEHAVIOR: url(#default#ActionButton)" type=button value="Search
Criteria Below"> <font color="#ffffff">
</font></div> <div> </div> <div> </div> <div> IT Tracking
Number: <input type="text" name="search_ittracking" size="20"> Case
number: <input type="text" name="Search_casenumber" size="20"></div> <div>
</div> <p><input type="submit" value="Submit" name="B1"><input
type="reset" value="Reset" name="B2"></p> </form> </body> </HTML>
 
THIS IS THE UPDATE QUERY I HAVE STARTED

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 2</title>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT">Tracking Number</th>
<th ALIGN="LEFT">Submitted By</th>
<th ALIGN="LEFT">Date Submitted</th>
<th ALIGN="LEFT">Date Due</th>
<th ALIGN="LEFT">Priority</th>
<th ALIGN="LEFT">Case Number</th>
<th ALIGN="LEFT">Customer ID</th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-columntypes="202,202,202,202,202,135,135,135,131,5,202,202,202,202,202,202,202,202,202,202,202,131,202,131"
s-dataconnection="Ittracking" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource
s-displaycolumns="ITtrackingnumber,SUBMITTEDBY,DATESUB,DATEDUE,ITpriority,CScasenumber,CScusomerid"
s-criteria s-order s-sql="SELECT * FROM ITTRACKING where it1status =
'Active'" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0"
botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a
Database Results region.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ITTRACKING where it1status = 'Active'"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=7 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Ittracking"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&SUBMITTEDBY=202&PRODUCT=202&PRODUCTVERSION=202&OPERATINGSYSTEM=202&BACKENDDATABASE=202&DATESUB=135&DATEDUE=135&DATECOMP=135&ITtrackingnumber=131&totalhoursspent=5&IT1status=202&ITpriority=202&ITassigned=202&ITresolution=202&ITdescription=202&CScasenumber=202&CScusomerid=202&CScontact=202&CSphone=202&CSemail=202&CSinvoice=202&CScharge=131&cspartnumber=202&csqty=131&"
fp_iDisplayCols=7
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="56103" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="ITtrackingnumber" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>ITtrackingnumber<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"ITtrackingnumber")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="39798" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="SUBMITTEDBY" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>SUBMITTEDBY<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"SUBMITTEDBY")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="18478" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="DATESUB" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DATESUB<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"DATESUB")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="6613" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="DATEDUE" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DATEDUE<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"DATEDUE")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="6601" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="ITpriority" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>ITpriority<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"ITpriority")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="29069" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CScasenumber" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>CScasenumber<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"CScasenumber")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28007" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CScusomerid" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>CScusomerid<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"CScusomerid")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="27066" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
width="100%"><font color="#000000">This is the end of a Database Results
region.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>

</body>

</html>
 
THIS IS THE RESULT SET FROM THE HYPERLINK

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 2</title>
</head>

<body>

<form BOTID="0" METHOD="POST" action="opentickquery.asp">
<input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
</form>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>SUBMITTEDBY</b></th>
<th ALIGN="LEFT"><b>PRODUCT</b></th>
<th ALIGN="LEFT"><b>PRODUCTVERSION</b></th>
<th ALIGN="LEFT"><b>OPERATINGSYSTEM</b></th>
<th ALIGN="LEFT"><b>BACKENDDATABASE</b></th>
<th ALIGN="LEFT"><b>DATESUB</b></th>
<th ALIGN="LEFT"><b>DATEDUE</b></th>
<th ALIGN="LEFT"><b>DATECOMP</b></th>
<th ALIGN="LEFT"><b>ITtrackingnumber</b></th>
<th ALIGN="LEFT"><b>totalhoursspent</b></th>
<th ALIGN="LEFT"><b>IT1status</b></th>
<th ALIGN="LEFT"><b>ITpriority</b></th>
<th ALIGN="LEFT"><b>ITassigned</b></th>
<th ALIGN="LEFT"><b>ITresolution</b></th>
<th ALIGN="LEFT"><b>ITdescription</b></th>
<th ALIGN="LEFT"><b>CScasenumber</b></th>
<th ALIGN="LEFT"><b>CScusomerid</b></th>
<th ALIGN="LEFT"><b>CScontact</b></th>
<th ALIGN="LEFT"><b>CSphone</b></th>
<th ALIGN="LEFT"><b>CSemail</b></th>
<th ALIGN="LEFT"><b>CSinvoice</b></th>
<th ALIGN="LEFT"><b>CScharge</b></th>
<th ALIGN="LEFT"><b>cspartnumber</b></th>
<th ALIGN="LEFT"><b>csqty</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-columntypes="202,202,202,202,202,135,135,135,131,5,202,202,202,202,202,202,202,202,202,202,202,131,202,131"
s-dataconnection="Ittracking" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="TRUE" s-recordsource
s-displaycolumns="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-criteria s-order s-sql="SELECT * FROM ittracking where (ITtrackingnumber =
'::ticket_num::')" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="ticket_num=" s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results
region.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ittracking where (ITtrackingnumber = '::ticket_num::')"
fp_sDefault="ticket_num="
fp_sNoRecords="<tr><td colspan=24 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Ittracking"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&SUBMITTEDBY=202&PRODUCT=202&PRODUCTVERSION=202&OPERATINGSYSTEM=202&BACKENDDATABASE=202&DATESUB=135&DATEDUE=135&DATECOMP=135&ITtrackingnumber=131&totalhoursspent=5&IT1status=202&ITpriority=202&ITassigned=202&ITresolution=202&ITdescription=202&CScasenumber=202&CScusomerid=202&CScontact=202&CSphone=202&CSemail=202&CSinvoice=202&CScharge=131&cspartnumber=202&csqty=131&"
fp_iDisplayCols=24
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="53184" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="SUBMITTEDBY" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>SUBMITTEDBY<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"SUBMITTEDBY")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="18478" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="PRODUCT" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PRODUCT<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"PRODUCT")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9702" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="PRODUCTVERSION" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>PRODUCTVERSION<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"PRODUCTVERSION")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="32185" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="OPERATINGSYSTEM" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>OPERATINGSYSTEM<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"OPERATINGSYSTEM")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29319" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="BACKENDDATABASE" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>BACKENDDATABASE<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"BACKENDDATABASE")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="25713" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="DATESUB" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DATESUB<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"DATESUB")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="6613" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="DATEDUE" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DATEDUE<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"DATEDUE")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="6601" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="DATECOMP" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DATECOMP<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"DATECOMP")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="8312" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="ITtrackingnumber" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>ITtrackingnumber<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"ITtrackingnumber")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="39798" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="totalhoursspent" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>totalhoursspent<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"totalhoursspent")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="45872" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="IT1status" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>IT1status<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"IT1status")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="17759" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="ITpriority" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>ITpriority<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"ITpriority")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="29069" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="ITassigned" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>ITassigned<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"ITassigned")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="25384" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="ITresolution" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>ITresolution<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"ITresolution")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29936" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="ITdescription" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>ITdescription<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"ITdescription")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="34166" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CScasenumber" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>CScasenumber<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"CScasenumber")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28007" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CScusomerid" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>CScusomerid<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"CScusomerid")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="27066" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CScontact" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>CScontact<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"CScontact")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="16601" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CSphone" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>CSphone<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"CSphone")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9823" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CSemail" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>CSemail<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"CSemail")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9838" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CSinvoice" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>CSinvoice<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"CSinvoice")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="15765" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="CScharge" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>CScharge<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"CScharge")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="12125" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="cspartnumber" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>cspartnumber<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"cspartnumber")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="34280" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="SUBMITTEDBY,PRODUCT,PRODUCTVERSION,OPERATINGSYSTEM,BACKENDDATABASE,DATESUB,DATEDUE,DATECOMP,ITtrackingnumber,totalhoursspent,IT1status,ITpriority,ITassigned,ITresolution,ITdescription,CScasenumber,CScusomerid,CScontact,CSphone,CSemail,CSinvoice,CScharge,cspartnumber,csqty"
s-column="csqty" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>csqty<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"csqty")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="11106" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
width="100%"><font color="#000000">This is the end of a Database Results
region.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>

</body>

</html>
 
files posted in three responses
new record no issues , report with hyperlink of open tickets, then the
results from the selection of hyperlink tracking number. Need these results
to be in the same style as the new form to populate the data then update if
needed. thanks Also can I make certain fields readonly ?
 
Back
Top