And now, this??

All Forums >> [Web Development] >> ASP and Database

Message

pd_it_guy -> And now, this?? (3/21/2008 20:30:46)
Thanks to the site members, with all the other huge problems now solved with my repair database that sends e-mail orders to people to fix things, I now find out that whenever a field value has a space in it all that makes it through the CDOSYS mail is the form field contents up to the space. Then it cuts off. Thus, if the value of the field, Problem_description is, "This car won't start", all that gets picked out and transmitted in the CDOSYS mail is "This" and nothing else. I checked the underlying Access database records we write to and pull from and everything there is just fine. I can get around this by dropdowns where we always use underscores instead of spaces, but people do have to have freeform to describe what the problem is they are reporting. The CDOSYS mail is being sent with HTML format tags to be read by Outlook. That works fine as well except for this problem. Can anyone tell me what am I doing wrong now.

rdouglass -> RE: And now, this?? (3/21/2008 23:48:42)
quote: I now find out that whenever a field value has a space in it all that makes it through the CDOSYS mail is the form field contents up to the space. Are you passing them as hidden fields or something? I do know that if you have spaces, you must have the value wrapped in double quotes as in: <input type=hidden name=myField value="This car won't start"> instead of: <input type=hidden name=myField value=This car won't start> That type of field code will reporoduce that symptom. If not that, can you post some code?

pd_it_guy -> RE: And now, this?? (3/22/2008 0:05:51)
They come from a form. This is closely related to the previous post. We save output from a database results region to variables, and in an adjoining form on the same page, POST all those hidden variables, along with a few others, to another page, where we update the database with them, and continue down the page to use them in a CDOSYS mailing operation. I know CDOSYS can mail text with spaces just fine, but somewhere along the line from when I fetch the variables from just under the bot to real variables and then to hidden variables to POST, the ones that have spaces in them cutoff everything after the first space. I have tried Dimensioning the variables thus: Dim k_General_Problem and Dim k_Problem_Description just before I take them but no help. Does it sound like a Dimension problem, or what? I have searched everywhere on this. Its the last thing on this project I cant figure out and have to solve.

pd_it_guy -> RE: And now, this?? (3/22/2008 0:07:05)
Stand by a just a sec for the code....

pd_it_guy -> RE: And now, this?? (3/22/2008 0:23:03)

Starting with the second and much shorter part, this is what is on the second page that reads the POST'ed variables and assembles and sends the mail. I hope this is enough, I can drag the whole thing if need be. What is just above is the database results that does the SQL update. It is not part of the variable fetching; that is on the previous page. See if any of this looks troubling; if not, I will get the first page for us to look at (its pretty big):

<%
Dim objCDOSYSCon
Dim sFrom
Dim sTo
Dim sSubject
Dim sMessage

If Request.Form("UPD_Repair_By")="Internal_Only" Then
sTo=Request.Form("Mail_Internal_Only")
ElseIf Request.Form("UPD_Repair_By")="Corp_Yard" Then
sTo=Request.Form("Mail_Corp_Yard")
ElseIf Request.Form("UPD_Repair_By")="Info_Systems" Then
sTo=Request.Form("Mail_Info_Systems")
ElseIf Request.Form("UPD_Repair_By")="D911" Then
sTo=Request.Form("Mail_D911")
ElseIf Request.Form("UPD_Repair_By")="Day_Wireless" Then
sTo=Request.Form("Mail_Day_Wireless")
ElseIf Request.Form("UPD_Repair_By")="No_Notification" Then
sTo=Request.Form("Mail_No_Notification")
End If

