CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Subcategories listbox

Print topic Send  topic

Author Message
Pepi Txispi
Posted: 12/11/2003, 9:27 AM

Hi Guys,

got another question for you...

I have...Table Categories 1, table subcategories 1.1, table subcategories
1.1.1..and so on.

I want to construct a search form with a list box with the "Table Categories
1" categories, and when selected one of them, a second listbox with the
"table subcategories 1.1" shows up (just with the subcategories chosen) and
when selected a new list box with the subcategories from table 1.1.1 shows
up...and so on.

The last thing: if no more subcategories exists for a particular category or
subcategory, the matching final products must be shown.

I have seen this in several websites but I cannot find the proper manual to
have a look at.

Using CCS 2.2.40 with asp 3.0 and access as a databse.

Any help will be greatly appreciated.

Thanks




Pepi Txispi
Posted: 12/11/2003, 10:32 AM

Playing with it a little bit, I can make it in Access... check this out,
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
however, how can I implement it within codecharge studio?


"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:bra9di$6ib$1@news.codecharge.com...
> Hi Guys,
>
> got another question for you...
>
> I have...Table Categories 1, table subcategories 1.1, table subcategories
> 1.1.1..and so on.
>
> I want to construct a search form with a list box with the "Table
Categories
> 1" categories, and when selected one of them, a second listbox with the
> "table subcategories 1.1" shows up (just with the subcategories chosen)
and
> when selected a new list box with the subcategories from table 1.1.1 shows
> up...and so on.
>
> The last thing: if no more subcategories exists for a particular category
or
> subcategory, the matching final products must be shown.
>
> I have seen this in several websites but I cannot find the proper manual
to
> have a look at.
>
> Using CCS 2.2.40 with asp 3.0 and access as a databse.
>
> Any help will be greatly appreciated.
>
> Thanks
>
>
>
>
>

DonB
Posted: 12/11/2003, 11:31 AM

The hard way is to try doing it without refreshing the entire screen. I
think some have had success putting the controls in IFRAMEs. But CCS has
(or used to have) problems with IFRAMES.

The easier way is to load the Where property of the listbox's datasource
based on the "parent" control, so that you modify the listbox contents based
on some parameter value. There will be a round-trip to the server each time
the parent changes.

Generally, the problem is referred to using the phrase "dependent listbox".

You might find the ExamplePack to be helpful - there is a popup listbox
example that could accomplish this task although not the exact appearance
you are trying to produce.

--
DonB

http://www.gotodon.com/ccbth


"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:brad7l$asi$1@news.codecharge.com...
> Playing with it a little bit, I can make it in Access... check this out,
> http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> however, how can I implement it within codecharge studio?
>
>
> "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
>news:bra9di$6ib$1@news.codecharge.com...
> > Hi Guys,
> >
> > got another question for you...
> >
> > I have...Table Categories 1, table subcategories 1.1, table
subcategories
> > 1.1.1..and so on.
> >
> > I want to construct a search form with a list box with the "Table
> Categories
> > 1" categories, and when selected one of them, a second listbox with the
> > "table subcategories 1.1" shows up (just with the subcategories chosen)
> and
> > when selected a new list box with the subcategories from table 1.1.1
shows
> > up...and so on.
> >
> > The last thing: if no more subcategories exists for a particular
category
> or
> > subcategory, the matching final products must be shown.
> >
> > I have seen this in several websites but I cannot find the proper manual
> to
> > have a look at.
> >
> > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> >
> > Any help will be greatly appreciated.
> >
> > Thanks
> >
> >
> >
> >
> >
>
>

Pepi Txispi
Posted: 12/11/2003, 11:53 AM

wow, I am still a rookie trying CCS (I will problaby buy next week)...is
there any example or chunks of code I can look at, or something to help? is
it possible to follow the procedure shown in the website (1 st post) that
works well with access in CCS?
I mean, adding a "after execute event">"add action" to the 1st list box, and
so on ?
Also, you mentioned a method refreshing the webpage...could you please tell
us more about that?


Any help is welcome!!

Thanks for your help!!!!
"DonB" <~ccbth~@gotodon.com> wrote in message
news:bragmi$f0s$1@news.codecharge.com...
> The hard way is to try doing it without refreshing the entire screen. I
> think some have had success putting the controls in IFRAMEs. But CCS has
> (or used to have) problems with IFRAMES.
>
> The easier way is to load the Where property of the listbox's datasource
> based on the "parent" control, so that you modify the listbox contents
based
> on some parameter value. There will be a round-trip to the server each
time
> the parent changes.
>
> Generally, the problem is referred to using the phrase "dependent
listbox".
>
> You might find the ExamplePack to be helpful - there is a popup listbox
> example that could accomplish this task although not the exact appearance
> you are trying to produce.
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
>news:brad7l$asi$1@news.codecharge.com...
> > Playing with it a little bit, I can make it in Access... check this out,
> >
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> > however, how can I implement it within codecharge studio?
> >
> >
> > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> >news:bra9di$6ib$1@news.codecharge.com...
> > > Hi Guys,
> > >
> > > got another question for you...
> > >
> > > I have...Table Categories 1, table subcategories 1.1, table
> subcategories
> > > 1.1.1..and so on.
> > >
> > > I want to construct a search form with a list box with the "Table
> > Categories
> > > 1" categories, and when selected one of them, a second listbox with
the
> > > "table subcategories 1.1" shows up (just with the subcategories
chosen)
> > and
> > > when selected a new list box with the subcategories from table 1.1.1
> shows
> > > up...and so on.
> > >
> > > The last thing: if no more subcategories exists for a particular
> category
> > or
> > > subcategory, the matching final products must be shown.
> > >
> > > I have seen this in several websites but I cannot find the proper
manual
> > to
> > > have a look at.
> > >
> > > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> > >
> > > Any help will be greatly appreciated.
> > >
> > > Thanks
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>

