HOW CAN I INSERT VALUES INTO A DATABASE

[ivoestg]

hello i'm new on asp and i need to insert values on a access database can you tell me how? thanks...

I'm in ivoestg@yahoo.com

 

[jmerencilla]

use the SQL INSERT command

syntax: (assuming you already had setup the necessary connections to your database)

INSERT INTO table_name VALUES(Field1, Field2, ..., FieldN)

 

[ivoestg]

no i don't have anything done can you tell me all the step's??? thanks...

I'm in ivoestg@yahoo.com

 

[onpnt]

you can also do something like this to avoid the insert sql statements if you're newer to asp
set rs = server.createobject("ADODB.recordset&quot
rs.open "INSERT INTO tblname", connection,2,2
rs.addnew
rs("name&quot=request.form("name&quot
rs.update

this takes the form name value and puts it into the name column at the end of the records with the addnew method and update. A lot of people use this way for many reasons but it seems like a easy way to start off before messing with doing this via the sql statement. remember that the directory where the DB is has to be writable for any insert to work. You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com

 

[onpnt]

sorry that should be
rs.open "SELECT * FROM tblname", connection,2,2
not
rs.open "INSERT INTO tblname", connection,2,2
You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com