This is a partial code for an application that collects information from a form where you request the UserID and DepartmentID. The code will append @MYDOMAIN.COM to the end of the user’s ID to obtain the e-mail address.
What I want to do is to get the First and Last names from another table using the User’s ID as a locator. For example, if the user ID is DOEJ that means that the user’s first name is John and the last name is Doe. And before I do that I want to make sure that the UserID is in the Database first.
quote: <% Set conn = Server.createobject ("ADODB.Connection") conn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\Inetpub\wwwroot\mydomain\mydatabase.mdb;"
If Not Isempty(Request.Form("Send")) Then EmailAddress = Request.Form("UserID") & ("@MYDOMAIN.com") CurrentDateTime = now 'Name = XXXXXXXXXXXX
If Not Isempty(Request.Form("Send")) Then EmailAddress = Request.Form("UserID") & ("@MYDOMAIN.com") CurrentDateTime = now Set rs = con.execute("SELECT FirstName, Lastname FROM table WHERE UserID = " & Request.Form("UserID")) If Not rs.BOF and not rs.EOF Then ... ... Else 'No name in DB End If ...
You'll have to fill in a few blanks, this is just an off the top idea not complete tested code.
Topic Locked
Posted - 27 June 2001 : 20:54:48