sFrom=Request.Form("repair_supervisor")&"@somewhere.com"
sSubject="Vehicle Repair Trouble Ticket- "&Request.Form("k_Veh_Portable")
sMessage="Online Service Request (OSR) Trouble ticket notification"&"<BR>"
sMessage=sMessage&"This is your official request to initate repairs on the item reported below.  "
sMessage=sMessage&"If you do not dispo on line you must notify the repair supervisor- <B>"&Request.Form("repair_supervisor")&"</B> of what was done."&"<BR><BR>"
sMessage=sMessage&"Ticket Details"&"<BR><BR>"
sMessage=sMessage&"Trouble Ticket No. <B>"&Request.Form("k_Ticket_ID")&"</B><BR>"
sMessage=sMessage&"Reported By:  <B>"&Request.Form("k_Operator")&"</B><BR>"
sMessage=sMessage&"Report Date:  <B>"&Request.Form("k_Report_Date")&"</B><BR>"
sMessage=sMessage&"Report Time:  <B>"&Request.Form("k_Report_Time")&"</B><BR>"
sMessage=sMessage&"The general description of the problem was:  <B>"&Request.Form("k_General_Problem")&"</B><BR>"
sMessage=sMessage&"The problem:  <B>"&Request.Form("k_Problem_Description")&"</B><BR><BR>"
sMessage=sMessage&"Additional pertinenet information about this request"&"<BR><BR>"
sMessage=sMessage&"Is the item described still in service?  <B>"&Request.Form("k_Still_In_Service")&"</B><BR>"
sMessage=sMessage&"Item may be found at:  <B>"&Request.Form("k_Item_Location")&"</B><BR>"
sMessage=sMessage&"Has this been designated a Special Priority Request?  <B>"&Request.Form("k_Special_Priority")&"</B><BR>"
sMessage=sMessage&"Is a 302 form reasonably believed to be required?  <B>"&Request.Form("k_Damage_Report_Required")&"</B><BR>"
sMessage=sMessage&"If a 302 was required, who is supposed to complete it?  <B>"&Request.Form("k_PD_Damage_Reporter")&"</B><BR>"
sMessage=sMessage&"Is this a second report, or more for the SAME PROBLEM? <B>"&Request.Form("k_Multiple_Request")&"</B><BR><BR>"
sMessage=sMessage&"Repair actions taken so far on this are:  <B>"&Request.Form("k_Repair_Response")&"</B><BR><BR>"
sMessage=sMessage&"Person/ Group assigned this ticket:  <B>"&Request.Form("UPD_Repair_By")&"</B><BR>"
sMessage=sMessage&"Status of this ticket is now:  <B>"&Request.Form("UPD_Status")&"</B><BR><BR>"
sMessage=sMessage&"This repair ticket was last updated on:  <B>"&Request.Form("UPD_Last_Update")&"</B><BR>"
sMessage=sMessage&"The ticket was submitted from IPA:  <B>"&Request.Form("k_Remote_computer_name")&"</B><BR>"
sMessage=sMessage&"Audit timestamp of ticket submission was on:  <B>"&Request.Form("k_Timestamp")&"</B><BR>"


Set objCDOSYSMail = Server.CreateObject("CDO.Message")
Set objCDOSYSCon = Server.CreateObject ("CDO.Configuration")

