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/ ]