Database Results Wizard Error Solution

M

Mark Constant

I have Frontpage 2003 and I am editing a page that is located on an
IIS box with Windows 2000 installed. I want to create a search page
using the results wizard in Frontpage 2003. So I ran the wizard and
linked it to the database. I Also add the search form using the
wizard. Yet once I get done the wizard I get "Database Results Wizard
Error" I have read the Knowledge database and other solutions but it
still doesn't work. Here is part of my code that should be relavent. I
am using ASP not ASP.NET by the way. Also my exact steps where this.
1. Go to results wizard
2. Make the connection to phonelist by choosing "Use existing
database"
3. For a record source I choose All Numbers
4. Click edit list and remove location, type, and title
5. Click more options. Click criteria and add Name for a search field
6. Use Table - One record per row on drop down menu
7. Click add search form

<%
fp_sQry="SELECT * FROM ""All Numbers"" WHERE (Name = '::Name::')"
fp_sDefault="Name="
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="phonelist_connection"
fp_iMaxRecords=10
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&Ext=202&Location=202&Title=202&Type=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
 
K

Kathleen Anderson [MVP - FP]

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
 
M

Mark Constant

I changed the line in the file and here is what I get for an error


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

So it basically looks like the Syntax created from Frontpage is wrong.
From what I am reading in different posts is that I need to change ""
to []. But I don't know exactly where to do that. Thanks for any help.
 
K

Kathleen Anderson [MVP - FP]

I would try putting brackets around All Numbers, [All Numbers]

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


Mark Constant said:
I changed the line in the file and here is what I get for an error


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

So it basically looks like the Syntax created from Frontpage is wrong.
From what I am reading in different posts is that I need to change ""
to []. But I don't know exactly where to do that. Thanks for any help.

Kathleen Anderson said:
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
http://www.spiderwebwoman.com/resources/
Click to expand...
Click to expand...
 
M

Mark Constant

I followed your advice and it works. Thank you. But I have one more
question.
Right now under the input textbox you have to type it exactly like
Constant, Mark. How do I change the SQL so all the person has to do is
type in something like Co or Const if they don't remember my whole
name and it returns everybody that lasts name starts with Co or Const.
I think it would be changing a command to LIKE in the sequel statement
but I am not exactly sure how to do it. Below are two places I would
think would need to be edited.

<%
fp_sQry="SELECT * FROM [All Numbers] WHERE (Name = '::Name::')"
fp_sDefault="Name=NULL"
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="phonelist_connection"
fp_iMaxRecords=5
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&Ext=202&Location=202&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

s-criteria="[Name] EQ {Name} +" s-order s-sql="SELECT * FROM [All
Numbers] WHERE (Name = '::Name::')"


Kathleen Anderson said:
I would try putting brackets around All Numbers, [All Numbers]

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


Mark Constant said:
I changed the line in the file and here is what I get for an error


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

So it basically looks like the Syntax created from Frontpage is wrong.
From what I am reading in different posts is that I need to change ""
to []. But I don't know exactly where to do that. Thanks for any help.

Kathleen Anderson said:
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
http://www.spiderwebwoman.com/resources/


I have Frontpage 2003 and I am editing a page that is located on an
IIS box with Windows 2000 installed. I want to create a search page
using the results wizard in Frontpage 2003. So I ran the wizard and
linked it to the database. I Also add the search form using the
wizard. Yet once I get done the wizard I get "Database Results
Wizard Error" I have read the Knowledge database and other
solutions but it still doesn't work. Here is part of my code that
should be relavent. I am using ASP not ASP.NET by the way. Also my
exact steps where this.
1. Go to results wizard
2. Make the connection to phonelist by choosing "Use existing
database"
3. For a record source I choose All Numbers
4. Click edit list and remove location, type, and title
5. Click more options. Click criteria and add Name for a search
field
6. Use Table - One record per row on drop down menu
7. Click add search form

<%
fp_sQry="SELECT * FROM ""All Numbers"" WHERE (Name = '::Name::')"
fp_sDefault="Name="
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="phonelist_connection"
fp_iMaxRecords=10
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&Ext=202&Location=202&Title=202&Type=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
Click to expand...
Click to expand...
Click to expand...
 
K

Kathleen Anderson [MVP - FrontPage]

Mark:
You'd probably want to use "Begins With":

example:
SELECT * FROM Categories WHERE (CategoryName LIKE '::CategoryName::%')

from: FP: SQL Syntax Generated by the FrontPage Database Results Wizard
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430

In HTML/Code view, make the change to the gray-colored code only, save your
change, and it will replicate to the maroon colored code.

--

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



Mark Constant said:
I followed your advice and it works. Thank you. But I have one more
question.
Right now under the input textbox you have to type it exactly like
Constant, Mark. How do I change the SQL so all the person has to do is
type in something like Co or Const if they don't remember my whole
name and it returns everybody that lasts name starts with Co or Const.
I think it would be changing a command to LIKE in the sequel statement
but I am not exactly sure how to do it. Below are two places I would
think would need to be edited.

<%
fp_sQry="SELECT * FROM [All Numbers] WHERE (Name = '::Name::')"
fp_sDefault="Name=NULL"
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="phonelist_connection"
fp_iMaxRecords=5
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&Ext=202&Location=202&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

s-criteria="[Name] EQ {Name} +" s-order s-sql="SELECT * FROM [All
Numbers] WHERE (Name = '::Name::')"


Kathleen Anderson said:
I would try putting brackets around All Numbers, [All Numbers]

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


Mark Constant said:
I changed the line in the file and here is what I get for an error


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

So it basically looks like the Syntax created from Frontpage is
wrong.
From what I am reading in different posts is that I need to change
""
to []. But I don't know exactly where to do that. Thanks for any
help.

message 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
http://www.spiderwebwoman.com/resources/


I have Frontpage 2003 and I am editing a page that is located on
an
IIS box with Windows 2000 installed. I want to create a search
page
using the results wizard in Frontpage 2003. So I ran the wizard
and
linked it to the database. I Also add the search form using the
wizard. Yet once I get done the wizard I get "Database Results
Wizard Error" I have read the Knowledge database and other
solutions but it still doesn't work. Here is part of my code that
should be relavent. I am using ASP not ASP.NET by the way. Also my
exact steps where this.
1. Go to results wizard
2. Make the connection to phonelist by choosing "Use existing
database"
3. For a record source I choose All Numbers
4. Click edit list and remove location, type, and title
5. Click more options. Click criteria and add Name for a search
field
6. Use Table - One record per row on drop down menu
7. Click add search form

<%
fp_sQry="SELECT * FROM ""All Numbers"" WHERE (Name = '::Name::')"
fp_sDefault="Name="
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="phonelist_connection"
fp_iMaxRecords=10
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&Ext=202&Location=202&Title=202&Type=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

updating error 1
editing database with results wizard 1
Querying a database between two values? 5
editing database with frontpage 1
Database Results 7
Filtering database results 15
Database Results 1
Numeric Formatting 3

Top