>>> Kim Ryan <[EMAIL PROTECTED]> 19/12/05 2:46 PM >>>
Hi,

This is probably a very simple question, but am still unsure how to do 
what I want.

I have a table called tests with a column called code, which holds the 
code id
Another table, result_code has a primary key called code, plus a column
called description

When I  view the tests table, I would like to see the code description 
rather than the code id.

Am trying the following, but the code id is still displayed.
MyDB::Tests->has_a(code => "MyDB::result_code");

Do I have to refer to the column to display form the result of the join, 
such as
MyDB::Tests->has_a(code => "MyDB::result_code::description");

Thanks,

Kim






-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click 
_______________________________________________
Maypole-users mailing list
[email protected] 
https://lists.sourceforge.net/lists/listinfo/maypole-users



This message (including any attachments) is intended solely for the addressee 
named and may contain confidential and privileged information. If you are not 
the intended recipient, please delete it and notify the sender.
Views expressed in this message are those of the individual sender, and are not 
necessarily the views of the Independent Transport Safety and Reliability 
Regulator (ITSRR). Whole or parts of this e-mail may be subject to copyright
of ITSRR or third parties. You should only re-transmit, distribute or use the 
material for commercial purposes if you are authorised to do so.

                        Visit us at:

www.transportregulator.nsw.gov.au  or  Telephone: (02) 8263 7100




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Maypole-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/maypole-users

Reply via email to