I have a place on our site where you can set-up a meeting and also be able to edit the fields. One field is for future announcements that holds 2500 characters, since the other fields in the table add up to 4000 or more we cannot set this field to 5000 characters. I created another table and added a pk and an eventsev field, but now I am having problems getting the field to update. Here is my code - help!


If request.form("b4") = "Next Page" then
        Set objConn = ficpa.getNetLinkDBConnection()

strSQL = "SELECT * FROM chapmeetreq2 WHERE chapter = '" & session("chap") & "' and entrydate = '" & date() & "' order by req_id desc"



strSQL = "SELECT * FROM chapmeetreq2 inner JOIN chapmeetreq2ev ON chapmeetreq2.req_id = chapmeetreq2ev.req_id WHERE (chapmeetreq2.chapter = '" & session("chap") & "') AND (chapmeetreq2.entrydate = '" & date() & "') ORDER BY chapmeetreq2.req_id DESC"



     set objRS2= Server.CreateObject("ADODB.Recordset")
        objRS2.Open strSQL2, objConn, 3, 3


    req_id = objrs2("req_id")
    session("req_id") = req_id
     req_id = objrs2("req_id")

    if request.form("eventsev") <> "" then
        objRS2.fields("eventsev") = request.form("events")
    else
        objRS2.fields("eventsev") = ""
    end if

    objRS2.Update
    objRS2.Close
    objrs.close
    set objrs2= nothing
    Set objRS = Nothing
    response.redirect("/ficpa/members/chapters/toolkit/chaptermeetingnotice2/page5")
end if
%>

this looks like vbscript... I'm right??

also you are not specifying where the error happens...

are you sure that your select work???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I don't actually know where the error is. I don't know where to look for that. It doesn't give it to me on the error report. Jen

well.. first of all.. just an idea, try to trace the code and see if the query is ok... maybe the wrong parameter is there....

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========