DRW error all of a sudden (Full Version)

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



Message

Gregg -> DRW error all of a sudden (8/23/2004 11:53:09)

Hi All,

I have a database on my site that generates results set up with Frontpage and Access...........everything had worked fine up until now I get an error message like the following:

Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator

I have checked out the MSKB about this issue and it stated that you have to set a default value for number fields........I don't know why because it had been working fine for months.....I did follow the article procedure about the default number value in the properties of the DRW but the defaults button is not available to me. I have 2 databases on the web and each page that generated results worked perfectly until today.......they are both generating the same error message as above........Could someone please tell me what to do?

Thanks a bunch



Aelaron -> RE: DRW error all of a sudden (8/23/2004 12:07:45)

Gregg,

First follow the suggestions in this:

DRW Error

Then if that doesn't help, post the error you get after making the change suggested in the first entry of that thread.

JB



BeTheBall -> RE: DRW error all of a sudden (8/23/2004 12:17:54)

JB is correct. My guess is someone upgraded the server to Windows 2003.



Gregg -> RE: DRW error all of a sudden (8/23/2004 13:50:17)

I just got news that someone else backward published to the hard drive and was prompted about certain things and who knows how or what they clicked on........all I know is that since that happened this morning neither of the databases work...........Host Server did admit they don't support FP 2003...........What???????? then how did it work prior??? ........moving to a different host tomorrow morning so until that is completed I will follow the instructions here and will post what the results are...........Thanks a bunch guys...it's good to have support



Gregg -> RE: DRW error all of a sudden (8/24/2004 11:09:16)

Here is the TRUE error message that is displaying:

Unable to find operator in query string. Query string currently is SELECT * FROM "CBD Properties" WHERE ("Town ID" = 'BF') ORDER BY ::Sort:: ASC

And in the other result page from a different database is displaying the following:

Database Results Wizard Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine



Any clues??



BeTheBall -> RE: DRW error all of a sudden (8/24/2004 11:53:02)

The best suggestion I can give you is to replace the files in the _fpclass folder with the ones Spooky posted in the thread referenced by Aelaron. Here is the link again:

http://www.frontpagewebmaster.com/m_175524/tm.htm

This is a know flaw that seems to appear in FP 2002 and 2003 with sites running on Windows 2003 servers.



Gregg -> RE: DRW error all of a sudden (8/24/2004 12:19:57)

Thanks for the suggestion.....but I replaced them while renaming the current ones that were in there but that didn't do any good. Any other suggestions?????



Gregg -> RE: DRW error all of a sudden (8/24/2004 13:50:24)

Tried putting [] around the table name in place of the quotes as instructed from another source but that didn't do it either........AHHHHHHHHHHHHH



Aelaron -> RE: DRW error all of a sudden (8/24/2004 14:04:08)

Try this:

SELECT * FROM CBD Properties WHERE (Town ID = 'BF') ORDER BY Sort ASC

My select/where lines don't have the syntax as you have in yours, i.e. "" or ::. Then again mine are fp_sQry.

JB



Gregg -> RE: DRW error all of a sudden (8/24/2004 14:11:53)

Thanks for the suggestion JB but that didn't work either.........I'm at a complete loss here..........I appreciate your efforts and willing to try any new ideas



Spooky -> RE: DRW error all of a sudden (8/24/2004 15:08:56)

SELECT * FROM [CBD Properties] WHERE ([Town ID] = 'BF') ORDER BY ::Sort:: ASC

Are you passing the value 'sort' from a previous form?
Does it work firstly with a valid column name?



Gregg -> RE: DRW error all of a sudden (8/24/2004 15:22:14)

Spooky, thanks so much for the heads up..........but I got one question. If I change the query string in the DRW, how can I do that WITHOUT frontpage putting back all of the fields to be displayed in the following steps of the wizard.......when I do that all of my formatting and selected displayed fields from previous are all shot out of the water........Is there any way to change the query string in the DRW WITHOUT it changing anything else displayed??



Spooky -> RE: DRW error all of a sudden (8/24/2004 15:50:10)

