Updating a whole table

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Updating a whole table

    Can anyone give me an example of an Update query that would update a entire
    table. The field I want to update is a Yes/No field and the page I've
    created has a check box in a repeat region that displays the field. Checked
    if yes and un-checked if no. I'd like to toggle all or un-toggle all and
    update all fields according to the state of hte chackbox.

    Bill


    BillB Guest

  2. Similar Questions and Discussions

    1. #25473 [Opn->Bgs]: Updating single row in table causing all rows in table to be updated.
      ID: 25473 Updated by: sniper@php.net Reported By: jim at bluedojo dot com -Status: Open +Status: ...
    2. #25473 [Fbk->Opn]: Updating single row in table causing all rows in table to be updated.
      ID: 25473 User updated by: jim at bluedojo dot com Reported By: jim at bluedojo dot com -Status: Feedback +Status: ...
    3. #25473 [Opn->Fbk]: Updating single row in table causing all rows in table to be updated.
      ID: 25473 Updated by: sniper@php.net Reported By: jim at bluedojo dot com -Status: Open +Status: ...
    4. #25473 [Opn]: Updating single row in table causing all rows in table to be updated.
      ID: 25473 User updated by: jim at bluedojo dot com Reported By: jim at bluedojo dot com Status: Open Bug Type: ...
    5. #25473 [NEW]: Updating single row in table causing all rows in table to be updated.
      From: jim at bluedojo dot com Operating system: WinXP PHP version: 4.3.3 PHP Bug Type: MySQL related Bug description: ...
  3. #2

    Default Re: Updating a whole table

    On Fri, 25 Mar 2005 10:33:24 -0500, BillB
    <bill.betournay<"spamTrap"@gmail.com>> wrote:
    > Can anyone give me an example of an Update query that would update a
    > entire
    > table. The field I want to update is a Yes/No field and the page I've
    > created has a check box in a repeat region that displays the field.
    > Checked
    > if yes and un-checked if no. I'd like to toggle all or un-toggle all and
    > update all fields according to the state of hte chackbox.
    >
    > Bill
    >
    >
    WE have an extension for this, is called ImpAKT and you can generate this
    forms with ease. Our new version (still beta) even reminds what the user
    put so even if the validation catch some odd data, it will not delete the
    rest of the information. This allows fast data capturing and improve
    productivity.

    Please have a look here:
    [url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Overview/[/url]
    make sure to see some of the Flash Demo's.


    --
    Alexandro Colorado
    ------------------------------
    Support Engineer
    InterAKT Online
    [url]http://www.interaktonline.com[/url]
    Tel: 40(21) 312.5312
    Alexandro Colorado Guest

  4. #3

    Default Re: Updating a whole table

    You guys have an extension for everything don't you :-)

    I'll likely end up buy that too.

    Bill


    "Alexandro Colorado" <acolorado@interaktonline.com> wrote in message
    news:opsn699gzvrohbc4@acolorado...
    > On Fri, 25 Mar 2005 10:33:24 -0500, BillB
    > <bill.betournay<"spamTrap"@gmail.com>> wrote:
    >
    >> Can anyone give me an example of an Update query that would update a
    >> entire
    >> table. The field I want to update is a Yes/No field and the page I've
    >> created has a check box in a repeat region that displays the field.
    >> Checked
    >> if yes and un-checked if no. I'd like to toggle all or un-toggle all and
    >> update all fields according to the state of hte chackbox.
    >>
    >> Bill
    >>
    >>
    > WE have an extension for this, is called ImpAKT and you can generate this
    > forms with ease. Our new version (still beta) even reminds what the user
    > put so even if the validation catch some odd data, it will not delete the
    > rest of the information. This allows fast data capturing and improve
    > productivity.
    >
    > Please have a look here:
    > [url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Overview/[/url]
    > make sure to see some of the Flash Demo's.
    >
    >
    > --
    > Alexandro Colorado
    > ------------------------------
    > Support Engineer
    > InterAKT Online
    > [url]http://www.interaktonline.com[/url]
    > Tel: 40(21) 312.5312

    BillB Guest

Posting Permissions

  • You may not post new threads
  • You may 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