A web page that queries a database

General Questions
#1

I know this is not a really easy question.

But…

I want to set up a web page that queries an MS SQL database. The database has a list of events, with dates. I want the page to have a drop-down box for the reader to pick type of event and a date range, whereupon the page will display the results.

I have a web server running IIS. I have a second server running MS SQL. I have enough SQL knowledge that I can write raw SQL queries. I have enough HTML experience that I can write basic pages. I understand ODBC connections. I am a quick learner. How do I do this?

Is there a quick-and-easy on-line resource to refer to? Is there a volunteer that wants to pick up a few extra dollars walking me through this off-line?

Thanks.

#2

You’ll need to use ASP with IIS (IIRC) and either VBscript or Java script to execute the querries and properly display the results.

It’s very simple really.

Give this a shot:

http://www.w3schools.com/asp/default.asp

If you have any specfic questions, come back.

#3

Sorry but I only had 2 minutes to search…
Try reading this until someone else comes along…

HTML -> SQL

#4

If you can’t figure it out from the link Kinthalis sent, I like dollars :smiley: I do believe my email’s listed here.

#5

I do it using php. Am I the only one?

#6

No.

We use PHP running on RedHat servers at my (soon-to-be-ex) job and I have it setup on an IIS machine for testing at home.

But it’s whatever you’re used to or whatever molds to your background.

SD

#7

I’ve spent all week trying to work out how to do this. I’m using PHP on IIS in conjunction with MySQL. These tutorials have been invaluable, but this book allowed me to make the breakthrough I needed (today! yay!) to actually get things running.

#8

You can do this with asp programming. BUT, if you really want to be productive, run, do not walk, and pick up a copy of Macromedia’s Cold Fusion. Cold Fusion provides a very powerful yet easy-to-use tool to allow you to create dynamic Web pages that interface with SQL and other database back ends.

Basically, the product provides a set of HTML-style tags which you incorporate into the Web page. You can pick up the basics of using it in an hour or so. All you need is reasonable familiarity with HTML, general programming, and wirting SQL queries.

Very powerful, very easy to use, very easy to maintain. I can’t recommend it highly enough.