no results

	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

Recent Posts

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

no results

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 >> no results

Page: [1]


Misty Posts: 4 From: Ramona, Ok, USA Status: offline	no results - 4/1/2001 21:34:00 I am a newbie to frontpage. I have made a database in access (my first feat in access as well...). I want to make a page that can search that database. what I came up with so far is this http://ramonaalumni.netfirms.com/class.asp the only problem is when I go to search I get no results. It does the same thing in preview too. I don't know what's wrong and I've been messing with it for a long time now. I went through the FAQs and did what it said exactly, no results then either. Of course Frontpage's help files were absolutely no help. Can anyone help? I'm sure it's something fairly simple that I'm missing too but I am failing to see it.


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: no results - 4/2/2001 19:59:00 Can you confirm your server is NT and not Unix? (in reply to Misty)


hzarabet Posts: 1540 From: New Milford CT USA Status: offline	RE: no results - 4/2/2001 20:19:00 Do you have all your defaults set or are they blank. Fill in your defaults with a word that would never come up. ------------------ www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada (in reply to Misty)

Misty

Posts: 4
From: Ramona, Ok, USA
Status: offline

RE: no results - 4/2/2001 20:37:00

I tried to check on the NT thing but their web page didn't say anything about it in the FAQs. Any clue how I could find out ?

Defaults meaning what ?

I looked in the html and saw this. I'm not sure but is this where you're talking about ?

s-sql="SELECT * FROM RamonaAlumni.mdb WHERE ("Class of" = ::Class_of:: AND "Last Name" = '::Last_Name::' AND "First Name" = '::First_Name::' AND "Middle Name" = '::Middle_Name::' AND Deceased = : :Deceased:: AND Remarks = '::Remarks::')"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="Class_of=&Last_Name=&First_Name=&Middle_Name=&Deceased=&Remarks="
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="0"

I also found this:

fp_sQry="SELECT * FROM RamonaAlumni.mdb WHERE (""Class of"" = ::Class_of:: AND ""Last Name"" = '::Last_Name::' AND ""First Name"" = '::First_Name::' AND ""Middle Name"" = '::Middle_Name::' AND Deceased = : :Deceased:: AND Remarks = '::Remarks::')"
fp_sDefault="Class_of=&Last_Name=&First_Name=&Middle_Name=&Deceased=&Remarks="
fp_sNoRecords="No records returned."

[This message has been edited by Misty (edited 04-02-2001).]

(in reply to Misty)


Misty Posts: 4 From: Ramona, Ok, USA Status: offline	RE: no results - 4/4/2001 16:25:00 okay, that server is on unix, I finally got an email back from them. I have a few other accounts on other servers that I'm still waiting on responses from. (in reply to Misty)

hzarabet

Posts: 1540
From: New Milford CT USA
Status: offline

RE: no results - 4/4/2001 16:43:00

By defaults I mean this line:

DefaultFields="Class_of=&Last_Name=&First_Name=&Middle_Name=&Deceased=&Remarks="

In Step 3 I believe" More Options" there is a place to insert defaults. I would enter defualt words that would never come up.

Spooky would be able to say this much better than I can, but I know the problem you are describing is similar to what I was having.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

(in reply to Misty)


Misty Posts: 4 From: Ramona, Ok, USA Status: offline	RE: no results - 4/8/2001 20:01:00 Well guys I thank you for all of your help even though I finally gave up on the asp file. I found a way to convert the database to a flatline format and then I used a cgi script. Thanks again for trying, I just kept getting no where and decided to try another option. (in reply to Misty)