Inserting records into Multiple Tables at one with DataAssist is this possible

9/01/2009 2:47 amneil.batchelor254136

Hi Eric,

I have the USER id in every other table using Foreign keys.
I will as you say insert the userID in the session variable for each form/page.
I will try the insert server behaviour tonight.
In addition if there are other foreign key columns I want to record do I insert these as a hidden field?

I am not sure hopw to do this: "add in a where clause and say to make it select the records where the userID is equal to the session variable for the logged in user."

I also want to search where the userID is equal to the session variable for the logged in user.I think this is all generally part of the same question.

Thanks,
Neil

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Type in the characters exactly as displayed below - if you don't complete the Captcha correctly you will get a blank page, so you may want to copy the text of your message before you submit!

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Inserting records into Multiple Tables at one with DataAssist is this possible

9/01/2009 2:47 amneil.batchelor254136