Chris Seymour
|
| Posted: 04/23/2002, 6:10 AM |
|
Hi All,
I have a field called member_id which joins two tables. From the 2nd table
I want to display 2 fields say fname and lname. I know I can modify the
code generated to do this, is it possible to do from within CodeCharge
directly?
Thanks.
|
|
|
 |
Alistair McFadyen
|
| Posted: 04/23/2002, 7:03 AM |
|
Chris
You could handle it in your SQL statement with something like "SELECT
[fname] & " " & [lname] AS fullname
FROM tblNames"
Alistair McFadyen
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:91F95A2F3cseymourseywarecom@66.180.229.147...
> Hi All,
> I have a field called member_id which joins two tables. From the 2nd
table
> I want to display 2 fields say fname and lname. I know I can modify the
> code generated to do this, is it possible to do from within CodeCharge
> directly?
>
> Thanks.
|
|
|
|
Alexey Alexapolsky
|
| Posted: 04/23/2002, 7:39 AM |
|
If you refer to listbox you can achieve desired functionality but
entering sql statement into fiel properties/list tab/lookup sql ,
field list should consist of id and name fields , e.g.
select id,name from table
field order matters.
if you need to use some script variable , it's done this way :
(ASP)
select id,name from table where id = " & script_variable &"
--
Alex
CodeCharge Developer
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:91F95A2F3cseymourseywarecom@66.180.229.147...
> Hi All,
> I have a field called member_id which joins two tables. From the 2nd
table
> I want to display 2 fields say fname and lname. I know I can modify the
> code generated to do this, is it possible to do from within CodeCharge
> directly?
>
> Thanks.
|
|
|
|
|