DonB
Posted: 12/11/2003, 4:11 PM

If you would go to my site and click through the banner to them for your
purchase, I'd really appreciate that because I'll get a little fee for that.

I have very little more info regarding the IFRAME, just that I heard people
doing that . If you gotto http://www.gotocode.com/community.asp and check
the notes there I know it's been covered a lot.


As to another approach...

Try this:

Create a form with two listboxes: a "parent" and a "child'. They should
each have datasources sharing this relationship
(let's assume the child datasource has a foreign key of "parent_id")
Change the form from method="post" to method="get"
Add this client event to the <SELECT> tag of the parent:
onchange="javascript:this.form.submit()"
Modify the datasource of the child to have a "where" that is like:
parent_id=parent_id (type set to URL)

So now, each time you select a parent_id in the parent listbox, the form
submits and the child listbox reloads with all child records where parent_id
= the URL parameter "parent_id"


--
DonB

http://www.gotodon.com/ccbth


"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:brahvb$gh8$1@news.codecharge.com...
> wow, I am still a rookie trying CCS (I will problaby buy next week)...is
> there any example or chunks of code I can look at, or something to help?
is
> it possible to follow the procedure shown in the website (1 st post) that
> works well with access in CCS?
> I mean, adding a "after execute event">"add action" to the 1st list box,
and
> so on ?
> Also, you mentioned a method refreshing the webpage...could you please
tell
> us more about that?
>
>
> Any help is welcome!!
>
> Thanks for your help!!!!
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:bragmi$f0s$1@news.codecharge.com...
> > The hard way is to try doing it without refreshing the entire screen. I
> > think some have had success putting the controls in IFRAMEs. But CCS
has
> > (or used to have) problems with IFRAMES.
> >
> > The easier way is to load the Where property of the listbox's datasource
> > based on the "parent" control, so that you modify the listbox contents
> based
> > on some parameter value. There will be a round-trip to the server each
> time
> > the parent changes.
> >
> > Generally, the problem is referred to using the phrase "dependent
> listbox".
> >
> > You might find the ExamplePack to be helpful - there is a popup listbox
> > example that could accomplish this task although not the exact
appearance
> > you are trying to produce.
> >
> > --
> > DonB
> >
> > http://www.gotodon.com/ccbth
> >
> >
> > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> >news:brad7l$asi$1@news.codecharge.com...
> > > Playing with it a little bit, I can make it in Access... check this
out,
> > >
> http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> > > however, how can I implement it within codecharge studio?
> > >
> > >
> > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > >news:bra9di$6ib$1@news.codecharge.com...
> > > > Hi Guys,
> > > >
> > > > got another question for you...
> > > >
> > > > I have...Table Categories 1, table subcategories 1.1, table
> > subcategories
> > > > 1.1.1..and so on.
> > > >
> > > > I want to construct a search form with a list box with the "Table
> > > Categories
> > > > 1" categories, and when selected one of them, a second listbox with
> the
> > > > "table subcategories 1.1" shows up (just with the subcategories
> chosen)
> > > and
> > > > when selected a new list box with the subcategories from table 1.1.1
> > shows
> > > > up...and so on.
> > > >
> > > > The last thing: if no more subcategories exists for a particular
> > category
> > > or
> > > > subcategory, the matching final products must be shown.
> > > >
> > > > I have seen this in several websites but I cannot find the proper
> manual
> > > to
> > > > have a look at.
> > > >
> > > > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> > > >
> > > > Any help will be greatly appreciated.
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Pepi Txispi
Posted: 12/11/2003, 5:34 PM

Thanks for your tips!!
Of course I will buy the software through your site!
Do you know how good is to pay $ 149.00 for the 1 year online support? I am
not sure about that.

About the list box, I will try your code and I will post the results here.

Thanks again!!
"DonB" <~ccbth~@gotodon.com> wrote in message
news:brb12k$3od$1@news.codecharge.com...
> If you would go to my site and click through the banner to them for your
> purchase, I'd really appreciate that because I'll get a little fee for
that.
>
> I have very little more info regarding the IFRAME, just that I heard
people
> doing that . If you gotto http://www.gotocode.com/community.asp and check
> the notes there I know it's been covered a lot.
>
>
> As to another approach...
>
> Try this:
>
> Create a form with two listboxes: a "parent" and a "child'. They should
> each have datasources sharing this relationship
> (let's assume the child datasource has a foreign key of "parent_id")
> Change the form from method="post" to method="get"
> Add this client event to the <SELECT> tag of the parent:
> onchange="javascript:this.form.submit()"
> Modify the datasource of the child to have a "where" that is like:
> parent_id=parent_id (type set to URL)
>
> So now, each time you select a parent_id in the parent listbox, the form
> submits and the child listbox reloads with all child records where
parent_id
> = the URL parameter "parent_id"
>
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
>news:brahvb$gh8$1@news.codecharge.com...
> > wow, I am still a rookie trying CCS (I will problaby buy next week)...is
> > there any example or chunks of code I can look at, or something to help?
> is
> > it possible to follow the procedure shown in the website (1 st post)
that
> > works well with access in CCS?
> > I mean, adding a "after execute event">"add action" to the 1st list box,
> and
> > so on ?
> > Also, you mentioned a method refreshing the webpage...could you please
> tell
> > us more about that?
> >
> >
> > Any help is welcome!!
> >
> > Thanks for your help!!!!
> > "DonB" <~ccbth~@gotodon.com> wrote in message
> >news:bragmi$f0s$1@news.codecharge.com...
> > > The hard way is to try doing it without refreshing the entire screen.
I
> > > think some have had success putting the controls in IFRAMEs. But CCS
> has
> > > (or used to have) problems with IFRAMES.
> > >
> > > The easier way is to load the Where property of the listbox's
datasource
> > > based on the "parent" control, so that you modify the listbox contents
> > based
> > > on some parameter value. There will be a round-trip to the server
each
> > time
> > > the parent changes.
> > >
> > > Generally, the problem is referred to using the phrase "dependent
> > listbox".
> > >
> > > You might find the ExamplePack to be helpful - there is a popup
listbox
> > > example that could accomplish this task although not the exact
> appearance
> > > you are trying to produce.
> > >
> > > --
> > > DonB
> > >
> > > http://www.gotodon.com/ccbth
> > >
> > >
> > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > >news:brad7l$asi$1@news.codecharge.com...
> > > > Playing with it a little bit, I can make it in Access... check this
> out,
> > > >
> >
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> > > > however, how can I implement it within codecharge studio?
> > > >
> > > >
> > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > >news:bra9di$6ib$1@news.codecharge.com...
> > > > > Hi Guys,
> > > > >
> > > > > got another question for you...
> > > > >
> > > > > I have...Table Categories 1, table subcategories 1.1, table
> > > subcategories
> > > > > 1.1.1..and so on.
> > > > >
> > > > > I want to construct a search form with a list box with the "Table
> > > > Categories
> > > > > 1" categories, and when selected one of them, a second listbox
with
> > the
> > > > > "table subcategories 1.1" shows up (just with the subcategories
> > chosen)
> > > > and
> > > > > when selected a new list box with the subcategories from table
1.1.1
> > > shows
> > > > > up...and so on.
> > > > >
> > > > > The last thing: if no more subcategories exists for a particular
> > > category
> > > > or
> > > > > subcategory, the matching final products must be shown.
> > > > >
> > > > > I have seen this in several websites but I cannot find the proper
> > manual
> > > > to
> > > > > have a look at.
> > > > >
> > > > > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> > > > >
> > > > > Any help will be greatly appreciated.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

DonB
Posted: 12/11/2003, 7:25 PM

Can't say - up to you. I'd guess they might have another release within a
year's time which would be handy to get at no additional cost (I have NO
knowledge whatsoever of when, or what, they plan for the future). If you
really get stuck, then the priority support could help you, too if you need
some help and need it right now.

--
DonB

http://www.gotodon.com/ccbth


"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:brb5uo$9ij$1@news.codecharge.com...
> Thanks for your tips!!
> Of course I will buy the software through your site!
> Do you know how good is to pay $ 149.00 for the 1 year online support? I
am
> not sure about that.
>
> About the list box, I will try your code and I will post the results here.
>
> Thanks again!!
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:brb12k$3od$1@news.codecharge.com...
> > If you would go to my site and click through the banner to them for your
> > purchase, I'd really appreciate that because I'll get a little fee for
> that.
> >
> > I have very little more info regarding the IFRAME, just that I heard
> people
> > doing that . If you gotto http://www.gotocode.com/community.asp and
check
> > the notes there I know it's been covered a lot.
> >
> >
> > As to another approach...
> >
> > Try this:
> >
> > Create a form with two listboxes: a "parent" and a "child'. They should
> > each have datasources sharing this relationship
> > (let's assume the child datasource has a foreign key of "parent_id")
> > Change the form from method="post" to method="get"
> > Add this client event to the <SELECT> tag of the parent:
> > onchange="javascript:this.form.submit()"
> > Modify the datasource of the child to have a "where" that is like:
> > parent_id=parent_id (type set to URL)
> >
> > So now, each time you select a parent_id in the parent listbox, the form
> > submits and the child listbox reloads with all child records where
> parent_id
> > = the URL parameter "parent_id"
> >
> >
> > --
> > DonB
> >
> > http://www.gotodon.com/ccbth
> >
> >
> > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> >news:brahvb$gh8$1@news.codecharge.com...
> > > wow, I am still a rookie trying CCS (I will problaby buy next
week)...is
> > > there any example or chunks of code I can look at, or something to
help?
> > is
> > > it possible to follow the procedure shown in the website (1 st post)
> that
> > > works well with access in CCS?
> > > I mean, adding a "after execute event">"add action" to the 1st list
box,
> > and
> > > so on ?
> > > Also, you mentioned a method refreshing the webpage...could you please
> > tell
> > > us more about that?
> > >
> > >
> > > Any help is welcome!!
> > >
> > > Thanks for your help!!!!
> > > "DonB" <~ccbth~@gotodon.com> wrote in message
> > >news:bragmi$f0s$1@news.codecharge.com...
> > > > The hard way is to try doing it without refreshing the entire
screen.
> I
> > > > think some have had success putting the controls in IFRAMEs. But
CCS
> > has
> > > > (or used to have) problems with IFRAMES.
> > > >
> > > > The easier way is to load the Where property of the listbox's
> datasource
> > > > based on the "parent" control, so that you modify the listbox
contents
> > > based
> > > > on some parameter value. There will be a round-trip to the server
> each
> > > time
> > > > the parent changes.
> > > >
> > > > Generally, the problem is referred to using the phrase "dependent
> > > listbox".
> > > >
> > > > You might find the ExamplePack to be helpful - there is a popup
> listbox
> > > > example that could accomplish this task although not the exact
> > appearance
> > > > you are trying to produce.
> > > >
> > > > --
> > > > DonB
> > > >
> > > > http://www.gotodon.com/ccbth
> > > >
> > > >
> > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > >news:brad7l$asi$1@news.codecharge.com...
> > > > > Playing with it a little bit, I can make it in Access... check
this
> > out,
> > > > >
> > >
> http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> > > > > however, how can I implement it within codecharge studio?
> > > > >
> > > > >
> > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > >news:bra9di$6ib$1@news.codecharge.com...
> > > > > > Hi Guys,
> > > > > >
> > > > > > got another question for you...
> > > > > >
> > > > > > I have...Table Categories 1, table subcategories 1.1, table
> > > > subcategories
> > > > > > 1.1.1..and so on.
> > > > > >
> > > > > > I want to construct a search form with a list box with the
"Table
> > > > > Categories
> > > > > > 1" categories, and when selected one of them, a second listbox
> with
> > > the
> > > > > > "table subcategories 1.1" shows up (just with the subcategories
> > > chosen)
> > > > > and
> > > > > > when selected a new list box with the subcategories from table
> 1.1.1
> > > > shows
> > > > > > up...and so on.
> > > > > >
> > > > > > The last thing: if no more subcategories exists for a particular
> > > > category
> > > > > or
> > > > > > subcategory, the matching final products must be shown.
> > > > > >
> > > > > > I have seen this in several websites but I cannot find the
proper
> > > manual
> > > > > to
> > > > > > have a look at.
> > > > > >
> > > > > > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> > > > > >
> > > > > > Any help will be greatly appreciated.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Pepi Txispi
Posted: 12/15/2003, 8:36 AM

Hi again, I can make it work up to the next level but I cannot go further,
letīs say, once I have the results for the 2nd list box, I would like to
click o none of the choices, and get the same effect, showing up in the 3rd
listbox just the subcategory chosen in listbox2 (that comes form list box 1)

I really would like to know how to achieve this result.

Help, please!!!


"DonB" <~ccbth~@gotodon.com> wrote in message
news:brbcg4$hcg$1@news.codecharge.com...
> Can't say - up to you. I'd guess they might have another release within a
> year's time which would be handy to get at no additional cost (I have NO
> knowledge whatsoever of when, or what, they plan for the future). If you
> really get stuck, then the priority support could help you, too if you
need
> some help and need it right now.
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
>news:brb5uo$9ij$1@news.codecharge.com...
> > Thanks for your tips!!
> > Of course I will buy the software through your site!
> > Do you know how good is to pay $ 149.00 for the 1 year online support? I
> am
> > not sure about that.
> >
> > About the list box, I will try your code and I will post the results
here.
> >
> > Thanks again!!
> > "DonB" <~ccbth~@gotodon.com> wrote in message
> >news:brb12k$3od$1@news.codecharge.com...
> > > If you would go to my site and click through the banner to them for
your
> > > purchase, I'd really appreciate that because I'll get a little fee for
> > that.
> > >
> > > I have very little more info regarding the IFRAME, just that I heard
> > people
> > > doing that . If you gotto http://www.gotocode.com/community.asp and
> check
> > > the notes there I know it's been covered a lot.
> > >
> > >
> > > As to another approach...
> > >
> > > Try this:
> > >
> > > Create a form with two listboxes: a "parent" and a "child'. They
should
> > > each have datasources sharing this relationship
> > > (let's assume the child datasource has a foreign key of "parent_id")
> > > Change the form from method="post" to method="get"
> > > Add this client event to the <SELECT> tag of the parent:
> > > onchange="javascript:this.form.submit()"
> > > Modify the datasource of the child to have a "where" that is like:
> > > parent_id=parent_id (type set to URL)
> > >
> > > So now, each time you select a parent_id in the parent listbox, the
form
> > > submits and the child listbox reloads with all child records where
> > parent_id
> > > = the URL parameter "parent_id"
> > >
> > >
> > > --
> > > DonB
> > >
> > > http://www.gotodon.com/ccbth
> > >
> > >
> > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > >news:brahvb$gh8$1@news.codecharge.com...
> > > > wow, I am still a rookie trying CCS (I will problaby buy next
> week)...is
> > > > there any example or chunks of code I can look at, or something to
> help?
> > > is
> > > > it possible to follow the procedure shown in the website (1 st post)
> > that
> > > > works well with access in CCS?
> > > > I mean, adding a "after execute event">"add action" to the 1st list
> box,
> > > and
> > > > so on ?
> > > > Also, you mentioned a method refreshing the webpage...could you
please
> > > tell
> > > > us more about that?
> > > >
> > > >
> > > > Any help is welcome!!
> > > >
> > > > Thanks for your help!!!!
> > > > "DonB" <~ccbth~@gotodon.com> wrote in message
> > > >news:bragmi$f0s$1@news.codecharge.com...
> > > > > The hard way is to try doing it without refreshing the entire
> screen.
> > I
> > > > > think some have had success putting the controls in IFRAMEs. But
> CCS
> > > has
> > > > > (or used to have) problems with IFRAMES.
> > > > >
> > > > > The easier way is to load the Where property of the listbox's
> > datasource
> > > > > based on the "parent" control, so that you modify the listbox
> contents
> > > > based
> > > > > on some parameter value. There will be a round-trip to the server
> > each
> > > > time
> > > > > the parent changes.
> > > > >
> > > > > Generally, the problem is referred to using the phrase "dependent
> > > > listbox".
> > > > >
> > > > > You might find the ExamplePack to be helpful - there is a popup
> > listbox
> > > > > example that could accomplish this task although not the exact
> > > appearance
> > > > > you are trying to produce.
> > > > >
> > > > > --
> > > > > DonB
> > > > >
> > > > > http://www.gotodon.com/ccbth
> > > > >
> > > > >
> > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > >news:brad7l$asi$1@news.codecharge.com...
> > > > > > Playing with it a little bit, I can make it in Access... check
> this
> > > out,
> > > > > >
> > > >
> >
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> > > > > > however, how can I implement it within codecharge studio?
> > > > > >
> > > > > >
> > > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > > >news:bra9di$6ib$1@news.codecharge.com...
> > > > > > > Hi Guys,
> > > > > > >
> > > > > > > got another question for you...
> > > > > > >
> > > > > > > I have...Table Categories 1, table subcategories 1.1, table
> > > > > subcategories
> > > > > > > 1.1.1..and so on.
> > > > > > >
> > > > > > > I want to construct a search form with a list box with the
> "Table
> > > > > > Categories
> > > > > > > 1" categories, and when selected one of them, a second listbox
> > with
> > > > the
> > > > > > > "table subcategories 1.1" shows up (just with the
subcategories
> > > > chosen)
> > > > > > and
> > > > > > > when selected a new list box with the subcategories from table
> > 1.1.1
> > > > > shows
> > > > > > > up...and so on.
> > > > > > >
> > > > > > > The last thing: if no more subcategories exists for a
particular
> > > > > category
> > > > > > or
> > > > > > > subcategory, the matching final products must be shown.
> > > > > > >
> > > > > > > I have seen this in several websites but I cannot find the
> proper
> > > > manual
> > > > > > to
> > > > > > > have a look at.
> > > > > > >
> > > > > > > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> > > > > > >
> > > > > > > Any help will be greatly appreciated.
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Pepi Txispi
Posted: 12/15/2003, 9:11 AM

So, I insert a custom code for the 1st list box (On Change Client)

//Custom Code @89-2A29BDB7

window.location.href = "users.asp?category_id=" + this.value ;

//End Custom Code

and works for the 1st listbox: retrieves the names of the subcategory 1 on
listbox2 , based on the election from listbox1

Now I want to do the same with listbox2: click on any value on listbox2,
retrieves the names of the subcategory 2 on listbox3 , based on the election
from listbox2

What should the code be?

Form: store_categoriesSearch
listbox1: s_category_name
listbox2: subcat01
listbox3: subcat02

the tables and relationships are: see pic attached (donīt pay attention to
the 4th subcat, I wanna make it work for 3 levels first!!!)


I am ***kinda*** stuck here....



"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:brknv6$rdp$1@news.codecharge.com...
> Hi again, I can make it work up to the next level but I cannot go further,
> letīs say, once I have the results for the 2nd list box, I would like to
> click o none of the choices, and get the same effect, showing up in the
3rd
> listbox just the subcategory chosen in listbox2 (that comes form list box
1)
>
> I really would like to know how to achieve this result.
>
> Help, please!!!
>
>
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:brbcg4$hcg$1@news.codecharge.com...
> > Can't say - up to you. I'd guess they might have another release within
a
> > year's time which would be handy to get at no additional cost (I have NO
> > knowledge whatsoever of when, or what, they plan for the future). If
you
> > really get stuck, then the priority support could help you, too if you
> need
> > some help and need it right now.
> >
> > --
> > DonB
> >
> > http://www.gotodon.com/ccbth
> >
> >
> > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> >news:brb5uo$9ij$1@news.codecharge.com...
> > > Thanks for your tips!!
> > > Of course I will buy the software through your site!
> > > Do you know how good is to pay $ 149.00 for the 1 year online support?
I
> > am
> > > not sure about that.
> > >
> > > About the list box, I will try your code and I will post the results
> here.
> > >
> > > Thanks again!!
> > > "DonB" <~ccbth~@gotodon.com> wrote in message
> > >news:brb12k$3od$1@news.codecharge.com...
> > > > If you would go to my site and click through the banner to them for
> your
> > > > purchase, I'd really appreciate that because I'll get a little fee
for
> > > that.
> > > >
> > > > I have very little more info regarding the IFRAME, just that I heard
> > > people
> > > > doing that . If you gotto http://www.gotocode.com/community.asp and
> > check
> > > > the notes there I know it's been covered a lot.
> > > >
> > > >
> > > > As to another approach...
> > > >
> > > > Try this:
> > > >
> > > > Create a form with two listboxes: a "parent" and a "child'. They
> should
> > > > each have datasources sharing this relationship
> > > > (let's assume the child datasource has a foreign key of
"parent_id")
> > > > Change the form from method="post" to method="get"
> > > > Add this client event to the <SELECT> tag of the parent:
> > > > onchange="javascript:this.form.submit()"
> > > > Modify the datasource of the child to have a "where" that is like:
> > > > parent_id=parent_id (type set to URL)
> > > >
> > > > So now, each time you select a parent_id in the parent listbox, the
> form
> > > > submits and the child listbox reloads with all child records where
> > > parent_id
> > > > = the URL parameter "parent_id"
> > > >
> > > >
> > > > --
> > > > DonB
> > > >
> > > > http://www.gotodon.com/ccbth
> > > >
> > > >
> > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > >news:brahvb$gh8$1@news.codecharge.com...
> > > > > wow, I am still a rookie trying CCS (I will problaby buy next
> > week)...is
> > > > > there any example or chunks of code I can look at, or something to
> > help?
> > > > is
> > > > > it possible to follow the procedure shown in the website (1 st
post)
> > > that
> > > > > works well with access in CCS?
> > > > > I mean, adding a "after execute event">"add action" to the 1st
list
> > box,
> > > > and
> > > > > so on ?
> > > > > Also, you mentioned a method refreshing the webpage...could you
> please
> > > > tell
> > > > > us more about that?
> > > > >
> > > > >
> > > > > Any help is welcome!!
> > > > >
> > > > > Thanks for your help!!!!
> > > > > "DonB" <~ccbth~@gotodon.com> wrote in message
> > > > >news:bragmi$f0s$1@news.codecharge.com...
> > > > > > The hard way is to try doing it without refreshing the entire
> > screen.
> > > I
> > > > > > think some have had success putting the controls in IFRAMEs.
But
> > CCS
> > > > has
> > > > > > (or used to have) problems with IFRAMES.
> > > > > >
> > > > > > The easier way is to load the Where property of the listbox's
> > > datasource
> > > > > > based on the "parent" control, so that you modify the listbox
> > contents
> > > > > based
> > > > > > on some parameter value. There will be a round-trip to the
server
> > > each
> > > > > time
> > > > > > the parent changes.
> > > > > >
> > > > > > Generally, the problem is referred to using the phrase
"dependent
> > > > > listbox".
> > > > > >
> > > > > > You might find the ExamplePack to be helpful - there is a popup
> > > listbox
> > > > > > example that could accomplish this task although not the exact
> > > > appearance
> > > > > > you are trying to produce.
> > > > > >
> > > > > > --
> > > > > > DonB
> > > > > >
> > > > > > http://www.gotodon.com/ccbth
> > > > > >
> > > > > >
> > > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > > >news:brad7l$asi$1@news.codecharge.com...
> > > > > > > Playing with it a little bit, I can make it in Access... check
> > this
> > > > out,
> > > > > > >
> > > > >
> > >
> http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> > > > > > > however, how can I implement it within codecharge studio?
> > > > > > >
> > > > > > >
> > > > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > > > >news:bra9di$6ib$1@news.codecharge.com...
> > > > > > > > Hi Guys,
> > > > > > > >
> > > > > > > > got another question for you...
> > > > > > > >
> > > > > > > > I have...Table Categories 1, table subcategories 1.1, table
> > > > > > subcategories
> > > > > > > > 1.1.1..and so on.
> > > > > > > >
> > > > > > > > I want to construct a search form with a list box with the
> > "Table
> > > > > > > Categories
> > > > > > > > 1" categories, and when selected one of them, a second
listbox
> > > with
> > > > > the
> > > > > > > > "table subcategories 1.1" shows up (just with the
> subcategories
> > > > > chosen)
> > > > > > > and
> > > > > > > > when selected a new list box with the subcategories from
table
> > > 1.1.1
> > > > > > shows
> > > > > > > > up...and so on.
> > > > > > > >
> > > > > > > > The last thing: if no more subcategories exists for a
> particular
> > > > > > category
> > > > > > > or
> > > > > > > > subcategory, the matching final products must be shown.
> > > > > > > >
> > > > > > > > I have seen this in several websites but I cannot find the
> > proper
> > > > > manual
> > > > > > > to
> > > > > > > > have a look at.
> > > > > > > >
> > > > > > > > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> > > > > > > >
> > > > > > > > Any help will be greatly appreciated.
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

DonB
Posted: 12/15/2003, 1:23 PM

I think you are asking how do you reference the other listbox, because you
realize that "this.value" refers to the current listbox. My limited
javascript says use "document.listbox3.value". I think you wan to set the
window.location.href like you already did - except you need to append
"&"subcat03="+ document.listbox3.value.

As I said, I'm not a javascript expert, but this should get you looking in
the right direction.

--
DonB

http://www.gotodon.com/ccbth


"Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
news:brkpvq$tu0$1@news.codecharge.com...
> So, I insert a custom code for the 1st list box (On Change Client)
>
> //Custom Code @89-2A29BDB7
>
> window.location.href = "users.asp?category_id=" + this.value ;
>
> //End Custom Code
>
> and works for the 1st listbox: retrieves the names of the subcategory 1 on
> listbox2 , based on the election from listbox1
>
> Now I want to do the same with listbox2: click on any value on listbox2,
> retrieves the names of the subcategory 2 on listbox3 , based on the
election
> from listbox2
>
> What should the code be?
>
> Form: store_categoriesSearch
> listbox1: s_category_name
> listbox2: subcat01
> listbox3: subcat02
>
> the tables and relationships are: see pic attached (donīt pay attention to
> the 4th subcat, I wanna make it work for 3 levels first!!!)
>
>
> I am ***kinda*** stuck here....
>
>
>
> "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
>news:brknv6$rdp$1@news.codecharge.com...
> > Hi again, I can make it work up to the next level but I cannot go
further,
> > letīs say, once I have the results for the 2nd list box, I would like to
> > click o none of the choices, and get the same effect, showing up in the
> 3rd
> > listbox just the subcategory chosen in listbox2 (that comes form list
box
> 1)
> >
> > I really would like to know how to achieve this result.
> >
> > Help, please!!!
> >
> >
> > "DonB" <~ccbth~@gotodon.com> wrote in message
> >news:brbcg4$hcg$1@news.codecharge.com...
> > > Can't say - up to you. I'd guess they might have another release
within
> a
> > > year's time which would be handy to get at no additional cost (I have
NO
> > > knowledge whatsoever of when, or what, they plan for the future). If
> you
> > > really get stuck, then the priority support could help you, too if you
> > need
> > > some help and need it right now.
> > >
> > > --
> > > DonB
> > >
> > > http://www.gotodon.com/ccbth
> > >
> > >
> > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > >news:brb5uo$9ij$1@news.codecharge.com...
> > > > Thanks for your tips!!
> > > > Of course I will buy the software through your site!
> > > > Do you know how good is to pay $ 149.00 for the 1 year online
support?
> I
> > > am
> > > > not sure about that.
> > > >
> > > > About the list box, I will try your code and I will post the results
> > here.
> > > >
> > > > Thanks again!!
> > > > "DonB" <~ccbth~@gotodon.com> wrote in message
> > > >news:brb12k$3od$1@news.codecharge.com...
> > > > > If you would go to my site and click through the banner to them
for
> > your
> > > > > purchase, I'd really appreciate that because I'll get a little fee
> for
> > > > that.
> > > > >
> > > > > I have very little more info regarding the IFRAME, just that I
heard
> > > > people
> > > > > doing that . If you gotto http://www.gotocode.com/community.asp
and
> > > check
> > > > > the notes there I know it's been covered a lot.
> > > > >
> > > > >
> > > > > As to another approach...
> > > > >
> > > > > Try this:
> > > > >
> > > > > Create a form with two listboxes: a "parent" and a "child'. They
> > should
> > > > > each have datasources sharing this relationship
> > > > > (let's assume the child datasource has a foreign key of
> "parent_id")
> > > > > Change the form from method="post" to method="get"
> > > > > Add this client event to the <SELECT> tag of the parent:
> > > > > onchange="javascript:this.form.submit()"
> > > > > Modify the datasource of the child to have a "where" that is like:
> > > > > parent_id=parent_id (type set to URL)
> > > > >
> > > > > So now, each time you select a parent_id in the parent listbox,
the
> > form
> > > > > submits and the child listbox reloads with all child records where
> > > > parent_id
> > > > > = the URL parameter "parent_id"
> > > > >
> > > > >
> > > > > --
> > > > > DonB
> > > > >
> > > > > http://www.gotodon.com/ccbth
> > > > >
> > > > >
> > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > >news:brahvb$gh8$1@news.codecharge.com...
> > > > > > wow, I am still a rookie trying CCS (I will problaby buy next
> > > week)...is
> > > > > > there any example or chunks of code I can look at, or something
to
> > > help?
> > > > > is
> > > > > > it possible to follow the procedure shown in the website (1 st
> post)
> > > > that
> > > > > > works well with access in CCS?
> > > > > > I mean, adding a "after execute event">"add action" to the 1st
> list
> > > box,
> > > > > and
> > > > > > so on ?
> > > > > > Also, you mentioned a method refreshing the webpage...could you
> > please
> > > > > tell
> > > > > > us more about that?
> > > > > >
> > > > > >
> > > > > > Any help is welcome!!
> > > > > >
> > > > > > Thanks for your help!!!!
> > > > > > "DonB" <~ccbth~@gotodon.com> wrote in message
> > > > > >news:bragmi$f0s$1@news.codecharge.com...
> > > > > > > The hard way is to try doing it without refreshing the entire
> > > screen.
> > > > I
> > > > > > > think some have had success putting the controls in IFRAMEs.
> But
> > > CCS
> > > > > has
> > > > > > > (or used to have) problems with IFRAMES.
> > > > > > >
> > > > > > > The easier way is to load the Where property of the listbox's
> > > > datasource
> > > > > > > based on the "parent" control, so that you modify the listbox
> > > contents
> > > > > > based
> > > > > > > on some parameter value. There will be a round-trip to the
> server
> > > > each
> > > > > > time
> > > > > > > the parent changes.
> > > > > > >
> > > > > > > Generally, the problem is referred to using the phrase
> "dependent
> > > > > > listbox".
> > > > > > >
> > > > > > > You might find the ExamplePack to be helpful - there is a
popup
> > > > listbox
> > > > > > > example that could accomplish this task although not the exact
> > > > > appearance
> > > > > > > you are trying to produce.
> > > > > > >
> > > > > > > --
> > > > > > > DonB
> > > > > > >
> > > > > > > http://www.gotodon.com/ccbth
> > > > > > >
> > > > > > >
> > > > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > > > >news:brad7l$asi$1@news.codecharge.com...
> > > > > > > > Playing with it a little bit, I can make it in Access...
check
> > > this
> > > > > out,
> > > > > > > >
> > > > > >
> > > >
> >
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/683875
> > > > > > > > however, how can I implement it within codecharge studio?
> > > > > > > >
> > > > > > > >
> > > > > > > > "Pepi Txispi" <pepitxispi@telefonica.net> wrote in message
> > > > > > > >news:bra9di$6ib$1@news.codecharge.com...
> > > > > > > > > Hi Guys,
> > > > > > > > >
> > > > > > > > > got another question for you...
> > > > > > > > >
> > > > > > > > > I have...Table Categories 1, table subcategories 1.1,
table
> > > > > > > subcategories
> > > > > > > > > 1.1.1..and so on.
> > > > > > > > >
> > > > > > > > > I want to construct a search form with a list box with the
> > > "Table
> > > > > > > > Categories
> > > > > > > > > 1" categories, and when selected one of them, a second
> listbox
> > > > with
> > > > > > the
> > > > > > > > > "table subcategories 1.1" shows up (just with the
> > subcategories
> > > > > > chosen)
> > > > > > > > and
> > > > > > > > > when selected a new list box with the subcategories from
> table
> > > > 1.1.1
> > > > > > > shows
> > > > > > > > > up...and so on.
> > > > > > > > >
> > > > > > > > > The last thing: if no more subcategories exists for a
> > particular
> > > > > > > category
> > > > > > > > or
> > > > > > > > > subcategory, the matching final products must be shown.
> > > > > > > > >
> > > > > > > > > I have seen this in several websites but I cannot find the
> > > proper
> > > > > > manual
> > > > > > > > to
> > > > > > > > > have a look at.
> > > > > > > > >
> > > > > > > > > Using CCS 2.2.40 with asp 3.0 and access as a databse.
> > > > > > > > >
> > > > > > > > > Any help will be greatly appreciated.
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


   


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.