The New Guy
|
Posted: 09/17/2003, 5:28 PM |
|
Hello everyone,
I know it seems ridiculous, but I am have a hard time with a insert form that I have to build.
Here is how the thing is supposed to work:
The form contains about 30 objects to be inserted into the database. The user logs in and fills the form and submits it.
The form then iserts the data plus the id (captured from the session) into the database.
I have looked at examples from the bookstore and other ready Code Charge scripts, but did not help.
here's how I am capturing the ID
DataSource.uid.Value = Session("UserID")
but then I get this error:
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'Objects.Item(...)'
/host/Classes.asp, line 558
The only thingt I want to do it identify who inserted the data...
Any sugestion?
|
|
|
arrowgance
|
Posted: 09/30/2003, 10:49 PM |
|
i visualize you have a dbase table like
products(productid,productname,quantity,volume,whoinserted)
Then you want to insert Session("UserID") to whoinserted field.
Add the whoinserted database column to your record form or whatever it is named.
add it is a HIDDEN.
Go to the before show event of that hidden field and add the code
YourFormName.whoinserted.Value = Session("UserID")
Do not use Datasource but YourFormName (RecordProducts, MyRecord, TheRecordForm, etc.)
|
|
|
|