[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