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?
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.
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.