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 -> ASP

 Dependent Listbox... again

Print topic Send  topic

Author Message
hfshultz

Posts: 17
Posted: 02/01/2004, 6:09 PM

OK, so I've scoured the forums here including the archives and I haven't come across a clear way to do dependent listboxes without refreshing the page. I need to call a list of categories based on a department listbox and can't figure out how to do it. I have a bunch of fields pre-filled from the URL data, but when the page refreshes after the department listbox is changed, I lose everything but the department listbox value. Yes, it works right but I lose all the other values on the form. If I can make this work right, that would be great, but I'd rather get around the refresh thing and get it to work without that altogether. I've read about the javascript arrays but that was way over my head and I'm hoping there is a better way or that someone can better explain it to me.

Thanks again for all your help... I really appreciate the comraderie on this forum.
View profile  Send private message
Oper_a
Posted: 02/01/2004, 10:20 PM

the same way you send parameters for the listbox to change you need to resend all other paramters on the current page
derylb
Posted: 02/02/2004, 1:46 PM

Here's a good website with an ASP class to generate the Javascript for doing the dependent listboxes without a refresh. I think it's easy to setup and use.

http://www.atgconsulting.com/oodynlistbox.asp

Make sure you get the latest version of the class

http://www.atgconsulting.com/cdynlistbox3.zip
Robert Rodgers
Posted: 02/02/2004, 4:04 PM

I like those but I was never thrilled about sending all the data for each item in the dependant boxes. I like this one
better. but that is only my opinion.
http://www.atgconsulting.com/gofetch.asp


rob

"derylb" <derylb@forum.codecharge> wrote in messagenews:6401ec5462eac8@news.codecharge.com...
> Here's a good website with an ASP class to generate the Javascript for doing the dependent listboxes without a refresh. I
think it's easy to setup and use.
>
> http://www.atgconsulting.com/oodynlistbox.asp
>
> Make sure you get the latest version of the class
>
> http://www.atgconsulting.com/cdynlistbox3.zip
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

hfshultz

Posts: 17
Posted: 02/25/2004, 12:57 PM

I still can't get this to work... the atgconsulting website is good but puts things together piece by piece and I couldn't get it to work at all.

Does anyone had a CCS 2 file with this example in it? I'd really appreciate if I could take a look at a completed page in a CCS project.

Thanks,
Frank
View profile  Send private message
DonB
Posted: 02/25/2004, 1:08 PM

Oooh, I like it!

I did a quick a diirty one myself.
http://www.gotodon.com/examples/dependentlistbox.asp. I decided to accept
the page refresh. Putting it in an external page is definitely clever and
gets around the limitations noted on my example. I suppose one could even
to it in a frame with no height (or width) and not have the popup (although
it's not all that annoying, and you COULD position it at -100,-100 or
something like that)

--
DonB

http://www.gotodon.com/ccbth
Navneet Kakkar
Posted: 02/25/2004, 7:41 PM

Dear Don

Its not working getting an error, page cannot be found.
--
Thanks

luv

Navneet
aquananu@yahoo.com
9811153443
rookie
Posted: 04/16/2004, 11:36 AM

:( Hi.... how can this be implemented in CCS (Access2000, ASP), can you send me the page where you didi it...? Please, im totally lost... :-<:-<:-(
rookie
Posted: 04/16/2004, 1:05 PM

Hi Don...

It seems you are the expert in CCS, I hope you could help me with this...

I've tried to implement http://www.atgconsulting.com/oodynlistbox.asp but I
just cant get it to work, first because CCS use templates, that is .html and
..asp, where and how I have to put that code, and in the page it's all in
pieces...

:( ...how can this be implemented in CCS (Access2000, ASP), can you send me
the page where you did it...? Please, im totally lost... :-<:-<:-(
DonB
Posted: 04/16/2004, 5:07 PM

Here's the approach I took:
http://www.gotodon.com/ccbth/examples/dependentlistbox.asp

I have not tried to implement the one from ATG Consulting, but it should be
without any tricks to it.

--
DonB

http://www.gotodon.com/ccbth
rookie
Posted: 04/17/2004, 4:41 PM

there's an error, it calls the "events" table.... what for?
if I delete the sql call, then the page display this error: Command text was
not set for the command object. (Microsoft JET Database Engine)
hfshultz

Posts: 17
Posted: 04/21/2004, 6:20 AM

When it was all said and done and I had spent countless hours worrying about how to implement dependent listboxes into my application, I ended up using the codecharge FAQ method. It works ok for what I need it to do, but users have to make sure they select that box first or the rest gets cleared when the page refreshes.

The FAQ is at:

http://support.codecharge.com/kb_article.asp?s_keyword=...=&article_id=61
View profile  Send private message
rrodgers
Posted: 04/21/2004, 1:37 PM

Here is an example of dependent list boxes. I like doing it this way but ... everyone has their own preference.

http://www.sylvancomputing.com/ccs/deplist/default.asp

Quote hfshultz:
When it was all said and done and I had spent countless hours worrying about how to implement dependent listboxes into my application, I ended up using the codecharge FAQ method. It works ok for what I need it to do, but users have to make sure they select that box first or the rest gets cleared when the page refreshes.

The FAQ is at:

http://support.codecharge.com/kb_article.asp?s_keyword=...=&article_id=61
wanshamsul
Posted: 04/27/2004, 8:25 PM

guys... most of the examples have only 2 listboxes... well i have four and i do not know what went wrong but for the third listbox, everything went crazy after changes occur... below is the code... pls help

function page_efi_reports1_ppu_name_OnChange()
{
var result;

window.location.href = "report.asp?ppu_name=" + this.value ;

return result;
}

function page_efi_reports1_substation_name_OnChange()
{
var result;

window.location.href = "report.asp?ppu_name=" + efi_reports1.ppu_name.value + "&substation_name=" + this.value;

return result;
}

function page_efi_reports1_feeder_code_OnChange()
{
var result;

window.location.href = "report.asp?ppu_name=" + efi_reports1.ppu_name.value + "&substation_name=" + efi_reports1.substation_name.value + "&feeder_code" + this.value;

return result;
}

the feeder_code listbox depends on the substation_name listbox, and the substation_name listbox depends on the ppu_name listbox... what did i do wrong?

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.