I have a table with two columns. ftr_sampler is set as varchar(255). I want the script to search for similar keyword in the ftr_sampler.
sample table:
id ftr_sampler
- -----------
1 I like to eat apple.
<% if RS3("ftr_sampler") = "%apple%" Then %>
Id 1 like to eat apple.
<% else %>
Id 1 does not like to eat apple.
<% end if %>
Is there a way to see if 2 fields are similar.. for instance:Code:
If rsHomeT("TeamName") [IS SIMILAR THING HERE???] (rsHomeT("CustomHomeName")) Then
Response.Write " & CustomHomeName & "
Else
Response.Write " & HomeTeamName & "
End If
I dont want to use LIKE in my sql queries to be able to do this.
Is there another program similar to PWS, for W9X? I have problems with the installation, and I wonder if any company made something similar.
View Replies View RelatedI have learnt how to use some aspects of php. But have got a little stuck on databases. Are there some easy examples to follow from the internet on how to modify databases in asp?
Is asp very similar to php? In the sense that you can achieve the same things with it?
is there an online dictionary that I can use to learn asp? especially one that can be kept and stored offline(I am not on the internet at home)
I'm developing with CF 5 and SQL Server 2000. I think they are both
great products. The major draw is their cost. I don't develop stand
alone products because anyone that wants to purchase them must also
purchase CF Server and SQL Server. So I run them as a hosted service.
MySQL is supposed to be free. If you are using this product, how do
you like it? What are you using for a front end?
I'd like to move toward developing software that some one can run on
their own webserver with the only cost being the software purchase.
That means the database and front end software need to be free (MySQL,
PHP, CGI). If the customer doesn't have these, they can download them
for free or small fee. What are some feasible alternatives to CF and
SQL Server?
Is ASP Apache comparable to ASP or ASP.NET? Everything will run on a
Lunix Server to keep cost down.
Where i can get similar script to ( http://www.vrating.com ) in ASP & Access
View Replies View RelatedI'm trying to query my database and return partial matches of a book title field...how do i go about doing that? Like if they enter "Gatsby," i want it to return, among any other titles with the word Gatsby in the title, "The Great Gatsby."
View Replies View RelatedIs it possible with 'classic' ASP to find out the SERVER_SOFTWARE of a remote server.
I wish to have a form where people can enter their domain name and then have a page that based on the form post determine what type of hosting the domain is using.
the next is my platform
IIS5
windows 2000
asp vbscript
My working area has the next virtual directoy:
testAc (corrective ambient)
testAe (evolutionary ambient)
testA (official ambient)
testBc (corrective ambient)
testBe (evolutionary ambient)
testB (official ambient)
Every virtual directory above mentioned , has the same content with littles differences but not important for cookies or for the structure of my
applications.
When I enter in my application I set up in my cookies my language and my profile informations.
I set up the cookies with an expires date and I set the cookie value with a response.cookies("lid")=VARLINGUA (VARLINGUA is an application variable that I have recorded in global.asa).
There is a problem with cookies when I open more of the above virtual directory at the same time or when I din't have cleaned my cookies in my temp files.
After my debug I have understood that my cookies are recordered correctly in my temp files (testAc , testBc ,testA etc....) and they contains the right content, but when I try to read my cookie with the request.querystring I read the double content of my cookie(In my case I have found 2 info about language and 2 info about my profile).
It is possible for you that I read the correct cookie but there is also another value in memory.
I think that IIS has problems to read cookies in virtual directory with similar names. I have this doubt because renaming my virtual directories with various(not similar for example testAc I have called Actest, testBe I have called Betest etc...) I do not have more problems.
I'm looking for an ASP component that manage USER PROFILE, that works similar to facebook or myspace The features that I would like are: Code:
View Replies View RelatedI'm building a site which runs on 4 templates, each a different colour. I would like to pull in different content into each template using ASP.NET, similar to the php version of index.php?page=content.
I've not programmed in ASP before so am hoping someone can either supply me with a script or point me in the right direction.
Code:
uery="select top 21 * from profile where enabled='yes' order by mating desc"
I cant get this to woek , it shows all the records when i just want it to show top 21 records based on column mating. I am using access database. Does top keyword work with access?
I've got a search query that involves a kewyord input that searchs 2 db feilds. It works fine if you use one word searches, but draws no records if you have 2 words. How do I set up a search that can include multiple words or multiple individual letters etc... Code:
View Replies View Relatedcurrently doing a wep application that contain of search engine. i did browse through some web applciation's search engine, notice that they can highlighted the keywork for searching when they display the search result.
example,
when i enter keyword 'test' in my search engine and preform search, let say i found a file called testing.asp, i want the word test to be highlighted. may i know how can it be done?
I have been told that I must not use the set keyword if that is the case then what would I use? Has anyone ever heard of that?
View Replies View Relatedi want to develop a small application which will generate a list of
product from a database based on a user web page contents. something
like google adsense but not that extensive. any help or resource
available?
any guidelines. i want to use ASP , access or SQL server .
in short a script page, when called, read the contents and search a DB
for products and diplay it .
I am using a keyword search facility which uses the SQL Like operator. The problem with this is that if I enter the search keyword evil, it will match the word devil. I want to match the string from the start of a word, not in the middle or anywhere else. Can I achieve this using wild card operators? If so what is the format?
View Replies View Relatedcheck the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <from> is missing or what?
View Replies View RelatedI'm using the code on:
http://www.aspfree.com/c/a/ASP%20Co...n-by-Meraj-Sami
I want to use two colors on two keywords, one in red, the second in blue.
This is the result:
http://n.1asphost.com/wheelofgod/highlighting.asp
there is a third color with a third keyword but,never mind that.The problem is that it's restarting the text once it has found and replaced the keyword in color.
Is the keyword 'as' supported in ASP? I'm reasonably sure it's valid VBScript (code examples I've downloaded use it) but when I try to use it in ASP I get an error. Is it perhaps a version issue?
View Replies View Relatedi want to search a database containing the keyword entered by the user.
i tried this code:
myquery = "SELECT * FROM articles WHERE author LIKE '%" & Request.Form("keyword") & "%';"
but this one only searches the "author" field. i want asp to search the entire database regardless of the field.
I read a text file in ASP using readline. The line is stored in a variable. I want to be able to search that line for a specific word.
How do I go about this?
I'm a user of ADO 2.8
Difference between declaring a RecordSet
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
and
Using the Set keyword when expecting a RecordSet to be returned during a Command.Execute
Dim rs
Set rs = cmd.Execute 'cmd is a ADODB.Command object
Why is there a need for this?
Im doing a text search, and i need to highlight the word which is being searched for in the results page. How do i do that?
View Replies View RelatedI have been searching for a way to search a database based on keywords. All I can seem to find is google searches. All I want to search is my own database.The db contains inventory for a friends store. As list is long he would like to be able to search an item based on item name, supplier, or type.
View Replies View RelatedHow do i add a keyword list to my website to make it searchable using a user key in certain keyword for a search engine?
View Replies View Relatedcheck the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <form> is missing or what?
View Replies View RelatedCan you please check the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <from> is missing or what?
View Replies View Relatedi 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 am now all of a sudden getting an error in this sql connection
string, saying that the Provider keyword is invalid:
<add key="MM_CONNECTION_STRING_isox"
value="Provider=SQLOLEDB;SERVER=xx.xx.xx.xx;UID=xx;PWD=xx x;DATABASE=xxxx;"
/>