11 Apr
2011
11 Apr
'11
12:55 a.m.
1. When we do a SQL query, if we want to pass value to query, we make use %d for integers or %s for strings. Similarly do we have any place holders for arrays.
2. I am facing a below typical problem, can somebody tell me what should I do?
Below query works fine. SELECT skillid FROM {resubmt_skills} WHERE resubmt_skills.skillname IN (*'PHP', 'HTML', 'SQL'*)
But in above query search string *'PHP', 'HTML', 'SQL' *is hard coded. I want to make the query generic.
Lets say in custom search form, user entered search string PHP, Telecom, HTML,, so how can I write a generic query.
Thanks Austin