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

 

Database Results Error - Help!

 
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 >> Database Results Error - Help! 		Page: [1]
 
spcafc

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		Database Results Error - Help! - 6/12/2004 11:47:20   
Well I am here again with yet another asp question.

I am trying to set up a database results with search. I can get the sample database info to set up right but not my own. I've imported the real db but get that awful
Database Results Error
The operation failed. If this continues, please contact your server administrator.

I've verified the database and it's there.

My global.asa file was reloaded and that's there too.

Not sure what is not working. Which code should I post - global or the asp?

Thanks!

Rebecca
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/12/2004 12:40:46   
First step is to follow the instructions in the very first post of this thread:

http://www.frontpagewebmaster.com/m-175524/tm.htm

By doing that, you will get a more descriptive error message. Then post the code for the ASP page along with the error message.

_____________________________

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

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/15/2004 17:54:01   
This is the error I now get. Have no idea what it means. What do I do now?

Thanks!

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

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

(in reply to BeTheBall)
Spooky

 

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

  		RE: Database Results Error - Help! - 6/15/2004 17:58:27   
What does your query clause look like?
Itll be the line fp_sQry = "....." in the code.

_____________________________

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

§þ:)k¥


(in reply to spcafc)
spcafc

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/16/2004 7:32:52   
fp_sQry = FP_ReplaceQuoteChars(fp_sQry)

(in reply to Spooky)
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/16/2004 8:50:34   
That doesn't look right. Better post the code for the whole page.

_____________________________

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

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/16/2004 13:58:03    
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' 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">
<title>OrganizationName</title>
<meta name="Microsoft Theme" content="copy-of-watermark 011, default">
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="databasesearch.asp">
  <table BORDER="0">
    <tr>
      <td><b>OrganizationName</b></td>
      <td>
      <input TYPE="TEXT" NAME="OrganizationName" VALUE="<%=Server.HtmlEncode(Request("OrganizationName"))%>" size="20"></td>
    </tr>
  </table>
  <p><br>
  <input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --></p>
  <p> </p>
</form>
<table width="100%" border="1">
  <thead>
    <tr>
      <td><b>County</b></td>
      <td><b>OrganizationName</b></td>
      <td><b>Mailing Address</b></td>
      <td><b>Mailing address2</b></td>
      <td><b>City</b></td>
      <td><b>State</b></td>
      <td><b>PostalCode</b></td>
      <td><b>Physical Address</b></td>
      <td><b>Physical Address2</b></td>
      <td><b>Physical City</b></td>
      <td><b>Physical State</b></td>
      <td><b>Physical Zip</b></td>
      <td><b>Phone</b></td>
      <td><b>FaxNumber</b></td>
      <td><b>EmailAddress</b></td>
      <td><b>Website</b></td>
    </tr>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203" s-dataconnection="Database1" 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="Mailing List" s-displaycolumns="County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-criteria="[OrganizationName] CNT {OrganizationName} +" s-order s-sql="SELECT * FROM "Mailing List" WHERE (OrganizationName LIKE '%::OrganizationName::%')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="OrganizationName=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" 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>" startspan --><!--#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 ""Mailing List"" WHERE (OrganizationName LIKE '%::OrganizationName::%')"
fp_sDefault="OrganizationName="
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Mailing ListID=3&Proof?=202&County=202&OrganizationName=202&Mailing Address=202&Mailing address2=202&City=202&State=202&PostalCode=202&Physical Address=202&Physical Address2=202&Physical City=202&Physical State=202&Physical Zip=202&Phone=202&FaxNumber=202&EmailAddress=202&Website=203&"
fp_iDisplayCols=16
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48234" --><tr>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="County" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>County<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"County")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15566" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="OrganizationName" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>OrganizationName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"OrganizationName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="44266" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Mailing Address" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Mailing Address<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Mailing Address")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33740" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Mailing address2" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Mailing address2<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Mailing address2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36463" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="City" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>City<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"City")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4267" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="State" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>State<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"State")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="10114" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="PostalCode" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PostalCode<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PostalCode")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28780" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Physical Address" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Physical Address<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Physical Address")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33181" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Physical Address2" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Physical Address2<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Physical Address2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33511" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Physical City" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Physical City<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Physical City")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="25669" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Physical State" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Physical State<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Physical State")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34558" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Physical Zip" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Physical Zip<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Physical Zip")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="25081" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Phone" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Phone<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Phone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8388" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="FaxNumber" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>FaxNumber<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"FaxNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="18464" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="EmailAddress" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>EmailAddress<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"EmailAddress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31177" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="Mailing ListID,Proof?,County,OrganizationName,Mailing Address,Mailing address2,City,State,PostalCode,Physical Address,Physical Address2,Physical City,Physical State,Physical Zip,Phone,FaxNumber,EmailAddress,Website" s-column="Website" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Website<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Website")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13439" --></td>
    </tr>
    <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" 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><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/5]</NOBR><BR></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table></body>

</html>


< Message edited by Spooky -- 6/16/2004 15:55:01 >

(in reply to BeTheBall)
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/16/2004 14:09:38   
fp_sQry="SELECT * FROM ""Mailing List"" WHERE (OrganizationName LIKE '%::OrganizationName::%')"

Seems to be a common theme lately. Spaces in table/field names cause problems. Try renaming your db table without a space in the name. The create the database results region again and see if that remedies the problem. If for some reason you cannot change the table name, apply the Spooky Diet referenced in my signature below and then chang the SQL to:

fp_sQry="SELECT * FROM [Mailing List] WHERE (OrganizationName LIKE '%::OrganizationName::%')"

