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
LVL 7
mcse2007Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rbudjCommented:
Sadly this is not an easy question to answer because it requires many elements and a lot of code.  Fortunately there is a book you can use that will not only walk you through it but give you extensions to automatically generate the code you need: http://www.amazon.com/Macromedia-Dreamweaver-Recipes-Joseph-Lowery/dp/0321393910/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1202567095&sr=8-1 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GuitarFingersCommented:
In Dreamweaver, do you already have your database connection setup, tested and working? Can you see the tables when you click on the query database in the Application Window on the right? Just trying to determine where you are in the process is all.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.