troubleshooting Question

updating records using rs.update method

Avatar of humer2000
humer2000 asked on
9 Comments3 Solutions310 ViewsLast Modified:
hi experts,

i am updating record using the following method

shopopendatabase myconn
            Set objRS = Server.CreateObject("ADODB.Recordset")
   "select * from bm_bannerstbl where banner_id="&id, myconn, adopenkeyset, adlockoptimistic, adcmdtable
            objrs("banner_accountid") = banner_accountid
            objrs("banner_zoneid") = banner_zoneid
            objrs("banner_name") = banner_name
            objrs("banner_description") = replace(banner_description,"'","''")
            objrs("banner_targeturl") = banner_targeturl
            objrs("banner_imageurl") = banner_imageurl
            objrs("banner_alttext") = banner_alttext
            objrs("banner_width") = banner_width
            objrs("banner_height") = banner_height
            objrs("banner_border") = banner_border
            objrs("banner_textunderneath") = banner_textunderneath
            objrs("banner_newwindow") = banner_newwindow
            objrs("banner_active") = banner_active
            objrs("banner_startdate") = banner_startdate
            objrs("banner_enddate") = banner_enddate
            objrs("banner_impressions") = banner_impressions
            objrs("banner_weightings") = banner_weightings
            objrs("banner_tpbanner") = bmfalse
            shopclosedatabase myconn

But it's not working and my records are not updated, why ?
what's the problem with my code ?
please help

Cem Türk
Senior Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros