[WEB4LIB] sql help - asp application

[Dobbs, Aaron]

Crate a SQL view (oh drat you said M$ Access - so create a query (as
straighforwardly as possible)) with the required elements from their
respective tables and correctly format your .asp to insert the records into
that query.  (the caveat is if one (or more) of the tables requires data to
be already present (think a referenced recordID that needs to pre-exist)
then your .asp needs to first create the entry in that referenced table then
insert the rest of the data in the query -- the level of difficulty will
depend on the data integrity settings you selected in your Access db)  

Aaron W. Dobbs, MSLS
A+, MCDBA, MCSE+I, Network+
Network Services Librarian
Austin Peay State University

Clear as mud, right? -me

-----Original Message-----
From: Mary Beth Faccioli [mailto:mbfaccioli at yahoo.com]
Sent: Monday, November 25, 2002 1:21 PM
To: Multiple recipients of list
Subject: [WEB4LIB] sql help - asp application


Hi all,
I am developing a database driven web application
using ASP/IIS/Access where users (librarians) will be
inputting data (about instruction sessions) from a
form.  The database has several tables that populate
drop-down boxes on this form.  For example, there is a
table that lists different university departments and
is connected to the main table via a DeptID field. 

I am trying to use sql INSERT INTO in the form
processing but am having trouble figuring this out
because there are 5 tables to be joined when the user
submits the form.  Are there any good online resources
that would deal with this - I have seen some basic
things but nothing that deals with pulling together
this many tables.  I know this has to go on all the
time with database driven applications.  Can anyone
help?

Thanks in advance,

Mary Beth Faccioli
Web Specialist
Georgia State University Pullen Library
100 Decatur Street SE
Atlanta, GA 30303
404-463-9947
mbfaccioli at yahoo.com


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com