chris
|
| Posted: 02/25/2003, 11:26 AM |
|
I want to create a window that has two dropdowns on it.
The strange part is the contents of the second dropdown is based off the
selection of the first.
Let say Dropdown1 is CPU and the two options are Intel or AMD. Then
Dropdown2 is the Processors. Obviously I don't want Athlon XP processors
showing in the Dropdown2 if they had choosen Intel in Dropdown1. This is not
the real app but a good example of what I want.
In Dreamweaver/php/mysql, I had to create seperate windows for this.
The first window has one drop down, you make a selection and then click
next.
Then the second window opens with only the dropdown based on the selection
on the prior window.
Can I combine these dropdowns on one window in CodeCharge or CCS and have
them function properly?
Thanks
|
|
|
 |
DAVID
|
| Posted: 02/25/2003, 11:42 AM |
|
Yes both can.
"chris" <chris@ftii.com> wrote in message
news:b3gg1n$epr$1@news.codecharge.com...
> I want to create a window that has two dropdowns on it.
> The strange part is the contents of the second dropdown is based off the
> selection of the first.
> Let say Dropdown1 is CPU and the two options are Intel or AMD. Then
> Dropdown2 is the Processors. Obviously I don't want Athlon XP processors
> showing in the Dropdown2 if they had choosen Intel in Dropdown1. This is
not
> the real app but a good example of what I want.
>
> In Dreamweaver/php/mysql, I had to create seperate windows for this.
> The first window has one drop down, you make a selection and then click
> next.
> Then the second window opens with only the dropdown based on the selection
> on the prior window.
>
> Can I combine these dropdowns on one window in CodeCharge or CCS and have
> them function properly?
>
> Thanks
>
>
|
|
|
|
chris
|
| Posted: 02/25/2003, 11:48 AM |
|
Are there any example sites that have this so I can look at one?
Thanks
"DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
news:b3ggvf$grv$1@news.codecharge.com...
> Yes both can.
>
> "chris" <chris@ftii.com> wrote in message
>news:b3gg1n$epr$1@news.codecharge.com...
> > I want to create a window that has two dropdowns on it.
> > The strange part is the contents of the second dropdown is based off the
> > selection of the first.
> > Let say Dropdown1 is CPU and the two options are Intel or AMD. Then
> > Dropdown2 is the Processors. Obviously I don't want Athlon XP
processors
> > showing in the Dropdown2 if they had choosen Intel in Dropdown1. This is
> not
> > the real app but a good example of what I want.
> >
> > In Dreamweaver/php/mysql, I had to create seperate windows for this.
> > The first window has one drop down, you make a selection and then click
> > next.
> > Then the second window opens with only the dropdown based on the
selection
> > on the prior window.
> >
> > Can I combine these dropdowns on one window in CodeCharge or CCS and
have
> > them function properly?
> >
> > Thanks
> >
> >
>
>
|
|
|
|
DAVID
|
| Posted: 02/25/2003, 12:40 PM |
|
I'm typing hang on a minute
"chris" <chris@ftii.com> wrote in message
news:b3ghaf$hei$1@news.codecharge.com...
> Are there any example sites that have this so I can look at one?
>
> Thanks
>
>
> "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
>news:b3ggvf$grv$1@news.codecharge.com...
> > Yes both can.
> >
> > "chris" <chris@ftii.com> wrote in message
> >news:b3gg1n$epr$1@news.codecharge.com...
> > > I want to create a window that has two dropdowns on it.
> > > The strange part is the contents of the second dropdown is based off
the
> > > selection of the first.
> > > Let say Dropdown1 is CPU and the two options are Intel or AMD. Then
> > > Dropdown2 is the Processors. Obviously I don't want Athlon XP
> processors
> > > showing in the Dropdown2 if they had choosen Intel in Dropdown1. This
is
> > not
> > > the real app but a good example of what I want.
> > >
> > > In Dreamweaver/php/mysql, I had to create seperate windows for this.
> > > The first window has one drop down, you make a selection and then
click
> > > next.
> > > Then the second window opens with only the dropdown based on the
> selection
> > > on the prior window.
> > >
> > > Can I combine these dropdowns on one window in CodeCharge or CCS and
> have
> > > them function properly?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>
|
|
|
|
DAVID
|
| Posted: 02/25/2003, 1:09 PM |
|
1. Say you want to create a search header grid.
you have:
table products (
product_id
, category_id
, manufacturer_id
, product_description
, product_price
)
table categories (
category_id
, category_description
)
table manufacturers (
manufacturer_id
, manufacturer_description
)
2. start with a grid builder with search (source : table products).
Add all fields to the grid
Add category_id,manufacturer_id to the search grid
....
Finish
3. Click onto search element category_id , change control to ListBox.
Change Data Source Type to Table
Change Data Source to categories
Bound Column ->category_id
Data Type ->category_description
4. Click onto search element manufacturer_id , change control to ListBox.
Change Data Source Type to SQL
Change Data Source to "SELECT DISTINCT(manufacturer_id) as
manufacturer_id
,
manufacturer_description
FROM products INNER JOIN
manufacturers on products.manufacturer_id=manufacturers.manufacturer_id
WHERE
products.category_id={category_id}"
Add parameter "category_id"(Integer) -> "category_id" (URL;Default=0)
Bound Column ->manufacturer_id
Data Type ->manufacturer_description
5. Click onto category_id listbox, In Format.Events.onchange type
"Whatevertheformnameis.submit"
Click onto manufacturer_id listbox, In Format.Events.onchange type
"Whatevertheformnameis.submit"
--------------
By default these fields might be genned as s_category_id and
s_manufacturer_id so adjust as it goes.
----------
Expected behaviour:
On load (no search) Search shows all categories but no manufacturers.
Record grid shows all products in db.
Once you search by category, you *might* get some results in the grid ,
if in fact you have products under this category. If this is the case,
Manufacturers should now list all available manufacturers in this category.
Category search should list all categories known, reguardless of of matches
in product table.
--------------
LEmme know if this is confusing :))))
"chris" <chris@ftii.com> wrote in message
news:b3ghaf$hei$1@news.codecharge.com...
> Are there any example sites that have this so I can look at one?
>
> Thanks
>
>
> "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
>news:b3ggvf$grv$1@news.codecharge.com...
> > Yes both can.
> >
> > "chris" <chris@ftii.com> wrote in message
> >news:b3gg1n$epr$1@news.codecharge.com...
> > > I want to create a window that has two dropdowns on it.
> > > The strange part is the contents of the second dropdown is based off
the
> > > selection of the first.
> > > Let say Dropdown1 is CPU and the two options are Intel or AMD. Then
> > > Dropdown2 is the Processors. Obviously I don't want Athlon XP
> processors
> > > showing in the Dropdown2 if they had choosen Intel in Dropdown1. This
is
> > not
> > > the real app but a good example of what I want.
> > >
> > > In Dreamweaver/php/mysql, I had to create seperate windows for this.
> > > The first window has one drop down, you make a selection and then
click
> > > next.
> > > Then the second window opens with only the dropdown based on the
> selection
> > > on the prior window.
> > >
> > > Can I combine these dropdowns on one window in CodeCharge or CCS and
> have
> > > them function properly?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>
|
|
|
|
chris
|
| Posted: 02/25/2003, 2:24 PM |
|
Whoa... LOL
I am not a code charge user (Yet!). This was more of a general question. I
have an upcoming application and it was recommended to use Code Charge
Studio.
I was specifically looking for an example site so I could see this in
action.
Thanks for the detailed message though. It's a good indication of the
support this group provides.
Chris
"DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
news:b3gm33$rtr$1@news.codecharge.com...
> 1. Say you want to create a search header grid.
> you have:
> table products (
> product_id
> , category_id
> , manufacturer_id
> , product_description
> , product_price
> )
>
> table categories (
> category_id
> , category_description
> )
>
> table manufacturers (
> manufacturer_id
> , manufacturer_description
> )
>
> 2. start with a grid builder with search (source : table products).
> Add all fields to the grid
> Add category_id,manufacturer_id to the search grid
> ....
> Finish
> 3. Click onto search element category_id , change control to ListBox.
> Change Data Source Type to Table
> Change Data Source to categories
> Bound Column ->category_id
> Data Type ->category_description
>
> 4. Click onto search element manufacturer_id , change control to ListBox.
> Change Data Source Type to SQL
> Change Data Source to "SELECT DISTINCT(manufacturer_id) as
> manufacturer_id
> ,
> manufacturer_description
> FROM products INNER JOIN
> manufacturers on products.manufacturer_id=manufacturers.manufacturer_id
> WHERE
> products.category_id={category_id}"
> Add parameter "category_id"(Integer) -> "category_id" (URL;Default=0)
> Bound Column ->manufacturer_id
> Data Type ->manufacturer_description
>
> 5. Click onto category_id listbox, In Format.Events.onchange type
> "Whatevertheformnameis.submit"
> Click onto manufacturer_id listbox, In Format.Events.onchange type
> "Whatevertheformnameis.submit"
> --------------
>
> By default these fields might be genned as s_category_id and
> s_manufacturer_id so adjust as it goes.
> ----------
> Expected behaviour:
> On load (no search) Search shows all categories but no manufacturers.
> Record grid shows all products in db.
> Once you search by category, you *might* get some results in the grid
,
> if in fact you have products under this category. If this is the case,
> Manufacturers should now list all available manufacturers in this
category.
> Category search should list all categories known, reguardless of of
matches
> in product table.
>
> --------------
> LEmme know if this is confusing :))))
>
>
>
> "chris" <chris@ftii.com> wrote in message
>news:b3ghaf$hei$1@news.codecharge.com...
> > Are there any example sites that have this so I can look at one?
> >
> > Thanks
> >
> >
> > "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
> >news:b3ggvf$grv$1@news.codecharge.com...
> > > Yes both can.
> > >
> > > "chris" <chris@ftii.com> wrote in message
> > >news:b3gg1n$epr$1@news.codecharge.com...
> > > > I want to create a window that has two dropdowns on it.
> > > > The strange part is the contents of the second dropdown is based off
> the
> > > > selection of the first.
> > > > Let say Dropdown1 is CPU and the two options are Intel or AMD. Then
> > > > Dropdown2 is the Processors. Obviously I don't want Athlon XP
> > processors
> > > > showing in the Dropdown2 if they had choosen Intel in Dropdown1.
This
> is
> > > not
> > > > the real app but a good example of what I want.
> > > >
> > > > In Dreamweaver/php/mysql, I had to create seperate windows for this.
> > > > The first window has one drop down, you make a selection and then
> click
> > > > next.
> > > > Then the second window opens with only the dropdown based on the
> > selection
> > > > on the prior window.
> > > >
> > > > Can I combine these dropdowns on one window in CodeCharge or CCS and
> > have
> > > > them function properly?
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
DAVID
|
| Posted: 02/25/2003, 2:59 PM |
|
Well, actually the easiest way of doing this is not CSS. :)))
Preload a javascript .js file (autogenned via scheduler) that contains
group/subgroup relationships. As user switched groups change subgroup list
via onChange javascript event... That's how most of the people are doing
this...
"chris" <chris@ftii.com> wrote in message
news:b3gqf0$5o3$1@news.codecharge.com...
> Whoa... LOL
>
> I am not a code charge user (Yet!). This was more of a general question.
I
> have an upcoming application and it was recommended to use Code Charge
> Studio.
>
> I was specifically looking for an example site so I could see this in
> action.
>
> Thanks for the detailed message though. It's a good indication of the
> support this group provides.
>
> Chris
>
> "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
>news:b3gm33$rtr$1@news.codecharge.com...
> > 1. Say you want to create a search header grid.
> > you have:
> > table products (
> > product_id
> > , category_id
> > , manufacturer_id
> > , product_description
> > , product_price
> > )
> >
> > table categories (
> > category_id
> > , category_description
> > )
> >
> > table manufacturers (
> > manufacturer_id
> > , manufacturer_description
> > )
> >
> > 2. start with a grid builder with search (source : table products).
> > Add all fields to the grid
> > Add category_id,manufacturer_id to the search grid
> > ....
> > Finish
> > 3. Click onto search element category_id , change control to ListBox.
> > Change Data Source Type to Table
> > Change Data Source to categories
> > Bound Column ->category_id
> > Data Type ->category_description
> >
> > 4. Click onto search element manufacturer_id , change control to
ListBox.
> > Change Data Source Type to SQL
> > Change Data Source to "SELECT DISTINCT(manufacturer_id) as
> > manufacturer_id
> > ,
> > manufacturer_description
> > FROM products INNER JOIN
> > manufacturers on products.manufacturer_id=manufacturers.manufacturer_id
> > WHERE
> > products.category_id={category_id}"
> > Add parameter "category_id"(Integer) -> "category_id"
(URL;Default=0)
> > Bound Column ->manufacturer_id
> > Data Type ->manufacturer_description
> >
> > 5. Click onto category_id listbox, In Format.Events.onchange type
> > "Whatevertheformnameis.submit"
> > Click onto manufacturer_id listbox, In Format.Events.onchange type
> > "Whatevertheformnameis.submit"
> > --------------
> >
> > By default these fields might be genned as s_category_id and
> > s_manufacturer_id so adjust as it goes.
> > ----------
> > Expected behaviour:
> > On load (no search) Search shows all categories but no
manufacturers.
> > Record grid shows all products in db.
> > Once you search by category, you *might* get some results in the
grid
> ,
> > if in fact you have products under this category. If this is the case,
> > Manufacturers should now list all available manufacturers in this
> category.
> > Category search should list all categories known, reguardless of of
> matches
> > in product table.
> >
> > --------------
> > LEmme know if this is confusing :))))
> >
> >
> >
> > "chris" <chris@ftii.com> wrote in message
> >news:b3ghaf$hei$1@news.codecharge.com...
> > > Are there any example sites that have this so I can look at one?
> > >
> > > Thanks
> > >
> > >
> > > "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
> > >news:b3ggvf$grv$1@news.codecharge.com...
> > > > Yes both can.
> > > >
> > > > "chris" <chris@ftii.com> wrote in message
> > > >news:b3gg1n$epr$1@news.codecharge.com...
> > > > > I want to create a window that has two dropdowns on it.
> > > > > The strange part is the contents of the second dropdown is based
off
> > the
> > > > > selection of the first.
> > > > > Let say Dropdown1 is CPU and the two options are Intel or AMD.
Then
> > > > > Dropdown2 is the Processors. Obviously I don't want Athlon XP
> > > processors
> > > > > showing in the Dropdown2 if they had choosen Intel in Dropdown1.
> This
> > is
> > > > not
> > > > > the real app but a good example of what I want.
> > > > >
> > > > > In Dreamweaver/php/mysql, I had to create seperate windows for
this.
> > > > > The first window has one drop down, you make a selection and then
> > click
> > > > > next.
> > > > > Then the second window opens with only the dropdown based on the
> > > selection
> > > > > on the prior window.
> > > > >
> > > > > Can I combine these dropdowns on one window in CodeCharge or CCS
and
> > > have
> > > > > them function properly?
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
DAVID
|
| Posted: 02/25/2003, 3:01 PM |
|
Yet others, preload the whole lookup table (like city/zip code/phone
exchange)
see iwon.com / excite.com /myway.com new user registration.
Tables are preloaded (Java servlets / mod_perl) for ultra fast lookups.
"chris" <chris@ftii.com> wrote in message
news:b3gqf0$5o3$1@news.codecharge.com...
> Whoa... LOL
>
> I am not a code charge user (Yet!). This was more of a general question.
I
> have an upcoming application and it was recommended to use Code Charge
> Studio.
>
> I was specifically looking for an example site so I could see this in
> action.
>
> Thanks for the detailed message though. It's a good indication of the
> support this group provides.
>
> Chris
>
> "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
>news:b3gm33$rtr$1@news.codecharge.com...
> > 1. Say you want to create a search header grid.
> > you have:
> > table products (
> > product_id
> > , category_id
> > , manufacturer_id
> > , product_description
> > , product_price
> > )
> >
> > table categories (
> > category_id
> > , category_description
> > )
> >
> > table manufacturers (
> > manufacturer_id
> > , manufacturer_description
> > )
> >
> > 2. start with a grid builder with search (source : table products).
> > Add all fields to the grid
> > Add category_id,manufacturer_id to the search grid
> > ....
> > Finish
> > 3. Click onto search element category_id , change control to ListBox.
> > Change Data Source Type to Table
> > Change Data Source to categories
> > Bound Column ->category_id
> > Data Type ->category_description
> >
> > 4. Click onto search element manufacturer_id , change control to
ListBox.
> > Change Data Source Type to SQL
> > Change Data Source to "SELECT DISTINCT(manufacturer_id) as
> > manufacturer_id
> > ,
> > manufacturer_description
> > FROM products INNER JOIN
> > manufacturers on products.manufacturer_id=manufacturers.manufacturer_id
> > WHERE
> > products.category_id={category_id}"
> > Add parameter "category_id"(Integer) -> "category_id"
(URL;Default=0)
> > Bound Column ->manufacturer_id
> > Data Type ->manufacturer_description
> >
> > 5. Click onto category_id listbox, In Format.Events.onchange type
> > "Whatevertheformnameis.submit"
> > Click onto manufacturer_id listbox, In Format.Events.onchange type
> > "Whatevertheformnameis.submit"
> > --------------
> >
> > By default these fields might be genned as s_category_id and
> > s_manufacturer_id so adjust as it goes.
> > ----------
> > Expected behaviour:
> > On load (no search) Search shows all categories but no
manufacturers.
> > Record grid shows all products in db.
> > Once you search by category, you *might* get some results in the
grid
> ,
> > if in fact you have products under this category. If this is the case,
> > Manufacturers should now list all available manufacturers in this
> category.
> > Category search should list all categories known, reguardless of of
> matches
> > in product table.
> >
> > --------------
> > LEmme know if this is confusing :))))
> >
> >
> >
> > "chris" <chris@ftii.com> wrote in message
> >news:b3ghaf$hei$1@news.codecharge.com...
> > > Are there any example sites that have this so I can look at one?
> > >
> > > Thanks
> > >
> > >
> > > "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
> > >news:b3ggvf$grv$1@news.codecharge.com...
> > > > Yes both can.
> > > >
> > > > "chris" <chris@ftii.com> wrote in message
> > > >news:b3gg1n$epr$1@news.codecharge.com...
> > > > > I want to create a window that has two dropdowns on it.
> > > > > The strange part is the contents of the second dropdown is based
off
> > the
> > > > > selection of the first.
> > > > > Let say Dropdown1 is CPU and the two options are Intel or AMD.
Then
> > > > > Dropdown2 is the Processors. Obviously I don't want Athlon XP
> > > processors
> > > > > showing in the Dropdown2 if they had choosen Intel in Dropdown1.
> This
> > is
> > > > not
> > > > > the real app but a good example of what I want.
> > > > >
> > > > > In Dreamweaver/php/mysql, I had to create seperate windows for
this.
> > > > > The first window has one drop down, you make a selection and then
> > click
> > > > > next.
> > > > > Then the second window opens with only the dropdown based on the
> > > selection
> > > > > on the prior window.
> > > > >
> > > > > Can I combine these dropdowns on one window in CodeCharge or CCS
and
> > > have
> > > > > them function properly?
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Norbert
|
| Posted: 03/01/2003, 4:40 AM |
|
you can also check this link
http://support.codecharge.com/kb_article.asp?s_keyword=...ent&s_prod=&kb_
articlesPageSize=10&s_type=&order_by=Popularity&s_cat=&article_id=61
/Norbert
|
|
|
|
|
