This does not seem to work:
CREATE Procedure getSearchResults2
(
@search nvarchar(4000)
)
as
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, @search') b
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
GO
It always treats @search as NULL. What's wrong with my syntax here?
Thanks!
Casey
3 6128
I should be more clear:
DECLARE @SearchWord nvarchar(4000)
SET @SearchWord = 'tax'
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, @SearchWord')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
This returns no results. But this...
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, tax')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
returns over 500 results
????????
Please! Can nobody help? I am really stuck here!
Casey
you have two opening ( but one closing, not sure if that makes a difference in my scripting languages it would
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, tax'))
also your variable up there has quotation around it you might try removing the quotation
Sign in to post your reply or Sign up for a free account.
Similar topics
by: HumanJHawkins |
last post by:
Hi,
I have a table of text. I need to search for whole words within this text...
For example, I need to be able to search for records that contain 'dog' but
not return 'hotdog' or 'dogma' for...
|
by: Jeffrey A. Hawkins |
last post by:
Hi,
I have been able to JOIN ON CONTAINS(column, 'whatever'), but can't seem to
get the syntax right to join on one field containing a related field.
The query below is what I am working...
|
by: HumanJHawkins |
last post by:
The following query works perfectly (returning all words on a list called
"Dolch" that do not contain a form of "doing"):
SELECT 'Dolch' AS , dbo.Dolch.vchWord
FROM dbo.Dolch LEFT OUTER JOIN...
|
by: james_oinn |
last post by:
We have 2 SQL Server 2005 machines. One has the CTP version installed,
the other is the RTM.
When running the query below, results are returned for the CTP version
but not the RTM version.
...
|
by: Casey |
last post by:
Hi,
How would one allow for possible multiple search criteria using FREETEXTTABLE. For example, my table "listings" has a full-text search catalog, and I may want to:
SELECT * FROM listings...
|
by: Chung Leong |
last post by:
Here's the rest of the tutorial I started earlier:
Aside from text within a document, Indexing Service let you search on
meta information stored in the files. For example, MusicArtist and...
|
by: garrettm |
last post by:
What if you want to search using FTS with AND logic using the FORMSOF(inflectional,...) inside the CONTAINS() clause???
if my search phrase is "light hearted" I can easily do an OR search using...
|
by: jerrycan |
last post by:
Hi All
I have the following SQL script:
ALTER procedure FREESEARCH1
@SVALUE as nvarchar(255)
as
declare @rc int
if @SVALUE like '*' exec dbo.ALLREQ else
Select * from Requirements where
|
by: HumanJHawkins |
last post by:
Hi all,
I need something stronger than LIKE or CONTAINS, but not so
comprehensive as the FORMSOF(Field, INFLECTIONAL).
I am looking to see which words from one list also exist in another....
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| | |