Do you mean changing '::sort::' to a valid name?
No- it shouldnt cause any problems at all.

If you havent already - do check out the spooky diet as it may make things easier



Gregg -> RE: DRW error all of a sudden (8/24/2004 15:53:19)

I was referring to changing the query string with [] after selecting the custom query button in the DRW......it doesn't give me a choice to finish from that point. I must continue through with the wizard but that only makes me re-do everything including field names to be displayed etc etc..........I will see what you mean with the Spooky Diet



Spooky -> RE: DRW error all of a sudden (8/24/2004 15:54:40)

"changing the query string with [] " ??

Not sure what you mean - these arent querystrings



Gregg -> RE: DRW error all of a sudden (8/24/2004 16:01:43)

I mean taking the quotes out and putting brackets around the field name .........that seems to work BUT I must continue with the wizard and specify all other elements.......can I just change the SQL code and it effect nothing else on my page?



Spooky -> RE: DRW error all of a sudden (8/24/2004 16:06:34)

Yes - do it within the 'gray' code of the page source, without going through the wizard.

If the diet is done, then you only need to modify the 'red' code in the page.



Gregg -> RE: DRW error all of a sudden (8/25/2004 7:52:10)

Thanks ALOT Spooky your suggestion worked............this place is great!

However, getting back to part of the code that you mentioned earlier now doesn't work and that is my sort options.......the code I had in there prior was for a dropdown menu with a go button that a visitor could select and sort by one of the 5 columns being displayed. It worked prior to the upgrade but now it does not. Do I need to modify that in anyway..........::sort::



Spooky -> RE: DRW error all of a sudden (8/25/2004 14:55:20)

The "name" of the select box is 'sort' and it contains only valid column names?



Gregg -> RE: DRW error all of a sudden (8/25/2004 15:13:56)

Yes the name of the text box is sort and it does contain valid column names



Spooky -> RE: DRW error all of a sudden (8/25/2004 15:18:31)

Do you still get the same error as above or no error - just no records?



Gregg -> RE: DRW error all of a sudden (8/25/2004 15:25:20)

No No........I get the results on the page since your last suggestion......only now the sort dropdown menu doesn't sort them after the fact like it used to.



Spooky -> RE: DRW error all of a sudden (8/25/2004 15:33:37)

If you place an actual value in there (instead of ::sort::) it still sorts as normal?
Do you have an example page we can see?



Gregg -> RE: DRW error all of a sudden (8/25/2004 15:35:40)

http://www.mainstreetcenter.com ...........click on Freedom on Left..........and then choose "Property Listings"



Spooky -> RE: DRW error all of a sudden (8/25/2004 15:44:49)

And what does the current DRW code look lile for that page?
Have you set a default sort order - for when the user first arrives at the page?

That could be the original error - if there is no default, the SQL string would error



Gregg -> RE: DRW error all of a sudden (8/25/2004 15:51:41)

I have a default sort of the Property Address Column which works fine when the list is initially displayed........on second look it doesn't work initially......but here is the code

s-sql="SELECT * FROM [CBD Properties] WHERE ([Town ID] = 'FR')" order by
::sort:: asc " b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Sort=Property_Address"



Spooky -> RE: DRW error all of a sudden (8/25/2004 15:54:08)

Post the full pages code?



