Why does This error message occur (Full Version)

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



Message

Kage -> Why does This error message occur (12/17/2003 18:39:24)

I've been using a method of creating an update form betheball suggested to me of calling an update form from a DRW page. In the DRW results table, i have a hyperlink that should take a value from the page and open the update form with that value while displaying the information needed to update said record. the hyperlink reads as such:

<a href="#" onclick="javascript:window.open('UpdateErrorTracking.asp?PickTicket=<%=FP_FieldVal(fp_rs,"PickTicket")%>', 'none', 'width=800,height=600');">Click Here</a>

but when i pull the UpdateErrorTracking.asp page up with this i get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Pickticket ='.

/ErrorTracking/UpdateErrorTracking.asp, line 36


it's telling me that a variable isn't declared but I don't fully understand why it's giving me this when I did declare the variable. I will post the code to the DRW and the Code to the update form. Perhaps one of you gurus know what I've done wrong.



Kage -> RE: Why does hit error message occur (12/17/2003 18:45:01)

This is the UpdateForm I was talking about.





<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Update Error Tracking</title>
</head>

<body>

<!-- Query statement -->
<%
' ' ' ' declare all the variables
DIM SQL, objRS, objConn, strConn
DIM strPickTicket

' ' ' ' pull all the data from the previous page
strPickTicket = Request.Form("PickTicket")

' ' ' ' create sql statement
SQL = "SELECT * FROM ""Results"" WHERE Pickticket = " & strPickTicket & " "

' ' ' ' creates a connection object
Set objConn = Server.CreateObject("ADODB.Connection")

' ' ' ' identifies the database and tells the computer where to store the data
strConn = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("/fpdb/ErrorTracking.mdb")
' ' ' ' opens the database
objConn.Open strConn

' ' ' ' creates the recordset
Set objRS = Server.CreateObject("ADODB.Recordset")

' ' ' ' executes the sql statement
Set objRS = objConn.Execute (SQL)
%>

<!-- No records found statement -->
<%
If objRS.EOF = True Then
Response.Write "No records found to match the given search criteria."
End If
%>



