|
 |
asp_databases thread: Insert data into table
Message #1 by "Hery" <s_hery@e...> on Wed, 29 Aug 2001 10:25:35 +0700
|
|
I got a problem when i want to add new record.
I know there is 2 ways to insert data into table, first i can use SQL
statement like Insert into bla bla.... (this way is ok ... no problem)
and second i wanna use recordset to insert data to table but i get a
problem here.
i did like this :
set rs= server.createobject("ADODB.Recordset")
rs.Open "MyTable","MyDSNName", adOpenKeySet, adLockPessimistic,
adCmdTable
rs.AddNew
rs.Fields("Name") = "MyName"
rs.Fields("Address") = "MyAddress"
rs.Update
rs.Close
but it always get an error.
Please help me asap
HERY
Message #2 by "Drew, Ron" <RDrew@B...> on Wed, 29 Aug 2001 08:42:20 -0400
|
|
I typically use Insert but you can use Recordset. Position to the end, add
the record, update to commit it. The way I do it is:
set rs=3D server.createobject("ADODB.Recordset")
rs.Open "Select * from MyTable",ConnectionToDatabase,1,2
rs.AddNew
rs.Fields("Name") =3D "MyName"
rs.Fields("Address") =3D "MyAddress"
rs.Update
-----Original Message-----
From: Hery [mailto:s_hery@e...]
Sent: Wednesday, August 29, 2001 2:33 AM
To: ASP Databases
Subject: [asp_databases] Insert data into table
I got a problem when i want to add new record.
I know there is 2 ways to insert data into table, first i can use SQL
statement like Insert into bla bla.... (this way is ok ... no problem)
and second i wanna use recordset to insert data to table but i get a
problem here.
i did like this :
set rs= server.createobject("ADODB.Recordset")
rs.Open "MyTable","MyDSNName", adOpenKeySet, adLockPessimistic,
adCmdTable
rs.AddNew
rs.Fields("Name") =3D "MyName"
rs.Fields("Address") =3D "MyAddress"
rs.Update
rs.Close
but it always get an error.
Please help me asap
HERY
Message #3 by "Hasenfratz, Philipp" <maillist@e...> on Wed, 29 Aug 2001 15:46:37 +0200
|
|
> I got a problem when i want to add new record.
> I know there is 2 ways to insert data into table, first i can use SQL
> statement like Insert into bla bla.... (this way is ok ... no problem)
> and second i wanna use recordset to insert data to table but i get a
> problem here.
> i did like this :
> set rs= server.createobject("ADODB.Recordset")
> rs.Open "MyTable","MyDSNName", adOpenKeySet, adLockPessimistic,
> adCmdTable
> rs.AddNew
> rs.Fields("Name") = "MyName"
> rs.Fields("Address") = "MyAddress"
> rs.Update
> rs.Close
>
> but it always get an error.
> Please help me asap
>
> HERY
Hello Hery,
you can use SQL, too :
INSERT INTO mytable (Name, Address) VALUES ('MyName', 'MyAddress');
---Philipp
|
|
|
View Cart
