|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > ADO Bug ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Topayung, Amdys Max 2002-10-05, 9:07 pm |
| I'm new to SQL Server 2000 and it starting get me mad.
I'm using it for my website. (ASP/IIS)
I have provide a search tool on my page and using Full Text.
Don't know this a ADO bug or not, but i recently cannot retrieve data from
database.
This is my sql string :
strSQL = "SELECT IdNews,Title,News " &_
"FROM News " &_
"WHERE CONTAINS(*,'"&tmpSearch&"') " &_
"ORDER BY IdNews DESC"
Then I execute it using ADO Connection and save in my recordset :
SET RS = Con.Execute(strSQL)
I placed in variable :
idNews = RS("IdNews")
Title = RS("Title")
News = RS("News")
Then for debug :
Response Write idNews
Response Write Title
Response Write News
NEWS doesn't contain anything !
That's made me crazy.
Pls help
Thanks
| |
| Roman Tumaykin 2002-10-05, 9:12 pm |
| What if you execute the same statement from Query Analyzer? My guess would
be that the full text index has to be rebuilt.
--
Regards
-- Roman Tumaykin
"Topayung, Amdys Max" <amdys@ToughGuy.net> wrote in message
news:Ou8tY3iWCHA.4008@tkmsftngp11...
> I'm new to SQL Server 2000 and it starting get me mad.
> I'm using it for my website. (ASP/IIS)
>
> I have provide a search tool on my page and using Full Text.
> Don't know this a ADO bug or not, but i recently cannot retrieve data
from
> database.
>
> This is my sql string :
>
>
> strSQL = "SELECT IdNews,Title,News " &_
> "FROM News " &_
> "WHERE CONTAINS(*,'"&tmpSearch&"') " &_
> "ORDER BY IdNews DESC"
>
> Then I execute it using ADO Connection and save in my recordset :
>
> SET RS = Con.Execute(strSQL)
>
> I placed in variable :
>
> idNews = RS("IdNews")
> Title = RS("Title")
> News = RS("News")
>
> Then for debug :
>
> Response Write idNews
> Response Write Title
> Response Write News
>
>
> NEWS doesn't contain anything !
> That's made me crazy.
>
> Pls help
>
> Thanks
>
>
|
|
|
|
|