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
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