Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Updating mass data

    Could anyone tell me how to update a large quantity of data using ASP.net with
    an Access db attached, for example at the end of a week I want to reset
    numerous fields to a null value. Obviously in Access this can be done with an
    update query.

    Any help appreciated.

    Cheers

    Dave_03 Guest

  2. Similar Questions and Discussions

    1. Updating components when data changes
      I am having trouble getting a set of components to update when data is modified by another set of components. A...
    2. updating XML data
      I have the following code in place to move a variable from my Flash app to an XML file for storage . . . //replace the GoodVN value in the XML...
    3. Updating data sent from Paypal
      I have a value sent from paypal that I am trying to insert into an existing database. I am trying to call up the data, from the existing...
    4. Updating data in a column using it's own value
      I trying to change all the entries in a column of a table to titlecase. I have a custom tag that does the case change but I can't get it to work in...
    5. Updating Data Using a Subform
      On Tue, 8 Jul 2003 12:27:39 -0700, "Brian" <btvisc@hotmail.com> wrote: Base the Subform on a Query with a criterion of on the date/time...
  3. #2

    Default Re: Updating mass data

    Sounds like you answered your question. Whether you are using CF, ASP, .NET
    or JSP ... you want to execute the Access update. If CF, then try CFquery.
    hth

    -brian

    "Dave_03" <webforumsuser@macromedia.com> wrote in message
    news:d69ll1$qlm$1@forums.macromedia.com...
    > Could anyone tell me how to update a large quantity of data using ASP.net
    with
    > an Access db attached, for example at the end of a week I want to reset
    > numerous fields to a null value. Obviously in Access this can be done with
    an
    > update query.
    >
    > Any help appreciated.
    >
    > Cheers
    >

    Brian Hogue 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