Query

[Socheat Net]

Hi all, I have problem with search form, i have created form for searching data, below is my example. When user type keyword "Economics Review" it will transfer the keyword to compare with sql query if it found Economics it will dispaly Economics and Review is found will also display but i want to find only the keyword "Economics Review"

Socheat

[Imran Khan Pathan]

Which Query string are you using?

GOD HELP THOSE WHO HELP THEMSELVES

[Colin Angus Mackay]

Socheat.Net wrote:

below is my example

I don't see any code in this post. What example?

Socheat.Net wrote:

When user type keyword "Economics Review" it will transfer the keyword to compare with sql query if it found Economics it will dispaly Economics and Review is found will also display but i want to find only the keyword "Economics Review"

So what code do you have already?

---

Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Ready to Give up - Your help will be much appreciated. My website

[PrakashBhaskar]

try using like statement by the following way coz i had the same issue and i have succeed with the below technique select * from where like '%Economics%' and like '%Review%'

Regards Prakash-B

[Socheat Net]

Thanks, but not what i want

Socheat

[Chetan Ranpariya]

HI, Try the follwing way. select * from where like '%Economics Review%' I hope this will help you.

Thanks and Regards, Chetan Ranpariya