Stanj
Posts: 166
|
| Posted: 05/12/2008, 11:46 PM |
|
Hi CoderChargers
PHP5.xx/MySql 5.xx CCS 4.04
I noticed a strange problem that is confusing me. I built a forum that has a dependent list box. The dependent data should return from 0 to about 14 maximum records according to the data in the tables. The two tables are Ships with an PK of ship_id. and a table called portcalls with the FK being ship_id. The displayed text in the dependent box is date_arrival.
With a SQL query that the Visual Query Builder created is run directly the results list the entire list of date_arrival, up to 14 dates for any ship_id. It is simply "select * from portcalls"
Using the dependent list box feature of 4.0 with the dependency field being ship_id., it all works as expected except it only returns a maximum of 10 dates. If I remove or change the sorting on the results, a different data set is displayed(because dates were not entered in order) but still only 10 are displayed. So all the data can be seen as long as it is among the first 10 result records regardless of how they are sorted.
Has anyone seen this? Does anyone have an idea of how this could be happening?
_________________
Stan
St Petersburg Russia |
 |
 |
wkempees
|
| Posted: 05/13/2008, 4:12 AM |
|
I have not seen this in using Dependent listboxes (Ajax) style nor in CTT.
Just make sure all returned id's (from the query) are unique as a listbox
will not show duplicates!
(?Show output of yr query?)
Walter
|
|
|
|
Stanj
Posts: 166
|
| Posted: 05/13/2008, 4:38 AM |
|
Hi Walter
I looked at the query results as my first step in trying to figure it out. I tried copying the page a few minutes ago( I did not want to experiment with an otherwise working page that is live on a site) and deleted the dependent list box and replaced it with the CCT untility dependent listbox builder and it works perfectly, I see all the expected port call dates.
I'll play some more to see what possibly is going on with this case. I have used the CCS AJAX dependent listbox many times and never ran into this, or that I noticed anyway.
The only reason I noticed it this time was seeing a problem when looking at sales reports and found several port call dates from one ship had very poor bookings through the shopping cart and good sales when booked directly by phone or email. Only one of the popular ships had more than 10 port calls(and another one that is not so popular) this summer here in St Petersburg so it was not noticed with the other 65 cruise ships that we cater to. Most have 9 port calls, mainly because they can't get additional dock assignments, the port can't handle any more of the gigantic 3000 passenger cruise ships. Today we had two of our contract ships at the same time and ended up giving 2-day intensive museum and palace tours for 2,700 visitors.
Thanks for the suggestion, and to CCT for making such good products.
_________________
Stan
St Petersburg Russia |
|
|
|
wkempees
Posts: 1679
|
| Posted: 05/13/2008, 3:15 PM |
|
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
