DB Bindings and Dynamic Pages

Working with Text Files, Image Lists and more.
Post Reply
mark_anderson_us
Trusted Contributor
Trusted Contributor
Posts: 61
Joined: Fri Mar 16, 2012 12:21 pm

DB Bindings and Dynamic Pages

Post by mark_anderson_us »

Hi Guys

Either I'm not getting it, or dynamic pages don't work correctly with DB Bindings. I have multiple visitors every day and I want to cycle through each of them at x-second intervals. I have a single list and a record is returned for each site the visitor will visit. I want to use DB Binding for this, so that I don't need to create 4 separate projects.

I have 4 visitor boards and want to create a single project. (The idea is to filter the data each displays using DB Bindings). Seems fairly straightforward. My test data returns the following:

Code: Select all

ID	VisitDate	 Company	           Site	        StartTime	        EndTime
1	7/22/2014	  WH GI BV 1	   Wheeling	7/22/14 0:01	7/22/14 23:59
1	7/22/2014  WH GI BV 1	   Gilman	        7/22/14 0:01	7/22/14 23:59
1	7/22/2014	  WH GI BV 1	   Broadview	7/22/14 0:01	7/22/14 23:59
2	7/22/2014	  WH GI BV 2	   Wheeling	7/22/14 0:01	7/22/14 23:59
2	7/22/2014  WH GI BV 2	   Gilman	        7/22/14 0:01	7/22/14 23:59
2	7/22/2014	  WH GI BV 2	   Broadview	7/22/14 0:01	7/22/14 23:59
3	7/22/2014	  BV	                   Broadview	7/22/14 0:01	7/22/14 23:59
4	7/22/2014	  WH GI	           Wheeling	7/22/14 0:01	7/22/14 23:59
4	7/22/2014	  WH GI	           Gilman	        7/22/14 0:01	7/22/14 23:59
5	7/22/2014	  GI	                   Gilman	        7/22/14 0:01	7/22/14 23:59
6	7/22/2014	  GI BV	           Gilman	        7/22/14 0:01	7/22/14 23:59
6	7/22/2014	  GI BV	           Broadview	7/22/14 0:01	7/22/14 23:59
The player bound to Broadview (site is the binding column) is displaying 12 dynamic pages (Always Record 7). It should display records 3,6,7,12 as they are the only ones where the DB Binding matches the Site.

There's nothing in the documentation that explains how dynamic pages are handled and how overlapping or concurrent events are handled.

One other question: do I have to use start time and end time?
Post Reply