"charles" <spam@synthigence.com> wrote in message
news:O$WT0wvhEHA.3200@TK2MSFTNGP10.phx.gbl...
> 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
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:eImiwiyhEHA.712@TK2MSFTNGP09.phx.gbl...
> are you getting this message in Query Analyzer? If so which language is it
> being returned in?
>
> Are you getting it in ADO? If so, what is your localeID, and what are your
> regional settings (check control panel for this).
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "charles" <spam@synthigence.com> wrote in message
> news:O$WT0wvhEHA.3200@TK2MSFTNGP10.phx.gbl...
> > 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
> >
> >
>
>

"charles" <spam@synthigence.com> wrote in message
news:uMSxblSiEHA.3548@TK2MSFTNGP09.phx.gbl...
> With Query analyser the error comes back in English. Don't know about
ADO,
> my app is in C# and uses the SqlClient calls. But I've only found this
one
> message in Spanish. Does the Full-text system have a separate language
> configuration entry? Also, my App is multilingual, when a user selects a
> different language, how will I tell SQL-Server what language should be
used
> for error messages?
>
> thanks
> charles
>
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:eImiwiyhEHA.712@TK2MSFTNGP09.phx.gbl...
> > are you getting this message in Query Analyzer? If so which language is
it
> > being returned in?
> >
> > Are you getting it in ADO? If so, what is your localeID, and what are
your
> > regional settings (check control panel for this).
> >
> > --
> > Hilary Cotter
> > Looking for a book on SQL Server replication?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "charles" <spam@synthigence.com> wrote in message
> > news:O$WT0wvhEHA.3200@TK2MSFTNGP10.phx.gbl...
> > > 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
> > >
> > >
> >
> >
>
>