Damian Hupfeld
|
| Posted: 12/10/2005, 12:23 PM |
|
Hi Sixto,
Does your Dependant Listbox Action work in version 3.0?
I have been trying to get it to work in v3.0 unsuccessfully - but have used
it very happily in version 2.4.
Damian
|
|
|
 |
Damian Hupfeld
|
| Posted: 12/11/2005, 4:03 AM |
|
Anyone out there tried the excellent Dependant Listbox Action from Sixto
with CCS v3?
I have spent many hours going around and around and around...
I am know at the point where I have identified that all the code/steps work
fine until I add the Client Action On Load to the page - it makes all the
values in the listboxes hidden? If I view the page source from the browser I
can see all the options listed - but NONE of them are visible....
1. Add a record form to your page
2. Add the master listbox. Set the list datasource, the bound column and the
text column.
3. Add the slave listbox. Set also the list datasource, but this time, add a
field alias to the field that would be compared against the id of the master
listbox. Name this alias slave_sync
4. In HTML view, move to the HEAD section of the html template, then add a
simple label. Change the Content type to HTML.
5. Select the record form, move to the actions tab in the properties window.
Select BeforeShow and click the plus sign. In the actions window select
Dependant Listboxes.
6. In the properties for the action, set the Master listbox, the Slave
listbox, and the label.
7. Select the page, then add a client action to the onload event. Select
Dependant Listboxes for the action.
8. That's it. Test your form now.
regards
Damian
"Damian Hupfeld" <damian.hupfeld@itng.com.au> wrote in message
news:dnfdgt$3k0$1@news.codecharge.com...
> Hi Sixto,
>
> Does your Dependant Listbox Action work in version 3.0?
> I have been trying to get it to work in v3.0 unsuccessfully - but have
> used it very happily in version 2.4.
>
> Damian
>
>
|
|
|
|
Walter Kempees
|
| Posted: 12/12/2005, 3:20 PM |
|
Readers: Damian and I have been challenging this off-line.
But he doesn't know this yet......
Damian:
It works, I found the problem.
Now I need to know how to edit an xml file, than I can repack the action for
you.
Peterr, if you're watching:
CCS2 and CCS3 have a major difference in building the
record->datasource->SQL
CCS2 : $this->clientid->ds->SQL = "SELECT * FROM client";
CCS3: $this->clientid->datasources->SQL = "SELECT * FROM client {SQL_Where}
{SQL_OrderBy}";
(In a RecordForm.php where client is a listbox and contact the dependant
listbox)
The ->ds->, ->datasource-> is not the problem, the problem lies in the
{SQL_Where) (SQL_OrderBy}
Peterr will probably be able to explain what I am not seeing, but I solved
the Sixto problem by str_replacing the '{SQL_Where) (SQL_OrderBy}' in
Sixto's generated source.
All other Sixto-source will still function.
So now I need someone to tell me a fast way to change the xml, and we're go!
Cheers D.
Walter
"Damian Hupfeld" <damian.hupfeld@itng.com.au> schreef in bericht
news:dnh4jb$rem$1@news.codecharge.com...
> Anyone out there tried the excellent Dependant Listbox Action from Sixto
> with CCS v3?
>
> I have spent many hours going around and around and around...
>
> I am know at the point where I have identified that all the code/steps
> work fine until I add the Client Action On Load to the page - it makes all
> the values in the listboxes hidden? If I view the page source from the
> browser I can see all the options listed - but NONE of them are
> visible....
>
> 1. Add a record form to your page
> 2. Add the master listbox. Set the list datasource, the bound column and
> the text column.
> 3. Add the slave listbox. Set also the list datasource, but this time, add
> a field alias to the field that would be compared against the id of the
> master listbox. Name this alias slave_sync
> 4. In HTML view, move to the HEAD section of the html template, then add a
> simple label. Change the Content type to HTML.
> 5. Select the record form, move to the actions tab in the properties
> window. Select BeforeShow and click the plus sign. In the actions window
> select Dependant Listboxes.
> 6. In the properties for the action, set the Master listbox, the Slave
> listbox, and the label.
> 7. Select the page, then add a client action to the onload event. Select
> Dependant Listboxes for the action.
> 8. That's it. Test your form now.
>
> regards
> Damian
>
>
>
>
> "Damian Hupfeld" <damian.hupfeld@itng.com.au> wrote in message
>news:dnfdgt$3k0$1@news.codecharge.com...
>> Hi Sixto,
>>
>> Does your Dependant Listbox Action work in version 3.0?
>> I have been trying to get it to work in v3.0 unsuccessfully - but have
>> used it very happily in version 2.4.
>>
>> Damian
>>
>>
>
>
|
|
|
|
Walter Kempees
|
| Posted: 12/12/2005, 4:00 PM |
|
Ok So that's done as well.
http://www.consultair.nl/newsite/go.php?m=rbk&t=shw&rbk_id=43
Dependant listboxes as per Sixto's Action
Sleep well, all
Walter
|
|
|
|
Damian Hupfeld
|
| Posted: 12/13/2005, 2:48 AM |
|
Love your work Walter!
Am downloading the updated files now.
Damian
"Walter Kempees" <kempe819@planet.nl> wrote in message
news:dnl2us$ojs$1@news.codecharge.com...
> Ok So that's done as well.
>
> http://www.consultair.nl/newsite/go.php?m=rbk&t=shw&rbk_id=43
>
> Dependant listboxes as per Sixto's Action
>
> Sleep well, all
> Walter
>
>
|
|
|
|
ziggetty
Posts: 20
|
| Posted: 12/13/2005, 1:23 PM |
|
THANX ! Walter
|
 |
