below is my code.  My goal is to response.write ("Thank You!"---'and then 
the user name from the form.").  everything so far is working fine.
My question is i am already connected to the database but i am inputing 
the data.  if i want the user's name written there, i will have to call 
the data.  i looked for example of having.

Do i need to make 2 trips to the database? Can i accomplish this in one 
trip? one more thing where would  i place this code?

<% 
    IF request.form ("Message")="True" THEN 
    strTB1=request.form("UserName") 
    strTB2=request.form("StoreName") 
    strTB3=request.form("EMail") 
     
     
    'Opening the DataBase Object 
    set objConn = server.createobject("ADODB.Connection") 
    objConn.Open "DSN=info" 
    set cm = Server.CreateObject("ADODB.Command") 
    cm.ActiveConnection = objConn 
     
    cm.CommandText ="INSERT INTO SampleDb(TB1,TB2,TB3) VALUES (?,?,?)" 
     
     
        'First Text Box Parameter Statement 
    set objparam=cm.createparameter(, 200, , 255, strTB1) 
    cm.parameters.append objparam 

    'Second Text Box Parameter Statement 
    set objparam=cm.createparameter(, 200, , 255, strTB2) 
    cm.parameters.append objparam 

    'Third Text Box Value Parameter Statement 
    set objparam=cm.createparameter(, 200, , 255, strTB3) 
    cm.parameters.append objparam 

    cm.execute 
    response.write("Thank you!")   
ELSE%> 


 

response.write("Thank you! " & strTB1)

-----Original Message-----
From: craig [mailto:cn60@m...]
Sent: Monday, August 19, 2002 1:22 PM
To: ASP Databases
Subject: [asp_databases] connection and recordset??


below is my code.  My goal is to response.write ("Thank You!"---'and
then
the user name from the form.").  everything so far is working fine. My
question is i am already connected to the database but i am inputing
the data.  if i want the user's name written there, i will have to call
the data.  i looked for example of having.

Do i need to make 2 trips to the database? Can i accomplish this in one
trip? one more thing where would  i place this code?

<%
    IF request.form ("Message")=3D"True" THEN
    strTB1=3Drequest.form("UserName")
    strTB2=3Drequest.form("StoreName")
    strTB3=3Drequest.form("EMail")
    
    
    'Opening the DataBase Object
    set objConn =3D server.createobject("ADODB.Connection")
    objConn.Open "DSN=3Dinfo"
    set cm =3D Server.CreateObject("ADODB.Command")
    cm.ActiveConnection =3D objConn
    
    cm.CommandText =3D"INSERT INTO SampleDb(TB1,TB2,TB3) VALUES (?,?,?)" 

    
    
        'First Text Box Parameter Statement
    set objparam=3Dcm.createparameter(, 200, , 255, strTB1)
    cm.parameters.append objparam

    'Second Text Box Parameter Statement
    set objparam=3Dcm.createparameter(, 200, , 255, strTB2)
    cm.parameters.append objparam

    'Third Text Box Value Parameter Statement
    set objparam=3Dcm.createparameter(, 200, , 255, strTB3)
    cm.parameters.append objparam

    cm.execute
    response.write("Thank you!")  
ELSE%>