Hey everybody,
i've been struggling for some hours over something quite simple. I've got two parts of my new website that I want to combine.
- The first part are nodes that represent certain events.
- The second part are images, that are structured on base of this tutorial: http://www.theartlab.net/drupal-school-009-maintainable-gallery, witch all works fine.
What I now want to do, is the gallery to be shown together with a particular event. So, i've added a CCK-node-reference from all the images to the event. I now need to make a block that selects all the images, but only for this specific event. What is the best way to do this? I've tried arguments, witch didn't seem to work for blocks since there's no $arg to apply? I may misunderstood this, but I got really stuck.
I looked further and came to this: http://awebfactory.com.ar/node/320. This method with views_view_add_filter () works great, as long as I use the title to select (after hours of trying and getting more frustrated). When I try to select using the nid from the node-reference, I get this error:
"user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '42')' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node_data_field_masterclass.field_masterclass_nid AS node_data_field_masterclass_field_masterclass_nid FROM node node LEFT JOIN content_type_masterclass_gallery node_data_field_masterclass ON node.vid = node_data_field_masterclass.vid WHERE (node.type = 'masterclass_gallery') AND (.field_masterclass_nid = '42') in /home/mmclass/public_html/includes/database.mysql.inc on line 172."
Does this looks any familiar to anyone? Any tips to get through this?
Thanks in advance, I'll go get some sleep now (03:00)..
J.
