navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
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

Search Forums
 

Advanced search
Recent Posts

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

 

DRW error all of a sudden

 
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 and Database >> DRW error all of a sudden 		Page: [1] 2   next >   >>
 
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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

 

Posts: 223
Joined: 6/8/2004
Status: offline

  		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

(in reply to Gregg)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		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.

_____________________________

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 Aelaron)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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

(in reply to BeTheBall)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

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

< Message edited by Gregg -- 8/24/2004 11:48:01 >

(in reply to Gregg)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		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.

_____________________________

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

 

Posts: 19
Joined: 1/20/2003
Status: offline

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

(in reply to BeTheBall)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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

(in reply to Gregg)
Aelaron

 

Posts: 223
Joined: 6/8/2004
Status: offline

  		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

(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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

(in reply to Aelaron)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

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

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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?

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

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

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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.

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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"

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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"

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: DRW error all of a sudden - 8/25/2004 15:54:08   
Post the full pages code?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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>


< Message edited by Spooky -- 8/25/2004 16:22:07 >

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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>


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Gregg)
Gregg

 

Posts: 19
Joined: 1/20/2003
Status: offline

  		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

(in reply to Gregg)
Page:   [1] 2   next >   >>

All Forums >> Web Development >> ASP and Database >> DRW error all of a sudden 		Page: [1] 2   next >   >>
Jump to: 1





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


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.