Search results for query: *

I have an asp page with a text box that feeds a stored procedure that builds a FTS query and displays the results. If the user types in "category 5", I build this query: SELECT TOP 100 Level1Desc, Level1, Level2Desc, Level2, Level3Desc, Level3, Level4Desc, Level4, Level5Desc, Level5...

Sorry, I specifically meant leading AND trailing wildcards... I can't see that there is a way to do this with CONTAINS in BOL. For example, I have a xyz-123 in the field I am searching. I want it to return this row if the user enters "xyz 123" as search criteria. I can't seem to write a FTS...

How do I convert a query with a where clause like this: WHERE column LIKE '%xyz%' AND column LIKE '%123%' into a full text search query assuming everything is configured and all catalogs are created on the proper fields? Thanks, Gordon

Is there any configuration for how FTS handles noise words, word concatenation, etc that might be causing this problem? Thanks, Gordon

Anyone???

Yes, both are true. It runs fine and I get results for both if I run each separately: WHERE CONTAINS(SearchText, ' "*fluke*" ') WHERE CONTAINS(SearchText, ' "*187*" ') but I don't get anything if I try to combine them with AND... This is only on the server box. I know there is a part in the...

I developed a database table on my desktop XP Pro Sql server 2000, and populated it there. I built a full text index and I can run and get values with this query SELECT Level1Desc, Level1, Level2Desc, Level2, Level3Desc, Level3, Level4Desc, Level4, Level5Desc, Level5...

i suppose i could have the form page submit to itself, build the session string/array, check to see if the user clicked compare if the user clicked compare, redirect to the compare page, pull the values from the session This would work I think, but it doesn't seem like the best method. Any...

Thanks for the propmt reply! these are some of the things i have been thinking about. When the page is loaded, If I have an array or string with values, I check my array or string to see what values are in there and if any match the current page, I set the appropriate checks in the...

I am trying to implement a solution similar to what best buy and many others use. I have many pages of results displayed each with checkboxes. The user can select several items and then click compare to compare the checked items. I currently have this working with javascript, but only for the...

I am trying to determine the best approach for a data source that will drive a drill down list. I have started over on a design three times. The data is like this: Pants Cargo Pants Denim Cargo Pants Button Fly Zipper Fly Khaki Cargo Pants Button Fly Zipper Fly No Fly...

I have been experimenting with the indexes... the weird thing was that when I just had indexes on part_id, rel_part_num, and mfg_id it was pretty slow. I added the clustered index including each of them and it went fast. I removed the individual indexes leaving only the clustered and it went...

I had trouble with this, too. The single quote was not working... My DTS package counted anything with a leading zero null. My approach was to append a character (i.e. X) to the front of all values in the column then strip off the x when I moved it from a temporary table to the permanent table...

Here is the query that I am trying to fine tune my indexes for: SELECT TOP 500 T1.alias_ind, T2.supplier_ind, T2.mfg_id, T1.part_id, T2.mfg_name, T1.rel_part_num, T3.commodity_cd, T3.family, T3.part_size, T4.component_type_desc, T3.cap_value, T3.voltage, T3.cap_tolerance...

Thanks! I'll try it as soon as my slow load finishes running. I suppose that you mean something like declare DataCursor cursor forward readonly static for...

My data loading has really begun to bog. I know that part of the reason is the cursor that I am using to load the data. After researching, I realized that I had misunderstood the fill factor for indexes. I was thinking that a fill factor of 70 meant 70% additional free space. I guess that it...

anyone??? I am sure it is something simple that I am missing because it works fine in query analyzer, but just stops (after processing a few records) without returning any errors when I try and execute it through dts. gordon

I have a dts package that reads an excel file into a temp table. When I execute the package, it loads the excel data into the db table fine, then it executes a sp to verify/move the data. It runs for a few seconds and returns complete. All green, but when I query the database, only a small...

I have been working on a package to import an excel spreadsheet. My only problem is the size field. It is a four character field that may contain a leading zero. (ie 0805 is .08"x.05". It seems as though when the import encounters the leading zero, it just makes the field null. I...

It is a bad idea to cache connections in an application object. If one connection is cached in the application object and multiple pages access the connection, they will all contend for use of the connection. Create and destroy the connection on every page that uses the connection. gordon