[support] String conversion

nan wich nan_wich at bellsouth.net
Mon Apr 11 00:51:25 UTC 2011


<:avglsdata id=avglsdata> 
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 at gmail.com>
To: support at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110410/0cf020b1/attachment-0001.html 


More information about the support mailing list