</body>
<BODY background="../images/BackgroundForms.JPG">
<H1>Error Tracking Ops Database</H1>
<P>
</P>
<FORM METHOD="POST" ACTION="--WEBBOT-SELF--">
<DT><b>Date</b>:
<INPUT TYPE=TEXT NAME="Date" SIZE=8 MAXLENGTH=8 value="<%=Date%>">
<EM> -- mm/dd/yy</EM><DT><b>Pickticket</b>:
<INPUT TYPE=TEXT NAME="Pickticket" SIZE=10 MAXLENGTH=10 value="<%PickTicket%>">  <b>Claim #</b>:
<INPUT TYPE=TEXT NAME="ClaimNumber" SIZE=10 MAXLENGTH=10 value="<%ClaimNumber%>">  <b>Part #</b>:
<INPUT TYPE=TEXT NAME="PartNumber" SIZE=28 MAXLENGTH=28 value="<%PartNumber%>">  <b>Reason</b>: 
<SELECT NAME="Reason">
<OPTION SELECTED><%Reason%>
<OPTION>Overage
<OPTION>Underage
<OPTION>Wrong Part
<OPTION>Short Shipped
<OPTION>MisPick
<OPTION>POD Sent
<OPTION>Arrived Late
<OPTION>Being Tracked
<OPTION>Mfr Mis-Labeled
</SELECT><DT><b>Picked By</b>:
<INPUT TYPE=TEXT NAME="PickedBy" SIZE=7 MAXLENGTH=7 value="<%PickedBy%>">  <b>Date Picked</b>:
<INPUT TYPE=TEXT NAME="DatePicked" SIZE=8 MAXLENGTH=8 value="<%DatePicked%>"><EM>   </EM><b>Weighed\Inspected By</b>:
<INPUT TYPE=TEXT NAME="WeighedBy" SIZE=7 MAXLENGTH=7 value="<%WeighedBy%>">  <b>Date Weighed</b>:
<INPUT TYPE=TEXT NAME="DateWeighed" SIZE=8 MAXLENGTH=8 value="<%DateWeighed%>"><DT><b>Findings</b>:   
<TEXTAREA NAME="Findings" ROWS=1 COLS=35 value="<%Findings%>"></TEXTAREA>  <b>         In-House/Claim</b>: 
<INPUT TYPE=CHECKBOX NAME="InHouseOrClaim_In-House" value="<%InHouseOrClaim_In-House%>">In-House 
<INPUT TYPE=CHECKBOX NAME="InHouseOrClaim_Claim" value="<%InHouseOrClaim_Claim%>">Claim<DT><b>Qty Customer Got</b>:  
<INPUT TYPE=TEXT NAME="QtyCustomerGot" SIZE=5 MAXLENGTH=5 value="<%QtyCustomerGot%>">  <b>Actual Qty</b>:
<INPUT TYPE=TEXT NAME="ActualQty" SIZE=7 MAXLENGTH=7 value="<%ActualQty%>">  <b>Part # If Received Wrong</b>: 
<INPUT TYPE=TEXT NAME="PartNumIfReceivedWrong" SIZE=28 MAXLENGTH=28 value="<%PartNumIfReceivedWrong%>"><DT><b>Amount Over/Short</b>:
<INPUT TYPE=TEXT NAME="AmtOverShort" SIZE=5 MAXLENGTH=5 value="<%AmtOverShort%>">  <b> Location</b>:   
<INPUT TYPE=TEXT NAME="Location" SIZE=9 MAXLENGTH=9 value="<%Location%>">     <b>Qty Shipped/Received</b>:
<INPUT TYPE=TEXT NAME="QtyShippedReceived" SIZE=5 MAXLENGTH=5 value"<%QtyShippedReceived%>"><DT><b>Comments</b>: 
<TEXTAREA NAME="Comments" ROWS=3 COLS=35 value="<%Comments%>"></TEXTAREA>  <b>          Customer</b>:
<INPUT TYPE=TEXT NAME="Customer" SIZE=25 MAXLENGTH=25 value="<%Customer%>"><DT><b>Part Description</b>:
<INPUT TYPE=TEXT NAME="PartDescription" SIZE=28 MAXLENGTH=28 value="<%PartDescription%>">        
<b>Scale Counted</b>:
<INPUT TYPE=CHECKBOX NAME="ScaleCounted_Yes" value="<%ScaleCounted_Yes%>">Yes   Value
<INPUT TYPE=TEXT NAME="Value" SIZE=7 MAXLENGTH=7 value="<%Value%>"><DT><b>Order Drop Time</b>:
<INPUT TYPE=TEXT NAME="OrderDropTime" SIZE=8 MAXLENGTH=8 value="<%OrderDropTime%>">  <b>Pick Time</b>:
<INPUT TYPE=TEXT NAME="PickTime" SIZE=8 MAXLENGTH=8 value="<%Picktime%>">  <b>Pack Time</b>:
<INPUT TYPE=TEXT NAME="PackTime" SIZE=8 MAXLENGTH=8 value="<%PackTime%>">  <b>Ship Via</b>: 
<INPUT TYPE=TEXT NAME="ShipVia" SIZE=5 MAXLENGTH=5 value="<%ShipVia%>">  
<DT><b>Export Order</b>: <INPUT TYPE=CHECKBOX NAME="ExportOrder_Yes" value="<%ExportOrder_Yes%>">Yes  
<INPUT TYPE=CHECKBOX NAME="ExportOrder_No" value="ON">No  <b>Lines on Pick</b>:
<INPUT TYPE=TEXT NAME="LinesOnPick" SIZE=5 MAXLENGTH=5 value="<%LinesOnPick%>">   <b>                           Day of Week</b>:
<INPUT TYPE=TEXT NAME="DayOfWeek" SIZE=9 MAXLENGTH=9 value="<%DayOfWeek%>"></DL>
<p>
<INPUT TYPE=SUBMIT VALUE="Submit Form">
<INPUT TYPE=RESET VALUE="Reset Form"> </p>
</FORM>
<HR>
<H5 align="center">
<font size="5"><a href="../main_page_right.htm">HOME</a></font><BR>
Revised:
<!--WEBBOT BOT=TimeStamp
S-Type="EDITED"
S-Format="%m/%d/%y"
--></H5>
</BODY>
</HTML>
</html>



