Error message in wrong language?
From: charles (spam_at_synthigence.com)
Date: 08/20/04
- Next message: Alok: "optmizing full text"
- Previous message: Eric Keeney: "Re: CONTAINS and Monetary values stored in text data type"
- Next in thread: Hilary Cotter: "Re: Error message in wrong language?"
- Reply: Hilary Cotter: "Re: Error message in wrong language?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Aug 2004 14:31:59 -0700
I want to give users access to full-text searching and presume that I can
let SQL-server do all the dirty work. If I pass in a syntax error, things
fail as expected and I get an appropriate error message in the exception.
If I pass in a query with only "a" (for example) with only ignored words,
the exception is thrown with an error message in Spanish!
"Una proposizione della query conteneva solo parole ignorate."
Since syntax errors on the same stored procedure come back in English, I
assume my culture is correct (and I set it explicitly). If call the stored
procedure from DevStudio with the same params, the error message is in
English.
Any ideas?
thanks
charles
DETAILS:
The stored procedure:
ALTER PROCEDURE dbo.GetMessageList
(
@ForumID int,
@FullTextSearch nvarchar(200)='',
@BeginDate DateTime=NULL,
@EndDate DateTime=NULL,
@IsModerator bit=0
)
AS
SELECT
ForumMessages.ID,Title,MessageBody,Format,Locked,Importance,Hidden,PostTime,
UpdateTime,EventDate,Alias,Views,
(SELECT COUNT(ID) FROM ForumMessages AS F1 WHERE
ForumMessages.ID=F1.RootParentID) AS Replies
FROM ForumMessages, ForumUsers
WHERE
ParentID IS NULL AND
ForumID=@ForumID AND
(@IsModerator=0 OR Hidden=0) AND
(@BeginDate IS NULL OR EventDate>=@BeginDate) AND
(@EndDate IS NULL OR EventDate<=@EndDate) AND
ForumUsers.ID=UserID AND
(@FullTextSearch='' OR ForumMessages.ID IN
(SELECT RootParentID FROM ForumMessages WHERE
CONTAINS(Title,@FullTextSearch) OR CONTAINS(MessageBody,@FullTextSearch)
)
OR ForumMessages.ID IN
(SELECT ID FROM ForumMessages WHERE CONTAINS(Title,@FullTextSearch) OR
CONTAINS(MessageBody,@FullTextSearch)
)
)
ORDER BY Importance DESC,UpdateTime DESC
RETURN
- Next message: Alok: "optmizing full text"
- Previous message: Eric Keeney: "Re: CONTAINS and Monetary values stored in text data type"
- Next in thread: Hilary Cotter: "Re: Error message in wrong language?"
- Reply: Hilary Cotter: "Re: Error message in wrong language?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