objCDOSYSCon.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "mail.internal.city"
objCDOSYSCon.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objCDOSYSCon.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objCDOSYSCon.Fields("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60
objCDOSYSCon.Fields.Update
Set objCDOSYSMail.Configuration = objCDOSYSCon

objCDOSYSMail.From = sFrom
objCDOSYSMail.To = sTo
objCDOSYSMail.Subject = sSubject
objCDOSYSMail.HTMLBody = sMessage

If Request.Form("UPD_Repair_By")<>"No Notification" Then
objCDOSYSMail.Send
End If

Set objCDOSYSMail = Nothing
Set objCDOSYSCon = Nothing
%>

<P><FONT COLOR="#000000">Now go back and <A HREF="view_submitted_reports.asp">dispo
out more newly submitted</A></FONT></P>

rdouglass -> RE: And now, this?? (3/22/2008 0:27:22)
quote: See if any of this looks troubling; if not, I will get the first page for us to look at (its pretty big): That (at first glance) seems OK. To be honest, I'm interested in just hidden fields at the moment.

pd_it_guy -> RE: And now, this?? (3/22/2008 0:33:00)

Well, here's the first page. All of this works perfectly except for the failure to pass values that have spaces. Note between the bots I pull bot variables to ones I can get and use later on.

<HTML>

<HEAD>
<META HTTP-EQUIV="Content-Language" CONTENT="en-us">
<META NAME="GENERATOR" CONTENT="Microsoft FrontPage 4.0">
<META NAME="ProgId" CONTENT="FrontPage.Editor.Document">
<TITLE>Review newly submitted tickets</TITLE>
<meta name="Microsoft Theme" content="bluecalm 1011, default">
</HEAD>

<BODY STYLESRC="default.htm">

<P><FONT SIZE="6" COLOR="#FF0000"><I>Review pending tickets and initiate service:</I></FONT></P>

<!--WEBBOT bot="DatabaseRegionStart" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMNTYPES="3,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,135,202"
S-DATACONNECTION="vehicle" B-TABLEFORMAT="FALSE" 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="Results"
S-DISPLAYCOLUMNS="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Repair_Response,Repair_By,Status,Last_Update,Remote_computer_name,Timestamp"
S-CRITERIA="[Status] EQ [Submitted] +" S-ORDER="[Ticket_ID] -"
S-SQL="SELECT * FROM Results WHERE (Status =  'Submitted') ORDER BY Ticket_ID DESC"
B-PROCEDURE="FALSE" CLIENTSIDE SuggestedExt="asp" s-DefaultFields
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="1"
BOTID="0" U-DBLIB="_fpclass/fpdblib.inc" U-DBRGN1="_fpclass/fpdbrgn1.inc"
U-DBRGN2="_fpclass/fpdbrgn2.inc" TAG="BODY"
LOCAL_PREVIEW="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.</font></td></tr></table>"
PREVIEW="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM Results WHERE (Status =  'Submitted') ORDER BY Ticket_ID DESC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="vehicle"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=19
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--WEBBOT bot="DatabaseRegionStart" endspan i-CheckSum="64420" -->
<P><B>Ticket_ID:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Ticket_ID" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Ticket_ID<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Ticket_ID<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Ticket_ID")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="16525" -->
<% k_Ticket_ID=FP_FieldVal(fp_rs,"Ticket_ID")%>
<B><BR>
Operator:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Operator" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Operator<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Operator<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Operator")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="17187" -->
<% k_Operator=FP_FieldVal(fp_rs,"Operator")%>
<B><BR>
Veh_Portable:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Veh_Portable" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Veh_Portable<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Veh_Portable<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Veh_Portable")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="30713" -->
<% k_Veh_Portable=FP_FieldVal(fp_rs,"Veh_Portable")%>
<B><BR>
Report_Date:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Report_Date" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Report_Date<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Report_Date<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Report_Date")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="29408" -->
<% k_Report_Date=FP_FieldVal(fp_rs,"Report_Date")%>
<B><BR>
Report_Time:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Report_Time" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Report_Time<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Report_Time<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Report_Time")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="29536" -->
<% k_Report_Time=FP_FieldVal(fp_rs,"Report_Time")%>
<B><BR>
General_Problem:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="General_Problem" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>General_Problem<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>General_Problem<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"General_Problem")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="38438" -->
<%
Dim k_General_Problem
k_General_Problem=FP_FieldVal(fp_rs,"General_Problem")
%>
</P>
<P><B>Problem_Description:</B> <!--WEBBOT bot="DatabaseResultColumn"
startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Problem_Description" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE"
CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Problem_Description<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Problem_Description<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Problem_Description")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="56135" -->
<%
Dim k_Problem_Description
k_Problem_Description=FP_FieldVal(fp_rs,"Problem_Description")
%>
</P>
<P><B>Still_In_Service:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Still_In_Service" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Still_In_Service<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Still_In_Service<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Still_In_Service")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="40248" -->
<% k_Still_In_Service=FP_FieldVal(fp_rs,"Still_In_Service")%>
<B><BR>
Item_Location:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Item_Location" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Item_Location<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Item_Location<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Item_Location")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="36815" -->
<% k_Item_Location=FP_FieldVal(fp_rs,"Item_Location")%>
<B><BR>
Special_Priority:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Special_Priority" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Special_Priority<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Special_Priority<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Special_Priority")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="43700" -->
<% k_Special_Priority=FP_FieldVal(fp_rs,"Special_Priority")%>
<B><BR>
Damage_Rpt_Required:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Damage_Rpt_Required" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE"
CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Damage_Rpt_Required<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Damage_Rpt_Required<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Damage_Rpt_Required")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="56235" -->
<% k_Damage_Rpt_Required=FP_FieldVal(fp_rs,"Damage_Rpt_Required")%>
<B><BR>
PD_Damage_Reporter:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="PD_Damage_Reporter" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>PD_Damage_Reporter<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>PD_Damage_Reporter<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"PD_Damage_Reporter")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="50900" -->
<% k_PD_Damage_Reporter=FP_FieldVal(fp_rs,"PD_Damage_Reporter")%>
<B><BR>
Multiple_Request:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Multiple_Request" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Multiple_Request<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Multiple_Request<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Multiple_Request")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="40977" -->
<% k_Multiple_Request=FP_FieldVal(fp_rs,"Multiple_Request")%>
</P>
<P><B>Repair_Response:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Repair_Response" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Repair_Response<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Repair_Response<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Repair_Response")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="40103" -->
<% k_Repair_Response=FP_FieldVal(fp_rs,"Repair_Response")%>
</P>
<P><B>Repair_By:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Repair_By" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Repair_By<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Repair_By<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Repair_By")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="19046" -->
<% k_Repair_By=FP_FieldVal(fp_rs,"Repair_By")%>
<B><BR>
Status:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Status" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Status<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Status<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Status")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="17178" -->
<% k_Status=FP_FieldVal(fp_rs,"Status")%>
<B><BR>
Last_Update:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Last_Update" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Last_Update<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Last_Update<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Last_Update")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="29497" -->
<% k_Last_Update=FP_FieldVal(fp_rs,"Last_Update")%>
<B><BR>
Remote_computer_name:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Remote_computer_name" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE"
CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Remote_computer_name<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Remote_computer_name<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Remote_computer_name")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="57953" -->
<% k_Remote_computer_name=FP_FieldVal(fp_rs,"Remote_computer_name")%>
<B><BR>
Timestamp:</B> <!--WEBBOT bot="DatabaseResultColumn" startspan
S-COLUMNNAMES="Ticket_ID,Operator,Veh_Portable,Report_Date,Report_Time,General_Problem,Problem_Description,Still_In_Service,Item_Location,Special_Priority,Damage_Rpt_Required,PD_Damage_Reporter,Multiple_Request,Last_Update,Repair_Response,Status,Remote_computer_name,User_name,Browser_type,Timestamp,Repair_By"
S-COLUMN="Timestamp" B-TABLEFORMAT="FALSE" b-hasHTML="FALSE" CLIENTSIDE
LOCAL_PREVIEW="<font size="-1"><<</font>Timestamp<font size="-1">>></font>"
PREVIEW="<font size="-1"><<</font>Timestamp<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Timestamp")%><!--WEBBOT
bot="DatabaseResultColumn" endspan i-CheckSum="20579" -->
<% k_Timestamp=FP_FieldVal(fp_rs,"Timestamp")%>
</P>
<HR>
<!--WEBBOT bot="DatabaseRegionEnd" startspan B-TABLEFORMAT="FALSE"
B-MENUFORMAT="FALSE" U-DBRGN2="_fpclass/fpdbrgn2.inc" I-GROUPSIZE="1" CLIENTSIDE
TAG="BODY"
LOCAL_PREVIEW="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="center"><font color="#000000">End of Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE><FORM><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/1]</NOBR></FORM></td></tr></table>"
PREVIEW="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/1]</NOBR><BR></td></tr></table>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--WEBBOT bot="DatabaseRegionEnd" endspan i-CheckSum="62730" -->

