Professional Web Applications Themes

More help with DB deletion - Coldfusion Database Access

Removed by Administrator...

  1. Moderated Post

    Default More help with DB deletion

    Removed by Administrator
    Student_bob Guest
    Moderated Post

  2. #2

    Default Re: More help with DB deletion

    How are you getting the variable FORM.P_Num from delete_roster2.cfm to
    delete_roster3.cfm? You need to add an <input> tag of type="hidden" named P_Num
    with the value of FORM.P_Num on delete_roster2.cfm so that when you submit the
    form, the form variable is forwarded to delete_roster3.cfm.

    Phil

    paross1 Guest

  3. #3

    Default Re: More help with DB deletion

    We've tried this and it says the record has been deleted but when we check the
    database it does not delete it. No error messages just runs the code, but
    doesn't delete

    delete_roster2.cfm

    <form action="delete_roster3.cfm" method="post">
    <input type="hidden" name="P_Num" value= '#form.P_num#'>


    delete_roster3.cfm

    <cfquery datasource="Trackclub">
    DELETE FROM roster WHERE P_Num = '#form.P_Num#'
    </cfquery>



    We believe the error is in delete_roster2.cfm value= '#form.P_num#'

    because when we put the primary key hard coded it works.

    Student_bob Guest

  4. Moderated Post

    Default Re: More help with DB deletion

    Removed by Administrator
    paross1 Guest
    Moderated Post

  5. #5

    Default Re: More help with DB deletion

    Thank you so much, I appreciate it Phil.

    Have a good one.

    Bob
    Student_bob Guest

Similar Threads

  1. PREVENTING CSS DELETION
    By dave@zinco in forum Macromedia Contribute Connection Administrtion
    Replies: 0
    Last Post: June 2nd, 09:21 AM
  2. Help with database deletion
    By Student_bob in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 7th, 09:59 PM
  3. Bookmarks deletion
    By Ann_Dillard@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 4
    Last Post: April 22nd, 09:51 PM
  4. [PHP] File upload and deletion
    By Chris W. Parker in forum PHP Development
    Replies: 1
    Last Post: August 21st, 08:49 PM
  5. Deletion problems
    By Pauline in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 18th, 10:53 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139