Help with adding new records

hassaan

[HassaaN]
Local time
Tomorrow, 03:06
Joined
Jul 7, 2005
Messages
14
Hi,
I don't know much about how to add records using .AddItem method.

This is what I have used but it doesn't work
----------------------------
set con=server.createobject("ADODB.connection")
set rs = Server.CreateObject("ADODB.Recordset")

con.open "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("db.mdb")

rs.Open "TABLENAME","db.mdb"
rs.AddNew
rs("SongID") = request.QueryString("song")(I)
rs("Song") = song.fields(s).value
rs("Artist") = artist.fields(a).value
rs.Update
------------------------------------------------------------

all the querystring values are working fine. its just some problem in adding records. please help
 

Users who are viewing this thread

Back
Top Bottom