General discussion

Locked

RS.Update in not working in ASP

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

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 in not working in ASP

by jfarmer In reply to RS.Update in not working ...

Are you opening your data source with a DSN or DSN-less connection? Can you read ANY data from the data source?

Please post a sample of your code.

Collapse -

RS.Update in not working in ASP

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

Obviously yes.....rest everything is working..my DSN is working absolutely fine..


<%@ Language=VBScript %>
<%

instt=Request.form ("instt")
'Response.Write (instt)

address=Replace(trim(Request.Form ("address")),"'","''")
name1=Replace(trim(Request.Form ("name1")),"'","''")
phone1=Replace(trim(Request.Form ("phone1")),"'","''")
email1=Replace(trim(Request.Form ("email1")),"'","''")
name2=Replace(trim(Request.Form ("name2")),"'","''")
phone2=Replace(trim(Request.Form ("phone2")),"'","''")
email2=Replace(trim(Request.Form ("email2")),"'","''")
name3=Replace(trim(Request.Form ("name3")),"'","''")
phone3=Replace(trim(Request.Form ("phone3")),"'","''")
email3=Replace(trim(Request.Form ("email3")),"'","''")
name4=Replace(trim(Request.Form ("name4")),"'","''")
phone4=Replace(trim(Request.Form ("phone4")),"'","''")
email4=Replace(trim(Request.Form ("email4")),"'","''")
name5=Replace(trim(Request.Form ("name5")),"'","''")
phone5=Replace(trim(Request.Form ("phone5")),"'","''")
email5=Replace(trim(Request.Form ("email5")),"'","''")
ppt_dt=Replace(trim(Request.Form ("ppt_dt")),"'","''")
int_dt=Replace(trim(Request.Form ("int_dt")),"'","''")
hired=Replace(trim(Request.Form ("hired")),"'","''")
logistics=Replace(trim(Request.Form ("logistics")),"'","''")


set DataConn1 = Server.CreateObject ("ADODB.Connection")
DataConn1.Open Application("HRSystem_ConnectionString")



mySQL = "UPDATE CampusPPT SET"
mySQL = mySQL & " address = '" & address & "',"
mySQL = mySQL & " name1 = '" & name1 & "',"
mySQL = mySQL & " phone1 = '" & phone1 & "',"
mySQL = mySQL & " email1 = '" & email1 & "',"
mySQL = mySQL & " name2 = '" & name2 & "',"
mySQL = mySQL & " phone2 = '" & phone2 & "',"
mySQL = mySQL & " email2 = '" & email2 & "',"
mySQL = mySQL & " name3 = '" & name3 & "',"
mySQL = mySQL & " phone3 = '" & phone3 & "',"
mySQL = mySQL & " email3 = '" &

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

Related Discussions

Related Forums