Viewing and Updating Mulktiple Records

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default Viewing and Updating Mulktiple Records

    How do I set my array or structure to display all the records? Right now it
    only displays 1 record. Here is the structure:

    <cfset stSteps = structNew()>
    <cfset stSteps.ID = "#getsteps.TCodeID#">
    <cfset stSteps.TCode = "#getsteps.TCode#">

    What I need is to have this data displayed in a table and options selected for
    each ID and then have it update all the ID's at once.

    ID - Code - Select Box - Select Box - Select Box
    ID - Code - Select Box - Select Box - Select Box

    This is what it should look like and then the user will select options for
    each ID.

    Thanks in advance!!


    DJ5MD Guest

  2. Similar Questions and Discussions

    1. PHP - Login and updating member records
      I'm trying to to allow members to login to my site, and allow them to update their personal information. I know you have to past the user...
    2. Updating Multi records
      Is there any way to update muliple records in one database table in one go?
    3. Using the same page for viewing, editing and adding records
      Hi All I am not an ASP expert but do some coding in ASP. I am lookng to learn how to code a form/page which can be used to view, create or...
    4. Updating records when using a subform
      On Wed, 23 Jul 2003 12:39:22 -0700, "JohnL" <johnlaidlaw@nospamtalk21.com> wrote: <ftp.ipswitch.com>
    5. Updating Multiple Records
      I have a table in a database that contains all my photos. The fields are like Name, SRC, GalleryName, DateAdded, SpecialStyle. The only one you may...
  3. #2

    Default Re: Viewing and Updating Mulktiple Records

    You need to work in a <CFOUTPUT QUERY="myQuery">. That will loop through each record or the query. Your logic to display the records goes between the <CFOUTPUT> and the </CFOUTPUT>
    jdeline Guest

  4. #3

    Default Re: Viewing and Updating Mulktiple Records

    OK, thanks. That fixes 1 problem. I am now able to all the items. Now, how do I do the second part?
    DJ5MD Guest

  5. #4

    Default Re: Viewing and Updating Mulktiple Records

    I wrote a tutorial on multi-line form entry that should get you what you need:

    [url]http://tutorial214.easycfm.com/[/url]

    Cheers,

    --Matt--
    MSB Web Systems... [url]http://mysecretbase.com[/url]
    GALAHAD: "Camelot!"
    LAUNCELOT: "Camelot!"
    GAWAIN (to the PAGE): "It's only a model."
    ARTHUR (turning sharply): "Shhh!!!"
    - Monty Python from 'The Holy Grail'


    MattRobertson 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