Gregg -> RE: DRW error all of a sudden (8/25/2004 15:56:34) 

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Property Listings</title>
<style fprolloverstyle>a:hover      { color: #000080 }
</style>
</head>

<body link="#0000E1" vlink="#0000E1" alink="#0000E1">

<form botid="0" method="POST" action="property_listings_fr.asp">
  <div align="center">
    <center>
    <table border="0" width="97%" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
      <tr>
        <td width="192">  <a name="SortBy"></a> <select size="1" name="Sort">
            <option>Sort By...</option>
            <option value="Property_Address">Property_Address</option>
            <option value="Occupant">Occupant</option>
            <option value="Property_Owner">Property_Owner</option>
            <option value="Tax_Parcel">Tax_Parcel</option>
          </select> <input type="submit" value="Go" style="color: #FFFFFF; font-weight: bold; background-color: #008080"></td>
        <td width="473">
          <p align="right"><font color="#008080" style="font-size: 20pt">Property
          Listings</font></td>
      </tr>
    </table>
    </center>
  </div>
</form>
<div align="center">
  <center>
  <table width="97%" border="0" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111" cellspacing="0">
    <thead>
      <tr>
        <td bgcolor="#F2ECDB"> </td>
        <td bgcolor="#F2ECDB"><b>Property_Address</b></td>
        <td bgcolor="#F2ECDB"><b>Occupant</b></td>
        <td bgcolor="#F2ECDB"><b>Property_Owner</b></td>
        <td bgcolor="#F2ECDB">
          <p align="center"><b>Tax_Parcel</b></td>
      </tr>
    </thead>
    <tbody>
      <!--webbot bot="DatabaseRegionStart" startspan
      s-columnnames="Tax_Parcel,Town ID,Property_Address,Property City,Property State,Property Zip,Street Level Square Feet,Total Building_Square_Feet,Lot Frontage,Lot Size,Date Purchased,Property_Owner,Owner Address,Owner City State Zip,Owner Phone,Occupant,Occupant Type,Occupant Phone,Occupancy Description,Contact_for_Information_(Vacant),Contact Phone,Picture,Unit_ID,Details"
      s-columntypes="202,202,202,202,202,202,3,3,3,3,135,202,202,202,202,202,202,202,202,202,202,202,3,202"
      s-dataconnection="Mainstreet" b-tableformat="TRUE" b-menuformat="FALSE"
      s-menuchoice="Details" s-menuvalue="Details" 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="Details, Property_Address,Occupant,Property_Owner,Tax_Parcel"
      s-criteria s-order
      s-sql="SELECT * FROM [CBD Properties] WHERE ([Town ID] = 'FR')" order by
      ::sort:: asc " b-procedure="FALSE" clientside suggestedext="asp"
      s-defaultfields="Sort=Property_Address"
      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.</font></td></tr>"
      b-wastableformat="TRUE"
      local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>" --><!--#include file="../../../../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM [CBD Properties] WHERE ([Town ID] = 'FR')"
fp_sDefault="Sort=Property_Address"
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Mainstreet"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Details"
fp_sMenuValue="Details"
fp_iDisplayCols=5
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-checksum="30123" endspan -->
      <tr>
        <td width="7%" <%
dim x, bgcolor
 if x = 1 then
     bgcolor="#f7f3e8"
     response.write "bgcolor='#f7f3e8'"
     x=2
else
    bgcolor="white"
    response.write "bgcolor='white'"
    x=1
end if %>>
          <p align="center"><font size="1"><a href="../../../../details.asp?Town+ID='<%=FP_FieldURL(fp_rs,"Town ID")%>'"><!--webbot
          bot="DatabaseResultColumn" startspan
          s-columnnames="Tax_Parcel,Town ID,Property_Address,Property City,Property State,Property Zip,Street Level Square Feet,Total Building_Square_Feet,Lot Frontage,Lot Size,Date Purchased,Property_Owner,Owner Address,Owner City State Zip,Owner Phone,Occupant,Occupant Type,Occupant Phone,Occupancy Description,Contact_for_Information_(Vacant),Contact Phone,Picture,Unit_ID,Details"
          s-column="Details" b-tableformat="TRUE" b-hashtml="FALSE"
          b-makelink="FALSE" clientside b-menuformat
          preview="<font size="-1"><<</font>Details<font size="-1">>></font>"
          s-columntypes="202,202,202,202,202,202,3,3,3,3,135,202,202,202,202,202,202,202,202,202,202,202,3,202"
          local_preview="<font size="-1"><<</font>Details<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Details")%><!--webbot
          bot="DatabaseResultColumn" i-checksum="12365" endspan --></a></font></td>
        <td width="25%" bgcolor="<%=bgcolor%>"><font size="2"><!--webbot
          bot="DatabaseResultColumn" startspan
          s-columnnames="Tax_Parcel,Town ID,Property_Address,Property City,Property State,Property Zip,Street Level Square Feet,Total Building_Square_Feet,Lot Frontage,Lot Size,Date Purchased,Property_Owner,Owner Address,Owner City State Zip,Owner Phone,Occupant,Occupant Type,Occupant Phone,Occupancy Description,Contact_for_Information_(Vacant),Contact Phone,Picture,Unit_ID,Details"
          s-column="Property_Address" b-tableformat="TRUE" b-hashtml="FALSE"
          b-makelink="FALSE" clientside b-menuformat
          preview="<font size="-1"><<</font>Property_Address<font size="-1">>></font>"
          local_preview="<font size="-1"><<</font>Property_Address<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Property_Address")%><!--webbot
          bot="DatabaseResultColumn" i-checksum="39301" endspan --></font></td>
        <td width="28%" bgcolor="<%=bgcolor%>"><font size="2"><!--webbot
          bot="DatabaseResultColumn" startspan
          s-columnnames="Tax_Parcel,Town ID,Property_Address,Property City,Property State,Property Zip,Street Level Square Feet,Total Building_Square_Feet,Lot Frontage,Lot Size,Date Purchased,Property_Owner,Owner Address,Owner City State Zip,Owner Phone,Occupant,Occupant Type,Occupant Phone,Occupancy Description,Contact_for_Information_(Vacant),Contact Phone,Picture,Unit_ID,Details"
          s-column="Occupant" b-tableformat="TRUE" b-hashtml="FALSE"
          b-makelink="FALSE" clientside b-menuformat
          preview="<font size="-1"><<</font>Occupant<font size="-1">>></font>"
          local_preview="<font size="-1"><<</font>Occupant<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Occupant")%><!--webbot
          bot="DatabaseResultColumn" i-checksum="15483" endspan --></font></td>
        <td width="25%" bgcolor="<%=bgcolor%>"><font size="2"><!--webbot
          bot="DatabaseResultColumn" startspan
          s-columnnames="Tax_Parcel,Town ID,Property_Address,Property City,Property State,Property Zip,Street Level Square Feet,Total Building_Square_Feet,Lot Frontage,Lot Size,Date Purchased,Property_Owner,Owner Address,Owner City State Zip,Owner Phone,Occupant,Occupant Type,Occupant Phone,Occupancy Description,Contact_for_Information_(Vacant),Contact Phone,Picture,Unit_ID,Details"
          s-column="Property_Owner" b-tableformat="TRUE" b-hashtml="FALSE"
          b-makelink="FALSE" clientside b-menuformat
          preview="<font size="-1"><<</font>Property_Owner<font size="-1">>></font>"
          local_preview="<font size="-1"><<</font>Property_Owner<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Property_Owner")%><!--webbot
          bot="DatabaseResultColumn" i-checksum="40239" endspan --></font></td>
        <td width="15%" bgcolor="<%=bgcolor%>">
          <p align="center"><font size="2"><!--webbot bot="DatabaseResultColumn"
          startspan
          s-columnnames="Tax_Parcel,Town ID,Property_Address,Property City,Property State,Property Zip,Street Level Square Feet,Total Building_Square_Feet,Lot Frontage,Lot Size,Date Purchased,Property_Owner,Owner Address,Owner City State Zip,Owner Phone,Occupant,Occupant Type,Occupant Phone,Occupancy Description,Contact_for_Information_(Vacant),Contact Phone,Picture,Unit_ID,Details"
          s-column="Tax_Parcel" b-tableformat="TRUE" b-hashtml="FALSE"
          b-makelink="FALSE" clientside b-menuformat
          preview="<font size="-1"><<</font>Tax_Parcel<font size="-1">>></font>"
          local_preview="<font size="-1"><<</font>Tax_Parcel<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Tax_Parcel")%><!--webbot
          bot="DatabaseResultColumn" i-checksum="28379" endspan --></font></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>"
      local_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" i-checksum="3554" endspan -->
    </tbody>
  </table>
  </center>
