mindarch
Posts: 30
|
| Posted: 08/30/2005, 6:12 AM |
|
I am still learnig CCS and am having a slightly hard time grasping the more difficult advanced concepts with it.
1 - I have a table with 2 fields (first_name, last_name). I want to have a drop that that lists both the first and last name in the drop down list. How do I accomplish that? I seem to only be able to choose 1 in the properties and haven't found anything that shows differently.
2 - with a similar setup I need to cross reference another table. I have a table witha list of dates and times. I use these for scheduling people. So for member A they may have date/time 1. member B may have date/time 5. So when I show the drop down list of available dates/times I don't want to show the one with id of 1 or the one with id of 5. Just the ones with id of 2, 3, 4, 6.
Any help or pointing to an example would be appreciated.
Stephen
_________________
Mind Architecture
stephen@mindarch.com |
 |
 |
mindarch
Posts: 30
|
| Posted: 08/30/2005, 6:16 AM |
|
Sorry, another thing I'm trying to figure out.
3 - I have a table of members. I also have a table of access rights. On the member edit screen, I can display the list of access rights as checkboxes. When submitted, I want the value of any checked boxes entered into a third table that is a join table between members and access rights. So it would have membersid and access_rightsid, referencing both of the other tables.
Again, any guidance or pointing to examples is appreciated.
Stephen
_________________
Mind Architecture
stephen@mindarch.com |
|
|
|
matheus
Posts: 386
|
| Posted: 08/30/2005, 6:43 AM |
|
Hi,
1 - In dropdown list can change SQL and use concat from fields and using alias.
2 - Need do a SQL query to get NOT IN.
3 - Use Custom Update (or Insert)
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
|
mindarch
Posts: 30
|
| Posted: 08/30/2005, 6:06 PM |
|
Thanks. The first 2 I understand the concept but I will have to play with CCS a bit to figure out how to implement it within that framework.
The third, I'm really not sure how to do a custom update or insert. Is there a sample somewhere?
Stephen
_________________
Mind Architecture
stephen@mindarch.com |
|
|
|
matheus
Posts: 386
|
| Posted: 08/31/2005, 5:10 AM |
|
The third (Custom Update ) it's a property from component Record.
Had Custom Insert, Custom Update and Custom Delete.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
|
Ozum
Posts: 57
|
| Posted: 10/07/2005, 12:53 AM |
|
Hi,
1. You can do a concat:
a. Select Data Source Type of listbox as SQL
b. Enter data source of listbox where you build the SQL. Type your concat SQL such as
SELECT id, name || ' ' || surname AS full_name FROM member
( || is concat for PostgreSQL, so if different consult your SQL manual) You should use 'AS' syntax to properly select it in the bound column of listbox.
2. Enter data source, press + button on the left side and add your condition.
3. There is an exact example how to build many to many checkboxes in the example pack of CodeCharge Studio.
|
|
|
|
|
