9 Replies Latest reply on Aug 12, 2007 1:27 PM by Newsgroup_User

    Dynamic Text - mutlipe instances possible?

    GhengisJones Level 1
      I'm using Dreamweaver 8, MS Access and ASP VB

      It appears that if I use the same dynamic text -- {rs_invRollingStock.Model} for instance -- more than once on a page, it will only appear on the uploaded web page just once, in the instance that occurs first on the page.The other instance(s) are left blank but otherwise the page fucntions properly.

      I've also noticed that if I use the same dynamic text more than once but format each instance a different way (e.g. a number formatted as currency and without formatting) then both instances will appear on the uploaded web page.

      Is this correct? Why does this happen? Is there a work around?

      Thanks,

      c

        • 1. Re: Dynamic Text - mutlipe instances possible?
          Level 7
          > It appears that if I use the same dynamic text --
          > {rs_invRollingStock.Model}
          > for instance -- more than once on a page, it will only appear on the
          > uploaded
          > web page just once, in the instance that occurs first on the page.The
          > other
          > instance(s) are left blank but otherwise the page fucntions properly.

          There is something else happening, then. There would be no restriction for
          the number of times you could use such things. If it will help you, though,
          assign that value to a variable, and then use the variable in your
          Response.Write(), or echo(); commands.

          --
          Murray --- ICQ 71997575
          Adobe Community Expert
          (If you *MUST* email me, don't LAUGH when you do so!)
          ==================
          http://www.dreamweavermx-templates.com - Template Triage!
          http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
          http://www.dwfaq.com - DW FAQs, Tutorials & Resources
          http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
          ==================


          "GhengisJones" <webforumsuser@macromedia.com> wrote in message
          news:f9jddq$soi$1@forums.macromedia.com...
          > I'm using Dreamweaver 8, MS Access and ASP VB
          >
          > It appears that if I use the same dynamic text --
          > {rs_invRollingStock.Model}
          > for instance -- more than once on a page, it will only appear on the
          > uploaded
          > web page just once, in the instance that occurs first on the page.The
          > other
          > instance(s) are left blank but otherwise the page fucntions properly.
          >
          > I've also noticed that if I use the same dynamic text more than once but
          > format each instance a different way (e.g. a number formatted as currency
          > and
          > without formatting) then both instances will appear on the uploaded web
          > page.
          >
          > Is this correct? Why does this happen? Is there a work around?
          >
          > Thanks,
          >
          > c
          >
          >
          >


          • 2. Re: Dynamic Text - mutlipe instances possible?
            GhengisJones Level 1
            You are right.

            It seems I can put multiple instances of any record from a query (or its table) on a web page and have them appear properly.

            Any, that is, except for the one record that I need to have appear mulitple times on the web page!

            Any idea what could be wonky with this record?

            FWIW, it is named "Model".

            I will compare it in detail to the other records...

            c
            • 3. Re: Dynamic Text - mutlipe instances possible?
              Level 7
              Did you try assigning it to a variable and then printing the variable to the
              page?

              --
              Murray --- ICQ 71997575
              Adobe Community Expert
              (If you *MUST* email me, don't LAUGH when you do so!)
              ==================
              http://www.dreamweavermx-templates.com - Template Triage!
              http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
              http://www.dwfaq.com - DW FAQs, Tutorials & Resources
              http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
              ==================


              "GhengisJones" <webforumsuser@macromedia.com> wrote in message
              news:f9lnu9$jot$1@forums.macromedia.com...
              > You are right.
              >
              > It seems I can put multiple instances of any record from a query (or its
              > table) on a web page and have them appear properly.
              >
              > Any, that is, except for the one record that I need to have appear
              > mulitple
              > times on the web page!
              >
              > Any idea what could be wonky with this record?
              >
              > FWIW, it is named "Model".
              >
              > I will compare it in detail to the other records...
              >
              > c
              >


              • 4. Re: Dynamic Text - mutlipe instances possible?
                GhengisJones Level 1
                No. I'm a bit of a dynamic web page novice, so that doesn't even mean anything to me (yet).

                In further experimenting, I've discovered that Record Field in other MS Access tables named Model behave (or misbehave) the same way.

                Could it have something to do with naming a Field "Model"?

                I'm going to creat a new Field called Model1 with the same data and see what happens.
                • 5. Re: Dynamic Text - mutlipe instances possible?
                  GhengisJones Level 1
                  Found the problem!

                  Upon inspecting the "Model" Field, I discovered that it is a "Memo" data type as opposed to a "Text" data type. Other Fields of the "Memo" data type exhibt the same problem -- they can't appear on the dynamic web page more than once.

                  Is there a work around for this?

                  Or do I need to abandon good database practice and repeat the same data in Fields called Model, Model1, Model2....?
                  • 6. Re: Dynamic Text - mutlipe instances possible?
                    GhengisJones Level 1
                    I fixed the problem.

                    The database was originally created in Access 2002, which defaults the max number of characters in a Text data type Field to 50 (even though it is capable of holding 255 characters).

                    Not realizing that a Text Field could hold more characters, I had changed the data type to Memo to accomodate the records that had more than 50 characters.

                    To fix my problem, I changed the Memo data type Fields back to Text, making sure that I changed the max. character limit to 255 before saving the table (so I didn't lose any data).

                    The dynamic page works just fine now.
                    • 7. Re: Dynamic Text - mutlipe instances possible?
                      Level 7
                      There is no such restriction on "memo" data.

                      --
                      Murray --- ICQ 71997575
                      Adobe Community Expert
                      (If you *MUST* email me, don't LAUGH when you do so!)
                      ==================
                      http://www.dreamweavermx-templates.com - Template Triage!
                      http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
                      http://www.dwfaq.com - DW FAQs, Tutorials & Resources
                      http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
                      ==================


                      "GhengisJones" <webforumsuser@macromedia.com> wrote in message
                      news:f9lrj0$nf0$1@forums.macromedia.com...
                      > Found the problem!
                      >
                      > Upon inspecting the "Model" Field, I discovered that it is a "Memo" data
                      > type
                      > as opposed to a "Text" data type. Other Fields of the "Memo" data type
                      > exhibt
                      > the same problem -- they can't appear on the dynamic web page more than
                      > once.
                      >
                      > Is there a work around for this?
                      >
                      > Or do I need to abandon good database practice and repeat the same data in
                      > Fields called Model, Model1, Model2....?
                      >


                      • 8. Re: Dynamic Text - mutlipe instances possible?
                        GhengisJones Level 1
                        Well..that's what it does. Since I've sorted it out for my immediate needs, I'm not overly worried about it anymore.
                        • 9. Re: Dynamic Text - mutlipe instances possible?
                          Level 7
                          That's what your usage of it does. There is nothing about this kind of
                          thing that could possibly prevent data fetched from the database from being
                          displayed multiple times. But we have no idea HOW you have implemented
                          that - no doubt there is a logic flaw in there somewhere.

                          --
                          Murray --- ICQ 71997575
                          Adobe Community Expert
                          (If you *MUST* email me, don't LAUGH when you do so!)
                          ==================
                          http://www.dreamweavermx-templates.com - Template Triage!
                          http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
                          http://www.dwfaq.com - DW FAQs, Tutorials & Resources
                          http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
                          ==================


                          "GhengisJones" <webforumsuser@macromedia.com> wrote in message
                          news:f9no7g$sro$1@forums.macromedia.com...
                          > Well..that's what it does. Since I've sorted it out for my immediate
                          > needs, I'm not overly worried about it anymore.