teke507
Posts: 69
|
| Posted: 03/26/2007, 12:30 PM |
|
I purchased the CCT Dependent Listbox Builder but found it to be massivly slow delimiting my listboxs and on page load... understandable since they use java....how would i make dependent list boxs with a master of about 100-200 and a slave of about 30,000...the form it will be used in will be used for production and needs to be as fast as posible since they will be using it for every pc. the employee audits.....as it is it takes aboiut 5-10 minutes to load the page then another 5-10 minutes to deliment the listbox once the first selection is made... i dont mind if the page has to refresh but how would i implement such a procedure..
Thanks
-Anthony
|
 |
 |
Damian Hupfeld
|
| Posted: 03/26/2007, 1:22 PM |
|
It takes so long because you have to download all 30,000 records twice. I
dont think there is any way around that.
"teke507" <teke507@forum.codecharge> wrote in message
news:546082d4aeb8a5@news.codecharge.com...
>I purchased the CCT Dependent Listbox Builder but found it to be massivly
>slow
> delimiting my listboxs and on page load... understandable since they use
> java....how would i make dependent list boxs with a master of about
> 100-200
> and a slave of about 30,000...the form it will be used in will be used for
> production and needs to be as fast as posible since they will be using it
> for
> every pc. the employee audits.....as it is it takes aboiut 5-10 minutes
> to
> load the page then another 5-10 minutes to deliment the listbox once the
> first
> selection is made... i dont mind if the page has to refresh but how would
> i
> implement such a procedure..
>
> Thanks
> -Anthony
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
wkempees
|
| Posted: 03/26/2007, 1:32 PM |
|
My approach would be, as you state a page refresh is NO problem,
First listbox as a normal listbox, with a n change submit.
Second listbox, a normal listbox on the second table with a sql where clause
that filters on the valuf of the first listbox but initialy impossible value
resulting in empty listbox
upon submit by the first listbox, having a value by that time, your second
listbox will filter on a correct value.
Depending on the size of the subsets, dataset will be retreived only once
and "small"
You might have to "tell" your form that any insert update andor delete has
to be stopped.
There is an example of a URL state=1 value telling the form not to do any
other validation/update.
If needed I can assist.
Depending on the design of your tables, of course.
Walter
"teke507" <teke507@forum.codecharge> schreef in bericht
news:546082d4aeb8a5@news.codecharge.com...
>I purchased the CCT Dependent Listbox Builder but found it to be massivly
>slow
> delimiting my listboxs and on page load... understandable since they use
> java....how would i make dependent list boxs with a master of about
> 100-200
> and a slave of about 30,000...the form it will be used in will be used for
> production and needs to be as fast as posible since they will be using it
> for
> every pc. the employee audits.....as it is it takes aboiut 5-10 minutes
> to
> load the page then another 5-10 minutes to deliment the listbox once the
> first
> selection is made... i dont mind if the page has to refresh but how would
> i
> implement such a procedure..
>
> Thanks
> -Anthony
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 03/26/2007, 3:46 PM |
|
Your best bet is to use Ajax to do this.
It is not overly difficult, and works quite well.
I do it with tables that also have tens of thousands of records, where the
"parent level" is not a listbox but rather a textbox with a searchable
lookup, after which you get the dependent levels.
|
|
|
|
Damian Hupfeld
|
| Posted: 03/26/2007, 4:13 PM |
|
Similar problem -
I originally posted a workaround that simply displays a "Please wait..."
message but customer doesnt like so -
I have split registration into 2 screens -
On page 1 they choose (in this case) the mobile phone carrier and the retail
group name using dependant list boxes and also the state that their store is
in. This is inserted into the database and they are directed to page 2.
There is an After Insert event to store the last_insert_id() as a session
variable.
On page 2 they see the details they enterred on page 1 plus they get to
choose their store name and a few other details. They choose their store
name from a List Box which is filtered based on their retail group. I want
to also filter this list based on the state that they enterred on page 1 but
I cannot seem to choose the right method or syntax.
I am currently trying to use a hidden field in the form on page 2 and
reference that but am unsure of the right syntax to use when using FORM
controls in the datasource.... any suggestions?
Damian
"wkempees" <kempe819@planet.nl> wrote in message
news:eu9e53$jb4$1@news.codecharge.com...
> My approach would be, as you state a page refresh is NO problem,
> First listbox as a normal listbox, with a n change submit.
> Second listbox, a normal listbox on the second table with a sql where
> clause that filters on the valuf of the first listbox but initialy
> impossible value
> resulting in empty listbox
> upon submit by the first listbox, having a value by that time, your second
> listbox will filter on a correct value.
> Depending on the size of the subsets, dataset will be retreived only once
> and "small"
> You might have to "tell" your form that any insert update andor delete has
> to be stopped.
> There is an example of a URL state=1 value telling the form not to do any
> other validation/update.
>
> If needed I can assist.
> Depending on the design of your tables, of course.
>
> Walter
>
> "teke507" <teke507@forum.codecharge> schreef in bericht
>news:546082d4aeb8a5@news.codecharge.com...
>>I purchased the CCT Dependent Listbox Builder but found it to be massivly
>>slow
>> delimiting my listboxs and on page load... understandable since they use
>> java....how would i make dependent list boxs with a master of about
>> 100-200
>> and a slave of about 30,000...the form it will be used in will be used
>> for
>> production and needs to be as fast as posible since they will be using it
>> for
>> every pc. the employee audits.....as it is it takes aboiut 5-10 minutes
>> to
>> load the page then another 5-10 minutes to deliment the listbox once the
>> first
>> selection is made... i dont mind if the page has to refresh but how would
>> i
>> implement such a procedure..
>>
>> Thanks
>> -Anthony
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
|
Damian Hupfeld
|
| Posted: 03/26/2007, 4:26 PM |
|
Just typical - I post and then I stumble my way across an answer...
Instead of referenceing the FORM I added an OnClick Action - Save Control
Value and stored the state as a session variable.
This allows me to retrieve far smaller record sets.
regards
Damian
"wkempees" <kempe819@planet.nl> wrote in message
news:eu9e53$jb4$1@news.codecharge.com...
> My approach would be, as you state a page refresh is NO problem,
> First listbox as a normal listbox, with a n change submit.
> Second listbox, a normal listbox on the second table with a sql where
> clause that filters on the valuf of the first listbox but initialy
> impossible value
> resulting in empty listbox
> upon submit by the first listbox, having a value by that time, your second
> listbox will filter on a correct value.
> Depending on the size of the subsets, dataset will be retreived only once
> and "small"
> You might have to "tell" your form that any insert update andor delete has
> to be stopped.
> There is an example of a URL state=1 value telling the form not to do any
> other validation/update.
>
> If needed I can assist.
> Depending on the design of your tables, of course.
>
> Walter
>
> "teke507" <teke507@forum.codecharge> schreef in bericht
>news:546082d4aeb8a5@news.codecharge.com...
>>I purchased the CCT Dependent Listbox Builder but found it to be massivly
>>slow
>> delimiting my listboxs and on page load... understandable since they use
>> java....how would i make dependent list boxs with a master of about
>> 100-200
>> and a slave of about 30,000...the form it will be used in will be used
>> for
>> production and needs to be as fast as posible since they will be using it
>> for
>> every pc. the employee audits.....as it is it takes aboiut 5-10 minutes
>> to
>> load the page then another 5-10 minutes to deliment the listbox once the
>> first
>> selection is made... i dont mind if the page has to refresh but how would
>> i
>> implement such a procedure..
>>
>> Thanks
>> -Anthony
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
|
wkempees
|
| Posted: 03/26/2007, 5:11 PM |
|
> Instead of referenceing the FORM I added an OnClick Action - Save Control
> Value and stored the state as a session variable.
> This allows me to retrieve far smaller record sets.
Where did you add the OnClick Action
Walter
|
|
|
|
Damian Hupfeld
|
| Posted: 03/26/2007, 6:11 PM |
|
Sorry - Page1 - Add/Insert Button.
"wkempees" <kempe819@planet.nl> wrote in message
news:eu9qvh$sc7$1@news.codecharge.com...
>> Instead of referenceing the FORM I added an OnClick Action - Save Control
>> Value and stored the state as a session variable.
>> This allows me to retrieve far smaller record sets.
>
> Where did you add the OnClick Action
> Walter
>
>
|
|
|
|
C.I. Richards
|
| Posted: 03/30/2007, 11:34 PM |
|
You can have two pages for the selection and use te ID from one listbox to
filter and select the value in the other listbox. It would be a very fast
approach.
"wkempees" <kempe819@planet.nl> wrote in message
news:eu9e53$jb4$1@news.codecharge.com...
> My approach would be, as you state a page refresh is NO problem,
> First listbox as a normal listbox, with a n change submit.
> Second listbox, a normal listbox on the second table with a sql where
> clause that filters on the valuf of the first listbox but initialy
> impossible value
> resulting in empty listbox
> upon submit by the first listbox, having a value by that time, your second
> listbox will filter on a correct value.
> Depending on the size of the subsets, dataset will be retreived only once
> and "small"
> You might have to "tell" your form that any insert update andor delete has
> to be stopped.
> There is an example of a URL state=1 value telling the form not to do any
> other validation/update.
>
> If needed I can assist.
> Depending on the design of your tables, of course.
>
> Walter
>
> "teke507" <teke507@forum.codecharge> schreef in bericht
>news:546082d4aeb8a5@news.codecharge.com...
>>I purchased the CCT Dependent Listbox Builder but found it to be massivly
>>slow
>> delimiting my listboxs and on page load... understandable since they use
>> java....how would i make dependent list boxs with a master of about
>> 100-200
>> and a slave of about 30,000...the form it will be used in will be used
>> for
>> production and needs to be as fast as posible since they will be using it
>> for
>> every pc. the employee audits.....as it is it takes aboiut 5-10 minutes
>> to
>> load the page then another 5-10 minutes to deliment the listbox once the
>> first
>> selection is made... i dont mind if the page has to refresh but how would
>> i
>> implement such a procedure..
>>
>> Thanks
>> -Anthony
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
|
username
Posts: 24
|
| Posted: 09/13/2007, 4:04 AM |
|
thanks
does any body has any example for ajax in ccs php
please give me example for ajax ccs php
amir.emai [at]yahoo.com
|
|
|
|
|
