asp newbee insert into question 1

[rochnn]

I am trying to learn asp. I was building my first form and I came across a problem How do I do a insert sql statement

insert color, height, weight into descriptions

 

[DotNetGnat]

something like this:

dim sql, con
set con = server.createobject("ADODB.connection")
con.open "put the connection string to your database here"
sql = " INSERT INTO tablename(field1, field2, field3)" &_
      " VALUES ('"&request.form("val1")&"'," &_
      " '"&request.form("val2")&"'," &_
      " '"&request.form("val3")&"') "
con.execute(sql)

-DNG

 

[rochnn]

thank you DotNetGnat that is exactly what I was looking for. I created my whole input and works great.

 

[DotNetGnat]

no problem...gald to assist...

-DNG