<FORM METHOD="POST" ACTION="update_submitted_reports.asp" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">

  <P><FONT SIZE="6" COLOR="#FF0000"><I>Update the record and inititate action:    
    </I></FONT></P>
  <P>Regarding Ticket_ID # <!--webbot bot="Validation" S-Data-Type="Number"
  S-Number-Separators=",." B-Value-Required="TRUE" --> <INPUT TYPE="text" NAME="UPD_Ticket_ID" SIZE="4"> As
  of <INPUT TYPE="text" NAME="UPD_Last_Update" SIZE="13" VALUE="<% =date %>"> Assign To:
  <!--webbot bot="Validation" B-Disallow-First-Item="TRUE" --> <SELECT SIZE="1" NAME="UPD_Repair_By">
    <OPTION>-</OPTION>
    <OPTION>No_Notification</OPTION>
    <OPTION>Corp_Yard</OPTION>
    <OPTION>Internal_Only</OPTION>
    <OPTION>Day_Wireless</OPTION>
    <OPTION>D911</OPTION>
    <OPTION>Info_Systems</OPTION>
  </SELECT>  This is being done by supervisor:  <input type="text" name="repair_supervisor" size="8" value="who"></P>
<P>A trouble ticket will be sent to the person or group chosen, and the OSR
database will be updated.  Or you may choose to not make any notification
at all.  Internal notification will make it come directly back to you to
print out.</P>
 <P align="center"><INPUT TYPE="submit" VALUE="Submit" NAME="B1"></P>
 <INPUT TYPE="hidden" NAME="k_Ticket_ID" VALUE=<% =k_Ticket_ID %>>
 <INPUT TYPE="hidden" NAME="k_Operator" VALUE=<% =k_Operator %>>
 <INPUT TYPE="hidden" NAME="k_Veh_Portable" VALUE=<% =k_Veh_Portable %>>
 <INPUT TYPE="hidden" NAME="k_Report_Date" VALUE=<% =k_Report_Date %>>
 <INPUT TYPE="hidden" NAME="k_Report_Time" VALUE=<% =k_Report_Time %>>
 <INPUT TYPE="hidden" NAME="k_General_Problem" VALUE=<% =k_General_Problem %>>
 <INPUT TYPE="hidden" NAME="k_Problem_Description" VALUE=<% =k_Problem_Description %>>
 <INPUT TYPE="hidden" NAME="k_Still_In_Service" VALUE=<% =k_Still_In_Service %>>
 <INPUT TYPE="hidden" NAME="k_Item_Location" VALUE=<% =k_Item_Location %>>
 <INPUT TYPE="hidden" NAME="k_Special_Priority" VALUE=<% =k_Special_Priority %>>
 <INPUT TYPE="hidden" NAME="k_Damage_Rpt_Required" VALUE=<% =k_Damage_Rpt_Required %>>
 <INPUT TYPE="hidden" NAME="k_PD_Damage_Reporter" VALUE=<% =k_PD_Damage_Reporter %>>
 <INPUT TYPE="hidden" NAME="k_Multiple_Request" VALUE=<% =k_Multiple_Request %>>
 <INPUT TYPE="hidden" NAME="k_Repair_Response" VALUE=<% =k_Repair_Response %>>
 <INPUT TYPE="hidden" NAME="k_Repair_By" VALUE=<% =k_Repair_By %>>
 <INPUT TYPE="hidden" NAME="k_Status" VALUE=<% =k_Status %>>
 <INPUT TYPE="hidden" NAME="k_Last_Update" VALUE=<% =k_Last_Update %>>
 <INPUT TYPE="hidden" NAME="k_Remote_computer_name" VALUE=<% =k_Remote_computer_name %>>
 <INPUT TYPE="hidden" NAME="k_Timestamp" VALUE=<% =k_Timestamp %>>
  
 <INPUT TYPE="hidden" NAME="UPD_Status" VALUE="Pending">
 <input type="hidden" name="Mail_No_Notification" value="someone@somewhere.com">
 <input type="hidden" name="Mail_Corp_Yard" value="someone@somewhere.com">
 <input type="hidden" name="Mail_D911" value="someone@somewhere.com">
 <input type="hidden" name="Mail_Day_Wireless" value="someone@somewhere.com">
 <input type="hidden" name="Mail_Info_Systems" value="someone@somewhere.com">
 <input type="hidden" name="Mail_Internal_Only" value="someone@somewhere.com">
</FORM>

<P>If you are all done go back to the <A HREF="default.htm">Main Page</A></P>

</BODY>

</HTML>

rdouglass -> RE: And now, this?? (3/22/2008 0:44:42)
quote: <INPUT TYPE="hidden" NAME="k_Ticket_ID" VALUE=<% =k_Ticket_ID %>> Make sure every one of these hidden fields have double quotes around the VBScript (ASP) variable: <INPUT TYPE="hidden" NAME="k_Ticket_ID" VALUE="<%=k_Ticket_ID %>"> See them? That should help.

pd_it_guy -> RE: And now, this?? (3/22/2008 11:16:59)
Got it. Gimme as sec and I will put them in and report back.

pd_it_guy -> RE: And now, this?? (3/22/2008 11:28:43)
Wow... you guys are good. That worked perfectly. Thanks so much for everything. pd_it_guy

Page: [1]

0.09375