Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rtgordon

    Full text search problem

    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...
  2. rtgordon

    Convert like queries to Full Text Search

    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...
  3. rtgordon

    Convert like queries to Full Text Search

    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
  4. rtgordon

    Trouble with full text query

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

    Trouble with full text query

    Anyone???
  6. rtgordon

    Trouble with full text query

    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...
  7. rtgordon

    Trouble with full text query

    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...
  8. rtgordon

    Database Paging and Checkboxes

    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...
  9. rtgordon

    Database Paging and Checkboxes

    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...
  10. rtgordon

    Database Paging and Checkboxes

    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...
  11. rtgordon

    XML Design question... Hierarchical data

    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...
  12. rtgordon

    Fine tuning indexes

    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...
  13. rtgordon

    cannot importing excel file with leading zeros in zip+4

    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...
  14. rtgordon

    Fine tuning indexes

    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...
  15. rtgordon

    slow data loads

    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...
  16. rtgordon

    slow data loads

    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...
  17. rtgordon

    Peculiar problem with dts/sp

    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
  18. rtgordon

    Peculiar problem with dts/sp

    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...
  19. rtgordon

    Problem with DTS and Excel... leading zeros

    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...
  20. rtgordon

    ADO Open connections

    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

Part and Inventory Search

Back
Top