..unless it's multiple values.
It really is best to avoid direct queries of CCK fields. Sometimes fields on the same type will be in content_type_FOO tables or in content_field_FIELD_FOO.
If you are importing alot of data, I can't say enough good things about the Tablewizard and Migrate modules.
http://drupal.org/project/tw http://drupal.org/project/migrate
BTW, the technic that Domenic described is what Migrate module does under the hood.
-Mikey P __________________ Michael Prasuhn 503.512.0822 office 503.539.3864 cell 503.661.7574 home mike@mikeyp.net http://mikeyp.net
On Nov 20, 2009, at 1:45 PM, Paul Kim wrote:
CCK only creates content_field_xxxx when that field is shared between two or more content types. Otherwise, it just adds a column to content_type_yyyy.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Scott Sent: Friday, November 20, 2009 1:07 PM To: support@drupal.org Subject: Re: [support] New CCK field not found in mysql
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/ ]