Ken
Posts: 13
|
| Posted: 10/13/2005, 2:00 PM |
|
I want to make the "link" field in an auto-generated grid contain multiple fields from a table. For example, in a table of "people", I want the link to be "{Last_Name}, {First_Name}". This is easy to do in SQL and Php, but I can't seem to figure out how to do it in CCS. I tried just moving the {First_Name} 'Label' next to the {Last_Name} link, within the <a></a>, but then nothing gets displayed - last or first name!
Thanks for any help...
|
 |
 |
peterr
Posts: 5971
|
| Posted: 10/13/2005, 4:43 PM |
|
It's probably best to do this in SQL as you mentioned - concatenate 2 fields. Once your grid is based on such SQL then you will have only 1 field/column returned by the SQL, which you can then use with one CCS field.
Also see: http://forums.codecharge.com/search.php?s_keyword=conca...m[]=5&s_period=
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
DonB
|
| Posted: 10/14/2005, 1:15 PM |
|
You could just make both labels into links, with the same href.
Easy way to do this from scratch is to add the first link, define it's href
and any parameters needed, then copy/paste it and go back and change the
datasource to the appropriate column. Repeat the paste for as many links as
you need (e.g., first, middle, and last names).
--
DonB
http://www.gotodon.com/ccbth
"Ken" <Ken@forum.codecharge> wrote in message
news:2434ecb057b14b@news.codecharge.com...
> I want to make the "link" field in an auto-generated grid contain multiple
> fields from a table. For example, in a table of "people", I want the link
to be
> "{Last_Name}, {First_Name}". This is easy to do in SQL and Php, but I
can't seem
> to figure out how to do it in CCS. I tried just moving the {First_Name}
'Label'
> next to the {Last_Name} link, within the <a></a>, but then nothing gets
> displayed - last or first name!
>
> Thanks for any help...
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
