Select menu contents dependent upon another select menu sele

[freakingid]

I cannot think of a better way to word that title! Sorry...

I have one table that we can call "Categories."
I have another table that we can call "Subcategories."
Each "subcategory" item has one parent "category" item.
This means "Category 1" might own "Subcat A," "Subcat B," and "Subcat C", and "Category 2" might own "Subcat D," "Subcat E," and "Subcat F."

I would like for people entering data to:
1. Select a "Category" from a select list.
- no problem, dataface makes this easy.

2. Select a "Subcategory" from a select list, but have the contents of that select list change based on the "Category" they choose from the first select list.

Is there a way to do this in Dataface?
Ajaxy stuff?
Or a multi-page insert method? (i.e. the user would select the "Category" on the first page, then the second page would have knowledge of the selected category from a POST variable, perhaps.)

Thanks, Dataface is wonderful.
Paul

[shannah]

[baureggerM]

Hi,
sorry for my English

i have read much of this posts but every time i try something, i always fail.

i will do the same like the guy above:
my valuelist.ini:

[bautl]
__sql__ = "SELECT Bauteile.ID, Bezeichnung FROM Bauteile"

[auspr1]
__sql__ = "SELECT Auspraegung1.ID, CONCAT(Bezeichnung, ' (', Identifikation, ')') FROM Auspraegung1"

my fields.ini:

[Bauteile_ID]
widget:type = select
vocabulary = bautl
group = wichtig
oder = 3

[Auspraegung1_ID]
widget:type = select
vocabulary = auspr1
group=Auswahl
oder = 6

delegate class konfiguration.php:

at the moment there are nothing special


________
Bauteile_ID and Auspraegung1_ID are Fk in the konfiguration table.
also Bauteile_ID is a Fk in the Auspragung1 table.

someone should select Bauteile_ID and then, in Auspragung1_ID only should stay the values with the same ID which are selected above.

thank you for your help
Regards

Max

[auphi]

baureggerM:

This is a really old post. Check out the depselect module: http://xataface.com/dox/modules/depselect/latest/

That should let you do what you are wanting.

[baureggerM]

Hi,

thank you very much at the moment i cant try this.
is this automaticly installed in the newest version of Xataface ?
at the link i can't download the module

thank you

Max

[baureggerM]

Hey,

i copy all files out of the SVN and write the properties in my fields.ini

but in the moment i write "widget:type = depselect"

the whole page is white

Max

[shannah]

Check your php error log to see what the problem is. Likely the depselect module is not installed properly. Make sure you have added the appropriate line to the [_modules] section of your conf.ini and that you have installed the depselect folder inside the modules directory.

-Steve

[baureggerM]

Hi,
this was the error:

[20.02.2013 07:34:30] JavaScript - http://10.29.3.114/#######/index.php?-table=Konfiguration&-action=history&-cursor=2&-skip=0&-limit=30&-mode=list&-recordid=Konfiguration%3FID%3D4
Event thread: mouseup
Uncaught exception: ReferenceError: Undefined variable: activeButton
Error thrown at unknown location in <anonymous function>(event) in http://10.29.3.114/######/index.php?-table=Konfiguration&-action=history&-cursor=2&-skip=0&-limit=30&-mode=list&-recordid=Konfiguration%3FID%3D4:
/* no source available */ <------------- ????????????


the conf.ini :

[_modules]
modules_depselect=modules/depselect/depselect.php


inside of "xataface/modules/depselect" are all the files i found in the VDD

thanks for all Max



______________________________________________________________________________________________________

we update no to the 2.0.0alpha and now all is OK only on the text fields are no drop-down menus
also at the ordinary Select menus the "Other..." function don't work
this is my last problem this tool is very good , and i need only once help !
thanks

great job good tool

[shannah]

Was that a PHP error log or a Javascript error log?

Try moving the depselect module into your application's modules directory. It should work in either location, but it is worth a shot.

-Steve

[baureggerM]

[baureggerM]

[shannah]

Where is that source code snippet taken from? Is this your code or from Xataface file?

[baureggerM]

hey,

this is a javascript output from Dragonfly a Opera Javaskript "debugger" to know what is going wrong.
after press the "Other.." button the ordinary pop up menu -to fill in the new Value- is now at the bottom of the side
after fill in somthing in the Textfilds press save and the the site is pictured doubeld sems like 3D
always have to reload the page then is all ok and the value is saved
i have nothing change this filde should be written from Xataface developers perhapes you

thanks
- Max