insert problem

Results 1 to 3 of 3

Thread: insert problem

  1. #1
    Join Date
    Dec 1969

    Default insert problem

    if a user has logged into my site and wants to add a product to their portfolio and i can get all the needed information except for username ?How do i get the user name ,i have it stored in a session variable down the end of the login page but dont know how to pull it back up to insert it into the db.<BR>Thanks<BR>Leigh

  2. #2
    Reggie Guest

    Default RE: insert problem

    strUsername = session("username")

  3. #3
    Join Date
    Dec 1969

    Default RE: insert problem

    I&#039;m not sure I follow what you want? If you already have the user id stored in a session you just insert it. <BR><BR>sql="Insert Into Address_Xref(Xref_id, Address_Id, Xref_Type ) "<BR><BR>sql=sql & "Values("<BR>sql=sql & Session("Business_Id")<BR>sql=sql & "," & rs6("Addr")<BR>sql=sql & "," & "&#039;" & "Business" & "&#039;"<BR>sql=sql & ")"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts