|
adavies -> RE: Syntax error in query (2/24/2004 11:25:19)
|
Here is the code for the .asp page in question that is generating the error message
thanks
Ashley
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>SHIPPING INFORMATION</title>
</head>
<body>
<form BOTID="0" METHOD="POST" ACTION="cca-shippinginfo2.asp">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font color="#FF0000" face="Arial" size="2"><strong>SHIPPING
INFORMATION</strong></font><font face="Arial" size="2"><strong> </strong><font color="#000000">-
Please confirm/change the shipping information below and click the
"submit" button (below)</font></font></p>
<table BORDER="0" WIDTH="100%">
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Ship Date:</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ActualShip" VALUE="<%=Request("ActualShip")%>" size="30" style="color: #FF0000"></td>
<td width="17%" bgcolor="#CCCCCC"><font face="Arial" size="2">Job Number:</font></td>
<td width="33%" bgcolor="#CCCCCC"><input NAME="JobNo" VALUE="<%=Request("JobNo")%>" size="30" style="color: #FF0000"></td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Customer:</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="Customer" VALUE="<%=Request("Customer")%>" size="30" style="color: #FF0000"></td>
<td width="17%" bgcolor="#CCCCCC"><font face="Arial" size="2">Sub Job No:</font></td>
<td width="33%" bgcolor="#CCCCCC" valign="top"> <input NAME="SubJobNo" VALUE="<%=Request("SubJobNo")%>" size="30" style="color: #FF0000"></td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Purchase
Order #</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="CustomerPO" VALUE="<%=Request("CustomerPO")%>" size="30" style="color: #FF0000"></td>
<td width="17%" bgcolor="#CCCCCC"><font face="Arial" size="2">Class:</font></td>
<td width="33%" bgcolor="#CCCCCC"> <input NAME="ShipClass" VALUE="<%=Request("ShipClass")%>" size="30" style="color: #FF0000"></td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Ship Method:</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipMethod" VALUE="<%=Request("ShipMethod")%>" size="30" style="color: #FF0000"></td>
<td width="17%" bgcolor="#CCCCCC"><font face="Arial" size="2">Ship Weight:</font></td>
<td width="33%" bgcolor="#CCCCCC"> <input NAME="ShipWeight" VALUE="<%=Request("ShipWeight")%>" size="30" style="color: #FF0000"></td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Freight:</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="Freight" VALUE="<%=Request("Freight")%>" size="30" style="color: #FF0000"></td>
<td width="17%" bgcolor="#CCCCCC"><font face="Arial" size="2">Carrier:</font></td>
<td width="33%" bgcolor="#CCCCCC"> <input NAME="ShipCarrier" VALUE="<%=Request("ShipCarrier")%>" size="30" style="color: #FF0000"></td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="17%" bgcolor="#CCCCCC"> </td>
<td width="33%" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Destination:</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="Ship" VALUE="<%=Request("Ship")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC">Origin:</td>
<td width="25%" bgcolor="#CCCCCC" valign="middle">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial" size="2">Enerfab</font>
</td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipStreet" VALUE="<%=Request("ShipStreet")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC" valign="middle">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial" size="2">4955
Spring Grove Ave</font></p>
</td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipCity" VALUE="<%=Request("ShipCity")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC" valign="middle">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial" size="2">Cincinnati</font>
</td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipState" VALUE="<%=Request("ShipState")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC" valign="middle">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial" size="2">Ohio</font>
</td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipZip" VALUE="<%=Request("ShipZip")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC" valign="middle">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial" size="2">45232</font>
</td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Attention:</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipFirstName" VALUE="<%=Request("ShipFirstName")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipAttn" VALUE="<%=Request("ShipAttn")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC"> </td>
<td width="25%" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">Phone:</font></td>
<td width="25%" bgcolor="#CCCCCC"><input NAME="ShipPhone" VALUE="<%=Request("ShipPhone")%>" size="30" style="color: #FF0000"></td>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2">ID:</font></td>
<td width="25%" bgcolor="#CCCCCC"><font face="Arial" size="2"><input NAME="ID" VALUE="<%=Request("ID")%>" size="20" style="color: #FF0000"></font></td>
</tr>
</table>
<table border="0" width="100%">
<tr>
<td width="17%" bgcolor="#CCCCCC">
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial" size="2">Shipping
details:</font></p>
<p style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><font face="Arial" size="2">Partial
shipments: </font></p>
</td>
<td width="83%" bgcolor="#CCCCCC"><textarea rows="10" wrap="virtual" name="ShipNotes" cols="65" style="color: #FF0000"><%=Request("ShipNotes")%></textarea></td>
</tr>
</table>
<table border="0" width="100%">
<tr>
<td width="50%" valign="top">
<p align="center"><font face="Arial" size="2"><b>Click here to
confirm the
shipping information - </b></font></p>
</td>
<td width="50%"><input TYPE="Submit">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</td>
</tr>
</table>
</form>
<table width="100%" border="0">
<thead>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan s-columnnames s-columntypes
s-dataconnection="Database2" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-ListFormat="0" b-makeform="TRUE" s-recordsource s-displaycolumns
s-criteria s-order
s-sql="UPDATE DISTINCTROW RESULTS SET <br>Customer='::Customer::', <br>Ship='::Ship::', <br>ActualShip='::ActualShip::', <br>SubJobNo='::SubJobNo::', <br>ShipMethod='::ShipMethod::', <br>ShipClass='::ShipClass::', <br>ShipAttn='::ShipAttn::', <br>ShipPhone='::ShipPhone::', <br>ShipNotes='::ShipNotes::', <br>ShipWeight='::ShipWeight::', <br>ShipStreet='::ShipStreet::', <br>ShipCity='::ShipCity::', <br>ShipState='::ShipState::', <br>ShipZip='::ShipZip::', <br>Freight='::Freight::', <br>ShipFirstName='::ShipFirstName::', <br>JobNo='::JobNo::' <br>WHERE ID=::ID::"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="Customer=&Ship=&ActualShip=&SubJobNo=&ShipMethod=&ShipClass=&ShipAttn=&ShipPhone=&ShipNotes=&ShipWeight=&ShipStreet=&ShipCity=&ShipState=&ShipZip=&Freight=&ShipFirstName=&JobNo=&ID="
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>"
b-WasTableFormat="TRUE" b-ReplaceDatabaseRegion="TRUE" --><!--#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="UPDATE DISTINCTROW RESULTS SET Customer='::Customer::', Ship='::Ship::', ActualShip='::ActualShip::', SubJobNo='::SubJobNo::', ShipMethod='::ShipMethod::', ShipClass='::ShipClass::', ShipAttn='::ShipAttn::', ShipPhone='::ShipPhone::', ShipNotes='::ShipNotes::', ShipWeight='::ShipWeight::', ShipStreet='::ShipStreet::', ShipCity='::ShipCity::', ShipState='::ShipState::', ShipZip='::ShipZip::', Freight='::Freight::', ShipFirstName='::ShipFirstName::', JobNo='::JobNo::' WHERE ID=::ID::"
fp_sDefault="Customer=&Ship=&ActualShip=&SubJobNo=&ShipMethod=&ShipClass=&ShipAttn=&ShipPhone=&ShipNotes=&ShipWeight=&ShipStreet=&ShipCity=&ShipState=&ShipZip=&Freight=&ShipFirstName=&JobNo=&ID="
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="16633" -->
<!--webbot bot="DatabaseRegionEnd" startspan 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>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" -->
</tbody>
</table>
<br>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<form BOTID="1" METHOD="POST" ACTION="cca-shippinginfo.asp">
<table BORDER="0">
<tr>
<td><b>JobNo</b></td>
<td><input TYPE="TEXT" NAME="JobNo" VALUE="<%=Request("JobNo")%>" size="20"></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" CLIENTSIDE
SuggestedExt="asp" PREVIEW=" " startspan --><!--webbot bot="SaveAsASP" endspan -->
<p> </p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>ShipperName</b></td>
<td><b>ShipperAddress</b></td>
<td><b>ShipperContact</b></td>
<td><b>JobNo</b></td>
<td><b>Customer</b></td>
<td><b>Ship</b></td>
<td><b>Freight</b></td>
<td><b>ActualShip</b></td>
<td><b>ShipAttn</b></td>
<td><b>ShipPhone</b></td>
<td><b>ShipClass</b></td>
<td><b>ShipWeight</b></td>
<td><b>ShipNotes</b></td>
<td><b>Shipping_ID</b></td>
<td><b>ShipMethod</b></td>
<td><b>Results_ID</b></td>
<td><b>ShipStreet</b></td>
<td><b>ShipCity</b></td>
<td><b>ShipState</b></td>
<td><b>ShipZip</b></td>
<td><b>CustomerPO</b></td>
<td><b>ShipCarrier</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-columntypes="3,202,202,202,202,202,202,202,202,203,3,202,202,202,202,202,202,202,203,202,202,202,202,202"
s-dataconnection="Database2" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="ShipperName" s-menuvalue="ShipperName" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-ListFormat="0" b-makeform="TRUE" s-recordsource="Shipping Query"
s-displaycolumns="ShipperName,ShipperAddress,ShipperContact,JobNo,Customer,Ship,Freight,ActualShip,ShipAttn,ShipPhone,ShipClass,ShipWeight,ShipNotes,Shipping_ID,ShipMethod,Results_ID,ShipStreet,ShipCity,ShipState,ShipZip,CustomerPO,ShipCarrier"
s-criteria="[JobNo] EQ {JobNo} +" s-order
s-sql="SELECT * FROM "Shipping Query" WHERE (JobNo = '::JobNo::')"
b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="JobNo=1"
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="0"
BOTID="1" 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>" b-WasTableFormat="TRUE" b-ReplaceDatabaseRegion="FALSE" --><!--#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 ""Shipping Query"" WHERE (JobNo = '::JobNo::')"
fp_sDefault="JobNo=1"
fp_sNoRecords="<tr><td colspan=22 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ShipperName"
fp_sMenuValue="ShipperName"
fp_iDisplayCols=22
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14927" -->
<tr>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipperName" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipperName<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipperName")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29451" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipperAddress" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
preview="<font size="-1"><<</font>ShipperAddress<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipperAddress")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="40310" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipperContact" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
preview="<font size="-1"><<</font>ShipperContact<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipperContact")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="42296" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="JobNo" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>JobNo<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"JobNo")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="8863" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="Customer" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>Customer<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"Customer")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="16917" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="Ship" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>Ship<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"Ship")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="5134" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="Freight" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>Freight<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"Freight")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="14134" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ActualShip" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ActualShip<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ActualShip")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28047" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipAttn" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipAttn<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipAttn")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="16243" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipPhone" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipPhone<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipPhone")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19721" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipClass" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipClass<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipClass")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="20533" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipWeight" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipWeight<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipWeight")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30490" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipNotes" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipNotes<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipNotes")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="20457" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="Shipping_ID" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>Shipping_ID<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"Shipping_ID")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="25450" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipMethod" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipMethod<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipMethod")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29058" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="Results_ID" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>Results_ID<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"Results_ID")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="22042" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipStreet" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipStreet<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipStreet")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30482" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipCity" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipCity<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipCity")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="16515" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipState" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipState<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipState")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19797" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipZip" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipZip<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipZip")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="13596" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="CustomerPO" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>CustomerPO<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"CustomerPO")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="25324" -->
</td>
<td>
<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Shipping_ID,ShipperName,JobNo,Customer,ActualShip,ShipMethod,ShipAttn,ShipPhone,ShipClass,Ship,Results_ID,Expr1011,ShipStreet,ShipCity,ShipState,ShipZip,ShipWeight,Freight,ShipNotes,CustomerPO,ShipCarrier,ShipperAddress,ShipperContact,ShipFirstName"
s-column="ShipCarrier" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
preview="<font size="-1"><<</font>ShipCarrier<font size="-1">>></font>" b-makelink b-MenuFormat --><%=FP_FieldVal(fp_rs,"ShipCarrier")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29892" -->
</td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan 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>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" -->
</tbody>
</table>
</body>
</html>
|
|
|
|
