DrupalBin
Submit Code
About
Recent Posts
message i get when running openssl s_client -connect 150.203.86.21:443
Fix for Code
Code
add_to_cart_by_sku_contents()
Fix for page.tpl.php
Page.tpl
foreach is beeing disregarded dispite variable is array. Please help. Outside Drupal it works as standalone.php file
foreach is beeing disregarded dispite variable is array inside drupal. Please help. Outside Drupal it works as standalone.php
Fix for filefield implementation in an admin page. "An HTTP error 0 occurred. /drupal/?q=filefield/ahah///"
PHP Code custom.module
more
User login
Log in using OpenID:
What is OpenID?
Username:
*
Password:
*
Log in using OpenID
Cancel OpenID login
Create new account
Request new password
Tags
CCK
drupal
fapi
jquery
menu
module
php
simpletest
taxonomy
test
theme
views
more tags
Home
›
views sql for node reference/relationship reference
Fix for views sql for node reference/relationship reference
View
Fix
Fixes are not saved to the database until you submit.
Summary:
Tags:
Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Show summary in full view
SELECT node.nid AS nid, node.title AS node_title, node_node_data_field_location_node__location.latitude AS node_node_data_field_location_node__location_latitude, node_node_data_field_location_node__location.longitude AS node_node_data_field_location_node__location_longitude FROM node node LEFT JOIN content_field_location_node node_data_field_location_node ON node.vid = node_data_field_location_node.vid LEFT JOIN node node_node_data_field_location_node ON node_data_field_location_node.field_location_node_nid = node_node_data_field_location_node.nid LEFT JOIN location_instance node_node_data_field_location_node__location_instance ON node_node_data_field_location_node.vid = node_node_data_field_location_node__location_instance.vid LEFT JOIN location node_node_data_field_location_node__location ON node_node_data_field_location_node__location_instance.lid = node_node_data_field_location_node__location.lid WHERE node.type in ('resource')
Syntax highlighting mode:
ActionScript
ColdFusion
Diff
Drupal 5
Drupal 6
HTML
INI
Javascript
MySQL
PHP
Python
robots.txt
SQL
Text
Select the syntax highlighting mode to use.
See Also:
Order
Title:
URL:
-1
0
1
Title:
URL:
-1
0
1
Any links you'd like to have associated with the post (Drupal.org issue, Wikipedia article, etc).
File attachments
Changes made to the attachments are not permanent until you save this post. The first "listed" file will be included in RSS feeds.
Attach new file:
The maximum upload size is
1 MB
. Only files with the following extensions may be uploaded:
jpg jpeg gif png txt doc xls pdf ppt pps odt ods odp phps
.
