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