mcse2007
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.