Author Topic: How can I get value of custom field (Read 1235 times)

ViJu · July 26, 2007, 07:52:20 am

I use CiviCrm 1.6 and Drupal 5,

I need get value of one custom field of contact,

if I get it by query
SELECT custom_field_id, char_data FROM civicrm_custom_value c WHERE entity_id = $orgid and (custom_field_id = 1 or custom_field_id = 14
when error occurred:
SELECT command denied to user 'j'@'localhost' for table 'civicrm_custom_value']

speleo · July 26, 2007, 08:48:53 am

Do you have rights to the database as 'j'@'localhost' ? You can check this by issuing SHOW GRANTS ;

You are also missing a closing bracket

SELECT custom_field_id, char_data FROM civicrm_custom_value c WHERE entity_id = $orgid and (custom_field_id = 1 or custom_field_id = 14)

ViJu · July 26, 2007, 01:31:48 pm

I thought where is another way get values from custom fields,

e.g. I tried crm_get_contact(array('contact_id' => 111)),
with individuals it works, but with organisations it is't work,
I don't understand why

Dave Greenberg · July 26, 2007, 03:10:32 pm

Unfortunately we don't have sufficient resources to support older versions of CiviCRM. If you can recreate this problem on the current release (1.8 beta) - please file an issue on the issue tracker.

CiviCRM Community Forums (archive)

News:

Author Topic: How can I get value of custom field (Read 1235 times)

ViJu

How can I get value of custom field

speleo

Re: How can I get value of custom field

ViJu

Re: How can I get value of custom field

Dave Greenberg

Re: How can I get value of custom field