This content has been marked as final.
Show 9 replies
-
1. Re: Dynamic Text - mutlipe instances possible?
Newsgroup_User Aug 11, 2007 11:09 AM (in response to GhengisJones)> 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 Aug 11, 2007 6:31 PM (in response to Newsgroup_User)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?
Newsgroup_User Aug 11, 2007 6:33 PM (in response to Newsgroup_User)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 Aug 11, 2007 7:26 PM (in response to GhengisJones)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 Aug 11, 2007 7:34 PM (in response to GhengisJones)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 Aug 11, 2007 8:38 PM (in response to GhengisJones)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?
Newsgroup_User Aug 12, 2007 5:09 AM (in response to GhengisJones)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 Aug 12, 2007 12:49 PM (in response to Newsgroup_User)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?
Newsgroup_User Aug 12, 2007 1:27 PM (in response to Newsgroup_User)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.