<: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@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