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 |
|
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. |
 |
|
|