Kage -> RE: Why does hit error message occur (12/17/2003 18:51:07)

This one is the DRW that hasn't been dieted. I don't want to diet it until I can get it all working, sorry if it's a pain the rear to read.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' 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 1</title>
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="ErrorTrackingReportInv.asp">
<table BORDER="0">
<tr>
<td><b>Pickticket</b></td>
<td>
<input TYPE="TEXT" NAME="Pickticket" VALUE="<%=Request("Pickticket")%>" size="20"></td>
</tr>
</table>
<p><input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --></p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Pickticket</b></td>
<td><b>Claim Number</b></td>
<td><b>Part Number</b></td>
<td><b>Reason</b></td>
<td><b>Picked By</b></td>
<td><b>Date Picked</b></td>
<td><b>Weighed By</b></td>
<td><b>Date Weighed</b></td>
<td><b>Amt Over/Short</b></td>
<td><b>Comments</b></td>
<td><b>Customer</b></td>
<td>
<p align="center"><b>Scale</b></td>
<td><b>Update</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-columntypes="3,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,135" s-dataconnection="ErrorTracking" 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="Results" s-displaycolumns="Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,AmtOverShort,Comments,Customer,ScaleCounted_Yes" s-criteria="[Pickticket] EQ {Pickticket} +" s-order s-sql="SELECT * FROM Results WHERE (Pickticket = '::Pickticket::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Pickticket=" 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" align="left" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</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 Results WHERE (Pickticket = '::Pickticket::')"
fp_sDefault="Pickticket="
fp_sNoRecords="<tr><td colspan=12 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="ErrorTracking"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=12
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="20588" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="Pickticket" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Pickticket<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Pickticket")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30398" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="ClaimNumber" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ClaimNumber<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ClaimNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28814" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="PartNumber" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PartNumber<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PartNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28967" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="Reason" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Reason<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Reason")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15128" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="PickedBy" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PickedBy<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PickedBy")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15731" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="DatePicked" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DatePicked<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"DatePicked")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="26419" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="WeighedBy" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>WeighedBy<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"WeighedBy")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19343" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="DateWeighed" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DateWeighed<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"DateWeighed")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="27563" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="AmtOverShort" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>AmtOverShort<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"AmtOverShort")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31537" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="Comments" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Comments<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16369" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="Customer" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Customer<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Customer")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16917" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Date,Pickticket,ClaimNumber,PartNumber,Reason,PickedBy,DatePicked,WeighedBy,DateWeighed,Findings,InHouseOrClaim_In-House,InHouseOrClaim_Claim,QtyCustomerGot,ActualQty,PartNumIfReceivedWrong,AmtOverShort,Location,QtyShippedReceived,Comments,Customer,PartDescription,ScaleCounted_Yes,Value,OrderDropTime,PickTime,PackTime,ShipVia,ExportOrder_Yes,ExportOrder_No,LinesOnPick,DayOfWeek,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="ScaleCounted_Yes" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ScaleCounted_Yes<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ScaleCounted_Yes")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="44060" --></td>
<td>
<a href="#" onclick="javascript:window.open('UpdateErrorTracking.asp?PickTicket=<%=FP_FieldVal(fp_rs,"PickTicket")%>', 'none', 'width=800,height=600');">Click Here</a>
</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" align="left" 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="56926" --></tbody>
</table>

</body>

</html>



BeTheBall -> RE: Why does hit error message occur (12/17/2003 19:19:27)

Is the error occurring on the page that displays the results or on the page you are linked to? If the error occurs on the page with the update form, try changing this:

' ' ' create sql statement
SQL = "SELECT * FROM ""Results"" WHERE Pickticket = " & strPickTicket & " "

to this:

' ' ' create sql statement
SQL = "SELECT * FROM [Results] WHERE Pickticket = " & strPickTicket & ""

Edit - Disregard the above. The culprit is likely this:

' ' ' ' pull all the data from the previous page
strPickTicket = Request.Form("PickTicket")

Your hyperlink is not in a form, thus you cannot use the request.form method. Try this:

' ' ' ' pull all the data from the previous page
strPickTicket = Request.QueryString("PickTicket")



Kage -> RE: Why does hit error message occur (12/17/2003 20:04:34)

Thanks man, that changed the error message lol, now I've got a datatype mismatch:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/ErrorTracking/UpdateErrorTracking.asp, line 36


any clue where to start with that vague stuff?



BeTheBall -> RE: Why does hit error message occur (12/17/2003 21:04:44)

Evidently PickTicket is a text field?

Try putting single quotes around "& strPickTicket &"

' ' ' create sql statement
SQL = "SELECT * FROM ""Results"" WHERE Pickticket = '" & strPickTicket & "'"



Kage -> RE: Why does hit error message occur (12/18/2003 15:15:00)

Well, That removed the type mismatch error lol.

Now each field comes up blank.



Kage -> RE: Why does hit error message occur (12/18/2003 15:17:56)

If i leave the field values how they are:

value="<%PickTicket%>"

they give me a response on the displayed form as:

Pickticket: <font face=

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'PartNumber'

/ErrorTracking/UpdateErrorTracking.asp, line 59


this repeats for every field.

if i change:

value="<%=PickTicket%>"

it continues on to the next field i haven't added the "=" into but the fields are blank as I said. any idea where I went wrong?



BeTheBall -> RE: Why does hit error message occur (12/18/2003 15:18:45)

Did you get this from one of my prior posts:

The culprit is likely this:

' ' ' ' pull all the data from the previous page
strPickTicket = Request.Form("PickTicket")

Your hyperlink is not in a form, thus you cannot use the request.form method. Try this:

' ' ' ' pull all the data from the previous page
strPickTicket = Request.QueryString("PickTicket")



BeTheBall -> RE: Why does hit error message occur (12/18/2003 15:29:04)

Try:

value="<%="&PickTicket&"%>"



Kage -> RE: Why does hit error message occur (12/18/2003 15:38:11)

quote:

Did you get this from one of my prior posts:

The culprit is likely this:

' ' ' ' pull all the data from the previous page
strPickTicket = Request.Form("PickTicket")

Your hyperlink is not in a form, thus you cannot use the request.form method. Try this:

' ' ' ' pull all the data from the previous page
strPickTicket = Request.QueryString("PickTicket")




yes, thanks it worked. thats how i got to this point.



BeTheBall -> RE: Why does hit error message occur (12/18/2003 15:44:02)

Larry, in the places you are trying to display values from the db, you may need to do something like this:

value="<%=" & objRS.Fields("FieldName") & "%>"



Kage -> RE: Why does hit error message occur (12/18/2003 16:04:35)

Let me try that, thanks for helping me out Duane, if you ever need something let me know. I'll do what i can.



BeTheBall -> RE: Why does hit error message occur (12/18/2003 16:07:56)

No problem. Part of the problem is you have kind of a mixture of FP and pure ASP going on. Hopefully we'll work through it and get the end product you are hoping for.



Kage -> RE: Why does hit error message occur (12/18/2003 16:18:12)

Microsoft VBScript compilation error '800a03ee'

Expected ')'

/ErrorTracking/UpdateErrorTracking.asp, line 57

Response.Write(" & objRS.Fields("Pickticket") & ")
---------------------------------^


is what that results in, would it help if i zipped and mailed so you could see it fully?



Kage -> RE: Why does hit error message occur (12/18/2003 16:19:02)

If there's an easier way to do this or a better direction, I don't mind starting over one bit.



BeTheBall -> RE: Why does hit error message occur (12/18/2003 16:41:56)

Try just:

value="<%=objRS.Fields("FieldName")%>"



Kage -> RE: Why does hit error message occur (12/18/2003 17:07:06)

