CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Too slow dependent listboxes...

Print topic Send  topic

Author Message
Alvaro Cobo
Posted: 05/07/2005, 4:02 PM

Hi guys:

I have personalized the 3 dependent lisboxes in the CodeCharge Example Pack
2, from a data source of province, city, and parish as the three dependent
listboxes, which are something like 1000 records in the bigger table.

The problem is that the page takes a lot of time to be loaded (15 seconds in
a medium size test server) because the php script has to build the
javascript array into the same page (var src_parrish = new Array(
new Array('1316','13','Parrish1'),
new Array('2302','23','Parrish2'), etc... until 1000 records to be fetched).

I think the solution is to build the array externally into a static page,
and call it from the onchange event in the listbox tag in the HTML code
(onchange="set_child_listbox(this,
document.tbl_f1Bases1.s_ParrOB,src_parrish,'src_parrish');")

My question is:

Is it possible to refer the source of this onchange event, from an external
page/script?. If so, does anybody could help me with a clue to do it?.

Thanks a lot and best regards,

Alvaro Cobo.

PD: The problem is not in the sql query or the server. I have tested them
alone and works perfectly.


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.