Nothing w/ my database works

G

Guest

Hi, it's me again. Wish I could figure this out on my own, but I need you
guys. I've switched to a windows server that's running extensions, and
supports asp. I've connected my database to my FP2003 site, but the search
results never work. I think i read that you cant have .asp when you're
running on extensions, and if thats so, how do you search a database?? I've
even tried switching the pages to .html but it didnt do any good. All I want
to do is allow users to search for products. I made a search page, a form
page, and a details page... but I keep getting an error message, and when I
try a search it takes me to this page:
http://www.thomsonequipment.com/_derived/nortbots.htm
Please help, I'm dieing here.
 
A

Andrew Murray

Yes you need *.asp extensions for the pages. Running ASP and the server
extensions is OK.
 
A

Andrew Murray

It is true, when you use for example the form handler in Frontpage, it
reqires the page have a *.htm extension to use the server extensions to send
the email, but your situation is a different issue.

Your page must have an ASP extension since it is using ASP to write to the
database.
 
G

Guest

OK, thats what I thought. I connected my database by Importing the file. I
can verify a connection through Tools|site settings|Database, and it all
looks good in frontpage. But only errors appear when I try to use it on the
web. I've only used the databse results wizard, is there a step I'm missing?
I really appreciate the quick response.
 
G

Guest

Also, in fpdbrgn1.inc I switched fp_DEBUG=False, to fp_DEBUG=True, and now my
error message is this:
Database Results Wizard Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
 
G

Guest

Hi Kathleen, I hope this is what you're looking for:
fp_sQry="SELECT * FROM ""Masterfile Listing"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=8 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="EquipandAttach"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Stock
#=202&Description=202&Price=6&Category=202&Manufacturer=202&Model=202&Year=202&Photo=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
 
K

Kathleen Anderson [MVP - FrontPage]

Yes, that's what I was looking for :) I see 2 problems - the spaces in
the table name - either change it or enclose it in brackets [ ] and the
use of the field name Year which is a reserved word - you need to change
that as well.

--

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

Andrew Murray

Can you give an example link to the page?

Have you done the results wizard thoroughly?

Did you publish the Access db, the asp page and the global asa file (the
global.asa contains the db connection information).
 
G

Guest

I tried to change these problems in code view but when saving I get the
message "The contents of a Frontpage component have been modified, these
contents will be over written when you save this page." and of course, the
only option is to hit "ok" I guess this means that I need to go to the
actual database, make the changes, and then do all of the details, form, and
search pages over (?) Does that sound right to you? Thats what I'll try.

Kathleen Anderson said:
Yes, that's what I was looking for :) I see 2 problems - the spaces in
the table name - either change it or enclose it in brackets [ ] and the
use of the field name Year which is a reserved word - you need to change
that as well.

--

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


Alittleconfused said:
Hi Kathleen, I hope this is what you're looking for:
fp_sQry="SELECT * FROM ""Masterfile Listing"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=8 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="EquipandAttach"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Stock
#=202&Description=202&Price=6&Category=202&Manufacturer=202&Model=202&Year=202&Photo=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
Click to expand...
Click to expand...
 
K

Kathleen Anderson [MVP - FrontPage]

If it were just the table name, you could probably enclose it in the
brackets in your SQL and that would fix the problem. But, because you have
to change a field name in your database, Yes, you do need to change the
database, reimport it into your web and rerun the wizard.

--

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


Alittleconfused said:
I tried to change these problems in code view but when saving I get the
message "The contents of a Frontpage component have been modified, these
contents will be over written when you save this page." and of course, the
only option is to hit "ok" I guess this means that I need to go to the
actual database, make the changes, and then do all of the details, form,
and
search pages over (?) Does that sound right to you? Thats what I'll try.

Kathleen Anderson said:
Yes, that's what I was looking for :) I see 2 problems - the spaces
in
the table name - either change it or enclose it in brackets [ ] and
the
use of the field name Year which is a reserved word - you need to change
that as well.

--

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


Alittleconfused said:
Hi Kathleen, I hope this is what you're looking for:
fp_sQry="SELECT * FROM ""Masterfile Listing"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=8 align=""LEFT"" width=""100%"">No
records
returned.</td></tr>"
fp_sDataConn="EquipandAttach"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Stock
#=202&Description=202&Price=6&Category=202&Manufacturer=202&Model=202&Year=202&Photo=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID


:

Can you post your SQL statement?

--

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


message Also, in fpdbrgn1.inc I switched fp_DEBUG=False, to fp_DEBUG=True,
and
now
my
error message is this:
Database Results Wizard Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

Here's a link to the web page. The search hyperlink is slightly hidden at
this point, beneath the main menu buttons:
http://www.thomsonequipment.com/Equipment page.htm
Now, instead of an error message, I get a "no records returned" message.
This has to be an improvement right?!! I think we're getting closer! Should I
go to that spiderwebwoman designs site, and try to find a solution to a no
records returned issue? Oh, And as a side note, the global.asa file doesnt
seem to ever have been created for this particular search. I tried to make a
previous search form for another inventory list, and a global.asa was created
for that, but not for my current one. Is there only one global.asa file
created for a site? What should I do about that?
 
G

Guest

OK, the search is returning results, but it seems it's kind of random. For
instance, I searched "bucket" and got all the buckets listed. Then I searched
"forks" and got forks. But now, when I try to search for "buckets" again it
says there are no records. As well, not all of my database is coming up. Like
"excavators" and "compactors" return no records, but they're just as much a
part of my database as anything else. And I checked the table, it's
displaying "MasterfileListing" like I wanted, so that didnt switch on me. I
dont understand why some things would come up and others won't, and why the
things that do come up only appear when they feel like it. haha, this is just
comical now :O)
 
G

Guest

Alright, forget all that stuff I said earlier, it seems to be working fine
now. The only issue I have left (at this point) is that the occassional hit
that comes up in any given search has a page to go along with it, but the
hits dont come up as links. Like, if you search for excavators, a few will be
listed, and some of those pieces of equipment have detail pages with pictures
and info, but there's no way to access those details through the search hits.
How would I go about attaching a link? Is it possible to go back into the
access database and attach a link through there, by copying and pasting the
address of either the local or remote url?
 

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

Database Results Error 8
search 9
Submitting Query 1
ftp versus http 1
Run-time error? form submit error 1
FP Search Not Working 6
Form Mailer - GoDaddy Hosting (Shared Wiondows server) 11
Discussion Web Site issue 4

Top