That did it [:D]

lemme see if I can get the rest of the form to work. I tried the first 3 and they ran.



Kage -> RE: Why does hit error message occur (12/19/2003 11:56:39)

When you first started suggesting ways to do this on the update query thread you had me create two .asp pages. One was the updateform.asp and the other was just update.asp. Why did you have me create the update.asp? I'm now at a point where I want to submit the updates to the DB and am unsure how to go about doing this.



BeTheBall -> RE: Why does hit error message occur (12/19/2003 12:06:01)

updateform.asp is the form. update.asp contains the actual update SQL. So, in the form properties for updateform.asp, you have it submit to update.asp so the SQL can execute and update the record. Make sense?



Kage -> RE: Why does hit error message occur (12/19/2003 12:30:08)

I am still needing it to close the updateform window so i'm guessing that code you gave me last time would still apply.



BeTheBall -> RE: Why does hit error message occur (12/19/2003 12:43:01)

Actually you would want to close the Update.asp window. The form page will submit to the update page which will then open in the same window. Right??? And yes, the same code should do it.



Kage -> RE: Why does hit error message occur (12/19/2003 12:43:25)

quote:

ORIGINAL: betheball

updateform.asp is the form. update.asp contains the actual update SQL. So, in the form properties for updateform.asp, you have it submit to update.asp so the SQL can execute and update the record. Make sense?



Indeed. Only problem with that is I'm not quite sure how to make the button open up the update form and exactly what to include in the updateform.asp.



BeTheBall -> RE: Why does hit error message occur (12/19/2003 12:46:31)

quote:

Indeed. Only problem with that is I'm not quite sure how to make the button open up the update form and exactly what to include in the updateform.asp.


What button? I thought we were talking about a hyperlink on a page that displayed a set of records.



Kage -> RE: Why does hit error message occur (12/19/2003 12:57:40)

What I'm talking about is the UpdateErrorTracking.asp that calls up a form with all the previous information to be updated. It has a button on it to resubmit it but I need that button to update the record, not create a new one with the same info. It was at that point you mentioned the update.asp from the last thread.

The basic flow I'm guessing would look like this:

ErrorTrackingReportInv.asp-->UpdateErrorTracking.asp-->Update.asp

---------------update and submit updated data--^



BeTheBall -> RE: Why does hit error message occur (12/19/2003 13:23:32)

quote:

Go back to the form you created in UpdateForm.asp and in Normal view, right-click it. Choose "Form Properties". Check the "Send to other" radio button. Then click the options button. In the Action box, type Update.asp

Now you need to create a new page. Call it update.asp. On that page, insert a Database Results Wizard. In step 2, choose custom query with this as your query:

UDDATE Results SET Completed='Yes' WHERE ID=::ID::

Finish the rest of the wizard and then test the whole series of pages to ensure the update is working. Once we have that working, we'll see if we can add some code to close the popup and refresh the results page (I haven't done that part before, but think I found some code that will work.)


Remember the above from your other post? It's essentially what you want to do again, just change the Update query to include all the fields you wish to update.

Like:

UPDATE YourTable SET Field1='::Field1::', Field2='::Field2::', DateField=#::DateField::# WHERE PickTicketID='::PickTicketID::

Does that help?



Kage -> RE: Why does hit error message occur (12/19/2003 15:00:23)

yeah, that's what I was talking about. lemme see what i can do.



Kage -> RE: Why does hit error message occur (12/19/2003 15:41:24)

lol, what is your icon now?



BeTheBall -> RE: Why does hit error message occur (12/19/2003 22:22:23)

None other than Caddyshack's lovable little gopher.



Kage -> RE: Why does hit error message occur (12/22/2003 15:09:27)

On the updateerrortracking.asp there's a button for submission of the updated data. How do i point that button at the update.asp page with the update sql on it? I'm just wanting to know the easiest way to do it I suppose. There's bound to be a wizrd or easy click option somewhere for it that I obviously don't know about.

caddyshack is a great movie, btw.



Page: [1] 2   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.1411133