Results 1 to 9 of 9

Thread: [Resolved] Can ADD and DELETE from mDB but not UPDATE..?!?!

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2001
    Location
    www.alexdata.com
    Posts
    484

    Exclamation [Resolved] Can ADD and DELETE from mDB but not UPDATE..?!?!

    This is the code i use to UPDATE within my page.. but it doesnt update anything, it doesnt do anything, nor doest it trow any errors..
    Can someone look over my code (i'll upload the ASP page,and the mdb)
    (PS: the DB was renamed to .txt , because the upload system here doesnt accept .mdb as extension...dunno why??)

    Here's the code that create's the "problem" (it doesnt update the DB)
    Code:
      ELSEIF Request.Form("flag")="2" THEN
        SQLstmt = "UPDATE Produkter SET "
        SQLstmt = SQLstmt & "Varenavn='" & TRIM(Request.Form("Varenavn")) & "', "
        SQLstmt = SQLstmt & "Varenummer='" & TRIM(Request.Form("Varenummer")) & "', "
        SQLstmt = SQLstmt & "Varepris='" & TRIM(Request.Form("Varepris")) & "', "
        SQLstmt = SQLstmt & "Varetekst='" & TRIM(Request.Form("Varetekst")) & "', "
        SQLstmt = SQLstmt & " WHERE ID=" & TRIM(Request.Form("Recordid"))
    Attached Files Attached Files
    Last edited by alexdata; Dec 12th, 2005 at 02:48 PM. Reason: [Resolved] - See the last few posts..
    ***************
    Please use [highlight=vb] ..your code.. [/highlight] when posting code!

    When you have received the working answer to your question,
    please mark it as *SOLVED* + Your Questions Title ...using your Thread's Tool menu.


    Also try to point out what answer made it work for you, or edit your first post to contain a quote of the correct answer...

    Please Answer All Questions With Working Code Examples...


    My Unfinished Projects and My working Programs
    ***************

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width