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

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

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

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

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

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

I have a part database that in essence has two tables with a one to many relationship joined on a key. The PK table contains parametric data about the unique part and the FK table has information like part number, mfg, etc. For example parameters details ========== ==========...

I currently have a process that allows the user to upload an excel spreadsheet. The page queries the file, and uploads to the database. Currently, I am telling the users to verify that the sheet name matches the file name, then querying like: Set objExcelRS = objExcelConn.Execute("Select...

I have a process where the user will upload an excel spreadsheet, I connect, store the data into an array (which I will populate a SQL Server DB with), close connections and recordsets and set them to nothing, then delete the file. It works fine... the first time around. The second time...

as opposed to using like. I am currently using LIKE in the where clause, but I was asked to accept the user input and search where "part number begins with the user input" as opposed to searching for the string anywhere in the field. For example, If the user enters "08" I...

I am not sure if this is the correct forum, but I am in a bit of a pinch, and need a little advice. I have been given a challenge by my VP. He wants me to design a part number database that will allow a user to enter a part number (it can be our part number, a supplier part number, or a...

I am referring to the WHERE clause where I repeat the select max incident_num. Can I store it in a variable, and reference in the second part of the where clause? Thanks, gordon SELECT * FROM irsc_incident_dtl T1, irsc_sts T2, irsc_usr_tbl T3, irsc_cat_desc T4 WHERE...

This seems pretty strange to me, but the results of my ASP/Javascript code don't appear the way that I would anticipate. I don't uderstand the carriage returns in the output of my DescriptionLine1 variable in the client code. This gives me a "unterminated string constant" error, but...

ADODB.Command error '800a0bb9' The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. /development/gadams/irsctest/incident_dtl.asp, line 158 This is my stored procedure CREATE PROCEDURE mysp_update_status...

I finally was able to make my stored procedure that inserts records execute successfully. My question is how do I use locks with stored procedures? None of the documentation that I have mentions anything about it. Does it handle it on its own? If so, how, and what does it do? Thanks, gordon

I have read some elementary stored procedure tutorials, and I am looking at using stored procedures with ASP, and I still have a few fundamental questions regarding stored procedures. regarding committing and rolling back, if one of the queries fails between a BEGIN and an END, does the entire...

My goal is to be able to insert two rows into two different tables. One is a detail table and the other is like a status history table (new, opened, assigned, etc.) I would like to insert the new record into the detail table, and then, if that insert was sucessful, insert another record into...