[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

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

2 Solutions
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 
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.

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now