Link to home
Start Free TrialLog in
Avatar of mcse2007
mcse2007Flag for Australia

asked on

Creating basic site with SQL as DB engine

Hi Experts,

I have built our company's  INTRANET from the group up using IIS 5 and DreamWeaver 8.

I'm fascinated when I see a public website where you can do a search within that web site for product codes. So I'm looking to build a link in our company's intranet where my users can do a search of any customer using customer code then the result shows the customer's sales value.

I'm looking to create this page from the company's intranet but very basic requirements only - maybe in the future I can expand on its capabilities.

Here's my requirements.
In the default page, there are two boxes only, one for customer code and the other for customer sales
so I need to create this form in DreamWeaver;
Then, how do I link this form to my MS SQL server when I perform the customer code search then it query my database and it should show the customer sales results. I have a very basic database with customer code and customer sales only.

I always wanted to learn this stuff but havent been able to do it or I cannot be helped again here because this is to ambitious question to answer?

I'm using SQL 7, IIS 5 and Windows 2000

Appreciate any help and many thanks

mcse2007
ASKER CERTIFIED SOLUTION
Avatar of rbudj
rbudj
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial