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?
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 RelatedI 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 %>
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'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?
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 have been looking around at various design solutions for uploading a file using ASP and have found that many sources have devised a much simpler plan using ASP.NET.
My question is this, I have a box running Win2k Advanced Server, with the .NET framework installed. WIll that enable me to run some of the new functions etc. decribed in ASP.net ??
What's the difference between ASP and ASP.Net? Which one should I learn in order to start making dynamic web pages for the internet?
View Replies View RelatedSo I need to write the difference between the biggest and the smallest number in database table. I know that I need to take MAX and MIN from table, but I just can't get it work.
Example:
Let's say max = 5 and min = 1, I need to have it like this:
5-1=4 (max-min=total)
Maybe my books are just sorry, but I can't find a description of what <%# is supposed to mean. I find Dreamweaver inserting it often.
View Replies View RelatedIs there any technique available that my asp code will convert into asp.net
View Replies View RelatedWhat is the difference between
Code:
<meta http-equiv="refresh" content="5;url=menu.asp">
and
Code:
Responce.Redirect("")
Which one would you chose?
is there anybody know to code the time difference in asp? i used timediff, it returned a date, it should return a time actually. i tried the command in mysql n it's fine. but it's error when i switched to ASP. i hv refered to alot references such as sql time manual n other sites. but stil fail to find ans.
View Replies View RelatedWhat is the difference, and when to use one over the other?
View Replies View Relatedi have a problem with differentiating these
response.redirect()
server.transfer()
server.execute()
do they all perform same?
I'm writing an ASP app that administers an ISA server remotely. The fact that it's an ISA server isn't my problem I believe. My question? What is the security difference between disabling anonymous access and using account X from the web client, versusallowing anonymous access but using account X as the account that runs the application?
When I configure my web application to allow anonymous access, but set the anonymous process to use account X, my ASP code works (the ASP code can administer my ISA Server). When I disable anonymous access, and I log into the web application using the same account X I mention above, I get an error 80070005 when my ASP code tries to connect to my ISA server to administer it. I would think the above two options would be equivalent, but they're not. What is the difference?
I have a problem to calculate the day different. I use
datediff(currentdate, quoteDate) > 20
The error message is : Wrong number of arguments or invalid property
assignment: 'datediff'
I use datediff("D", Date, quoteDate) > 20, but still could get the correct one. Maybe I need to change string to the digit. How to do it?
I understand how asp scripting works and how you put <% %> around your server script. However this is .asp . what is .aspx? is this the new version ASP.nET? I dont understand how it works when i create a new aspx project in vstudio.net and i create a aspx page in design view.
I add a button and then double click it to add code to that button. I dont see any html code around it? In an asp page the server side code is surrounded by html code. An aspx page almost looks like a normal vb application, why is there no html
code around?
Can someone shed light on this: -
When I search for 'ô', the url encode shows a "%F4", whereas should I show a "%C3%B4"
A few weeks ago I was told in this forum that ASP would be a great solution to a large web site. I purchased a book about ASP.Net but have also seen info on ASP. Can you please tell me what is the difference between the two?
I don't know computer programming at all. Dreamweaver MX is the program I use. Can ASP be done with a WYSIWYG program? I have set up databases in Access & built web sites with DW MX I am not sure how to tie the two together.