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.
| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2010-07-06 : 08:38:49
|
| sir , I have this query -SELECT * FROM dbo.tbl_Consultant TC LEFT JOIN tbl_User TU ON TU.UserID = TC.HotLIstOwner LEFT JOIN tbl_State TS ON TS.StateID = TC.StateID ,CONTAINSTABLE(dbo.tbl_Consultant,(PrimarySkill,SecondarySkill,ResumeText),'vb java') S Error is - Syntax error near 'java' in the full-text search condition 'vb java'I have try catch block But try catch block not able to catch this error How can i handle this error .Please help me out sir .Yaman |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-06 : 09:53:09
|
| If you are using CONTAINSTABLE or CONTAINS of FREETEXT, make sure you have FULLTEXT CATALOG and FULLTEXT INDEX agains the table that you are running this query! |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-07-06 : 10:28:17
|
Syntax errors are NEVER catched with TRY-CATCH, unless you are building a dynamic query.Also, how many arguments are you passing to the function?Are you trying to cram in three columns in one paramter?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
Try - Catch Problem