_____________________________

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

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/17/2004 8:57:28   
Ok did the diet as I can't change the table name. Published the corrected page and this is the error I get now.

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FP_SetLocaleForPage'

/_fpclass/fpdbrgn1.inc, line 3

(in reply to BeTheBall)
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/17/2004 9:57:17   
That almost looks like you dieted too much. Can you post the code as it now stands.

_____________________________

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

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/17/2004 11:29:45   
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>OrganizationName</title>
<meta name="Microsoft Theme" content="copy-of-watermark 011, default">
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="databasesearch.asp">
<table BORDER="0">
<tr>
<td><b>OrganizationName</b></td>
<td>
<input TYPE="TEXT" NAME="OrganizationName" VALUE="<%=Server.HtmlEncode(Request("OrganizationName"))%>" size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --></p>
<p> </p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>County</b></td>
<td><b>OrganizationName</b></td>
<td><b>Mailing Address</b></td>
<td><b>Mailing address2</b></td>
<td><b>City</b></td>
<td><b>State</b></td>
<td><b>PostalCode</b></td>
<td><b>Physical Address</b></td>
<td><b>Physical Address2</b></td>
<td><b>Physical City</b></td>
<td><b>Physical State</b></td>
<td><b>Physical Zip</b></td>
<td><b>Phone</b></td>
<td><b>FaxNumber</b></td>
<td><b>EmailAddress</b></td>
<td><b>Website</b></td>
</tr>
</thead>
<tbody>
<% 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 ""Mailing List"" WHERE (OrganizationName LIKE '%::OrganizationName::%')"
fp_sDefault="OrganizationName="
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Mailing ListID=3&Proof?=202&County=202&OrganizationName=202&Mailing Address=202&Mailing address2=202&City=202&State=202&PostalCode=202&Physical Address=202&Physical Address2=202&Physical City=202&Physical State=202&Physical Zip=202&Phone=202&FaxNumber=202&EmailAddress=202&Website=203&"
fp_iDisplayCols=16
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<tr>
<td>
<%=FP_FieldVal(fp_rs,"County")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"OrganizationName")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Mailing Address")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Mailing address2")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"City")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"State")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"PostalCode")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Physical Address")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Physical Address2")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Physical City")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Physical State")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Physical Zip")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Phone")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"FaxNumber")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"EmailAddress")%>  </td>
<td>
<%=FP_FieldVal(fp_rs,"Website")%>  </td>
</tr>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</tbody>
</table></body>

</html>

(in reply to BeTheBall)
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/17/2004 11:52:49   
You deleted one of the include files.

Just above this block of code:

<%
fp_sQry="SELECT * FROM ""Mailing List"" WHERE (OrganizationName LIKE '%::OrganizationName::%')"
fp_sDefault="OrganizationName="
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Mailing ListID=3&Proof?=202&County=202&OrganizationName=202&Mailing Address=202&Mailing address2=202&City=202&State=202&PostalCode=202&Physical Address=202&Physical Address2=202&Physical City=202&Physical State=202&Physical Zip=202&Phone=202&FaxNumber=202&EmailAddress=202&Website=203&"
fp_iDisplayCols=16
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

Insert this:

<!--#include file="_fpclass/fpdblib.inc"-->

_____________________________

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

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/17/2004 12:50:01   
Now I get this:

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

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

(in reply to BeTheBall)
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/17/2004 13:03:03   
You did the diet, but didn't bracket the table name. Change the SQL to:

fp_sQry="SELECT * FROM [Mailing List] WHERE (OrganizationName LIKE '%::OrganizationName::%')"

_____________________________

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 spcafc)
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/17/2004 13:23:54   
So when you added the brackets the error went away? Terrific! I can fix the problem with all the results showing. You just need one more edit.

Change this line:

fp_sDefault="OrganizationName="

to

fp_sDefault="OrganizationName=xxxyyyzzz"

What that does is assign a default value for the search form so when the page loads it only returns records that contain xxxyyyzzz.

< Message edited by betheball -- 6/17/2004 13:26:02 >

_____________________________

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

 

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

  		RE: Database Results Error - Help! - 6/17/2004 13:27:15   
I edited the above to correct a misstatement. You need the brackets, not the double set of double quotes. Then by editing the fp_sDefault line you should be in business.

_____________________________

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 BeTheBall)
spcafc

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/17/2004 13:30:50   
That helped!

Now in order for the searcher to be able to edit their entry do I need to use the DIW? And if I do how do I limit it to only allowing them to edit their own and not other entries?

(in reply to BeTheBall)
BeTheBall

 

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

  		RE: Database Results Error - Help! - 6/17/2004 14:17:22   
Now you have entered into a different world! I still use FP 2000 so don't have any experience with the DIW. My first question to you would be is there a way to tie the record in the db to the user? Meaning, are you using some sort of login system so that your application can identify a particular user? If not, I do not see how you could do what you propose.

For example, if you have a login system with each user having a username and you record the username in the db with the record, then you have a way to tie them together so only the user with that username can edit the record.

Make sense?

_____________________________

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

 

Posts: 69
Joined: 5/11/2004
Status: offline

  		RE: Database Results Error - Help! - 6/17/2004 14:30:16   
Yes it does. I can see where FP 2000 didn't have that ability. I'll see what the MS Help file has. I am not sure I really want to go that route at this time but I think it will become necessary in the next few months.

Thanks so much for the help!

(in reply to BeTheBall)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Database Results Error - Help! 		Page: [1]
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.