The content_database_info() function gives you the storage information you need to build your custom queries. You can do something like:
$field = content_fields($field_name); $db_info = content_database_info($field); $sql = db_fetch_array(db_query('SELECT nid FROM {'. $db_info['table'] . '} WHERE '. $db_info['columns']['value'] .' = %d',$product_id));
See the PHPdoc for more details.
Yves Chedemois
William Smith a ecrit le 20/11/2009 22:49:
Absolutely. One of the things you'll find to is that where data is stored will shift on you depending on whether the field is isolated to one node type only or if it is shared, etc.. As Domenic said, it really is best to use the regular node api for this sort of thing rather than try to cram it in via direct SQL queries against the DB.
On Fri, Nov 20, 2009 at 4:41 PM, Domenic Santangelo <domenics@gmail.com mailto:domenics@gmail.com> wrote:
CCK is black magic... better not to try and decipher the db structure which at times seems kind of arbitrary to me. The better way is to write a fn that loops thru the nodes you want to batch add to, do a node_load() on them, modify the desired fields, then node_save(). HTH, -Dom On Nov 20, 2009, at 1:07 PM, Scott wrote: > I found where the data went by exporting the sites database. Rather > than create a new table named content_field_street_name, as I would > have > expected, it created content_type_[content_type_name]. This table has > fields: vid, nid and field_street_name_value. I'm about out of time > today but I wonder what would've happened had I added two new fields > to > this CCK type. > > > On Fri, 2009-11-20 at 12:07 -0800, Scott wrote: >> I've created a new field for a CCK type and it works fine in my >> drupal >> site. My problem is that it does not show up in mysql command line >> interface or with phpmyadmin. This is confusing to me. I can >> modify, >> add and delete data using the edit node function when viewing a >> page, so >> I know the data is somewhere, however, I wish to do a batch load of >> this >> field with mysql. >> > > -- > [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]