Searching Database results not working...

[Mr. Know Nothing]

I have a database and i'm showing all items in a table on my web page. (that
works and i have no problem) Now i'm trying to have a text box and search the
table with the text box input but i always get the following error:

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

Now the page was working before when i was running the webpage on a XP Pro
system and then i moved everything to a server running Win Server 2003
enterprise edition. Now i get the error everytime on all my pages except for
one that i haven't changed since the change in servers.

Does this problem make sense?? Does anyone have any idea how i can fix this??
Thanks in advance to all.

 

[Kathleen Anderson [MVP - FrontPage]]

The FP2003 code has changed slightly. To see the true error, open the hidden
folder /_fpclass/ and edit the fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Mr. Know Nothing]

I have changed the debug value to see the true error and i get the following:
Database Results Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

Know i have read the article but it says to change my asp page to asp.net. I
get lost at 3a) when it ask to click on ASP.NET, as i do not have that option
to click. I am running FP 2002 (10.2623.2625)

Do i really have to convert my pages to asp.net?

 

[Kathleen Anderson [MVP - FrontPage]]

That article has two parts - you need to do what's listed in the second
part:

1. Insert a new ASP page.
2. Insert a Database Results Wizard for the same database, and make
sure that you select all the fields.
3. Switch to Code View.
4. Locate the following section of code.
<!--webbot bot="DatabaseRegionStart"
5. Copy the values of the s-columnnames attribute and the
s-columntypes attribute.
6. Open the failing ASP page.
7. On the View menu, click Page, and then click Code at the bottom of
the document window.
8. Locate the following section of code.
<!--webbot bot="DatabaseRegionStart"

9. Update the s-columnnames value to include all field names as in the
following example.
s-columnnames="Expr1000,EmployeeID,FirstName"
10. Update the s-columntypes value to include all field types as in
the following example.
s-columntypes="3,3,202"
11. At the bottom of the document window, click Design. This will
force the update of the section of ASP code generated by the Webbot.
Note If you run the Database Results Wizard on the region again, you will
lose all your changes and you must repeat these steps.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Mr. Know Nothing]

I have followed those steps even if the values i was changing were the exact
same.
I changed the entire line and now i get the following error:

Active Server Pages error 'ASP 0126'
Include file not found
/test/CanadaDealers.asp, line 62
The include file 'fpweb:///_fpclass/fpdblib.inc' was not found.

I have a feeling it's to do with the file path but i'm not sure what it's
suppose to be.

Do you have any other suggestion?
Thanks for the help up to now.

 

[Mr. Know Nothing]

After trying many different things i have gone to the point that the asp page
does work but it seem like if it doesn't like to use the search. At this
point i am getting the following error:

Database Results Error
Description: Syntax error (missing operator) in query expression 'Province =
Nova Scotia'.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

and the code is:

<!--webbot bot="DatabaseRegionStart"
s-columnnames="BuyingGroup,DealerNum,StoreName,FirstName,LastName,MaillingAddress,City,Province,PotalCode,StreetAddress,PhoneNum,TollFree,FaxNum,Email"
s-columntypes="202,202,202,202,202,202,202,202,202,202,202,202,202,202"
s-dataconnection="CanadaDealers" 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="BuyingGroup,DealerNum,StoreName,FirstName,LastName,MaillingAddress,City,Province,PotalCode,StreetAddress,PhoneNum,TollFree,FaxNum,Email"
s-criteria s-order s-sql="SELECT * FROM Dealer where Province = ::T1::"
b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="T1="
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>" 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 Dealer where Province = ::T1::"
fp_sDefault="T1="
fp_sNoRecords="<tr><td colspan=14 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="CanadaDealers"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=14
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

Do you have any idea why it doesn't like it when i try to use the form "T1"?

 

[Mr. Know Nothing]

I have stumbled apon the answer to my problem. When entering the value in the
form I must include the single quotes. This is a suprise to me as I did not
need them on when I was running the site on my XP machine.

Thanks anyways.