|
kirchaj
|
| Posted: 01/03/2006, 1:38 PM |
|
Hey Guys,
thanks for all the hard work on this. I have gotten it to work on one of my listboxes but need to have two different dependent listboxes based on the same master table. There is one main category table, and two subcategory tables based on the main table. I have not had any luck in getting this to work.
Do you have any suggestions?
Thanks again for the effort.
TK
|
|
|
|
Walter Kempees
|
| Posted: 01/03/2006, 2:47 PM |
|
Suggestion is to have a look at ExamplePack2 for registered CCS3 users.
"kirchaj" <kirchaj@forum.codecharge> schreef in bericht
news:543baeef1726d9@news.codecharge.com...
> Hey Guys,
>
> thanks for all the hard work on this. I have gotten it to work on one of
> my
> listboxes but need to have two different dependent listboxes based on
> the
> same master table. There is one main category table, and two subcategory
> tables based on the main table. I have not had any luck in getting this to
> work.
>
>
> Do you have any suggestions?
>
> Thanks again for the effort.
>
> TK
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
glerma
Posts: 56
|
| Posted: 02/01/2006, 7:50 AM |
|
Quote Damian Hupfeld:
I cannot the files for downloading from the link above! Are thse files still available for download?
|
|
|
|
Walter Kempees
|
| Posted: 02/01/2006, 8:38 AM |
|
Back on-line, sorry.............
"glerma" <glerma@forum.codecharge> schreef in bericht
news:543e0d8e1287c3@news.codecharge.com...
> Quote Damian Hupfeld:
>
>
> I cannot the files for downloading from the link above! Are thse files
> still
> available for download?
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
glerma
Posts: 56
|
| Posted: 02/01/2006, 11:34 AM |
|
Thank you kind Sir!
Quote Walter Kempees:
|
|
|
|
DeKemp
|
| Posted: 02/22/2006, 3:56 AM |
|
Kirchaj
Nothing stops you from aliasing the master table and using the alias as child.
|
|
|
|
manuel
|
| Posted: 03/14/2006, 5:54 AM |
|
Im new in CCS, I have 2 questions:
1. exactly what this mean: 3. Add the slave listbox. Set also the list datasource, but this time, add a field alias to the field that would be compared against the id of the master listbox. Name this alias slave_sync
2. How can I implement it with 3 listboxes?
there a ccs project I can Download???
|
|
|
|
StefKe
|
| Posted: 03/14/2006, 6:40 AM |
|
Thanks Walt. This post has been a great help for me. SInce I had to choose a region for a specific country in a tourism database. The 'please select' can not be translated by locale settings. But that is a minor problem.
|
|
|
|
wkempees
|
| Posted: 03/14/2006, 10:55 AM |
|
Stefke,
thanks, I can, at a later stage adapt it to use Locale as well.
Manuel,
No 3 dependant listboxes, just two at the moment.
There is a 3 dependant (and a 2 also) in the examples or examplepack2
somewhere, not using this action.
It's also only PhP.
Your point 1.
Add the slave Listbox, means in your page add another listbox (the one that
is slave to the Master).
When you create the DataSource for that second listbox, you will have to go
into VisualQueryBuilder (VQB) and
give the slave's field to Master an alias "slave_sync"
|
|
|
|
manuel
|
| Posted: 03/14/2006, 1:56 PM |
|
Thanks it work....!
this is far easiest than the CCS example pack...!!! does anybody achieve a 3 list box example using this metod????
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 03/14/2006, 3:32 PM |
|
No, limited to 2 Lboxes at this moment in time.
Maybe in the near future, I have the need myself but other more important items on the table. Sorry
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
manuel
|
| Posted: 03/22/2006, 2:58 PM |
|
May be Yessoftware could look at this approach, and implement it...
There-s a tutorial on how to create plugins for CCS..????
|
|
|
|
WKempees
|
| Posted: 03/23/2006, 3:45 AM |
|
There is a manual for creating components but for CCS2.x
"manuel" <manuel@forum.codecharge> schreef in bericht
news:54421d6a86ea37@news.codecharge.com...
> May be Yessoftware could look at this approach, and implement it...
>
> There-s a tutorial on how to create plugins for CCS..????
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
byhabib
|
| Posted: 03/29/2006, 12:48 AM |
|
Hi Manual
your point 4. In HTML view, move to the HEAD section of the html template, then add a simple label. Change the Content type to HTML.
What name to give to this label and How to change the content type to HTML
Thanks
|
|
|
|
WKempees
|
| Posted: 03/29/2006, 1:37 AM |
|
Name = slave_sync
Change to type HTML in the properties (default right-lower pane in CCS
Designer) of that label.
Remember: insert the label from the Forms toolbox NOT the HTML toolbox.
"byhabib" <byhabib@forum.codecharge> schreef in bericht
news:5442a49e48c5ec@news.codecharge.com...
> Hi Manual
> your point 4. In HTML view, move to the HEAD section of the html template,
> then
> add a simple label. Change the Content type to HTML.
>
> What name to give to this label and How to change the content type to HTML
>
> Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
byhabib
Posts:
|
| Posted: 03/29/2006, 6:58 AM |
|
Thanks a lot !!!!
another question please: how can I download ccsexaplepack2 please.
any idea?
|
|
|
|
WKempees
|
| Posted: 03/29/2006, 8:03 AM |
|
Only available to registered CCS customers.
If registered then download it from the CodeChargeStudio Customer site.
"byhabib" <byhabib@forum.codecharge> schreef in bericht
news:5442aa0903a737@news.codecharge.com...
> Thanks a lot !!!!
> another question please: how can I download ccsexaplepack2 please.
> any idea?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
gpdeering
Posts: 57
|
| Posted: 04/18/2006, 9:30 AM |
|
I'm building a VB.NET 1.1 application. This tweaked "Sixto Solution" has really intrigued me because it's almost built right into CCS.
However, whether I'm doing something wrong or not, it's not working for me. The slave listbox is showing every item in the table (slave_sync is aliased to the field whose value shows up in the master listbox list).
All of my data is in one table, but I don't think that the Sixto solution should care about that. (Or does it matter?)
Any ideas here?
Thanks,
gpdeering
|
|
|
|
WKempees
|
| Posted: 04/18/2006, 1:29 PM |
|
Hi,
It is really targeted at PhP.
Concerning the one table question, I'll have to check don't really know the
answer.
Will get back to you on that.
If you get it to work, with or without my answer I really would like to see
the working code.
In order to maybe extract an extra language solution and built it in the
Dependant Listbox Solution.
Walter
"gpdeering" <gpdeering@forum.codecharge> schreef in bericht
news:54445143d662da@news.codecharge.com...
> I'm building a VB.NET 1.1 application. This tweaked "Sixto Solution" has
> really
> intrigued me because it's almost built right into CCS.
>
> However, whether I'm doing something wrong or not, it's not working for
> me.
> The slave listbox is showing every item in the table (slave_sync is
> aliased to
> the field whose value shows up in the master listbox list).
>
> All of my data is in one table, but I don't think that the Sixto solution
> should care about that. (Or does it matter?)
>
> Any ideas here?
>
>
> Thanks,
>
> gpdeering
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 04/18/2006, 1:37 PM |
|
Gpdeering,
If you are in a hurry and cannot wait for my reply on the one table dependent listboxes, try this:
In your database create an Alias_table on the primary table.
Use the aliased table in the second listbox.
That should work, ....... I think.
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
gpdeering
Posts: 57
|
| Posted: 04/18/2006, 3:44 PM |
|
Hi Walter,
No such luck. However, I am using an MS Access DB (bad idea, I know, but it's all I know right now). Same results as before.
The problem is that the data in the slave listbox is not being refreshed upon selection in the master listbox. I'm not even required to make a selection in the master listbox.
(Actually, the REAL problem is that I'm still a newbie...)
I probably just need to figure out how to refresh the slave listbox.
--Glen
|
|
|
|
gpdeering
Posts: 57
|
| Posted: 04/18/2006, 3:59 PM |
|
Update:
I suppose this should give me a clue as to why it's not working. When I publish the project, I consistently get the following "warning" for each page in my project:
Warning:XSL definition of the Action was not found in the Action's XML file.
I didn't change a thing in the XML files. But, perhaps it is as you implied, developed with only PHP in mind.
--Glen
|
|
|
|
WKempees
|
| Posted: 04/18/2006, 4:06 PM |
|
I am afraid you are on the short end of the stick.
It is a PhP implementation and in that it will accept an aliased single
table.
However, not all is lost.
In the Examplepack is an example of implementing Dependent LBX's, I would
refer to that.
I am not a VB NET adept and therefore probably not in a position to adept
the action.
Am truly sorry.
Walter
"gpdeering" <gpdeering@forum.codecharge> schreef in bericht
news:544456f41d67bb@news.codecharge.com...
> Update:
>
> I suppose this should give me a clue as to why it's not working. When I
> publish the project, I consistently get the following "warning" for each
> page
> in my project:
>
> Warning:XSL definition of the Action was not found in the Action's XML
> file.
>
>
> I didn't change a thing in the XML files. But, perhaps it is as you
> implied,
> developed with only PHP in mind.
>
> --Glen
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
WKempees
|
| Posted: 04/18/2006, 4:07 PM |
|
The XLS/XML warning is in fact generated because no VBNET implementation is
declared in the Action only PhP.
|
|
|
|
