Can some one please help me

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to duplicate a repair search like the one found at the link below:
http://www.netbags.com/warranty.asp?mscssid=VRBB7G12FQ399HH6XWHWHHE1DRG6DGM8

I already got some hints but the truth is I'm new at using frontpage and I'm just getting lost. Can someone please tell me what I need inorder to make this repair search form work on frontpage?
Thank you.

If neccessary I can create the database using Access. But I need a way of having my customers search for their repairs.
 
Hi....

To duplicate this functionality you are going to HAVE too use some type of
database. Access is ok for starters but it has some limits as to the number
of concurrent connections. (the number of people that can access... access
tables.... at the same time... and this is not a trivial issue with a web
application)

I posted a decent little link here a few days ago that gives some learning
material on relational database work. It uses MySql but that principles are
the same. If you have never done any database work... this might be a good
place to start. ( I think the thread was.... OT Learning Database... or
something close to that)

The built in Database tools can get you started but they have limits so you
may also have to get into a scripting language to accomplish some tasks.

The most important thing, however, will be to learn good database design...
learn some basic SQL... and THEN get into the implementation. This "upfront"
work will save you hours of headaches later on. "TRUST ME" on this. < vbg >

Also.... if this is an immediate need..... look for a consultant in your
area where you live and help him make a living.

Best to you......
Tom Gahagan
eThomaston.com

EGarcia said:
I'm trying to duplicate a repair search like the one found at the link below:
http://www.netbags.com/warranty.asp?mscssid=VRBB7G12FQ399HH6XWHWHHE1DRG6DGM8

I already got some hints but the truth is I'm new at using frontpage and
Click to expand...
I'm just getting lost. Can someone please tell me what I need inorder to
make this repair search form work on frontpage?
Thank you.

If neccessary I can create the database using Access. But I need a way of
Click to expand...
having my customers search for their repairs.
 
Access can handle approximately 255 +/- simultaneous users.

or another way to look at this

Access can handle 6000 +/- users per hour.

So in most cases Access is all that is needed by most small web sites,
however a lot depends on the site design, the database structure and how the
data is being used or accessed within the site.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Kathleen.....

Of course, I was using the generic "him" for all mankind and not just for
the male gender. < vbg >

Best to you.....
Tom Gahagan
 
Hi Thomas.....

No argument out of me... Not knowing the size of the fellows site I figured
I might give a general warning about some of it's limits. I have used Access
files for a number of situations and found it to be fine...... and will use
it again in the future.
Access can handle approximately 255 +/- simultaneous users.

or another way to look at this

Access can handle 6000 +/- users per hour.
Click to expand...

True..... but at these peek levels.... there ARE performance issues.
So in most cases Access is all that is needed by most small web sites,
however a lot depends on the site design, the database structure and how the
data is being used or accessed within the site.
Click to expand...
Absolutely!!!!
Database design and structure is where most folks at this level make
mistakes. I always try and lead newer folks in the direction of learning
design - normalization and good SQL before they learn a particular
product.
I also think that there are good alternatives... ie... MySql that are
worth a look... even for beginners. Anyway.... just my opinion with is
probably worth about .02 ! < vbg >

Best to you....
Tom Gahagan

ps.... being an old Foxpro hound I sure wise more web hosting sites would
support it. Foxpro is MS's best kept database secret. :)
 
No argument here either, just that Access if easier for most to work with
since you work with it locally.

BTW: The 6,000 +/- users I quote was not a limitation, but the total number
of users that hit one of my client's web site in a 1 hour period. There were
no known performance issues during that time period with the site.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
No argument here either, just that Access if easier for most to work with
since you work with it locally.
Click to expand...
That's cool..... and you are way right.. Access has always had every other
database product by the.... well you know....... when it comes to ease of
use. As I confessed in my last post.... I'm a FoxPro head from way back so I
have a built in bias! said:
BTW: The 6,000 +/- users I quote was not a limitation, but the total number
of users that hit one of my client's web site in a 1 hour period. There were
no known performance issues during that time period with the site.
Click to expand...

Well that is about the best that I have ever heard of! I guess I had better
update my opinion of the mdf file! :)

Tom Gahagan
 
Back
Top