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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-14 : 01:04:24
|
Rajendran menon writes "Hello,
I am handling couple of web based projects involving ASP/SQL7.0/COM/MTS etc. I ran into the following problems while doing this project. If anybody can help me out, I would be very greatful.
Problem 1.
--------------
One of the projects is a search engine. We are using SQL 7.0 as the back end and are using
the Full Text Indexing feature of SQL 7.0. When we issue a query as below,
Select distinct type,p_id,name,KEY_TBL.rank from searchall
INNER JOIN containstable(searchall, strtobesearched,"FORMSOF(INFLECTIONAL,'O'Hara'" ) AS KEY_TBL
ON searchall.p_ind_id = KEY_TBL.[KEY]
we are not getting any results. Actually O'Hara is present in the strtobesearched field. How can we re-write this Query to overcome this problem ?
Further Pls give the syntax to insert the O'Hara into a field using the insert into table statment. The data type of the field is Varchar. We can Insert O'Hara into the table using the GUI of SQL 7.0 but Insert into table name values('O'Hara') statment will show error. Our application is such that the original data is available in MS ACCESS database. We are then using a java program to download the Access database from an FTP site, and then upsize this to SQL 7.0 . We cannot use the Wizard because this has to an un-attended and automated process. Currently what we are doing is while upsizing from Access to SQL, we are replacing the ' with ~. Hence O'Hara becomes O~Hara. Unfortunately, the Full Text feature of SQL, which we are using for the search ignores ~ and hence the search fails.
Problem 2
----------
The above search is an ASP application. The user can enter the word(s) to be searched in a text boxt in the home page . The search results are displayed in a seperated Results page. In IE, if we enter the word to be searched and then press the Enter key, the search will be initiated. The user can also search from the Results page as well. But the Enter key does not work from the Results page. If we enter a word(s) to be searched in the text box and then press the Enter key from the results page, the search is not initiated. We have couple of option buttons after the text box for the user to select (AND , OR SEARCH options) and then the Search button. Selecting the search button works. In Netscape the enter key simply does not work at all from both the pages.
Can anybody suggest a remedy or workaround for this? We are using GET method for this.
The application uses the following.
Platform : Win-NT Server 4.0 (SP 4)
IIS 4.0
MTS 2.0
ASP 2.0
ADP 2.1
We are using Visual Interdev 6 for the applications and VB 6 for the components."
|
|
|
|
|
|
|
|
SQL Server 7.0/ASP