|
| |
|
|
adavies
Posts: 42 From: Cincinnati, Ohio, USA Status: offline
|
Syntax error in query - 2/24/2004 10:39:10
Hi, I am getting an error message with my .asp pages developed using Frontpage 2002 and Microsoft Access database... error reads as follows: Database Results Error Description: Syntax error in query. Incomplete query clause. Sours: Microsoft JET database Engine can anybody help please? thanks Ashley
|
|
|
|
dupati1
Posts: 84 Joined: 10/6/2003 Status: offline
|
RE: Syntax error in query - 2/24/2004 11:05:56
Hi, Post your query so that it would be easy to suggest you. Thanks VJ
|
|
|
|
adavies
Posts: 42 From: Cincinnati, Ohio, USA Status: offline
|
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>
|
|
|
|
BeTheBall
Posts: 6465 Joined: 6/21/2002 From: West Point Utah USA Status: offline
|
RE: Syntax error in query - 2/24/2004 12:18:43
According to your Update SQL, all fields in your database are text except the ID field. Is that true? Also, for the sake of our eyes. Consider using the Spooky Diet referenced in my signature. The diet will eliminate several lines from the above code and make your page load faster.
_____________________________
Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
|
|
|
|
tipsinc
Posts: 1 Joined: 3/9/2004 Status: offline
|
RE: Syntax error in query - 3/9/2004 6:48:51
try replacing the following code fp_sQry="SELECT * FROM ""Shipping Query"" WHERE (JobNo = '::JobNo::')" with this fp_sQry="SELECT * FROM [Shipping Query] WHERE (JobNo = '::JobNo::')" I hope it works for you too.
|
|
|
|
Spooky
Posts: 26657 Joined: 11/11/1998 From: Middle Earth Status: offline
|
RE: Syntax error in query - 3/9/2004 13:59:19
Does the error occur on the update or display of values?
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem §þ k¥
|
|

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
|
|
|