Hi, i am a starter in this asp thing and currently working on a project to update user's property of MS outlook. I have written down this code to fetch user's property to show him in a user interface screen which i have made also. option explicit DIM FLAG FLAG="false" DIM displayname,department,alias,company,email, address,title,city,state, zipcode, country,tel_ext, tel_off, tel_hom, tel_mob DIM rsTemp, adscon, com, strsql Set rsTemp = server.CreateObject("ADODB.Recordset") Set adscon = server.CreateObject("ADODB.connection") adscon.Provider = "ADsDSOObject" adscon.Properties("User ID") = Request.ServerVariables("Auth_User") adscon.Properties("Password") = Request.ServerVariables("Auth_Password") adscon.Properties("Encrypt Password") = true adscon.Open set com = server.CreateObject("ADODB.command") set com.ActiveConnection = adscon strsql = "SELECT Streetaddress,Postalcode,telephonenumber,company,c o,cn, title, department, mail, samAccountName, l, st FROM 'GC://ncorp-dc-01' where objectClass='User' and samAccountName = '" & Request.ServerVariables("Auth_User") &"'" com.CommandText = strsql Set rsTemp = com.execute(strsql) if rsTemp.RecordCount = 1 then displayname=rsTemp(6) alias=rsTemp(2) title=rsTemp(5) department=rsTemp(4) city=rsTemp(1) state=rsTemp(0) email=rsTemp(3) country=rsTemp(7) company=rsTemp( tel_off=rsTemp(9) zipcode=rsTemp(10) address=rsTemp(11) end if FLAG=TRIM(Request.Form("flag")) if FLAG="true" then Response.Write(tel_off & "<br>") tel_mob=TRIM(Request.form("tel_mob")) tel_ext=TRIM(Request.form("tel_ext")) tel_hom=TRIM(Request.form("tel_hom")) tel_off=TRIM(Request.form("tel_off")) end if Now Please tell, if I want to update user's phone no. only, then how to do so. Normal "Update set " command of sql is not working here. Please provide coding in asp only as I dont know the asp.Net thing. Hoping for some suggestions. thanking you
its very simple, you have already done all the work. just go to your code here com.CommandText = strsql Set rsTemp = com.execute(strsql) here strsql should be strsql = update table set phonenumber = 123 simple. It will work definately
dude, thanks a lot for your help. But, what are you saying is perfectly valid for sql server and microsoft access.Not for active directory on exchange server on which i am working. It demands a whole lot of new techniques. Anyways, I have done it successfully somehow. @Admin: Please close this thread as my problem has been solved.