bowtellj
Posts: 65
|
| Posted: 08/04/2007, 12:46 AM |
|
How do I show a label as a text value instead of an integer. The label does not have similar options to the list box.
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
 |
 |
TheunisP
Posts: 342
|
| Posted: 08/04/2007, 1:54 AM |
|
James, what is the problem - I think that when it hits the screen it is pretty much not an intger or text - so I assume you want it in a specific format?
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 08/04/2007, 4:23 AM |
|
I have a column in my grid called categoryid and I cannot figure out how to show the friendly field name instead of the primary key......
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
TheunisP
Posts: 342
|
| Posted: 08/04/2007, 4:32 AM |
|
so the cat id points to another table with cat id & name
open visual query builder (select grid, click on table in the properties - on the left click the ...)
right click in huge white area, add table - add your cat table
ccs will attempt to link if it fails, just click on the cat id in the original table, hold mouse button down and drop it on the cat id in the new table
check cat name
ok
go to lable
change to text type
and select cat name from the drop down
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 08/04/2007, 4:46 AM |
|
Great, worked a treat. Have a beer on me.
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 08/04/2007, 5:00 AM |
|
hmmmmm. While this showed the field name correctly it also filtered the records and did not show any with a null value. Is this normal.
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
TheunisP
Posts: 342
|
| Posted: 08/04/2007, 6:50 AM |
|
ok, get back into visual query builder - right click on th cat id link line
pic edit link (or do they say join cant remember - but pick 2bd from top I think it is an edit)
select the radio button that says that it should display all records from the main table even if there is no relationship
|
|
|
|
bowtellj
Posts: 65
|
| Posted: 08/04/2007, 4:45 PM |
|
Perfect. Oh and I am sorry, I drank your beer.....
Thanks
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
|
