ISABOUT and SPs - 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

SQL Server 2000 Forums

Transact-SQL (2000)

ISABOUT and SPs

Author

Topic

ronin2307
Posting Yak Master

126 Posts

Posted - 2007-04-26 : 16:19:26

hi,

I have a syntax issue that I need to figure out how to solve:

here is a test query i used to figure out how to make use of ISABOUT:

select ftitle, rank from engspecentries inner join
freetexttable(engspecentries,ftitle, 
'ISABOUT (single weight (.9))'
) as X
on X.[key] = engspecentries.fid
order by Rank DESC

this worked fine and as expected

now I tried to implement the ISABOUT logic in a rather large SP i have. Here is the part of it that is causing me a problem

select e.ffileloc,e.fid from engspecentries e
inner join freetexttable(e,e.ftitle,@ftitle) as X
on X.[key] = e.fid
where ...

in the above case the @ftitle is supposed to be a dynamically generated ISABOUT statement (it is coming from my VB app that is using this SP)
however if I pass this exact string as in the above test ( 'ISABOUT (single weight (.9))' ) i get this error

Line 63: Incorrect syntax near '.'.

this is pointing to the INNER JOIN line

EDIT:just to clarify: the error is happening when i tried to SAVE the SP, not when i try to run it. the above mentioned problem with passing the literal string will have to wait, because i realized that i did not properly write the logic of the SP when i was trying to run the SP

can somebody please tell me what am I screwing up here?
thanx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources