Hi All
I tried db_placeholder api, but getting 0 records from query.
The below query works fine, gives me required records.
$query = db_query("SELECT name, email, phone, yrsofexp FROM {resubmt_table}
  WHERE resubmt_table.uid IN (SELECT DISTINCT uid FROM {resubmt_users_skills}
  WHERE resubmt_users_skills.skillid IN(SELECT skillid FROM {resubmt_skills}
  WHERE resubmt_skills.skillname IN ('PHP', 'ITI')))");

Where as the query based on place holders giving 0 records.

$arrSkilll = array('PHP', 'HTML');
$query = db_query("SELECT name, email, phone, yrsofexp FROM {resubmt_table}
  WHERE resubmt_table.uid IN (SELECT DISTINCT uid FROM {resubmt_users_skills}
  WHERE resubmt_users_skills.skillid IN(SELECT skillid FROM {resubmt_skills}
  WHERE resubmt_skills.skillname IN (" . db_placeholders($arrSkilll, 'varchar') . ")))"); 
 
Not sure, whats the wrong here.
 
Regards,
Austin
 
On Mon, Apr 11, 2011 at 7:00 AM, Anth <malkouna@yahoo.com.au> wrote:
Sometimes you can't control what you're getting for your IN statement...

Try something like:

$string = "PHP,HTML,SQL";
$pieces = explode(",", $string);
$in_string = "'" . implode("','", $pieces) . "'";

On 6:59 AM, nan wich wrote:
In Drupal code, you should never find a query with %s that is not surrounded by quotes. To do what you are looking for check the db_placeholders function in the API docs.
 

Nancy

 

Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.



From: Austin Einter <austin.einter@gmail.com>
To: support@drupal.org
Sent: Sun, April 10, 2011 8:23:57 PM
Subject: [support] String conversion

Hi
I have a below string.
PHP, HTML, SQL
Want to convert it to
'PHP', 'HTML', 'SQL'
 
I tried to write a function to do it as below. If I print the function output it prints properly.
If same function output I use for SQL query as below I get warning.
 
Query:    SELECT skillid FROM {resubmt_skills}   WHERE resubmt_skills.skillname IN (%s)", $fSkill
Warning:   SELECT skillid FROM resubmt_skills WHERE resubmt_skills.skillname IN (\'ITI\',\' PHP\'))) in C:\MyWeb6.20\wamp\www\livejobs1\sites\default\modules\resume_search\resume_search.module on line 140.
 
Looks it has extra forward slashes. How can I overcome this.
 
Thanks
Austin
 
 
 

--
[ Drupal support list | http://lists.drupal.org/ ]