I'm uploading a file locally and I'm trying to passing it throug a variable and I'm having a problem with locating the exact file name from the upload_document page. I thought is was "r_title" but for some reason the file name isn't stored there.
View Repliesim defining a cookie as so:
Response.Cookies("something")("value") = "value";
now i want it expire in 20 minutes.. how do i do that? i tried to give the .Expired property a date object but it faild.
I am using ASP to query access db on IIS5
I need to find exact matches for search terms within a string. EG "cat" will find cat but not catastrophe from within a large string.
I cannot use "=" as that would match the whole string and I only want to find the exact match within the string.
I am trying "like '%[!a-z][search term][!a-z]%'" which is pretty clumsy and also doesn't pick up the search term if it is at the beginning of a sentence.
Can anyone help me with the syntax here? I have racked my brains coming up with all sorts of convoluted solutions that all end up having a flaw. I have been looking around ASP fora and it seems a few people are asking the same question but getting no answers. (you might see my question in some of them...) I am sure there must be some operator within sql as there is in FMP but I cannot find it.
regarding EXACT search. i want let user search with ANY or EXACT match. i had done any with
instr(products, '"&st&"') > 0
where products is my database field, from where search result come and st is the search string entered by user. now want to provide EXACT search. e.g. machinery will match only machinery and not machine, machineries, machines etc. i had tried LIKE predicate. is there any other way to provie EXACT match ?
i m doing a custom search. i have included SEARCH USING:
1. ALL OF THE WORDS
2. ANY OF THE WORDS
3. EXACT EXPRESSIONS
i m not able to have the search results using option no. 3 EXACT EXPRESSIONS. how to do that thing ?
i want to provide exact match. e.g. if user enters pharma machine result only display records containing pharma machine and not records containing either pharma or machine.
database table: company_info
database field: products
user entered search (field name): st
i had tried the following
select * from company_info where products like '"&st&"'
but is shows the wide result
Here's the problem I'm running into:Code:
Set RS = Conn.Execute("SELECT TOP 10 id, score, numvotes FROM [user] WHERE active = '1' ORDER BY (score/numvotes) DESC")
Simple query, nothing to fancy. However it doesn't order highest to lowest correctly. Here's a sample output:
10.00
10.00
9.63
8.00
8.25
8.00
7.00
7.82
7.42
7.86
As you can see it's not correctly ordered from highest to lowest.
i am doing a database search project. and i would like to know how do i get exact keyword searched from the database. for e.g. if the user enters keyword as "lan" to be searched it should return only records that contain exact keyword "lan" and should not return "plan" and other words like that.
View Replies View Relatedi get "system cannot find the file specified" error. iam sure that the path of file iam looking for is true. i guess this is a friendly message thrown. when i turned off the freind messages in IE (client side) i still get the same error. is there any way that i can see the exact error so that i can debug.
View Replies View Related