I have two columns authorForeNAme and authorLastName and i'm trying to
search against a Full Text index to find a specific author.
i thought i could do this:
SELECT *
FROM author
WHERE CONTAINS(authorForeName, N'B') AND CONTAINS(authorLastName,
N'LYNE')
But it returns zero records. however if i
SELECT *
FROM author
WHERE CONTAINS(authorForeName, N'B') AND CONTAINS(authorLastName,
N'LYNE')
Did you try the above query? Which is a slight derivation on yours.
Teddy R. Payne, ACCFD
Google Talk - teddyrpa...@gmail.com
On Fri, Jan 23, 2009 at 3:42 PM, jonese gig...@gmail.com wrote:
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'N'B''.
___
Eric Jones aka jonese
http://www.jonese.us
http://twitter.com/jonese
On Fri, Jan 23, 2009 at 3:48 PM, Teddy R. Payne teddyrpa...@gmail.comwrote:
SELECT *
FROM author
WHERE CONTAINS(authorForeName, N'B') AND
Still returns zero records.
if i do
select *from author
WHERE CONTAINS(authorLastName, N'LYNE')
i get 6 records, one of those has a forename of B
If i do
select *
from author
WHERE CONTAINS(authorForeName, N'B')
i get zero records
If I do
select *
from author
WHERE CONTAINS(authorForeName,
And this:
SELECT
*
FROM
(
SELECT
*
FROM
author
WHERE
CONTAINS(authorLastName, N'LYNE')
) q1
WHERE
CONTAINS(authorFirstName, N'B')
Teddy R. Payne, ACCFD
Google Talk - teddyrpa...@gmail.com
On Fri, Jan 23, 2009 at 4:11 PM, jonese gig...@gmail.com wrote:
Still returns zero
I'm thinking the index is just not finished being built and this is causing
issues. i'm going to give it a day (or weekend as the case may be) to catch
up and settle down...
thanks for your efforts though teddy!
___
Eric Jones aka jonese
http://www.jonese.us
How big is the table? It shouldn't take long at all to build the indexes.
From: jonese gig...@gmail.com
To: discussion@acfug.org
Sent: Friday, January 23, 2009 4:22:32 PM
Subject: Re: [ACFUG Discuss] Full Text Search Query Question
I'm thinking the index is
Thought you might like this one...
Mary Spencer
This is allegedly true story from the Word Perfect help line.
Word Perfect Technical Desk, may I help you?Yes, well, I'm having trouble
with Word Perfect.What sort of trouble?Well, I was just typing along, and
all of a sudden the words went
Thought you might like this one
Mary Spencer
This is allegedly true story from the Word Perfect help line.
Word Perfect Technical Desk, may I help you?Yes, well, I'm having trouble
with Word Perfect.What sort of trouble?Well, I was just typing along, and
all of a sudden the words went
and then the proctologist said badda boom!
On Sat, Jan 24, 2009 at 12:34 AM, John Mason ma...@fusionlink.com wrote:
Naturally, let's keep the jokes on the community list. Also please change
the subject line since this would be a new thread.
thanks,
John
10 matches
Mail list logo