This topic is locked

caputure user initial write to table

8/11/2005 6:39:19 PM
ASPRunnerPro General questions
S
shigou author

when i create a new record, how to capture the user table - initial name field

automatically into the record which the user logged-in ?

(USER : USER_ID, USER_PASS, USER_INIT)

admin 8/15/2005

Hi,
to do this choose main table on the Datasource tab(Step3) in PHPRunner and proceed to the Formatting tab(Step8).

Click on the Edit format - Change... and set default values for fields you want to fill automatically as Session("USER_ID"), Session("USER_PASS") etc.
Build the project and insert session variable definitions in the login.asp i.e.
Session("USER_ID")=rs("UserName")

Session("USER_PASS")=rs("Password")

...
Also you need to modify SQL query that choose login and password from users table.

S
shigou author 8/15/2005

HOW about in ASP Runner?
it seems more complicated to add the session there..

admin 8/16/2005

I'm sorry.

My previous post applies to ASPRunnerPro.