General discussion

Locked

RS.Update not working ....

By vikas.aditya ·
Hi friends

I am from New Delhi India .I was trying to use RS.Update in ASP but it simply doesn't work!! I am running IIS 5.0 as webserver.similarly RS.RecordCount also doesn't function.Can somebody suggest how these properties of RS could be made functioning?

Wishing you all a Happy New Year!

Vikas Aditya
IT Manager

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

RS.Update not working ....

by lee_button In reply to RS.Update not working ... ...

make sure you have opened with the correct keyset, below is an example - one with a sql result set and one with a sql table.

sSQL = "SQL query"
rs.Open sSQL, db connection variable, adOpenKeySet, adLockPessimistic, adCmdText
rs.AddNew
rs.Fields("field name") = variable
rs.update
rs.close
--------------------------------------------------rs.Open "table name", db connection variable, adOpenKeySet, adLockPessimistic, adCmdTable
rs.AddNew
rs.Fields("field name") = variable name
rs.update
rs.close

Collapse -

RS.Update not working ....

by vikas.aditya In reply to RS.Update not working ... ...

I hv already tried with all key set combinations...and tell me why to use rs.AddNew when u r not trying to do one...(well i hv tried with rs.addnew as well) and tell me why to use adCmdText ...

i m working on SQL7.0 server and IIS 5 web server....is it related to this??

thanx dear for your reply but it's not working...

Vikas

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums