Search results to error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Site Related Discussions

Search results to error

Author

Topic

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-02 : 04:10:39

If I search anything enclosed by double quotes, the page gives error

Search for "madhivanan"
Match exact phrase

results to

Microsoft OLE DB Provider for SQL Server error '80040e14'

Syntax error near 'madhivanan' in the full-text search condition '""madhivanan""'.

/forums/search_mssqlft.asp, line 180

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-01-15 : 01:10:06

Any replies?

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-15 : 01:33:08

quote:
Originally posted by madhivanan

Any replies?

Madhivanan

Failing to plan is Planning to fail

Its working for me Madhi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-15 : 01:38:57

Yup you're right Madhi
It errors when you select match exact phrases and uses double quotes

Kristen
Test

22859 Posts

Posted - 2010-01-15 : 03:08:48

Submit ticket, Wait three months, Check on ticket.

Clearly not a regular customer then Madhi! That would be "wait 1 second" ...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-01-15 : 04:08:48

quote:
Originally posted by Kristen

Submit ticket, Wait three months, Check on ticket.

Clearly not a regular customer then Madhi! That would be "wait 1 second" ...

I forgot this until I saw http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138368

Madhivanan

Failing to plan is Planning to fail

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2010-01-15 : 09:16:55

I can't replicate this problem. I searched on an exact phrase and it worked without problem. Were there any other options you chose?

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

Kristen
Test

22859 Posts

Posted - 2010-01-15 : 09:25:22

Fails here too:

http://www.sqlteam.com/forums/search.asp

Search for = "madhivanan"
Choose "Match exact phrase"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2010-01-15 : 09:43:42

Ah. It's the quotes that are causing the problem. Ok, let me look into that.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2010-01-17 : 11:01:22

This is fixed. I'm pretty sure I didn't make any new errors but let me know if there are any problems.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources