And now, this??

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

And now, this??

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> And now, this??

Page: [1]


pd_it_guy Posts: 172 Joined: 3/4/2008 Status: offline	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 Posts: 9229 From: Biddeford, ME USA Status: offline	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? < Message edited by rdouglass -- 3/22/2008 0:45:34 > _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to pd_it_guy)


pd_it_guy Posts: 172 Joined: 3/4/2008 Status: offline	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. (in reply to pd_it_guy)


pd_it_guy Posts: 172 Joined: 3/4/2008 Status: offline	RE: And now, this?? - 3/22/2008 0:07:05 Stand by a just a sec for the code.... (in reply to pd_it_guy)

pd_it_guy

Posts: 172
Joined: 3/4/2008
Status: offline

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>

(in reply to pd_it_guy)


rdouglass Posts: 9229 From: Biddeford, ME USA Status: offline	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. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to pd_it_guy)

pd_it_guy

Posts: 172
Joined: 3/4/2008
Status: offline

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>

< Message edited by rdouglass -- 3/22/2008 0:43:08 >

(in reply to pd_it_guy)


rdouglass Posts: 9229 From: Biddeford, ME USA Status: offline	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. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to pd_it_guy)


pd_it_guy Posts: 172 Joined: 3/4/2008 Status: offline	RE: And now, this?? - 3/22/2008 11:16:59 Got it. Gimme as sec and I will put them in and report back. (in reply to pd_it_guy)


pd_it_guy Posts: 172 Joined: 3/4/2008 Status: offline	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 (in reply to pd_it_guy)

Page: [1]

All Forums >> Web Development >> ASP and Database >> And now, this??

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts