Can be done w/o a subweb using 1 DB w/ 3 price fields (public, wholesaler, contractor)
Your server side code determines what the login status is and then displays the correct price from the db
Can be done w/ PHP, but as Rob points out you will probably need to use a mySQl db as I suspect your host is not on a Windows Server
(required for ASP and Access)
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| That would be a tremendous help if I could. We have the products and rates in
| Excel so it would be pretty easy to transfer it into Access. I talked to my
| ISP today and he said something about using a coupon code but I don't know if
| I like that approach. He also said that there server would support PHP, I
| think, but not ASP. I'll have to read up on that to see how that affects
| everything. The hard part about all this is where do you start. Build the
| database first then begin to build the log in and the sub site. Anyway,
| thanks for the suggestions.
|
| "Rob Giordano (Crash)" wrote:
|
| > I bet you can do it with one db and one subweb with the password somehow
| > pulling different pricing from different tables.
| >
| >
| >
| >
| > | > | David:
| > |
| > | Thanks for all the helpful links to creating this. Our ISP has Front Page
| > | extensions but I've asked them about sub webs and ASP support, etc. If
| > they
| > | do then would there be two separate subsites that would access two
| > different
| > | databases with unique prices based on their password access?
| > |
| > | Here's how I would like it to work:
| > |
| > | 1. Wholeseller X logs in with universal password which takes him to either
| > | an order form that uses an Access file for rates specific to this
| > password.
| > |
| > | 2. Contractor X logs in with the contractor universal password which
| > directs
| > | them to a different order form that accesses a different rate database.
| > |
| > | Is this the correct approach assuming that our ISP supports all the things
| > | you state below?
| > |
| > | Thanks for all your useful suggestions.
| > |
| > | Richard
| > |
| > | Thanks,
| > |
| > | Richard
| > |
| > | "David Berry" wrote:
| > |
| > | > Password Protect Part of a Web: (Requires FrontPage extensions on
| > | > server, and host must support subwebs with unique permissions)
| > | >
http://support.microsoft.com/default.aspx?scid=kb;en-us;301554 (FP2000)
| > | >
http://support.microsoft.com/default.aspx?scid=kb;en-us;825451 (FP2003)
| > | >
| > | > Protect individual pages: (Requires Windows Server with support for ASP
| > | > and Access database)
| > | >
http://support.microsoft.com/default.aspx?scid=kb;en-us;825498
| > | >
| > | >
| > | > See
http://support.microsoft.com/default.aspx?scid=kb;en-us;825451
| > | > Your host will have to support subwebs and unique permissions under the
| > FP
| > | > Server Extensions
| > | >
| > | > For another sample of using a database and ASP See
| > | >
http://www.kamath.com/tutorials/tut003_auth.asp
| > | >
| > | >
| > | > | > | > > I've recently finished designing our company's website but the next
| > step
| > | > > that
| > | > > my CEO has asked for is can we create an area where distributors can
| > log
| > | > > in
| > | > > and order products with prices unique to them and contractors having a
| > | > > higher
| > | > > price but the same products? I've read a little of the FAQ on
| > permission
| > | > > based subsites but I thought I would ask the experts before I spent
| > too
| > | > > much
| > | > > time going down the wrong alley. We'll probably add e-commerce to our
| > site
| > | > > so
| > | > > this may make a difference. Our new website is
| > | > >
http://www.filtrationmanufacturing.com if anyone wants to check it
| > out.
| > | > > I'm
| > | > > still a novice at web design even though I'm a photographer with
| > graphics
| > | > > experience.
| > | > >
| > | > > Thanks,
| > | > >
| > | > > Richard
| > | >
| > | >
| > | >
| >
| >
| >
