Ask a Question related to ASP Database, Design and Development.
-
Shawn #1
Best way to insert into controller table
I want to find out the best way to accomplish this. I
have a form that inserts documents for the user. There
can be many documents for 1 user. Currently, there is a
form that list user information and all the documents a
user can choose via checkbox. I am using ASP to loop
through the value of the form variable, then the next page
perform the inserts based on the number of checkboxes
entered on the form (Documents are read from db and
identified by checkboxes on the form). I want to populate
the tblUserDocuments from the userid and all the document
ids that the user has chosen. I'm using ASP/SQL Server.
Is there a simpler way instead of making an array, then
looping through the array? Could I use the IN clause for
an sql Statement? Here is my table structure:
tblDocuments
documentID int primarykey
documentTitle varchar(50)
documentDescription varchar(500)
tblUsers
UserID int primarykey
UserFName varchar(50)
userLName varchar(50)
tblUserDocuments
UserID int
DocumentID int
Thanks
Shawn Guest
-
How Do you insert a table in Previous Table
How Do you insert a table in Previous Table that has an image, in a web page -
Insert ASP variable into SQL table
Hi, I have a variable called 'pSKU' (without quotes) that holds the SKU of a product. When someone visits a product page, I would like it to... -
Login - multi table insert for registrant; subsquent login insert page requests into joined 'Selection' Table
Question regards insert and updates in sql server for a simple login script that requires registration the first time and only "email address" upon... -
I can't insert into mySQL db table - HELP!
I have to get this done by tonight! I have a .CSV file and a PHP file where I am inserting the values of the CSV file into the db table. See the... -
insert into temp table
Hi V R using IDS 7.31 on sco platform and Informix -4Gl 7.20 UD7. One of our developer want to load flat file in to the temp table created within...



Reply With Quote

