In my job as a server/web admin, I have been given the daunting task of building a customer information capture tool that has a web interface and an SQL 7.0 backend. I've been told what to do, but not how to do it.

For the past couple of months, I have been learning SQL and ASP from a couple of books, and I'm also using UltraDev 4 to help me with coding. Because I'm eager to learn and anxious to get the job done, I would love some advice from the pros.

I want to insert ~200 questions(and answers/choices via checkbox, dropdowns, radio buttons, etc.) into the database, and call them to HTML/ASP with stored procedures. Unfortunately, because I'm a bit rusty with stored procedures, indexing, foreign/primary keys and SQL in general, I'm not sure where/how to get started.

I've created tables in SQL 7.0 to house the data, but not sure how to get the data in and back out to the web pages.

Any professional advice, tips, sample code, or ideas that can help me would be greatly appreciated.

Take a look at tutorial that comes with UD, section Creating Recordsets (or something like this). That's a good start.
Also, read all tutorials on this site or post question here. Just try to ask when you have some specific problem. General questions (like how to build ASP/SQL site) are almost allways left unanswered.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
In my job as a server/web admin, I have been given the daunting task of building a customer information capture tool that has a web interface and an SQL 7.0 backend. I've been told what to do, but not how to do it.

For the past couple of months, I have been learning SQL and ASP from a couple of books, and I'm also using UltraDev 4 to help me with coding. Because I'm eager to learn and anxious to get the job done, I would love some advice from the pros.

I want to insert ~200 questions(and answers/choices via checkbox, dropdowns, radio buttons, etc.) into the database, and call them to HTML/ASP with stored procedures. Unfortunately, because I'm a bit rusty with stored procedures, indexing, foreign/primary keys and SQL in general, I'm not sure where/how to get started.

I've created tables in SQL 7.0 to house the data, but not sure how to get the data in and back out to the web pages.

Any professional advice, tips, sample code, or ideas that can help me would be greatly appreciated.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>