Vincent
|
| Posted: 07/02/2002, 8:11 AM |
|
Ok let's try to be clear now.... I'm working on a content management system for an intranet application. The administration part of it is a page that displays the list of articles published on the intranet. One field on one of the table is for Article type (News, Quicklinks, IT, etc...) In the main table this is referenced as an integer (News=1, Quicklinks=2, IT=3, etc...) In another table I have the name of each category.
Intranet DB:
Table: content Table: Type
Field: cnt_type <--join--> field: Id
field: label (Name I want to display on page)
What I was trying to say in my first post was that in Codecharge studio I have no idea how to do that if I'm not working within a grid where you can update data. From a listbox you can yes select data source and then do what you want to do with the query builder. but in the case of just displaying data within Html and a table, no forms component (input, listbox, etc...) I can't even find where to access data source, you don't have access to that. In CodeCharge 2.0.5, it was a breeze and easy to realize, a matter of seconds, you just had to go to the property of the table field where data were going to be displayed, choose the output tab and again do what you want to do....
Do I make myself more confusing? :)
Vincent
|
|
|
 |
Chris K.
|
| Posted: 07/02/2002, 9:35 AM |
|
Let's do it step by step. Assuming you want to display a grid containg articles and content type name from other table.
1. Start creating grid using Grid Builder.
2. Select your database connection
3. Selecting Data Source. Now press the button 'Build Query' for custom query.
4. Select your articles and types tables to join
5. If joining fields are not called the same in those two tables you will have to drag one field onto another to create relation. Select cnt_type in content table and drag onto Id field in Type table. Close Visual Query Builder.
6. Now you have fields from both tables available for your grid. Select fields from article and label field from Type table.
7. Finish creating grid. Now you have grid containig fields from both tables.
Another way could be to create a Query in MS Access (if you're using one), joining those two tables in similar way.
|
|
|
|
|
