- support - lists.drupal.org

db_select()->condition()
by Earnie Boyd 11 Jul '12

11 Jul '12

I have an existing module I'm trying to convert to DBTNG and have a condition I need a suggestion on. Original statement is something like SELECT mt.myvar FROM {mytable} mt WHERE mystring LIKE '%%%s%%'; I want to change it to db_select('mytable', 'mt') ->fields('mt', array('myvar')) ->condtion('mystring', '%:mystring%', LIKE) ->execute(); The problem is condition() only takes three parameters, what would you suggest to use to replace :mystring? I'm using t() but that seems like a misuse of it. -- Earnie -- https://sites.google.com/site/earnieboyd

7 19

Creating a service booking site
by Christian 11 Jul '12

11 Jul '12

Hello, I am new to Drupal (7) and would like to create a homepage where customers can search for services by a various criteria (distance, price range, etc.) and can send out a quote with a proposed price to several of those services. The people providing the service can than accept, decline or answer with a new quote. In a nutshell the requirements are: - While browsing for services one should be able to put them into something shopping cart like to send out the quote later - People offering the service have a profile where they present their business. My question is now how one should go about this? The shopping cart feature sounds like ubercart or eCommerce but to my knowledge there is no possibility to send out a quote proposing a price, is there? And further more, the people offering stuff have to be able to administer there own page. Thanks in advance and any help is greatly appreciated! Regards, Christian

2 1

Drush site alias question
by Anthony 11 Jul '12

11 Jul '12

I have a Drupal install at n:/. I defined some site aliases in the file aliases.drushrc.php defined in the drush dir. When I run *drush sa * I get Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. m:\drush>drush sa *Unable to create N://.drush. [error]* $aliases['dev'] = array( 'root' => 'm:/polamblue', 'uri' => 'http://polamblue.localhost:8080/', ); $aliases['prod'] = array( 'root' => '/home3/polamor1/public_html', 'uri' => 'http://www.polam.org/', ); $aliases['macdev'] = array( 'root' => 'm:/tonymac/public_html/tonymac', 'uri' => 'http://tonymac.localhost:8080/', ); $aliases['macprod'] = array( 'root' => '/home3/tonymacc/public_html/drupal', 'uri' => 'http://www.tony-mac.com/drupal/', ); *Unable to create N://.drush. [error]* I have no idea where to start looking for this error. Googling brings up nothing. Any help greatly appreciated. -- *Anthony Stefan Maciejowski*

1 0

Changing the value of a field
by Mutuku Ndeti 11 Jul '12

11 Jul '12

Dear All, I have a custom field (filefield) that I want to change the filename on a custom tpl file. How do I do this? Thanks. -- Tel:254- 722-490994 www.agile.co.ke | www.jipambe.com

1 0

Multistep form - second form in new page
by Selvam S 11 Jul '12

11 Jul '12

Hi all, I have a multi step form created using FAPI. My form is embedded inside panel's block content. Now I want to open the second form in a modal window (or atleast in a new page), as at the moment my first form is replaced with the second form. Thanks in advance. -- Regards, Selvam KnackForge <http://knackforge.com> Acquia Service Partner <http://knackforge.com/node/54> No. 1, 12th Line, K.K. Road, Venkatapuram, Ambattur, Chennai, Tamil Nadu, India - 600 053.

1 0

Hiding fields in themes(custom tpl)
by Mutuku Ndeti 10 Jul '12

10 Jul '12

I have a custom tpl file for a custom node. I need to hide some fields, but its not working below is my code hide($content['field1']); hide($content['field2']); print render($content); After printing $content, field1 and field2 still shows. what could I be doing wrong? -- Tel:254- 722-490994 www.agile.co.ke | www.jipambe.com

1 1

Really slow Views
by Ms. Nancy Wichmann 10 Jul '12

10 Jul '12

I have a blank page with 4 views placed as blocks in Content Bottom. This page is taking 75 seconds to load. According to Devel, there are 4 queries that comprise the bulk of the time. These are all identified as "_getFeeditemByItemid_block". I cannot find this function on my system. A query that takes 17 seconds (17,000 ms) is unacceptable, and even more so when it is repeated 4 times. Does anyone have any idea what this is and how I might address the slowness? Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

5 6

Solr search and custom filters
by amandil 001 10 Jul '12

10 Jul '12

Hallo, I want to change the default sorting order of a pre-populated Solr search page (the option "Show enabled facets' blocks in their configured regions and first page of all available results" under "Behavior on empty search" of the Advanced Search Options. I thought the solution would be setting a custom filter but I cannot find the right syntax: I tried everything from "solrsort=ds_created:desc" to "sort=created:desc" and all the variants between... but I failed... Anyone may help me please? Thanks, Amandil

1 0

2 content types feeding 2 separate columns on home page
by Jessica Hannan - Halo Digital Design 09 Jul '12

09 Jul '12

I know I can do this, I am just trying to wrap my mind around it. I am developing a theme / website for a media outlet. They need a column for recent articles and a column for recent videos on the home page. They need to be fed blog-style as they are published. What is the best way to go about this? Thank you SO much! You have all been so helpful! Jessica Hannan 815-545-5541 http://www.HaloDigitalDesign.com Join us on Facebook!! http://www.facebook.com/halodigitaldesign

3 2

Modules Disabled After Updates
by Kenneth Jacker 09 Jul '12

09 Jul '12

Drupal7 appears to *disable* modules after updating them. Is that behavior a "bug" or a "feature"? Either way, it sure is inconvenient ... -- Prof Kenneth H Jacker khj(a)cs.appstate.edu Computer Science Dept www.cs.appstate.edu/~khj Appalachian State Univ Boone, NC 28608 USA

6 7