Syntax error in query

	Home Register Search Help Login

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

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

Syntax error in query

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, PHP, and Database >> Syntax error in query

Page: [1]


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 (in reply to adavies)


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> (in reply to dupati1)


BeTheBall Posts: 6487 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. (in reply to adavies)


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. (in reply to BeTheBall)


Spooky Posts: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to tipsinc)