Thread

Is there any way to write a SQL query that selects/inserts/updates data in a weblog without requiring a separate query to get the field IDs?  I’m interested in doing something like this:

SELECT (
    SELECT CONCAT("field_id_", field_id)
    FROM exp_weblog_fields
    WHERE field_name = "blog-reviewed"
) AS blog_reviewed_values
FROM exp_weblog_data;

I want blog_reviewed_values to be the values from the appropriate column from the exp_weblog_data table, not the string “field_id_4.”

Thanks in advance for the help.

(bump)

If anybody has any insights on this problem, I could use the help.  If I don’t hear back, I may just admit defeat and hard-code the field IDs, but I’m hoping I can automate it for future-proofing.

Thanks again.