Correctly accessing CCK fields in SQL queries | drewish.com

Submitted by Benjamin Melançon on June 5, 2010 - 10:37am

Link Title and URL:

Correctly accessing CCK fields in SQL queries | drewish.com

since CCK can dynamically alter the database schema (when you add a field to a second content type or change the number of values) the query may break.

Fortunately CCK provides functions for finding a field's table and column names so it's simple to do it correctly

Karen Stevenson showed me how to do this ages ago, but i think i documented it in code instead of online, so here's the link to Drewish explaining.

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
Lines and paragraphs break automatically.

User login

Correctly accessing CCK fields in SQL queries | drewish.com

Comments

Post new comment

Search

Agaric?

Agaric Design Collective

Copyright