</div>
<p align="center"><a href="#SortBy">Up to Sort By</a></p>

</body>

</html>



Spooky -> RE: DRW error all of a sudden (8/25/2004 16:12:34)

Try this, its modified with the diet, so keep a backup of your old page.
The SQL string was incomplete 

 <html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Property Listings</title>
<style fprolloverstyle>a:hover { color: #000080 }
</style>
</head>

<body link="#0000E1" vlink="#0000E1" alink="#0000E1">

<form botid="0" method="POST" action="property_listings_fr.asp">
<div align="center">
<center>
<table border="0" width="97%" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="192">  <a name="SortBy"></a> <select size="1" name="Sort">
<option>Sort By...</option>
<option value="Property_Address">Property_Address</option>
<option value="Occupant">Occupant</option>
<option value="Property_Owner">Property_Owner</option>
<option value="Tax_Parcel">Tax_Parcel</option>
</select> <input type="submit" value="Go" style="color: #FFFFFF; font-weight: bold; background-color: #008080"></td>
<td width="473">
<p align="right"><font color="#008080" style="font-size: 20pt">Property
Listings</font></td>
</tr>
</table>
</center>
</div>
</form>
<div align="center">
<center>
<table width="97%" border="0" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111" cellspacing="0">
<thead>
<tr>
<td bgcolor="#F2ECDB"> </td>
<td bgcolor="#F2ECDB"><b>Property_Address</b></td>
<td bgcolor="#F2ECDB"><b>Occupant</b></td>
<td bgcolor="#F2ECDB"><b>Property_Owner</b></td>
<td bgcolor="#F2ECDB">
<p align="center"><b>Tax_Parcel</b></td>
</tr>
</thead>
<tbody>
<!--#include file="../../../../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM [CBD Properties] WHERE ([Town ID] = 'FR') ORDER BY ::sort:: asc;"
fp_sDefault="Sort=Property_Address"
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Mainstreet"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Details"
fp_sMenuValue="Details"
fp_iDisplayCols=5
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../../_fpclass/fpdbrgn1.inc"-->

<tr>
<td width="7%" <%
dim x, bgcolor
if x = 1 then
bgcolor="#f7f3e8"
response.write "bgcolor='#f7f3e8'"
x=2
else
bgcolor="white"
response.write "bgcolor='white'"
x=1
end if %>>
<p align="center"><font size="1"><a href="../../../../details.asp?Town+ID='<%=FP_FieldURL(fp_rs,"Town ID")%>'"><%=FP_FieldVal(fp_rs,"Details")%></a></font></td>
<td width="25%" bgcolor="<%=bgcolor%>"><font size="2"><%=FP_FieldVal(fp_rs,"Property_Address")%></font></td>
<td width="28%" bgcolor="<%=bgcolor%>"><font size="2"><%=FP_FieldVal(fp_rs,"Occupant")%></font></td>
<td width="25%" bgcolor="<%=bgcolor%>"><font size="2"><%=FP_FieldVal(fp_rs,"Property_Owner")%></font></td>
<td width="15%" bgcolor="<%=bgcolor%>">
<p align="center"><font size="2"><%=FP_FieldVal(fp_rs,"Tax_Parcel")%></font></td>
</tr>
<!--#include file="../../../../_fpclass/fpdbrgn2.inc"-->

</tbody>
</table>
</center>
</div>
<p align="center"><a href="#SortBy">Up to Sort By</a></p>

</body>

</html>



Gregg -> RE: DRW error all of a sudden (8/26/2004 7:52:25)

Spooky,

I replaced the code and it generates the following:

Unable to find operator in query string. Query string currently is SELECT * FROM [CBD Properties] WHERE ([Town ID] = 'FR') ORDER BY ::sort:: asc;
One or more form fields were empty. You should provide default values for all form fields that are used in the query.

Any ideas or clues?..........sorry to be such a pain



Page: [1] 2   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375