Searches My Selects

I have this code in a procedure, and it basically will select all the quotes from a certain 'manager' and if the date is more then 7 days, it will archive the quote (by placing a 'Y' in it)

Declare @tempDate varchar(20)

SELECT @tempDate = DATEDIFF(day, SaveDate, getdate())
FROM QuoteFeedBack
WHERE TerritoryManager = @Manager and Archive <> 'Y' and QuoteNumber = '3'

if (@tempDate > 7)
UPDATE QuoteFeedBack Set Archive = 'Y'

WHERE TerritoryManager = @Manager and Archive <> 'Y' and QuoteNumber = '3'

Now this code works, but instead of specifying the QuoteNumber, I want it to scan through all the records for that manager. Basically searching all the quotenumbers that have not been archive yet.

View Replies


ADVERTISEMENT

Instr Searches

I am searching a string that look like this (21,5,15,25) using Instr().
So, if I am searching for '5', I get everything that contains a five.

If InStr("21,5,15,25", req,QuerStr("id") Then
response.write "yes"
End If

I want only the one value '5' to get found but anything that contains a 5 is found. I have tried using Cint and Int to no avail.

View Replies View Related

Restricting Searches

I've created a search page that gets complete addresses based on postcodes, and name, suburb and address.Almost 6000 entries in the db.I want to limit the amount of times a user can search, i tried cookies but anyone can delete cookies and off they go again.The reason behind this is to prevent the opposition from collecting stuff and cold calling them.

View Replies View Related

Web Searches And ASP Pages

I was told by a friend that Web searches like Yahoo can't "find" ASP pages to return their results within a search. Is that true?

View Replies View Related

Too Many Selects??

I'm having a problem with my code. It works but one part at a time Code:

View Replies View Related

NoiseWords And Access DB Searches

I've got a catalog (table) of products (records), which will undoubtedly grow to over 5000 records in months. This is in an Access 2000 mdb file behind an ASP page, and the products have full text descriptions. I want my customer to easily "search" the database
table with a simple SQL query. I guess I'll use a LIKE operator to search the field with the product's long description.

Problem: Noise words. i.e. - and, but, it, its, or, the... will return thousands of records and slow down browsing efficiency.

Has anyone got a good solution to easily eliminate noise words from submitted text entered into the asp page "search" field?

I was able to find the file noise.enu from the Microsoft Index server installation. It has about 50 words or so. Would I use a replace() function to eliminate the words from my sql statement?

I'm sure someone else has come across this.

What would be the BEST and most logical way of using VBscript and ASP to accept the query string typed and then condition it for introduction into a "LIKE" statement in an ADO query?

View Replies View Related

How Can I Combine These SELECTs?

Right now i have multiple record sets. Im using the following Select statements:
How can I combine ClaimNbrSQL, ClaimCovSQL, and ClaimantSQL to pull data based on ClaimdraftSQL.

They have different Where_parts because one field is not accounted for in the innerjoins for the the last 3 selects. Anyone know of a better way of doing this? The problem is the queried table is not matched up correctly. For example if there are 2 rows where dft_mirco_ecd_nbr are blank, the ClamiantSQL is off by 2 rows. Code:

View Replies View Related

Multiple Selects

I need to retrieve data from an Oracle Database. The values to be retrieved are comming divided by commas, every time I try to run the select I�ll get an error.

View Replies View Related

Load Selects From Database

I have some countries, states and cities (three levels) loaded in a database. I have to put them in some form "selects" through a site.

All these data is not probably to change frequently. What would be the best option to load it from? I mean, should I load the data always from the database, even though they are not constantly changing and almost always remain the same? Should I use a XML file to load the data from there?

I don't want to hardcode them, because they appear in more than one form, and it could be a nightmare to update

View Replies View Related

Retrieve Date From Db And Use Selects To Reflect Day, Month, Year Seperately

I have a form which allows a user to select a 'commencement date' using separate day, month and year drop downs. The date is then submitted to db in DDMMYYYY format(as required).

I now need to allow user to edit this date if they need to. So, I retrieve the date from db as ie. 30101968. I now need to place the first 2 digits (30) into strDay, second 2 digits into strMonth and last 4 into strYears so that I can reflect these values in the their relevant drop downs.

Does anyone know how to 'grab' those specific values?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved